FASTEST Record Find with FileMaker Pro 7?
FASTEST Record Find with FileMaker Pro 7?
- Subject: FASTEST Record Find with FileMaker Pro 7?
- From: Jason Bourque <email@hidden>
- Date: Tue, 08 Mar 2005 20:42:46 -0500
Hello,
I have a script that uses a whose clause on a 10,000+ record database. Well
this isn't that fast. Is there a better way?
tell application "FileMaker Developer"
tell database "Catalog Item Num Index.fp7"
tell table "Text Box Archive"
with timeout of 600000 seconds
try
set vPagesFound to cell "Text Box Page Number" of
(every record whose cell "Text Box Field"'s cellValue contains
vItemNumToFind)
get vPagesFound
on error
set vPagesFound to {}
end try
end timeout
end tell
end tell
end tell
All Help Greatly appreciated!!!
Jason Bourque
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden