I've just checked :
SELECT "SKIP" FROM mytable
works.



Firebird 1.0 here.

./Maciek

>>> neczusia@... 14/10/03 11h36 >>>

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





To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/