Help Center
/
Help Center›AfxNova›CODBCStmt Class

CODBCStmt.ColTypemethod

A numeric value that specifies the SQL data type.

DatabasesmethodCODBCStmt.incdocumented

Syntax

FUNCTION ColType (BYVAL ColNum AS SQLUSMALLINT) AS SQLINTEGER

Parameters

NameDescription
ColNumColumn number.

Return value

A numeric value that specifies the SQL data type.

Result code (GetLastResult)

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Description

A numeric value that specifies the SQL data type. When colNum is equal to 0, SQL_BINARY is returned for variable-length bookmarks and SQL_INTEGER is returned for fixed-length bookmarks. For the datetime and interval data types, this field returns the verbose data type: SQL_DATETIME or SQL_INTERVAL. This information is returned from the SQL_DESC_TYPE record field of the IRD.

Reference

  • Include file CODBCStmt.inc
  • Defined in AfxNova/COdbcStmt.inc:1123
  • Documented in Databases/ODBC Classes/CODBCStmt Class.md
  • Topic: CODBCStmt Class