close a Statement module - Maple Help

Online Help

All Products    Maple    MapleSim


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

Statement:-Close - close a Statement module

Calling Sequence

statement:-Close( )

Parameters

statement

-

Statement module

Description

• 

Close frees the resources associated with statement. This happens automatically when statement is garbage collected; however, you can call Close to release the resources immediately.

• 

Any descendant modules of statement are closed when statement is closed.  (A module is a descendant of a parent module if it is returned by one of the parent module's exports or if it is a descendant of one of the parent module's descendants.)

Examples

Create a statement, stat.

driver:=Database[LoadDriver]:

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

Create a descendant of stat.

res:=stat:-ExecuteSELECT * FROM animals:

Close stat.

stat:-Close

Try using stat.

res:=stat:-ExecuteSELECT * FROM animals:

Error, (in ExecuteQuery) this object has been closed, no further operations are possible

Try to use stat's descendant.

res:-Next

Error, (in ExecuteQuery) this object has been closed, no further operations are possible

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