Re: AS/FMP: a list of fewer than two records
Re: AS/FMP: a list of fewer than two records
- Subject: Re: AS/FMP: a list of fewer than two records
- From: Gary Lists <email@hidden>
- Date: Sat, 28 Feb 2004 02:09:53 -0500
Chap Harrison wrote [2/27/04 5:03 PM]:
>
Gary Lists has suggested several times that FMP doesn't do the 'whose'
>
clause very well, and recommends invoking filemaker scripts to do these
>
finds. I'd like that to be an absolute last resort (I have enough
>
trouble finding where I left my glasses). Do other people feel that
>
FMP's 'whose' clause is utterly broken and no good for anything? Or
>
are there specific limits within which it can be trusted?
1. I did clarify to say that the latest version of FM is pretty good...if
you call multiple-choice class of result as 'pretty good'.
2. As for the Find, I just believe (from some experience, mind) that doing
"finds" in FM native is more reliable. FM knows how it likes to produce
queries (internally, from Find Mode) and I think I should let it.
3. I have not experienced any noticeable speed difference in switching to
Find Mode (via AS, if you like) and then using the 'do script FileMaker
script "name"' style of calling a script that is already pre-populated with
the Find criteria.
4. Whose clauses become most effective (to me) when you can ask about
multiple values [something whose something is this and something else is
that], and that is where I think many of the reported problems are found.
As for your search, which is the same kind of search you will be doing many
times over the life of your data file, why NOT fix the search into FM? It
takes one or two lines of FM script, the script can be called from any other
FM script, and it can be called from AppleScript.
I think "absolute last resort" is cutting off your nose to spite your face,
as my granny says. [Especially since you're not having much luck any other
way! ;)
--
Gary
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.