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