Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

SQL.FieldCount

Returns the number of fields (columns) in a result set.

Component Version macOS Windows Linux Server iOS SDK
SQL 2.6 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "SQL.FieldCount"; Command )   More

Parameters

Parameter Description Example
Command The command reference number gained with SQL.NewCommand. $Command

Result

Returns field count or error message.

Description

Returns the number of fields (columns) in a result set.
FieldCount method returns the number of fields created implicitly after the command execution if a result set exists.

See also

Example Databases

Blog Entries

This function is free to use.

Created 18th August 2014, last changed 13th January 2015


SQL.FetchPrior - SQL.FieldExists