DQQuestion
New Member
i am using this connection string to access data from a .NET Application through ADO.NET.
strConnection ="DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1D};WorkArounds2=4096;UID=SYSPROGRESS;DB=Sports2000;PORT=4500;
HOST=localhost;PWD=ODBC-Access"
I need to set the "NOLOCK" in my select statment.
for example: SELECT * FROM PUB.Department NOLOCK. this statement is runing well . BUT in case of a JOIN statement or in case i want to use a table Alias , an exception occurs.
So, i need the know how to use the locking in my statements(with table alias , Joins,...)
NB: SQL explorer can be used for testing instead of the ADO.NET.
thanks
strConnection ="DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1D};WorkArounds2=4096;UID=SYSPROGRESS;DB=Sports2000;PORT=4500;
HOST=localhost;PWD=ODBC-Access"
I need to set the "NOLOCK" in my select statment.
for example: SELECT * FROM PUB.Department NOLOCK. this statement is runing well . BUT in case of a JOIN statement or in case i want to use a table Alias , an exception occurs.
So, i need the know how to use the locking in my statements(with table alias , Joins,...)
NB: SQL explorer can be used for testing instead of the ADO.NET.
thanks