[FX.php List] Finding ("a" or "b") and "c"

[Jeff Norris]

I don't believe this is possible directly via the XML query.

To handle more complicated finds you should consider using a script to 
do all or part of the request(s). If you are using FM7/8, you can use 
script parameters along with Constrains & Extends to do almost anything, 
including [soapbox alert] the kinds of basic query optimization that 
showed up in personal databases in the early eighties but have yet to 
appear in FM!

- Jeff Norris

Peter Mason wrote:
> Greetings,
>
> I want to perform an FMFind() function call on an FMP version 8 db 
> similar to the following (simplified) example:
>     Find records that match...
>         1) Name="abc"
>             AND
>         2) Person lives in (Province="a" OR Province="b")
>
> In other words is it possible to combine AddDBParam('-lop', 'or') with 
> AddDBParam('-lop', 'and') within a single FMFind() function call?
>
> Can anyone tell me whether this is possible and if so how?
>
> Help appreciated...
>
> _____ (-:|:-) _____
>
> Peter Mason
> ACPM PTY LTD
> Sydney, AUSTRALIA
> tel: +61 2 4655 8868
> fax: +61 2 4655 8868
> Mbl: +61 409 881 118
> email: peter at acpm.info
> __________________________
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
>