Help Center
/
Help Center›AfxNova›CODBCStmt Class

CODBCStmt.ColNullablemethod

Checks if the column can have NULL values.

DatabasesmethodCODBCStmt.incdocumented

Syntax

FUNCTION ColNullable (BYVAL ColNum AS SQLUSMALLINT) AS SQLINTEGER

Parameters

NameDescription
ColNumColumn number.

Return value

SQL_NULLABLE, SQL_NO_NULLS or SQL_NULLABLE_UNKNOWN.

Result code (GetLastResult)

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Description

Returns SQL_NULLABLE if the column can have NULL values; SQL_NO_NULLS if the column does not have NULL values; or SQL_NULLABLE_UNKNOWN if it is not known whether the column accepts NULL values. This information is returned from the SQL_DESC_NULLABLE record field of the IRD.

Reference

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