Pops the first fields from all columns.

ExampleQuery Functions


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.


All string input arguments can be passed using standard parameterization.


    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}"));