VB.NET ODBC and Locking

[GX2]

I am sorry for all the noob questions, but I am new with Progress. Does any have the syntax to control record locking in VB.NET/ODBC against a Progress database? Things like no-lock or exclusive-lock.

Thanks,

GX2

 

[tamhas]

READ UNCOMMITTED as the mode for the session to do no lock.

 

[GX2]

Is there an Progress -> ODBC Cross Reference anywhere that will detail all the Locking types? I also need to know about Exclusive locks. Where would you put the READ UNCOMMITTED in the SQL Statement?

Thanks.

 

[bugg_tb]

Where would you put the READ UNCOMMITTED in the SQL Statement?

You can set that directly in the odbc driver settings. Although I am after the same answer to that question, so if anyone knows.....

 

[GX2]

Any further ideas? Does anyone have a SQL example for syntax?