Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
select from domain.locks?????
Date: Fri Feb 18 2005 - 01:58:54 CST
Before passing a data record to my application, i want to prove wether
the record is locked from another user.
user1 did : select * from xyz where recid = '10002' with lock optimistic
(recid is the tablekey type char(10)!!)
now in the domain.locks there is one record
with sql studio i can do:
select * from locks where tablename = 'xyz'
result = 1 record with tablename = xyz without quotation marks and
rowid ='10002' with single quotation marks ???
before user2 works with the same record i want to warn him, therefore i
want to do:
select * from locks where tablename = 'xyz' and rowid = '10002'
but no result ??????
what is the correct sql-syntax to prove wether there is a record in the
locks table for a tablename, keyvalue combination ??
Any help welcomed
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb