Help Center
/
Help Center›AfxNova›CSQLite Class

CSQLiteStmt.BindNullmethod

Binds a null value with the statement.

DatabasesmethodCSQLite.incdocumented

Syntax

FUNCTION BindNull (BYVAL idx AS LONG) AS LONG

Parameters

NameDescription
îdxIndex 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).

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 null 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:1815
  • Documented in Databases/CSQLite Class.md
  • Topic: CSQLite Class