Perform Find problem
FM 12. I want to use Perform Find in a script to find a set of records where one field has a specific value and another field contains any value (not empty). I have tried the following:
Enter Find Mode
Set Field 1 = 10
Set Field 2 > 0
This doesn’t work. When I try to set the criteria for Field 2 with >0, the Specify Calculation dialog box gives the error message: A number, text constant, field name or “(“ is expected here”.
Is there a better way to do this?