Unlocking

From: Mike Cox <Mike.Cox_at_orchard-systems.co.uk>
Date: Fri, 4 Feb 2000 10:29:35 -0000
Message-ID: <99ED1629CF36D3118B4A00A0C9837CF33CEDD1@swan>

Maxime,

If you "update" the record(s) locked by the "select for update" it removes the locks

-----Original Message-----
From: Maxime Tardif [mailto:maxime.tardif_at_cgi.ca] Posted At: 03 February 2000 16:13
Posted To: misc
Conversation: Unlocking
Subject: Unlocking

I use the "select for update" and I must do a commit or a rollback for unlocking the record. Our problem is that we use only one connection and we
do more than one transaction but we want to post only one of them. I can't
use a transaction because the select for update is already in the transaction and I don't want to post this transaction. Do you know an other
manner for managing the lock? Received on Fri Feb 04 2000 - 04:29:35 CST