Search results

  1. R

    Locking & Transactions : ODBC to Progress 9.1E w/ DATADIRECT 4.10

    I've tried every isolation level. First I tried by modifying the isolation level as defined in the windows odbc dsn setup -- then I tried by modifying my connection strings (I'm connecting using C# .NET) in my code. In every case I could not hold a lock for any period of time beyond the read...
  2. R

    Locking & Transactions : ODBC to Progress 9.1E w/ DATADIRECT 4.10

    Hello, I'm hoping someone can shed some light on the ability to lock rows in Progress via ODBC. In short I'd like to be able to do some pessimistic locking. This works using sqlexp on our server with a transaction of the form: SELECT x,y FROM TABLE z WHERE ... FOR UPDATE; UPDATE z SET...
  3. R

    Handle locks via ODBC for update (or insert)

    Hello, I have a question about locking in the other direction. Unless I am incorrectly setting up the isolation level of my connections I don't seem to have any luck in holding a lock myself. Here is my question: if I want to update a row in a table, is there any way for me to lock that row in...
Top