rguerrer
Member
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.
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.