Statement - Maple Programming 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

Parameters

Description

Examples

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

driverDatabase[LoadDriver]:

conndriver:-OpenConnectionurl,name,pass:statconn:-CreateStatement:

Execute some statements.

resstat:-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.

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