SQL update position
SQL update position
- Subject: SQL update position
- From: Ian Joyner <email@hidden>
- Date: Fri, 9 Mar 2007 15:33:22 +1100
I have just found that the statement:
UPDATE <table> SET POSITION = <value>
gives the error:
SQL ERROR - [position 13, near '' in 'ATE MEMBER SET POSITION =']
update error: SET expected but not found.
The following works:
UPDATE <table> SET OTHER_FIELD = >value>, POSITION = <value>
Seems that POSITION is a reserved word in SQL-92 but not 99 or 2003
(according to a table on the Web http://developer.mimer.com/validator/
sql-reserved-words.tml).
Above its reservedness depends on context it seems, and since WO
generates the fields in the order it sees fit, I can't guarantee that
POSITION won't come after SET.
Is WO using the SQL-92 standard? I'm using OpenBase so for those SQL
gurus out there (now come on you know who you are), should this be
reported as a bug to OpenBase? Or is OpenBase working correctly
according to the standard?
Thanks
Ian
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden