Returns one or more columns from a row in a table.
Read_Column(tablename, key, returncolumnlist, lockflag)
The Read_Column routine has the following parameter.
| Parameter | Description | |
|---|---|---|
| Tablename | Name of the table from which to read data. | |
| Key | The key of the row containing the column information to read. | |
| returncolumnlist | A column or list of columns to read from DICT.tablename. These columns are returned for the row specified in key. If returncolumnlist is null, all columns are returned. | |
| Lockflag | Specifies whether or not the row is locked during the read operation. Lockflag - Description 0 - No locking takes place. 1 - Row is locked. | |
Returns the column or columns specified in returncolumnlist.
This command reads the company name for customer "1".
run Read_Column "SAMPLE_CUSTOMERS", 1, "COMPANY_NAME"