SQL_FETCH action
Related pages:
The action reads one or more lines of the result of an SQL command prepared by the SQL_PREPARE action and optionally parameterized by the SQL_BINDIN action.
SQL_FETCH
handleIdent_Int, retCodeIdent_Int [, maxRowsIdent_Int]
handleIdent_Int | in | Identifier - the unique number (handle) of a connection. |
retCodeIdent_Int | out | Return code identifier. |
maxRowsIdent_Int | in | Identifier of the Int type - number of rows read at once (if not specified, the default value is 1). |
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:
Pridať komentár