> 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.