NextResult tries to retrieve the next result from preparedstat. If there are no results available, it returns NULL.

If a result is available, it will be an integer corresponding to an update statement, or a Result module corresponding to a query statement.

To issue a multi-statement SQL string, the Execute command must be used.

Some databases may require the processing of the current result be completed before the next result is returned by NextResult.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$$\mathrm{pstat}≔\mathrm{conn}:-\mathrm{CreatePreparedStatement}\left(''SELECT\; name\; FROM\; animals\; WHERE\; id\; =\; ?;\; INSERT\; INTO\; animals(\; id,\; name,\; number,\; mass\; )\; VALUES(\; ?,\; ?,\; ?,\; ?\; );\; SELECT\; name\; FROM\; animals\; WHERE\; id\; =\; ?;''\right)\:$

$\mathrm{res}≔\mathrm{pstat}:-\mathrm{Execute}\left(1\,14\,''boar''\,10\,60.67\,3\right)$

$\mathrm{res}:-\mathrm{Next}\left(\right)\;$$\mathrm{res}:-\mathrm{GetData}\left(''name''\right)$

$''fish''$

$\mathrm{pstat}:-\mathrm{NextResult}\left(\right)$

$1$

$\mathrm{res}≔\mathrm{pstat}:-\mathrm{NextResult}\left(\right)\:$$\mathrm{res}:-\mathrm{Next}\left(\right)\:$$\mathrm{res}:-\mathrm{GetData}\left(''name''\right)$

$''cat''$

$\mathrm{stat}:-\mathrm{NextResult}\left(\right)$