Guys,,


after the update i got a problem with the application.... the error msg is

General SQL erroe.
Invalid expression in the HAVING clause (nither an aggregate function nor a part of the GROUP BY clause).
I think I need to update the the UDF or LIB maybe

the application was working great with the FB ver. 1.0 but when I update to 2.5 I got this message.
any advice?

I have to applications (delphi) only one of them is giving the error and the other is great.

Thanks.

Ahmad sarhan

--- In firebird-support@yahoogroups.com, "mahdoom_a" <mahdoom_a@...> wrote:
>
> YESSSSSSSSSSSSSSSSSSSSSSSSS
>
> after the update to FB 2.5 and then backup & restore its wonderful,, appreciate it everyone
> svein_erling, iblogmanager, Alan.Davies, Hans
>
> Thanks all.
>
>
> --- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@> wrote:
> >
> > >> > my firebird server is V1.0.3.973 maybe its old thats why ?
> > >>
> > >> Yes. The CASE construct has been added in V1.5.
> > >
> > >I have update the FB server to 2.5 ,,,, Same problem :(
> >
> > Because your database still has an old ODS? Fb 2.5 can still open old Fb versions, but you don't get access to new things (like CASE) unless you upgrade the ODS. Backup your database using gbak from Firebird 1.0 (or it might work using Fb 2.5 - I don't know) and restore it using gbak from Fb 2.5.
> >
> > HTH,
> > Set
> >
>