Deleting records from Filemaker (continued)
Deleting records from Filemaker (continued)
- Subject: Deleting records from Filemaker (continued)
- From: Mike Tuller <email@hidden>
- Date: Fri, 21 Sep 2001 16:30:43 -0500
Thanks to all who helped me before, I forgot that Filemaker had the examples
in the install. I went to their website and couldn't find anything before.
I have another question now though. I am removing many records that are
loaded by a script created by another company. Here is what I have written.
tell application "FileMaker Pro"
activate
ignoring application responses
delete (every record whose (cell "Software" is "Apple Applet
Runner"))
delete (every record whose (cell "Software" is "Keychain
Scripting"))
delete (every record whose (cell "Software" is "Apple Verifier"))
delete (every record whose (cell "Software" is "Keychain Access"))
delete (every record whose (cell "Software" is "Network Setup
Scripting"))
delete (every record whose (cell "Software" is "Sound Scripting"))
delete (every record whose (cell "Software" is "URL Access
Scripting"))
......etc.
The problem with this way of doing it, if there isn't a record that equals
something I have in the script, the script is stopped because the object is
not found. I assume that you would create an if statement. What would be the
correct syntax for this statement. Also, is this the best way to do this
type of deleting? I have a lot of records that I want to delete, so if the
is a more efficient way, let me know.
Mike