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 [email protected], "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 [email protected], 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 > > >
