Just a shot on the dark, but try it with "SKIP".

What tool are you using ?

Artur

----- Original Message -----
From: "neczusia" <neczusia@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, October 14, 2003 11:36 AM
Subject: [firebird-support] Problem with SKIP keyword


> Hi,
>
> I have a problem with keyword 'SKIP'. I installed newer version of
> Firebird - 1.0. I have column in one of the tables named 'SKIP'. I
> cannot do anything with that column, because 'SKIP' is now new
> keyword! I want to 'move' data from that column to another and then
> drop it, but none of approaches works:
>
> 1.
> update TABLE_1 set NEW_SKIP = SKIP;
> alter table TABLE_1 drop SKIP;
>
> 2.
> update TABLE_1 set NEW_SKIP = TABLE_1.SKIP;
> alter table TABLE_1 drop TABLE_1.SKIP;
>
> 3.
> update TABLE_1 set NEW_SKIP = "SKIP";
> alter table TABLE_1 drop "SKIP";
>
> 4.
> update TABLE_1 set NEW_SKIP = 'SKIP';
> alter table TABLE_1 drop 'SKIP';
>
> 5.
> alter table TABLE_1 drop column SKIP;
>
> Any ideas?
>
> Thanks in advance,
> Neczka
>