Subject Re: [firebird-support] After moving firebird 1.0 to 2.0 : SQL error code = -104
Author Helen Borrie
At 06:21 AM 9/03/2007, you wrote:
>Hi,
>
>I just moved the database from firebird 1.0 to 2.0. It seems that
>everything
>is working except that I got error like
>
>"
>SELECT EMAIL
>FROM XW_EMAIL
>WHERE WID = ?
>
>: GDS Exception. Dynamic SQL Error
>SQL error code = -104
>Token unknown - line 1, char 260
>CHARACTER_LENGTH
>"
>I did not change any javacode as the program is in a different machine.
>
>I would appreciate any help.

CHARACTER_LENGTH is a reserved word in Fb 2. Find the whole of the
statement that is going to the database after the parameter
substitution has occurred and see whether you have this token there
at the reported position.

./heLen