Page tree
Skip to end of metadata
Go to start of metadata

SQL_FREE action


Function
The action closes (finishes) reading initialized by the action SQL_PREPARE.
Declaration
 SQL_FREE
handleIdent_Int
Parameters
handleIdent_Int in Identifier - the unique number (handle) of a connection.

Description
The action allows to release the OS resources used by particular process D2000 DBManager to execute the action SQL_PREPARE. If the action is not used, it will be executed automatically after the script termination or after using the action SQL_DISCONNECT.
Example
Work with a database (actions SQL_...).

 INT  _handle    ; handle to database
 INT  _retCode   ; return code
 TEXT _name      ; product name
 TEXT _type      ; product type
 
 SQL_CONNECT MyDatabase, _handle, _retCode
 SQL_PREPARE _handle, _retCode, _sqlNpar BIND _name, _type
 
 DO_LOOP
   SQL_FETCH _handle, _retCode
   EXIT_LOOP _retCode #  _ERR_NO_ERROR
   ; data processing goes here
 END_LOOP
 
 SQL_FREE _handle
 SQL_DISCONNECT _handle
 


Related pages:

Write a comment…