FileMaker Scripting Query
FileMaker Scripting Query
- Subject: FileMaker Scripting Query
- From: Steve Thompson <email@hidden>
- Date: Fri, 22 Mar 2002 11:31:13 +0000
I have a database that contains 6990 records. If I run this script
tell application "FileMaker Pro"
tell database "Item_.fp5"
activate
try
show (every record whose cell "rangecode" is "WSS1")
end try
set tmp to the count of records
display dialog tmp
end tell
end tell
I get a dialog box that says "47" which is correct. When I click OK and go
to FileMaker, the database shows the found set. Simple and perfect.
However, if I change the script slightly:
tell application "FileMaker Pro"
tell database "Item_.fp5"
activate
try
show (every record whose cell "rangecode" is "WSS1" and cell
"easycode" is "B4D1")
end try
set tmp to the count of records
display dialog tmp
end tell
end tell
I should get a dialog box that says "1" but I don't. It finds all the
records and displays a dialog box that says "6990". I have also found that
show (every record whose cell "rangecode" is "Banana")
Produces 0 records as it should, but
show (every record whose cell "rangecode" is "Banana" and cell "easycode" is
"Steve Jobs")
Also finds every record although there are no records like this in the
database.
Assumption: The instructions supplied with FileMaker are wrong or that
method doesn't work. Could someone give me a pointer? My actual finished
script will read...
show (every record whose cell "rangecode" is (item mk1 of theStyle) and cell
"easicode" is (item mk2 of theProduct))
Thanks in advance
Steve
_______________________________________________
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.