Find this...

[Leather Knight]

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?

[mr_vodka]

See here.

http://www.fmforums.com/forum/showtopic.php?tid/195128

[Leather Knight]

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...

[mr_vodka]

What happens if you do a manual find in the calc field?

[Leather Knight]

If I go into find mode, type in the name I am looking for, then hit find, it doesn't find anything either.

[mr_vodka]

What does your calc look like?

[Leather Knight]

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..

[Leather Knight]

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)

[mr_vodka]

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/

[Leather Knight]

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

[mr_vodka]

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.

[Leather Knight]

Thanks amigo, exactly, save one thing...the search does not work still... It all looks right. have a look.

Aquisitions.zip

[mr_vodka]

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

[Leather Knight]

Brain farts... I got it now. Thanks...

Edited May 22, 2008 by Guest