A.Beermannpiepenbrock.de
Date: Fri Feb 18 2005 - 01:58:54 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello everbody

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

Albert

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]