I would very much appreciate some help with this problem.
Is there a sample app I could look at?

Thanks,
Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com]On Behalf Of Robert Osowiecki
> Sent: Wednesday, November 08, 2006 9:56 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Bug report: Locate on TIBOQuery with WHERE
> condition in ()
>
>
> Hello
>
> My program failed on TIBOQuery->Locate in strange circumstances with
> DynamicSQL Error -104, token unknown ")".
>
> Looking at the position of ")" token I found that it was a
> closing ")"
> in my query for:
>
> SELECT some simple join query WHERE (some conditions)
>
> When I removed () enclosing conditions, Locate() is working all
> right... I suspect that IBO's Locate function uses query constructed
> from original SQL code, but it fails on some odd queries like mine.
>
> Apart from that, by replacing old BDE code with heavy load of TTable
> objects with editable IBO queries I greatly improved aplication speed
> and our customers are delighted :)
>
> Regards,
>
> Robert.