00001 /* $Id: ex10.c 221 2002-08-24 12:54:47Z kpoitschke $ */ 00002 #include <stdio.h> 00003 #include <stdlib.h> 00004 #include "examples.h" 00005 00006 sqlo_stmt_handle_t prepare_cursor(sqlo_db_handle_t dbh, double * min_salary) 00007 { 00008 sqlo_stmt_handle_t sth; /* statement handle */ 00009 00010 if (0 > (sth = sqlo_prepare(dbh, 00011 "SELECT ENAME, SAL FROM EMP WHERE SAL >= :salary ORDER BY 2,1"))) 00012 error_exit(dbh, "sqlo_prepare"); 00013 00014 if (SQLO_SUCCESS != 00015 sqlo_bind_by_pos(sth, 1, SQLOT_FLT, min_salary, sizeof(double), 0, 0)) 00016 error_exit(dbh, "sqlo_bind_by_pos"); 00017 00018 return sth; 00019 } 00020 /* $Id: ex10.c 221 2002-08-24 12:54:47Z kpoitschke $ */