Limit search in script

#1

Hi

I just made the following script with help from this group :-)

Go to Layout ["Database" (Table)]
Enter Find Mode []
Insert Calculated Result [Select; Table:

ate; Get (CurrentDate) - 7 & "..."
& Get (CurrentDate)]
Perform Find []
Sort Records [Restore; No dialog]
Enter Preview Mode [Pause]
Enter Browse Mode []
Go to Layout [original layout]

All the right records are shown this way, however I would like to limit the
search, so that all the records, which do not contain anything in the field
Table::Made by are not shown.

Does anybody know how?

Thanks

Daniel

#2

Quote:

Go to Layout ["Database" (Table)]
Enter Find Mode []
Insert Calculated Result [Select; Table:

ate; Get (CurrentDate) - 7 &
"..."
& Get (CurrentDate)]

New Record/Request
SetField( Table::Made, "=")
Omit Record/Request

Perform Find []
Sort Records [Restore; No dialog]
Enter Preview Mode [Pause]
Enter Browse Mode []
Go to Layout [original layout]

The modification above will exclude all records which are empty in
Table::Made.

Apart from using a new request, you might use a 'SetField (Table::Made,
">= 0") instead, which may return the same result, but which may depend
on your actual field type and contents (especially numbers vs. text).

Hi Martin

Thank you very much for your help!

/Daniel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Limit search in script

comp.databases.filemaker comp.databases.filemaker

Limit search in script - 07-07-2005 , 08:59 AM

Re: Limit search in script - 07-08-2005 , 10:56 AM