set options of a Result module - 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

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

driver:=Database[LoadDriver]:

conn:=driver:-OpenConnectionurl,name,pass:res:=conn:-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