retrieve the next result of a multiple statement execute - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : Statement : Database/Statement/NextResult

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]:

conn:=driver:-OpenConnectionurl,name,pass:stat:=conn:-CreateStatement:

Execute some statements.

res:=stat:-ExecuteSELECT name FROM animals WHERE id = 1; INSERT INTO animals( id, name, number, mass ) VALUES( 14, 'boar', 10, 60.67 ); SELECT name FROM animals WHERE id = 3;:

Check the value.

res:-Next;res:-GetDataname

fish

(1)

Get the next result.

stat:-NextResult

1

(2)

Now the last result.

res:=stat:-NextResult:res:-Next:res:-GetDataname

cat

(3)

Check for more results.

stat:-NextResult

NULL returned, no more results in this Statement Module.

See Also

Database, Database[Result], Database[Statement], Database[Statement][Execute], Database[usage]


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam