Does anyone know how I might do this?

Frequently, I want to create a complex search in a script, such as:

"Find all records on 7/14/2003 with either status code of 7 or 8"

In SQL-speak, this is easy:

"Select * from FILEV WHERE (

((MyDate = '07-14-2003') AND ((STCODE = '7') OR (STCODE = '8')))

);"

But I can't figure out how FM's logic works on this.

Enter Find Mode

Set Field (MyDate, 7/14/2003)

Set Field (STCODE, 7)

Duplicate Request

Set Field (STCODE, 8)

Perform Find

Note that Set Field doesn't always work as expected with date fields. Sometimes you have to use Insert Calculated Result, which means you have to be on a layout with the date field on it.

When you enter the find mode, you will need to create two find requests. The first would have a date of 7/14 and a status of 7. The second request would be the same except the status would be 8. When you perform the find it will find the records meeting that criteria. For a find (aka query) that uses AND needs to have multiple find requests.

HTH, Mike