Gets binary data from a result set or an output parameter.
Only SQL data types BINARY and BINARY VARYING may be retrieved using this routine.
Parameters
MimerStatement statementhandle,
int16_t paramno_colno,
void *dest,
size_t dest_maxsiz)
statementhandle |
in |
A handle returned by MimerBeginStatement[C|8], identifying a statement that have been executed. |
paramno_colno |
in |
The parameter number or column number to get data from. First parameter/column is 1. |
dest |
out |
A memory location where to place output binary data. If this is null, no data will be returned, but the size of the binary data is still returned by this routine. |
dest_maxsiz |
in |
The maximum size of the dest memory location in bytes. |
Returns
A negative value indicating error, or a non-negative value indicating the number of bytes in the binary column.
Return value |
Description |
---|---|
>= 0 |
The number of bytes in the binary column. If this value is larger than the dest_maxsiz parameter, the output data was truncated. |
MIMER_CAST_VIOLATION |
If the output parameter or column was not of the BINARY or BINARY VARYING data types. |
MIMER_HANDLE_INVALID |
The statementhandle parameter was not recognized as a handle. |
MIMER_NONEXISTENT_COLUMN_PARAMETER |
The supplied column or parameter number did not exist. |
MIMER_PARAMETER_NOT_OUTPUT |
The referenced parameter is not an output or input/output parameter, which is required when calling a data output routine. |
MIMER_SEQUENCE_ERROR |
If the statement cursor is not open, or the current row is before the first row of the result set, or after the last row of the result set. |
MIMER_SQL_NULL_VALUE |
The column or output parameter contained the SQL null value. (This can also be detected using the MimerIsNull routine.) |
Notes
Micro API compatible.