If locked... with SQL-92

[rguerrer]

Hi everyone, i have two questions about locks and transaction.

I am developing an application in ASP.NET connected to a Progress DB 10.0B throu DataDirect ODBC.

I am using READ UNCOMMITED Isolation because i have to update data.

1.- In progress i use the sentence "IF LOCKED..." to send a message to users when try to update a lock record. ¿In SQL-92 how can I do this?

2.- In progress i use the sentence "DO TRANSACTION..." to prevent data corruption and protect data integrity. ¿In SQL-92 how can I do this?

If someone has experience with this.. I apreciate your help.

Thanks.

 

[tboogerd]

I need to know the same thing. Does anyone know how to do this?