Re: Filemaker: whose cell is... doesn't search exact
Re: Filemaker: whose cell is... doesn't search exact
- Subject: Re: Filemaker: whose cell is... doesn't search exact
- From: Simon Forster <email@hidden>
- Date: Wed, 11 Jul 2001 08:59:48 +0100
on 11/7/01 2:11 am, cris at email@hidden wrote:
>
With the FM "whose cell x is y" statement i try do determine a record, but
>
the problem is that FM returns records which are not having the exact
>
requested value. For example:
>
>
<whose cell "bla" is "hello cris"> returns records with the cell value
>
"hello cris"
>
"cris hello"
>
"there cris hello"
Pretty much as you'd expect given FMP's method of indexing records.
>
I tried using the special search symbol for an exact search "==" with no
>
success. I guess that works only in the "find" command of FM.
Good to know.
>
I have to mention that i can't use the "find" command of FM since this needs
>
more than one statement (clearing and defining request) and the script is a
>
CGI, so another incoming call could override a current find which would lead
>
to false results or errors.
Use FileMaker's "transaction" command. This will prevent FMP from "breaking"
a chain of events contained within the begin transaction... end transaction
block. Be careful though. You can leave FMP in a locked state if it doesn't
receive the end transaction.
HTH
Simon Forster
________________________________________________
LDML Ltd, 4/5 Hazlitt Mews, London, W14 0JZ, UK
<tel int="+44 20 7602 9370" uk="020 7602 9370">
<fax int="+44 20 7371 6662" uk="020 7371 6662">
<
mailto:email@hidden>
________________________________________________