background image
<< To automatically retrieve the final row | Correlating a Query Automatically >>
<< To automatically retrieve the final row | Correlating a Query Automatically >>

guidelines

Database Vuser Scripts · Correlating Database Statements
Creating Vuser Scripts
Chapter 10, page 167
When using the second option,
Any
, follow these guidelines:
·
lrd_save_col is repeated before every lrd_fetch until it is
reset
by one of the
following functions: lrd_close_cursor, lrd_exec, lrd_stmt.
·
lrd_save_col assigns a new value to the parameter based on the most recent
fetch. If lrd_fetch is called several times for the same statement (for the same row
and column), lrd_save_col sets the parameter with the values from the latest
fetch.
·
Use caution when using the
Any
option, since subsequent calls to lrd_save_col
(for the same row and column), supersede previous ones. If the final fetch
retrieves invalid data or no data, the correlation fails.
Note: Correlated statements are not supported if the saved value is invalid or
NULL (no rows returned).