Re: Scripting FMP find
Re: Scripting FMP find
- Subject: Re: Scripting FMP find
- From: Bill Ferguson <email@hidden>
- Date: Fri, 26 Apr 2002 10:58:43 -0700
>
Does anyone know if I can define a search criteria in a script in
>
FMP 5. I can change to the Find Mode and execute a find but I
>
can't find a way to define what criteria I want to find in the
>
script.
>
>
Eric
hi eric,
dave told you how to do it from applescript. If you're trying to do it
from Filemaker, there are different ways to save a search criteria,
here's the easiest:
1. do the search, once, manually; go into find mode, type in the
criteria, perform find, make sure it's finding what you want
2. go into your script (or create new one)
3. choose command: Perform find Select option "restore find requests"
click OK and Done. that's it, you're finished. What happens is: The
script saves the most recent find (the one you've just done.)
if you print the script, you can see what you've saved in the find step.
otherwise you can't see those criteria while editing scripts in
scriptmaker
Bill Ferguson
www.jubileeusa.org
A worldwide campaign to cancel the crushing burden of debt of the most
impoverished countries.
----------------------------
dave dowling says:
>
>
you can specify your FMPro find from AppleScript in the following
>
manner:
>
>
tell application "FileMaker Pro"
>
show every record in database "myDatabase.fp5" whose cell
>
"myFieldName" contains "myTextToFind"
>
show every record in database "myDatabase.fp5" whose cell
>
"myNumberField" > 10
>
show every record in database "myDatabase.fp5" whose cell
>
"myDateField" < "01/01/2001"
>
end tell
>
>
hope this helps.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.