Subject | Bug report: Locate on TIBOQuery with WHERE condition in () |
---|---|
Author | Robert Osowiecki |
Post date | 2006-11-08T16:55:33Z |
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.
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.