What tool are you using to access your db? ISQL? IBCONSOLE?

Are you connecting as dialect3 (not dialect1) and the db was created
as dialect3?

Regards,
Andrew Ferguson
-- Neo-realist, avante-gardist, post-structuralist stuff and
thingies.

--- In ib-support@y..., "ohfrabjousday" <infocus@s...> wrote:
> I am creating my first Interbase/Firebird project by porting a large
> Sybase Adaptive Server Anywhere database. In the process, I
discovered
> that "active" is an IB keyword. Several of my tables have this as a
> column name. So I enclosed the name in double quotes and went
forward
> with the table creation process.
>
> Now when I try to reference an "active" column in DSQL, I get
a "local
> column not found error." Here are two examples of SQL statements
that
> fail:
>
> ALTER TABLE ProgCat ALTER "active" TO isactive
> ALTER TABLE ProgCat DROP "active"
>
> Any guidance here would be much appreciated.