Hello Dmitry, You're right it was something in IB Objects. Svein Tysvær suggested I set the KeyLinksAutoDefine to false. I did and the query worked as written.
Thanks for your help. Ron --- In [email protected], Dmitry Kuzmenko <kdv@...> wrote: > > Hello, Ron! > > Monday, April 9, 2012, 11:45:38 AM, you wrote: > > R> Tools: Delphi 2006, IB Objects 4.9.14 > > R> Query: > R> SELECT (COUNT(*)+0.00)/2 as "LabelsCount" > R> FROM LABELS > > R> previously worked. Now I get an error: > > yes, and it perfectly works on Firebird 2.5.0 and > 2.5.1 - just checked. > > Seems that something in IBObjects or your application > executes another query in addition, resulting that > strange error message. > > So, the reason of error is not in the upgrading FB. > > -- > Dmitry Kuzmenko, www.ib-aid.com >
