Result - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : Result : Database/Result/SetOptions

Result

  

SetOptions

  

set options of a Result module

 

Calling Sequence

Parameters

Description

Examples

Calling Sequence

result:-SetOptions( opts )

Parameters

result

-

Result module

opts

-

(optional) equation of the form fetchsize=integer

Description

• 

SetOptions sets various options that affect the behavior of result.

• 

SetOptions accepts one option.

  

fetchsize = integer

  

Determines how many rows must be fetched from the database.  The more rows fetched, the faster accessing rows will be. However, fetching more rows uses more memory.

• 

An option's current value can be obtained by calling GetOptions.

• 

SetOptions does not return anything.

• 

Calling SetOptions with no arguments raises an error.

Examples

driverDatabase[LoadDriver]:

conndriver:-OpenConnectionurl,name,pass:resconn:-ExecuteQuerySELECT * FROM animals:res:-GetOptions

fetchsize=5

(1)

stat:-SetOptions'fetchsize'=8;stat:-GetOptions

fetchsize=8

(2)

See Also

Database

Database[Connection]

Database[Connection][CreateStatement]

Database[Result]

Database[Result][GetOptions]

Database[Statement]

Database[Statement][GetOptions]

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