FIELDCOUNT tablename[]

The syntax above returns the number of columns in a table.

  • tablename: The table name with full path.

Practical example

Command:

FIELDCOUNT table01[]

Output:

FIELDCOUNT :: TABLE01[]
5



FIELDCOUNT tablename[-1]

The syntax above returns the number of columns in a table. The same as the expression higher up.

  • tablename: The table name with full path.
  • -1: Indicates that all columns need to be calculated.

Practical example

Command:

FIELDCOUNT table01[-1]

Output:

FIELDCOUNT :: TABLE01[-1]
5



FIELDCOUNT tablename[n]

The syntax above sets the number of columns in a table.

  • tablename: The table name with full path.
  • n: Number of columns to set.

Theoretical example

Command:

FIELDCOUNT table01[10]

Output:


Practical example

Command:

FIELDCOUNT table01[10]

Output:

FIELDCOUNT :: TABLE01[10]