Re: Delete records in Filemaker
Re: Delete records in Filemaker
- Subject: Re: Delete records in Filemaker
- From: David Simerly <email@hidden>
- Date: Thu, 20 Sep 2001 22:49:49 -0700
- Homepage: http://homepage.mac.com/beowulf/
on 9/20/01 10:04 PM, Mike Tuller at <email@hidden> wrote:
>
I want to delete records in a filemaker database that contain certain
>
information in a particular cell. Can anyone give me some direction on how
>
to do this? I can't find any examples of this on the web.
tell application "FileMaker Pro"
-- address command to a specific DB
tell database "Sample05.fp5"
-- show all
show every record
-- delete records matching a certain criteria
delete (every record whose cell "Company" contains "ABC")
end tell
end tell
This information and more is in the Apple Events Reference database that
ships with FMP. HTH.
DS
___________________________________
Ever Wonder: Why is lemon juice made with artificial flavor, and dishwashing
liquid made with real lemons?