I am having trouble using locks within a SELECT query. I'd like to use the SQL standard "FOR UPDATE", since I am actually porting a system from Oracle to SapDB. When I make even a simple query like:
SELECT * FROM Table FOR UPDATE I get the following error message: Missing keyword:OF [OF is the optional keyword for specifying the columns to lock. Since I want to lock all the columns, I shouldn't use OF.] The question is: can use "FOR UPDATE" in a SELECT query by itself? If not, what would it be the most similar solution? - Thanks __________________________________ Gabriele Carcassi SerializeDB DevTeam DyLogic S.r.l., via G.B. Brocchi 7/a, 20131 Milano ph. +39 02 26688231, fax +39 02 26688232 [EMAIL PROTECTED] http://serializedb.dylogic.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
