FileMaker Whose Clauses
FileMaker Whose Clauses
- Subject: FileMaker Whose Clauses
- From: "Bourque, Jason" <email@hidden>
- Date: Sun, 19 Aug 2001 15:36:28 -0400
Hello,
I am trying to find a particular set of records but it doesn't seem to work.
It is a repeating field.
tell application "FileMaker Pro"
set columnData to {"", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""}
set column1Data to {"", "", "", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", ""}
tell document mainDatabase
-->>>>>>>>>>>>>>>This works fine
show (every record whose cell "Create Excel" = "Yes" and cell "Chart Type" =
"Table")
-->>>>>>>>>>>>>>>But this doesn't Any idea's
show (every record whose cell "Column" = columnData and cell "Column 1" =
column1Data)
end tell
end
Also once I get this part to work how do I set the cell of every record in
this show to a new value. Repeat loop?
Thanks,
Jason Bourque
Senior Script Developer
Publishing Automation
MFS Investment Management
617-954-5312