Re: Deleting records from Filemaker (continued)
Re: Deleting records from Filemaker (continued)
- Subject: Re: Deleting records from Filemaker (continued)
- From: Ehsan Saffari <email@hidden>
- Date: Fri, 21 Sep 2001 16:20:17 -0600
tell application "FileMaker Pro"
set daList to {"Apple Applet Runner", "Keychain Scripting", "Apple
Verifier"}
tell document 1 --acts on the found set
repeat with x in daList
try
delete (every record whose cell "Software" is x)
on error number -1728 --object not found
end try
end repeat
end tell
end tell
cheers
ehsan
On 21/09/2001 Mike Tuller <email@hidden> wrote:
>
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