Help Center
/
Help Center›AfxNova›CSQLite Class

CSQLiteStmt.BindParameterCountmethod

This method can be used to find the number of SQL parameters in a prepared statement.

DatabasesmethodCSQLite.incdocumented

Syntax

FUNCTION BindParameterCount () AS LONG

Return value

The number of SQL parameters in a prepared statement.

Description

This method can be used to find the number of SQL parameters in a prepared statement. SQL parameters are tokens of the form "?", "?NNN", ":AAA", "$AAA", or "@AAA" that serve as placeholders for values that are bound to the parameters at a later time.

Remarks

This function actually returns the index of the largest (rightmost) parameter. For all forms except ?NNN, this will correspond to the number of unique parameters. If parameters of the ?NNN form are used, there may be gaps in the list.

Reference

  • Include file CSQLite.inc
  • Defined in AfxNova/CSQLite3.inc:1864
  • Documented in Databases/CSQLite Class.md
  • Topic: CSQLite Class