AppleScript and FileMaker 7 Examples
AppleScript and FileMaker 7 Examples
- Subject: AppleScript and FileMaker 7 Examples
- From: "Tim Cimbura" <email@hidden>
- Date: Tue, 9 Aug 2005 09:01:13 -0700
Can anyone suggest a good source of FileMaker 7 AppleScript examples? I've had a difficult time finding any on the internet. There are some major changes in 7 with how a database is references since there can be multiple tables within one file.
Those on this site do not show any examples of finds, etc.
http://www.fmpromigrator.com/downloads/demo_software/index.html#fmpro_migrator_demo
I haven't found much else anywhere.
I've heard the the "whose" clause does not work well and it proves to be the case in my experience.
For example, the following script...
tell application "FileMaker Pro"
tell database "TPS_ItemStatus"
-- The following line is the original "whose" line that is unreliable
set ItemList to (first record of table "Items" whose cell "Test" is equal to "find text")
-- Following is code that does not work...trying to replace the line above doing it a different way
delete every request
create new request at end
set cell "Test" of request -1 to "find text"
find
-- set ItemList to records of found set -- Is this possible?
end tell
-- display dialog ItemList -- Errors out and shows the list
end tell
I want to change those lines of code to equivalent find requests or go to related records code (to get a faster find)...but I'm having a difficult time getting it to work or finding some example code to follow.
Thanks for any help you can provide.
Tim
--------------------------
Tim Cimbura
16488 - 83rd Ave N
Maple Grove, MN 55311-1846
763-420-7083
612-298-0086 Mobile
email@hidden
http://www.cimbura.com
_______________________________________________
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