Method ClearAllKeys

Namespace

Skyline.DataMiner.Scripting

Assembly

SLManagedScripting.dll

ClearAllKeys(int)

Removes all rows from the specified table.

object ClearAllKeys(int tableId)

Parameters

tableId int

The ID of the table parameter.

Returns

object

• Starting from DataMiner 10.5.6/10.4.0 [CU15]/10.5.0 [CU3] (RN 42368): -1 In case the ClearAllKeys method has been invoked specifying an empty table, 0 if clearing succeeded, otherwise 1.
• Prior to DataMiner 10.5.6/10.4.0 [CU15]/10.5.0 [CU3]: The number of rows left. In case the ClearAllKeys method has been invoked specifying an empty table, -1 is returned.

Remarks

• Prior to DataMiner 10.1.1 (RN 27995), this method was defined as an SLProtocol extension method in the NotifyProtocol class.
• Starting from DataMiner 10.5.6/10.4.0 [CU15]/10.5.0 [CU3] (RN 42368): This method first retrieves all primary keys from the table using a NotifyProtocol type 397 call (NT_GET_KEYS_SLPROTOCOL). If there is at least one primary key present, the method performs a NotifyProtocol type 474 (NT_CLEAR_PARAMETER) call, removing all rows.
• Prior to DataMiner 10.5.6/10.4.0 [CU15]/10.5.0 [CU3]: This method first retrieves all primary keys from the table using a NotifyProtocol type 168 call (NT_GET_INDEXES). If there is at least one primary key present, the method performs a NotifyProtocol type 156 call (NT_DELETE_ROW), removing all rows.