hi!

I would like to perform a search with a script that looks in all fields and shows only the record corresponding to the searh condition.

e.g: I have search field and if I write a number in it the script searches all the fields and retrievs only the record that is holding this number.

so, how do I do it?

Hi,

Use the as many "New Request" as the number of fields you are searching for, within the script lines.

Do you mean you want to search in every field of every record for one number?

Or do you just want to search every record to find those in which that number is in one particular field?

If the latter, a simple search is all you need.

If the former, create a global field in which the "search number" goes. Then write a script:

Enter Find Mode -- uncheck "Restore" and "Pause"

Set Field (Field1, GlobalField) -- this places the contents of the global field into one field

New Record/Request/Page

Set Field (Field2, GlobalField)

etc., until all fields have been filled in, each in its own request.

Perform Find -- make sure "Restore" is unchecked.

That'll do it.