CSQLiteStmt.BindDoublemethod

Binds a double value with the statement.

DatabasesmethodCSQLite.incdocumented

Syntax

FUNCTION BindDouble (BYVAL idx AS LONG, BYVAL dblValue AS DOUBLE) AS LONG

Parameters

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).
`dblValue`		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 double 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:1776
Documented in Databases/CSQLite Class.md
Topic: CSQLite Class