Cicode Programming Reference > Cicode Function Categories > SQL Functions Introduction > SQLNoFields

SQLNoFields

Gets the number of fields or columns that were returned by the last SQL statement.

Syntax

SQLNoFields(hSQL)

hSQL:

The handle to the SQL connection, returned from the SQLConnect() function. The SQL connection handle identifies the table where details of the associated SQL connection are stored.

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, call the SQLErrMsg function).

Related Functions

SQLBeginTran, SQLCommit, SQLConnect, SQLDisconnect, SQLEnd, SQLErrMsg, SQLExec, SQLFieldInfo, SQLGetField, SQLInfo, SQLNext, SQLNumChange, SQLRollBack, SQLTraceOff, SQLTraceOn

Example

See SQLFieldInfo

See Also

SQL Functions