|
PreparedStatement:-NextResult - retrieve the next result of a multiple statement execute
|
|
Calling Sequence
|
|
preparedstat:-NextResult( )
|
|
|
Parameters
|
|
|
preparedstat
|
-
|
PreparedStatement module
|
|
|
|
|
|
Description
|
|
|
•
|
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.
|
|
|
|
Examples
|
|
|
>
|
![driver := Database[LoadDriver]()](/support/helpjp/helpview.aspx?si=7941/file05696/math60.png)
|
|
>
|
|
Execute pstat.
|
>
|
|
Check the value.
|
>
|
 
|
|
| (1) |
Get the next result.
|
>
|
|
|
| (2) |
Now the last result
|
| (3) |
Check for more results.
|
>
|
|
NULL returned, no more results in this PreparedStatement module.
|
|
Download Help Document
Was this information helpful?
