Record and Table Locking

Acu4GL for ODBC supports record locking for multi-user systems, as long as your ODBC driver supports record locking. To complement your driver’s locking method, Acu4GL for ODBC can initiate three locking sequences:

You specify which type of locking you want to use with the configuration file variable, A_ODBC_LOCK_METHOD. However, if your driver doesn’t support locking, Acu4GL for ODBC by itself cannot provide locking.

Record locking with ODBC drivers is a semi-random activity. Different ODBC drivers have different capabilities and even implement the same capabilities in different ways. For this reason, you will have to do some experimentation to determine which locking method to specify for A_ODBC_LOCK_METHOD. Only through trial and error will you be able to determine which method will lock records in the most efficient way for your particular ODBC driver.