Re: sql blocking problem.

From: dulem <member_at_dbforums.com>
Date: 11 Jul 2002 06:15:51 GMT
Message-ID: <3d2d2297$1@usenetgateway.com>

try to reserve record before you update it. You can reserve record by the following SQL statement: SELECT ...(whatever you want).. FROM ..(tablename).. FOR UPDATE OF ...(column name)... NOWAIT; if required record is locked - you will get exception, thus you must wait until record is released. otherwise you may procede with your update statement. regards, DUSAN MARJANOV macko_at_eunet.yu

--
Posted via dBforums
http://dbforums.com

Received on Thu Jul 11 2002 - 01:15:51 CDT