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   ??????
> 

The problem is that rowid contains the single quote as part of the
value. It is not just an output-behaviour of a tool.

--> to ask for a string containing single quote the single quote has to
be doubled and the string, of course, surrounded by single-quotes. In
this case, where the single quotes are in the beginning and the end of
the string the result looks funny:

rowid = '''10002'''

But then the row is found.

Elke
SAP Labs Berlin

> 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
> 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