[EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
