Subject Re: [firebird-support] Problem with query after upgrade FB 2.1x to 2.5.1
Author Mark Rotteveel
On 9-4-2012 10:34, Dmitry Kuzmenko 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.
>

Ron, you could try to use the trace API to see what query is actually
being sent to the server.

--
Mark Rotteveel