Example: lrd_cancel

In the following example, lrd_cancel resets the cursor, Csr2.

lrd_stmt(Csr2, "select first_name, last_name, salary,", "date_of_birth,dept from employee where (emp_id<9000)AND(emp_id>1000) ",-1, 1 /*Deferred*/, 1 /*Dflt Ora Ver*/, 0);

lrd_exec(Csr2, 0, 0, 0, 0, 0);

lrd_bind_col(Csr2, 1, &FIRST_NAME_D14, 0, 0);

lrd_bind_col(Csr2, 2, &LAST_NAME_D15, 0, 0);

lrd_exec(Csr2, 0, 0, 0, 0, 0);

lrd_fetch(Csr2, 3, 3, 0, PrintRow15, 0);

 /* VuGen returns a grid with three rows of data */

lrd_cancel(0, Csr2, 2 /*Current*/, 0);