A_MSSQL_EXTRA_PROC

A_MSSQL_EXTRA_PROC can be used to keep modifications to the AcuLocks table out of transactions. This variable works by creating a separate connection for these modifications.

When this variable is set to a non-zero value, then an extra connection is used for the following three procedures:

Modifying the AcuLocks table
Modifying the AcuOpenTables table
Modifying the IMAGE data

The default value is "0" (off, false, no). A non-zero value can also be represented by "On" (true, yes).

If this variable is set to "On," the extra connection is used to send TEXT or IMAGE data to the server. The first connection is used to deliver non-TEXT and non-IMAGE data to the server. When a WRITE or REWRITE is executed, the interface program INSERTS or UPDATES the non-TEXT and non-IMAGE data by using placeholder data in the TEXT or IMAGE columns.

The TEXT or IMAGE data is then sent using the extra connection established with the A_MSSQL_EXTRA_PROC variable. If the first connection is inside a transaction, then the second connection is locked out of the row that is added or updated. The result is that it is not possible to WRITE or REWRITE records containing TEXT or IMAGE data while inside a transaction.

Notes: Large columns cannot be used in conjunction with transaction management because any column larger than 255 bytes (254 characters) is automatically converted to a TEXT or IMAGE column when the table is created.

If you have TEXT or IMAGE columns in your table, WRITEs and REWRITEs fail unless this variable is set to "On".