> 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

Try it more often Steven. It doesn't take long until a whose clause crashes
your file. Frequently it requires that the resulting file be recovered.