InterBase and Firebird 1.0 sometimes accepted "inconsistent selects"
without reporting error, and returning sometimes inconsistent data. FB
1.5 check this and reports the error you are talking about. You need
to correct your select to be able to run it.

Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br



MS> I'm trying to convert a database from Interbase 6 to Firebird 1.5 but I
MS> got a strange error here.

MS> This is what I did:

MS> I backuped my database file, then I uninstalled Interbase and installed
MS> Firebird 1.5 (Firebird-1.5.1.4481-Win32.exe). After that I went to
MS> IBConsole and restored my file into a new .fdb file. This new database
MS> opens ok on IBConsole, it shows all the table names, but when I
MS> double-click in any of the tables to see its data I got the error:

MS> Dynamic SQL Error
MS> SQL error code = -104
MS> Invalid expression in the ORDER BY clause (not contained in either an
MS> aggregate function or the GROUP BY clause)

MS> So far, I had to return to use Interbase 6.

MS> Does somebody knows what is wrong here?

MS> Thanks!
MS> Marcelo







MS> Yahoo! Groups Links