Write_Column routine [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Write_Column routine    ======

 


 
==== Description ====
 
Writes one or more columns to a specified row in a table.
 
==== Syntax ====
 
**Write_Column**(//tablename//, //key//, //columnlist//, //columnvaluelist//, //lockflag//)
 
==== Parameters ====
 
The Write_Column routine has the following parameter.

^Parameter^Description^
|//Tablename//|Specifies the name of the table to which to write column information.|
|//Key//|The name of the key to which to write column information.|
|//Columnlist//|A dictionary column name or column number or a list of dictionary column names or numbers to write information to. Each entry in //columnlist// must have a corresponding value in //columnvaluelist//.|
|//columnvaluelist//|List of values to write to a column. Each value is written to a column specified in //columnlist//. Each entry in //columnvaluelist// must have a corresponding value in //columnlist//.|
|//Lockflag//|Specifies whether or not the row is locked during the write operation. If null, no locking takes place.\\ \\ __lockflag__ __Description__\\ 0 - No locking takes place.\\ 1 - Row is locked prior to the write operation and unlocked after the write operation.\\ 2 - Row is unlocked after the write operation.|

 
==== See Also ====
 
[[read_column|Read_Column]]
 
==== Example ====
 
<code>
/* Writes the value 2A100 to the ORDER_NUM column and the value B10 to the SUPP_NO column in row 1 of the CAR_ORDERS table. The row is unlocked after the write operation. */

columnlist = "ORDER_NUM":@FM:"SUPP_NO"
columnvaluelist = "2A100":@FM:"B10"

Write_Column("CAR_ORDERS", 1, columnlist, columnvaluelist, 2)
</code>