====== 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 ====
 
[[delete_function|Delete()]], [[list_keys|List_Keys]]
 
==== Examples ====
 
<code>
run Delete_Row "CAR_PARTS", "4*7", 0
</code>

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