| Subject | Re: [firebird-support] FB2.1 reserved word problem |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-03-23T05:11:36Z |
At 03:43 PM 23/03/2009, you wrote:
Don't get confused between ALTER something (which is DDL) and SELECT (which is DML). DDL has stuff under the hood (SQL ops and others) that gets past the human barriers for its own purposes.
Remember to separate DDL in its own transaction and commit that transaction before you proceed to make any futher reference to the affected objects.
./heLen
>>How else could you refer to it to alter it? ;-)
>> "START" and START are two different identifiers. You would have needed
>> to do this to make the (now illegal) identifier START into "START":
>>
>> ALTER TABLE TIMES ALTER START TO "START"
>>
>
>So Firebird lets you reference a "keyword" table column in ALTER TABLE
>(to allow you to change it?) but not in SELECT?
Don't get confused between ALTER something (which is DDL) and SELECT (which is DML). DDL has stuff under the hood (SQL ops and others) that gets past the human barriers for its own purposes.
Remember to separate DDL in its own transaction and commit that transaction before you proceed to make any futher reference to the affected objects.
./heLen