One shot in the darkness: did you check for case differences? ie, "active",
"Active","ACTIVE"

Artur

----- Original Message -----
From: "ohfrabjousday" <infocus@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, June 09, 2002 6:30 PM
Subject: [ib-support] Referencing "active" as a column name


> 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.
>