Leather Knight Posted May 22, 2008 Share Posted May 22, 2008 Is there a way to make a field perform a specific search? Say I want to find all records with "Colt" in them, I want to type "Colt" in the single field and have it search all records for that word. Any advice? Link to comment Share on other sites More sharing options...
mr_vodka Posted May 22, 2008 Share Posted May 22, 2008 See here. http://www.fmforums.com/forum/showtopic.php?tid/195128 Link to comment Share on other sites More sharing options...
Leather Knight Posted May 22, 2008 Author Share Posted May 22, 2008 Well, that is the idea. I created the script step, and the search field as well as the "cAllDescriptions" and modified the fields to search, however, it does work in the solution provided, but not in mine. It is duplicated except for the search criteria. I search for a name, and it doesn't find it. In fact, it finds nothing...Back to the drawing board... Link to comment Share on other sites More sharing options...
mr_vodka Posted May 22, 2008 Share Posted May 22, 2008 What happens if you do a manual find in the calc field? Link to comment Share on other sites More sharing options...
Leather Knight Posted May 22, 2008 Author Share Posted May 22, 2008 If I go into find mode, type in the name I am looking for, then hit find, it doesn't find anything either. Link to comment Share on other sites More sharing options...
mr_vodka Posted May 22, 2008 Share Posted May 22, 2008 What does your calc look like? Link to comment Share on other sites More sharing options...
Leather Knight Posted May 22, 2008 Author Share Posted May 22, 2008 Unbelievably I found the issue. In the field used for the criteria where you list all fields to be searched, I was using "field name & field name2 & so on..." I added "& ¶ &" (notice the middle thingy) and that fixed it. Each field listed needed to be separated completely. And now it works great.. Thanks for showing me the post. Again I learn.. Link to comment Share on other sites More sharing options...
Leather Knight Posted May 22, 2008 Author Share Posted May 22, 2008 Now if I can figure out a way to have a message box popup if nothing is found, then return to showing all records when clicking "OK" rather than the standard FM modify box it will be perfected...B) Link to comment Share on other sites More sharing options...
mr_vodka Posted May 22, 2008 Share Posted May 22, 2008 See the modified file I posted today on an earlier thread. It has steps in there that will do exactly what you are looking for. http://fmforums.com/forum/showpost.php?post/291721/ Link to comment Share on other sites More sharing options...
Leather Knight Posted May 22, 2008 Author Share Posted May 22, 2008 I must be missing something and banging my head is not working, just cracking the wall...If someone would take a look and see why my search is not working, I would appreciate it. It is a custom app for a friend. The input field is gSearchString. Aquisitions.zip Link to comment Share on other sites More sharing options...
mr_vodka Posted May 22, 2008 Share Posted May 22, 2008 Now if I can figure out a way to have a message box popup if nothing is found, then return to showing all records when clicking "OK" rather than the standard FM modify box it will be perfected... Set Error Capture [On] Enter Find Mode [] Set Field [ Aquisitions::cAllDescriptions; Aquisitions::gSearchString] Perform Find [] If [ NOT Get ( FoundCount ) ] Show Custom Dialog [ "No Records"; "No Records Found" ] Show All Records End If BTW, your gSearchString field in your file needs to be changed to a global field and in your script the set field does not have to be from Aquisitions2::cAllDescriptions. Link to comment Share on other sites More sharing options...
Leather Knight Posted May 22, 2008 Author Share Posted May 22, 2008 Thanks amigo, exactly, save one thing...the search does not work still... It all looks right. have a look. Aquisitions.zip Link to comment Share on other sites More sharing options...
mr_vodka Posted May 22, 2008 Share Posted May 22, 2008 Set Error Capture [On] Enter Find Mode [] Set Field [ [color:red]Aquisitions::cAllDescriptions; Aquisitions::gSearchString] Perform Find [color:red][] If [ NOT Get ( FoundCount ) ] Show Custom Dialog [ "No Records"; "No Records Found" ] Show All Records End If Link to comment Share on other sites More sharing options...
Leather Knight Posted May 22, 2008 Author Share Posted May 22, 2008 (edited) Brain farts... I got it now. Thanks... Edited May 22, 2008 by Guest Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5843 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now