Eric Schult <[log in to unmask]> reports on the Dartmouth Advanced Script List:

> I'm converting some FMP 5 scripts to FMP 6 in OS X and dealing with the
> broken "whose" command that has been mentioned so many times before on this
> list.

Mr. Schult:

I don't know what issues you're having with this, but the following
script works correctly for me in FMP 6.0v4 and OS X (10.2.3)--watch the
line wraps:

tell application "FileMaker Pro"

show (every record of database 1 whose cell "x" contains "y" and cell
"x2" does not contain "y2")

set somevar to get data of every field of document 1

end tell

Or, you could use this syntax:

tell application "FileMaker Pro"
show (every record of database 1 whose cell "x" contains "y")
show (every record of document 1 whose cell "x2" does not contains "y2")
end tell


--->to return a found set of all records where cell x contains y and
cell x2 does not contain y2.  Be sure to trap for errors, e.g. no
matches, etc.


HTH

Steven

--
Steven H. Blackwell
Partner Member, FileMaker Solutions Alliance
_________________________________________
"The commitment of our Fathers is now the calling of our time."
_________________________________________
The New http://www.FMP-Power.com
One Hundred Thirty Six Countries of FileMaker Pro!!