AW: select from domain.locks?????

A.Beermann@xxxxxxxxxxxxxx wrote:
> 
> 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 ??
> 
> 
Your question is one of those where one should ask for the real problem,
not help to solve a problem in a special way, the customer asks for.

Do you want to warn users if other users have share locks? Or do you
want to warn if there is an exclusive lock on this record and the
records values will change / changed just at that moment?

You want to see even uncommitted data (otherwise you never will see rows
having an exclusive lock)?

Please tell us what your needs/restrictions are and not so much about
the way you try to handle them. Then, I think, we will be able to help
much better.

Elke
SAP Labs Berlin

> Any help welcomed
> 
> Albert
> 
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx