on 5/30/03 7:04 AM, Steven H. Blackwell at [log in to unmask] wrote:

> 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:
>
> show (every record of database 1 whose cell "x" contains "y" and cell
> "x2" does not contain "y2")
>
> 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

Has FMP 6.0v4 fixed the notorious "whose" bug that's been dogging scripters
on this list for many moons, then? Is there a FMP 6.0v4 Unlimited? I don't
see an upgrade on FMP's web site for it. I see FMP and Developer, but not
Unlimited.

The whole "whose" bug question was hotly disputed last year, with some
scripters claiming they'd never had a problem with this. I was in quiet
agreement with them up till moving to OS 10.2.x. I never had trouble with
"whose" in OS 9.2.2 and any incarnation of FMP from 5.0-6.0v1. Now, with OS
10.2. and FMP 6.0v1, I can't run "whose" commands reliably. They work
sometimes, but blow up FMP too often to risk using in production.

I'm suspicious that this phenomenon might indicate a conflict with some
popular osaxen or some such, since it's not universal.

- WES