Gets the next row from a query result.
Returns one row of data from the query result associated with the current connection. Use this method to retrieve results from a query that returns data. Such queries include a SELECT statement and a stored procedure.
The Get Next Row function block can throw the CwDBSQLException exception if a database error occurs.
The Get Next Row function block returns one row of data from the query result associated with the current connection. Use this function block to retrieve results from a query that returns data. Such queries include a SELECT statement and a stored procedure. Only one query can be associated with the connection at a time. Therefore, if you execute another query before Get Next Row returns the last row of data, you lose the query result from the initial query.
This function block is based on the CwDBConnection.nextRow() method. For more information, see nextRow().