Porovnávané verzie
porovnané s
Kľúč
- Tento riadok sa pridal
- Riadok je odstránený.
- Formátovanie sa zmenilo.
SQL_DISCONNECT action
Function
The action closes the connection (handle) to a database.
Declaration
| Blok kódu | ||||
|---|---|---|---|---|
| ||||
SQL_DISCONNECT |
| Blok kódu | ||||
|---|---|---|---|---|
| ||||
handleIdent_Int |
Parameters
| handleIdent_Int | in | Identifier of the Int type (handle) - connection to a database (SQL_CONNECT). |
Description
Value of
handleIdent_Int must be gained by using the action SQL_CONNECT. 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
; parametrized SQL command
TEXT _sql = "SELECT Name, Type FROM Products WHERE ID>= #PAR# AND ID<= #PAR#"
SQL_CONNECT MyDatabase, _handle, _retCode
SQL_PREPARE _handle, _retCode, _sql BINDOUT _name, _type
SQL_BINDIN _handle, _retCode, 1, 100 ; read all products between 1 and 100
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