Nice "shot." Thank you. That was exactly what I was ignoring. This is
another migration issue I'll just have to get used to in moving from
Sybase to Firebird.

Mark Shapiro

--- In ib-support@y..., "Artur Anjos" <arsoft@n...> wrote:
> One shot in the darkness: did you check for case differences? ie,
"active",
> "Active","ACTIVE"
>
> Artur
>
> ----- Original Message -----
> From: "ohfrabjousday" <infocus@s...>
> To: <ib-support@y...>
> 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.
> >