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: Max Bonilla <email@hidden>
- Date: Wed, 15 Nov 2000 11:54:52 -0600
Xandra,
Thanks for your suggestion. Unfortunately, this did not work for me
(FM 3.0v2). I keep studying the problem and will appreciate any
other ideas you or others might have. At the moment both "Synoptic
Studies" and "Studies" are lumped together in the result find, which
is not what I want.
Thanks.
Max
Max,
changing line 5 of Shanes script to:
set cell "Class" of request 1 to (("==" & gCourseTitle) as string)
made it work for me. (FMP v4.1v3)
HTH
xandra
Yes, I think I'm after an exact match, but I can't get there, even
with your suggestion. With "==" & gCourseTitle (i.e., "==Studies") I
get an error with the UI, and 0 with AS. If I eliminate one "=" to
"=Studies") I always get "Synoptic Studies" thrown in together. If I
try the exact text option of the find (i.e., "" or "Studies", in my
case), I get also Synoptic Studies.
Thanks for your help.
Max
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
Alixandra Leigh
AceDesign
email@hidden
------------------------------------------
Furniture:
><http://home.rochester.rr.com/alexleighs/furniture/furniture.htm>
Renderings:
><http://home.rochester.rr.com/alexleighs/interiors/interiors.htm>