Subject | Problem with SKIP keyword |
---|---|
Author | neczusia |
Post date | 2003-10-14T10:36:32Z |
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
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