Table of Contents

NT_DELETE_ROW (156)

Removes a row from a table.

Parameters

Removing a row from the local element:

int tableID = 1000;
string primaryKey = "Row 1";

int rowCount = (int)protocol.NotifyProtocol(156/*NT_DELETE_ROW*/ , tableID, primaryKey);
  • tableID (int): ID of the table parameter.
  • primaryKey (string): Primary key of the row that needs to be removed.

Removing a row from a remote element:

uint[] ids = new uint[3];
ids[0] = (uint)protocol.DataMinerID;
ids[1] = (uint)protocol.ElementID;
ids[2] = (uint)tableId;

string primaryKey = "Row 1";

int rowCount = (int)protocol.NotifyDataMiner(156 /*NT_DELETE_ROW*/, ids, primaryKey);
  • ids (uint[]):
    • ids[0]: DataMiner Agent ID.
    • ids[1]: Element ID
    • ids[2]: table parameter ID
  • primaryKey (string): Primary key of the row that needs to be removed.

Return Value

  • (int) Number of remaining rows in the table.

Remarks

  • In order to delete multiple rows, provide a string array containing the primary keys of the rows to remove as second parameter.
  • Also supported for logger tables in the indexing database.

See also