JavaScript Functions > Virtual Table Server Functions for Single Connection (lrvtc) > Alphabetical Listing of Virtual Table Server Functions (Single Server) > lrvtc.queryColumn

lrvtc.queryColumn

Retrieves the data in a field.

Example query Functions

Syntax

lrvtc.queryColumn ( columnName, rowIndex );

Arguments

name Comments
columnName The name of the column.
rowIndex The number of the row. The first row has index 1.

lrvtc.queryColumn retrieves the data in a field and stores it in a parameter with the same name as the column.

If there is no data in a cell, the output is NULL.

Return Values

Returns zero on success or one of the Error codes.

Parameterization

All string input arguments can be passed using standard parameterization.

Example

    var rc;
    var rowNum;
    ...
    rowNum = 10;
    rc = lrvtc.queryColumn("C_credit", rowNum);
    lr.logMessage("query_column rc="+ rc);
    lr.logMessage("Column C_credit, row "+rowNum+", value is " + lr.evalString("{C_credit}"));