Description

Writes one row to a specified table.

Syntax

Write_Row (tablename, key, columnvaluelist, lockflag)

Parameters

The Write_Row routine has the following parameter.

ParameterDescription
TablenameSpecifies the name of the table to which to write a row.
KeyThe name of the key in tablename to which to write information.
columnvaluelistList of values to write to a row in tablename. Each value is written to a column. key and columnvaluelist create a row in the table.
 
LockflagDescription
0No locking takes place.
1Row is locked prior to write and is unlocked immediately following.
2Row unlocked after write operation.

See also

Read_Row

Examples

/* Writes row 1 to the CAR_ORDERS table. 
The ORDER_NUM is 30, the SUPP_NO is B10, the DATE_ORD is 10/20/90, and the TOTAL_PRICE is $23.50. 
The row is unlocked after the write operation. */
 
columnvaluelist = "30":@FM:"B10":@FM:"10/20/90":@FM:"23.50"
 
Write_Row("CAR_ORDERS", "1", columnvaluelist, 2)
 
if Get_Status(ErrCodes) then
  GoSub ErrorHandling
end
  • No labels