Re: FM question: Omit in find (fifth attempt)
Re: FM question: Omit in find (fifth attempt)
- Subject: Re: FM question: Omit in find (fifth attempt)
- From: Shane Stanley <email@hidden>
- Date: Tue, 14 Nov 2000 08:47:50 +1100
On 14/11/00 8:19 AM +1000, Max Bonilla, email@hidden, wrote:
>
Would someone please tell me how to omit a number of records in a
>
find command within AS? I'm trying to have FileMaker do the following
>
>
show (every record whose cell "Class" is gCourseTitle and cell "Type"
>
is gExamType and cell "SubType" is QuestionType)
>
>
But have two course titles (gCourseTitle) with similar names
>
("Studies" and "Synoptic Studies"). When gCourseTitle = "Studies" I
>
want to have FM exclude any cell "Class" that contains "Synoptic
>
Studies" leaving only those that contain "Studies". I can't find
>
info in the Dictionary. Am I clear?
What you're after, I think, is an exact match -- like you get in a UI find
with "==Studies". Try this:
tell application "FileMaker Pro"
tell database 1
delete every request
create new request
set cell "Class" of request 1 to ("==" & gCourseTitle)
set cell "SubType" of request 1 to QuestionType
find
end tell
end tell
--
Shane Stanley, email@hidden