Help Center
/
Help Center›AfxNova›CSQLite Class

CSQLiteStmt.ColumnDeclaredTypemethod

Returns the declared data type of a query result.

DatabasesmethodCSQLite.incdocumented

Syntax

FUNCTION ColumnDeclaredType (BYVAL nCol AS LONG) AS DWSTRING
FUNCTION ColumnDeclaredType (BYREF wszColName AS WSTRING) AS DWSTRING

Parameters

NameDescription
nCol / wszColNameThe column number or name of the result set. The leftmost column of the result set has the index 0. The number of columns in the result can be determined using ColumnCount.

Return value

The original un-aliased name of the database. If the column returned by the statement is an expression or subquery and is not a column value, then this functions returns an empty string.

Description

Returns the declared data type of a query result.

Remarks

This function is only available if the library was compiled with the SQLITE_ENABLE_COLUMN_METADATA C-preprocessor symbol.

If two or more threads call this function against the same prepared statement and column at the same time then the results are undefined.

If two or more threads call one or more column metadata interfaces for the same prepared statement and result column at the same time then the results are undefined.

Reference

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