Filemaker 'whose' clause broken?
Filemaker 'whose' clause broken?
- Subject: Filemaker 'whose' clause broken?
- From: Chap Harrison <email@hidden>
- Date: Sat, 24 Jan 2004 11:49:32 -0600
Gary Lists mentioned earlier that 'whose' clauses are broken in some
versions of FMP 6.
Is there a workaround for this?
And, is the following due to a broken 'whose'? MessageID is a FMP
field that is defined as unique-valued. On an empty database it
successfully reports that there is no record with a matching MessageID
cell, and stores the record. On a second invocation of the script, I
get "FMP error: Event not handled" on the 'if' statement.
Thanks, Chap
-- begin script
set myUniqueField to "MessageID" -- field 1 in creation seq.
set myTable to "WebOrders.fp5"
set myMessageID to "11111" -- cell #1
set myMessage to "hello world" -- cell #2
set myLeadSource to "Charlie" -- cell #3
tell application "FileMaker Pro"
if (exists (record of database myTable whose cell myUniqueField is
myMessageID)) then
display dialog "Exists"
else
display dialog "Not exists."
end if
end tell
tell application "FileMaker Pro"
create new record in database myTable with data ,
{myMessageID, myMessage, myLeadSource}
end tell
-- end script
_______________________________________________
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.