Hi, currently it is not possible to have more than one resultset with SAP DB. Maybe in future releases if dbprocs will have multiple resultsets.
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Eduardo L�pez [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 13. August 2003 16:51 > To: [EMAIL PROTECTED] > Subject: Does sapdb support multiple resultsets? > > > [...] > > Statement stm; > ResultSet rs; > [...] > this.stm = database.getJdbcConnection().createStatement(); > this.stm.setMaxRows(100); > [...] > boolean moreResults = this.stm.execute(sql); > if (moreResults ) { > rs = this.stm.getResultSet(); > [...] > moreResults = !(!rs.getStatement().getMoreResults() && > (rs.getStatement().getUpdateCount() == -1)); // THE RESULT IS > EVER FALSE!!! > while (moreResults) { > rs = rs.getStatement().getResultSet(); > while (rs.next()) > [...] > } > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
