Example: lrd_bind_col

In the following example, a SELECT statement retrieves all of the database records that contain a value of 1000 or greater in their SAL column. lrd_exec executes the statement and lrd_bind_col binds all of the columns to host variables.

 /* Set up and execute the SQL statement.*/

lrd_stmt(Csr1, "select ename from emp where (sal>=1000)\n", -1, 1/*Deferred*/, 1/*Default Ora Ver*/, 0);

lrd_bind_col(Csr1, 1, &ENAME_D21, 0, 0);

lrd_exec(Csr1, 0, 0, 0, 0, 1);

lrd_fetch(Csr1, -3, 1, 0, PrintRow24, 0);