May 22, 200817 yr 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?
May 22, 200817 yr Author 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...
May 22, 200817 yr Author If I go into find mode, type in the name I am looking for, then hit find, it doesn't find anything either.
May 22, 200817 yr Author 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..
May 22, 200817 yr Author 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)
May 22, 200817 yr 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/
May 22, 200817 yr Author 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
May 22, 200817 yr 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.
May 22, 200817 yr Author Thanks amigo, exactly, save one thing...the search does not work still... It all looks right. have a look. Aquisitions.zip
May 22, 200817 yr 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
Create an account or sign in to comment