Navigation:  Advantage SQL > System Procedures > Procedures >

sp_mgGetAllLocks

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Returns a result set containing all record numbers of records that are locked in the given table.

Syntax

EXECUTE PROCEDURE sp_mgGetAllLocks( TableName,Character,255 )

Parameters

TableName (I)

Fully qualified path to the table.

LockedRecNo (O)

Record Numbers of locked records.

Remarks

This procedure returns a result set containing all record numbers of records that are currently locked in the given table. To view the name of the user that has a particular record locked, use the sp_mgGetLockOwner procedure.

Note With the Advantage Local Server, sp_mgGetAllLocks will only return information about locks instantiated by the instance of Advantage Local Server currently loaded into memory. Information about locks instantiated from other instances of Advantage Local Server will not be returned.

Example

EXECUTE PROCEDURE sp_mgGetAllLocks( '\\server\share\data\table.adt' );

See Also

sp_mgGetLockOwner

sp_mgGetUserLocks