Subject Re: Problem with query after upgrade FB 2.1x to 2.5.1
Author Ron
Mark,

Good suggestion. Svein Tysvær noted that changing a setting in IB Objects might solve the problem and it did.

Thanks again for the suggestion. I appreciate it.

Rick

--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> 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
>