Posted Tuesday, July 11, 2006 @ 05:38:06
Using stored procedure in quicktable is similar to using select sql
First refer the following page for how to use a select sql to load the data in quicktable.
http://quicktable.org/tutorial/basic.htm
change the following line
// set the select statement which should be used by the table
dBTable1.setSelectSql("select * from employee");
to
dBTable1.setSelectSql("exec getEmployees()"); The exec keyword is specific to your database. Your database may use a keyword other than exec
There is also another approach
dbTable1.connectDatabase();
CallableStatement cst = dbTable1.getConnection().prepareCall("{ call mydb..mysproc( ?,? ) }");
cst.setObject(1, "FirstArgument");
cst.setObject(2, "Second Argument");
ResultSet rs = cst.executeQuery();
dBTable1.refresh(rs);
QuickTable
