Helen,

Thank you for your quick response. This is simple statemenet:

SELECT EMAIL
FROM XW_EMAIL
WHERE WID = 3211

There is no field called "CHARACTER_LENGTH". The query is running
fine, except in my java code.

Any other thought?

Jw

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> 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
>