SQLNoFields

When the hGeneral is the connection handle, the function returns the number of fields or columns that were returned by the last SQL statement. When the hGeneral is the recordset handle, the function returns the number of fields or columns in the recordset itself.

Note: This function is deprecated and may be removed in future releases.

This function can be called in the foreground or background.

Syntax

SQLNoFields(hGeneral)

hGeneral:

The handle either to:

• the DB connection object, returned from either SQLCreate() or SQLConnect() function. The handle identifies the DB connection object where details of the associated SQL connection are stored
• the recordset

Return Value

The number of fields. A value of 0 is returned if no fields were returned or if an error has been detected. (For details of an error code, call the SQLErrMsg function).

Related Functions

SQLSet, SQLAppend, SQLExec, SQLGetRecordset, SQLCall, SQLGetScalar, SQLEnd, SQLNumChange, SQLNoFields, SQLNumFields, SQLFieldInfo, SQLGetField, SQLIsNullField, SQLRowCount, SQLNext, SQLPrev

Example

See SQLFieldInfo

See Also

SQL Functions

Published June 2018