Subject | Re: [firebird-support] FB2.1 reserved word problem |
---|---|
Author | Helen Borrie |
Post date | 2009-03-23T04:26:58Z |
At 03:16 PM 23/03/2009, you wrote:
to do this to make the (now illegal) identifier START into "START":
ALTER TABLE TIMES ALTER START TO "START"
But, IMO, your ultimate solution was better.
./heLen
>Hi all"START" and START are two different identifiers. You would have needed
>
>I have just updated to v2.1.1 and struck a fieldname called START in one
>of my tables which is now a reserved word.
>
>I am trying to reference it so I can change the fieldname but this does
>not work
>
>SELECT "START" FROM TIMES (column unknown)
>
>but this does seem to be ok
>
>ALTER TABLE TIMES ALTER START TO NEWSTART
>
>Is this inconsistent or am I missing something?
to do this to make the (now illegal) identifier START into "START":
ALTER TABLE TIMES ALTER START TO "START"
But, IMO, your ultimate solution was better.
./heLen