Re: Filemaker 'whose' clause broken? (Modified by Chap Harrison)
Re: Filemaker 'whose' clause broken? (Modified by Chap Harrison)
- Subject: Re: Filemaker 'whose' clause broken? (Modified by Chap Harrison)
- From: Chap Harrison <email@hidden>
- Date: Sun, 25 Jan 2004 02:12:46 -0600
- Resent-date: Sun, 25 Jan 2004 11:52:56 -0600
- Resent-from: Chap Harrison <email@hidden>
- Resent-message-id: <email@hidden>
- Resent-to: Applescript Users <email@hidden>
On Jan 25, 2004, at 1:40 AM, Shane Stanley wrote:
if (exists (record 1 of database myTable whose cell myUniqueField is
myMessageID)) then
This seems to work dependably.
The objective is to make sure I will not attempt to add a record with a
non-unique MessageID. Doing so generates a general "Invalid data"
error from filemaker, since MessageID is defined as "unique". I
suppose I *could* use that error as evidence that I attempted to add a
record with a non-unique MessageID, but that seems extremely unwise.
Thanks!
Chap
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.