Subject | FB2.1 reserved word problem |
---|---|
Author | Tony Christiansen |
Post date | 2009-03-23T04:16:08Z |
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?
Thanks
Tony
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?
Thanks
Tony