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

lrvtc.retrieveRow

Pops the first fields from all columns.

Example Query Functions

Syntax

lrvtc.retrieveRow ( );

lrvtc.retrieveRow retrieves the values from the fields in the top row. The values are stored in parameters, each with the same name as the column the data is from.

All fields below the first row move up one row. For example, after the call, the values that were in the second row are in the first row, the values that were in the third row are in the second row, and so on. The last field of each column is cleared.

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;
    ...
    rc = lrvtc.retrieveRow();
    lr.logMessage("retrieve_row rc="+ rc);
    lr.logMessage(lr.evalString("{C_ID}") +", " + lr.evalString("{C_info}")+", " + lr.evalString("{C_credit}"));
    lr.logMessage( lr.evalString("{P_ID}")+", " + lr.evalString("{P_info}")+", " + lr.evalString("{P_name}")+", " + lr.evalString("{P_status}"));
    lr.logMessage( lr.evalString("{O_ID}")+", " + lr.evalString("{O_customerID}")+", " + lr.evalString("{O_info}")+", " + lr.evalString("{O_status}"));
    lr.logMessage( lr.evalString("{H_ID}")+", " + lr.evalString("{H_question}")+", " + lr.evalString("{H_status}"));