Share this page

# Example: lrd_save_last_rowid

In the following example, the lrd_save_last_rowid function saves a rowid to a parameter and retrieves the salary of the last employee.

     /* Recorded script */

    lrd_stmt(Csr1, "select id from employees where name='John'", ...);

    lrd_bind_col(Csr1,...);

    lrd_exec(Csr1, ...);

    lrd_fetch(Csr1, 1,...);

    lrd_stmt(Csr1, "select salary from payment where id='777' ",...);

    lrd_exec(Csr1, ...);

     / * Modified script */

    lrd_stmt(Csr1, "select id from employees where name='John'", ...);

    lrd_bind_col(Csr1,...);

    lrd_exec(Csr1, ...);

    /* Call lrd_fetch prior to lrd_save_last_rowid */

    lrd_fetch(Csr1, 1, ...);

    lrd_save_last_rowid(Csr1,"last_row_id");

    lrd_stmt(Csr1, "select salary from payment where rowid='{last_row_id}' ", ...);

    lrd_exec(Csr1, ...);

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: