Subject Re: [firebird-support] FB2.1 reserved word problem
Author Helen Borrie
At 03:16 PM 23/03/2009, you wrote:
>Hi all
>
>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?

"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"

But, IMO, your ultimate solution was better.

./heLen