Subject Re: Referencing "active" as a column name
Author csswa
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?

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

--- 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
> 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
> 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
> fail:
> ALTER TABLE ProgCat ALTER "active" TO isactive
> ALTER TABLE ProgCat DROP "active"
> Any guidance here would be much appreciated.