Jan Hlavatýwrote: > I've found a discrepancy between documentation and actual behavior: > When I try SELECT ... FOR UPDATE, it complains about missing > OF keyword > ( -5015: Syntax error or access violation). > > But update_clause in syntaxlist lists: > > <update_clause [Extern]> ::= FOR UPDATE [OF <column_name > [Page 15]>,...] > > Which means that it should be optional???
I have to assume that you are talking about the version 7.3. For this (as written before and could be found in the archive) Usually 'FOR UPDATE' is fine, even with SAP DB. BUT If you are using ODBC or a tool using ODBC (like SQLStudio, for example) then OF is mandatory, according to ODBC-standard. The semantic of FOR UPDATE, FOR UPDATE OF and FOR UPDATE OF <columnlist> is the same. For 7.4 FOR UPDATE (without OF) is allowed even for ODBC-connections. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
