• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Deleting records from Filemaker (continued)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Prev by Date: Re: Import a picture into FileMaker without osax
  • Next by Date: RE: What's the biggest barrier to wider AS adoption?
  • Previous by thread: Deleting records from Filemaker (continued)
  • Next by thread: Re: Deleting records from Filemaker (continued)
  • Index(es):
    • Date
    • Thread