Check if specified record exists (in script)

[jamin24b]

I am working in a script and want to find a record whose field equals a certain value. How can I view the results of this search and determine if there were results at all from within a script?

Would I have to enter find mode, etc.?

[IdealData]

Check out "Error Capture".

Basically when you instigate error capture (Scrip step: Set Error Capture [ON]) then you can catch the error number generated on the following line of your script with a conditional (If/EndIF) using the GetLastError function in your calculation.

There's a full list of error codes in the online help system.

[aldipalo]

Here's a simple find script that MAY answer your question. Change it anyway you want. Notice the Set Field Command. That's where you enter your criteria.

HTH

Al

Sorry, I attached the wrong script and I can not get connected to the download site to change it. I'll do so as soon as I can.

OK. This is the correct one.

HTH

Simple_find_script.pdf

[jamin24b]

Thanks for your help, I've gotten it to work.