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


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




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


See SQLFieldInfo

See Also

SQL Functions