• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Filemaker: whose cell is... doesn't search exact
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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>
________________________________________________


  • Follow-Ups:
    • Re: Filemaker: whose cell is... doesn't search exact
      • From: cris <email@hidden>
References: 
 >Filemaker: whose cell is... doesn't search exact (From: cris <email@hidden>)

  • Prev by Date: Re: Does Quark 3.32 support Program Linking
  • Next by Date: Re: Shutdown script for apple Mac
  • Previous by thread: Filemaker: whose cell is... doesn't search exact
  • Next by thread: Re: Filemaker: whose cell is... doesn't search exact
  • Index(es):
    • Date
    • Thread