PreparedStatement - Maple Programming Help

Online Help

All Products    Maple    MapleSim


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

PreparedStatement

  

NextResult

  

retrieve the next result of a multiple statement execute

 

Calling Sequence

Parameters

Description

Examples

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

driverDatabase[LoadDriver]:

conndriver:-OpenConnectionurl,name,pass:pstatconn:-CreatePreparedStatementSELECT name FROM animals WHERE id = ?; INSERT INTO animals( id, name, number, mass ) VALUES( ?, ?, ?, ? ); SELECT name FROM animals WHERE id = ?;:

Execute pstat.

respstat:-Execute1,14,boar,10,60.67,3

Check the value.

res:-Next;res:-GetDataname

fish

(1)

Get the next result.

pstat:-NextResult

1

(2)

Now the last result

respstat:-NextResult:res:-Next:res:-GetDataname

cat

(3)

Check for more results.

stat:-NextResult

NULL returned, no more results in this PreparedStatement module.

See Also

Database

Database[PreparedStatement]

Database[PreparedStatement][Execute]

Database[Result]

Database[Statement]

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