whose statement in FMP 7
whose statement in FMP 7
- Subject: whose statement in FMP 7
- From: Heidi McMath <email@hidden>
- Date: Mon, 20 Sep 2004 10:45:15 -0500
I am in the process of converting an image database that I had in
FileMaker 6 to 7. I have always used an applescript to automate
importing folders of pictures into the database. Among other things
the Applescript tested that the image file was of the correct type and
was not already in the database. That way I could re-import the same
folder when new images had been added to it without getting endless
duplications in the database. The applescript tested for the existence
of the image in the database with a line something like this:
tell application "FileMaker Developer"
exists (every record of database "Photo DB" whose cell "cImageName" is
equal to "photo10")
end tell
In FMP 6 this returns true if there is a record with "photo10" in cell
cImageName and false if there is not allowing me to test for true or
false and allow the importation of the image or not as needed. In FMP
7 the script line returns true if the photo exists in the file but
sends back an AppleScript error saying FileMaker got an error: event
not handled, if there is no such record. I created a work around
capturing the error number in a try statement and using that to trigger
my import but I worry that since I am not sure why the event is not
handled that some other error will trigger an import. Does anyone know
why my statement is not returning false when the record doesn't exist?
I am running Mac OSX 10.3 and FileMaker Developer 7.
Heidi McMath
_______________________________________________
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