--- In firebird-support@yahoogroups.com, Vlad Orlovsky
<vlad.orlovsky@...> wrote:

>
> Hi Set,
>
> I'm trying this in SQL Editor window in IB Expert:
>
> insert into USERS2(USER_ID, USER_ROLE_ID,USER_NAME)
> select USER_ID, USER_ROLE_ID,USER_NAME from USER;
>
> I'm getting:
>
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 2, column 45.
> USER.
>

Isn't USER a reserved word. (I couldn't create a table with that
name in FB 2.0, but CREATE TABLE "USER" worked ok if you really,
really want to do it.)

But isn't your table actually named USERS anyway?

Michael D. Spence
Mockingbird Data Systems, Inc.