CSQLiteStmt.BindLongIntmethod
Binds a longint value with the statement.
Syntax
FUNCTION BindLongInt (BYVAL idx AS LONG, BYVAL longintValue AS sqlite3_int64) AS LONGParameters
| Name | Description | |
|---|---|---|
îdx | Index of the SQL parameter to be set. The leftmost SQL parameter has an index of 1. When the same named SQL parameter is used more than once, second and subsequent occurrences have the same index as the first occurrence. The index for named parameters can be looked up using the BindParameterIndex method if desired. The index for "?NNN" parameters is the value of NNN. The NNN value must be between 1 and the Limit parameter SQLITE_LIMIT_VARIABLE_NUMBER (default value: 999). | |
longintValue | The value to bind to the parameter. |
Return value
SQLITE_OK on success or an error code if anything goes wrong. SQLITE_RANGE is returned if the parameter index is out of range. SQLITE_NOMEM is returned if malloc fails.
Description
Binds a longint value with the statement.
Remarks
Bindings are not cleared by the Reset function. Unbound parameters are interpreted as NULL.
Reference
- Include file
CSQLite.inc - Defined in AfxNova/CSQLite3.inc:1802
- Documented in Databases/CSQLite Class.md
- Topic: CSQLite Class