Physical Locking - MSSQL (Magic xpa 4.x)

A physical lock is a method that ensures that no one else can modify a record that is currently locked.

Specifically, from the moment a user locks the record until that user releases the record, the record cannot be modified by another user. The physical lock is implemented as follows: When Magic xpa locks a record according to its locking strategy, Magic xpa issues a Select statement with a UPDLOCK hint.

The UPDLOCK hint prevents other applications from making changes to the record until the end of the transaction.

Logical locking is also available by using the flag

SQL_PHYSICAL_LOCKING=N.