"Zabach, Elke" <[EMAIL PROTECTED]> ha scritto nel messaggio B9A2DDA03044D311BBD40008C75D69680DBAB330@dewdfx24">news:B9A2DDA03044D311BBD40008C75D69680DBAB330@dewdfx24... > Because both locks are share (select) - locks, which do not collide. > Only exclusive (insert/update/delete) - locks collide with share or other > exclusive locks. > To disallow any other user to select a record, you have to lock it exclusive.
Elke, thank you. What I'm trying to do is: select a record for update it. I want other users can read that record but not select it to modify it before I update it or I rollback the transaction. There is a method to do this without using SqlMode=uncommitted? Something like recordversioning like Interbase/Firebird has? -- Andrea Chiad� Piat Bit Informatica s.r.l. Progettazione e Sviluppo _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
