Highlighted
Absent Member.
Absent Member.
448 views

ACUSQL - Locking records and unlocking records

[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?
0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

RE: ACUSQL - Locking records and unlocking records

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.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.