Description

Deletes one or more specified rows from a table. Since Delete_Row uses the Delete statement itself, it is more efficient to use the Delete statement in a BASIC+ script. The Delete_Row routine can be called from the command line, making it useful for deleting specific records or emptying a file.

Syntax

Delete_Row(tablename, key, lockflag)

Parameters

The Delete_Row routine has the following parameters.

Parameterscope="col" Description
tablenameName of the table from which to delete a row.
keySpecifies the key for the row to delete. Keys are @fm-delimited. You can pass '*' to delete all rows.
lockflagSpecifies whether or not the row is locked during the delete row operation. If a row is locked by another station or process, it won't be deleted.

If lockflag is null or zero, no locking takes place.

See also

Delete()List_Keys

Remarks

run Delete_Row "CAR_PARTS", "4*7", 0

This example, run from the command line, deletes the row 4*7 from the CAR_PARTS table. No locking takes place.

  • No labels