Skip to main content

ACUSQL - Locking records and unlocking records

  • November 2, 2011
  • 1 reply
  • 0 views
D

[Migrated content. Thread originally posted on 01 November 2011]

Anyone know how to lock a record so that it cannot be updated? I have tried the FOR UPDATE in the DECLARE statement and that did not work. I used the example in the ACU manual.

I also set ARUSQL_ODBC__CURSORS to 0 That did not seem to help either.

Ideas?

    1 reply

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • November 2, 2011

    [Migrated content. Thread originally posted on 01 November 2011]

    Anyone know how to lock a record so that it cannot be updated? I have tried the FOR UPDATE in the DECLARE statement and that did not work. I used the example in the ACU manual.

    I also set ARUSQL_ODBC__CURSORS to 0 That did not seem to help either.

    Ideas?
    To clarify. I need to lock the record so a different user or session cannot update the record. The locking session/user will be updating the record and I do not want to have a conflict.


    Terms & ConditionsAccessibility statement