SQL_FREE action

Function
The action closes (finishes) reading initialized by the action SQL_PREPARE.
Declaration
?
SQL_FREE
handleIdent_Int
Parameters
handleIdent_Intin Identifier - the unique number (handle) of a connection.
Description
The action allows to release the OS resources used by a particular D2000 DBManager process 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 topics
DB_TRANS_OPEN
DB_TRANS_COMMIT
DB_TRANS_ROLLBACK
DB_TRANS_CLOSE

SQL_CONNECT
SQL_DISCONNECT
SQL_EXEC_DIRECT
SQL_EXEC_PROC

SQL_PREPARE
SQL_BINDIN
SQL_FETCH

SQL_SELECT

All database related actions.

Related pages:

Script actions

Napíšte komentár