|
Statement:-NextResult - retrieve the next result of a multiple statement execute
|
|
Calling Sequence
|
|
statement:-NextResult( )
|
|
|
Parameters
|
|
|
statement
|
-
|
Statement module
|
|
|
|
|
|
Description
|
|
|
•
|
NextResult tries to retrieve the next result from statement. If no results are available, it returns NULL.
|
|
•
|
If a result is available, it will either 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 that 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=7894/file05720/math60.png)
|
|
>
|
 
|
Execute some statements.
|
>
|
|
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 Statement Module.
|
|
Download Help Document
Was this information helpful?
