Recent content by rajeshdsadalkar

changed order with and where clause , it work. Thanks lot.

Thanks lot. SELECT * FROM customer WITH (READPAST NOWAIT) Looks like thisa will work but where i am adding where condition it is giving sysntax error with hint. Any idea why where clause is not working with hint in progress. SELECT column1 FROM customer WITH (READPAST NOWAIT) where (column1...

Thanks for reply. I am intested in commited data from progress so i can't change isolation level to 'Uncommited' , Any other way to avoid lock without change isolation level. rgds, Rajesh

Hi Guys, I am facing same type of issue. I am just reading records from progress database using ODBC drivers. ODBC isolation properties --> READ COMMITED SELECT COLUMN_NAME FROM TABLE_NAME WITH(NOLOCK) Whenever there is lock in progess , i got expection in my c# code. I don't understand how...