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


Pops the first fields from specified columns.

Example Query Functions


lrvtc.retrieveMessages1 ( columnNames, delimiter );


name Comments
columnNames The names of the columns to retrieve. The column names are separated by the delimiter.
delimiter The character that separates the column names and values in the lists. If a string, rather than a single character, is passed in delimiter, the string as a whole is the delimiter.

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

All fields in the columns below the first row move up one row. For example, after the call, the values that were in the second row in the columns are in the first row, the values that were in the third row are in the second row, and so on. The last field in each of the columns is cleared. Fields in columns not specified n the columnNames argument are not moved or changed.

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.retrieveMessages1("H_ID;H_question;H_status", ";");
    lr.logMessage("retrieve_messages1 rc="+ rc);
    lr.logMessage("Retrieved H_ID is " + lr.evalString("{H_ID}"));
    lr.logMessage("Retrieved H_question is " + lr.evalString("{H_question}"));
    lr.logMessage("Retrieved H_status is " + lr.evalString("{H_status}"));