Delete_Row routine
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.
| Parameter | Description | |
|---|---|---|
| tablename | Name of the table from which to delete a row. | |
| key | Specifies the key for the row to delete. Keys are @fm-delimited. You can pass '*' to delete all rows. | |
| lockflag | Specifies 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
Examples
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.