Pops the first fields from all columns.

C Language

VTCERR2 lrvtc_retrieve_row ( );

C# Language

void vts.retrieve_row ( );

Java Language

int Lrvtc.retrieve_row ( );
Query Functions



lrvtc_retrieve_row 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

C Language:   Returns zero on success or one of the Error Codes.

C# Language: No return value.

Java Language:   Returns zero on success or one of the Error Codes.


All string input arguments can be passed using standard parameterization.

C Language Example

    int rc;
    rc = lrvtc_retrieve_row();
    lr_log_message("retrieve_row rc=%d\n", rc);
    lr_log_message("%s, %s, %s", lr_eval_string("{C_ID}"), lr_eval_string("{C_info}"), lr_eval_string("{C_credit}"));
    lr_log_message("%s, %s, %s, %s", lr_eval_string("{P_ID}"), lr_eval_string("{P_info}"), lr_eval_string("{P_name}"), lr_eval_string("{P_status}"));
    lr_log_message("%s, %s, %s, %s", lr_eval_string("{O_ID}"), lr_eval_string("{O_customerID}"), lr_eval_string("{O_info}"), lr_eval_string("{O_status}"));
    lr_log_message("%s, %s, %s", lr_eval_string("{H_ID}"), lr_eval_string("{H_question}"), lr_eval_string("{H_status}"));


C# Language Example

.Net Single Connection Example

Java Language Example

Java Single Connection Example