Subject | Interbase to Firebird conversion error |
---|---|
Author | Marcelo Siqueira |
Post date | 2004-11-24T18:28:42Z |
I'm trying to convert a database from Interbase 6 to Firebird 1.5 but I
got a strange error here.
This is what I did:
I backuped my database file, then I uninstalled Interbase and installed
Firebird 1.5 (Firebird-1.5.1.4481-Win32.exe). After that I went to
IBConsole and restored my file into a new .fdb file. This new database
opens ok on IBConsole, it shows all the table names, but when I
double-click in any of the tables to see its data I got the error:
Dynamic SQL Error
SQL error code = -104
Invalid expression in the ORDER BY clause (not contained in either an
aggregate function or the GROUP BY clause)
So far, I had to return to use Interbase 6.
Does somebody knows what is wrong here?
Thanks!
Marcelo
got a strange error here.
This is what I did:
I backuped my database file, then I uninstalled Interbase and installed
Firebird 1.5 (Firebird-1.5.1.4481-Win32.exe). After that I went to
IBConsole and restored my file into a new .fdb file. This new database
opens ok on IBConsole, it shows all the table names, but when I
double-click in any of the tables to see its data I got the error:
Dynamic SQL Error
SQL error code = -104
Invalid expression in the ORDER BY clause (not contained in either an
aggregate function or the GROUP BY clause)
So far, I had to return to use Interbase 6.
Does somebody knows what is wrong here?
Thanks!
Marcelo