Porovnávané verzie
porovnané s
Kľúč
- Tento riadok sa pridal
- Riadok je odstránený.
- Formátovanie sa zmenilo.
SQL_FREE action
Function
The action closes (finishes) reading initialized by the action SQL_PREPARE.
Declaration
| Blok kódu | ||||
|---|---|---|---|---|
| ||||
SQL_FREE |
Parameters
| handleIdent_Int | in | Identifier - the unique number (handle) of a connection. |
Description
The action allows to release the OS resources used by a particular process 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_...).
| Blok kódu | ||||
|---|---|---|---|---|
| ||||
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