Hello all,
This statement fails with:
General error;-5016 POS(63) Missing delimiter: =.
UPDATE PNCVS_session_info
SET PNCVS_session_info.pn_lastused = 1035422696
WHERE PNCVS_session_info.pn_sessid =
'691372cb2546b8d98e47630424bcbaa7'
This statement executes successfully:
UPDATE PNCVS_session_info
SET pn_lastused = 1035422696
WHERE PNCVS_session_info.pn_sessid =
'691372cb2546b8d98e47630424bcbaa7'
Fromn the manual:
UPDATE Statement
The UPDATE statement changes column values in table rows.
Syntax
<update_statement> ::=
UPDATE [OF] <table_name> [<reference_name>] SET <set_update_clause>,... [KEY
<key_spec>,...] [WHERE <search_condition>]
| UPDATE [OF] <table_name> [<reference_name>] (<column_name>,...) VALUES
(<extended_value_spec>,...) [KEY <key_spec>,...] [WHERE <search_condition>]
| UPDATE [OF] <table_name> [<reference_name>] SET <set_update_clause>,... WHERE
CURRENT OF <result_table_name>
| UPDATE [OF] <table_name> [<reference_name>] (<column_name>,...) VALUES
(<extended_value_spec>,...) WHERE CURRENT OF <result_table_name>
SET UPDATE clause
Syntax
<set_update_clause> ::= <column_name> = <extended_expression>
| <column_name>,... = (<extended_expression>,...)
| (<column_name>,...) = (<extended_expression>,...)
| <column_name> = <subquery>
| (<column_name>,...) = <subquery>
So it looks like table identifier is not allowed before column name in UPDATE
stmt?
Or am I missing somethig (sure hope so...)
Thansk for your suggestions,
Regards,
--
Yours, Andrej Falout, http://www.falout.com/disclaimer.html
Visit the OpenSource alternative, Aubit 4gl: http://aubit4gl.sourceforge.net
PLEASE NOTE: All HTML email sent to me WILL BE DELETED AUTOMATICALLY WITHOUT
READING.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
