RECORDCOUNT tablename[]

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

  • tablename: The table name with full path.

Practical example

Command:

RECORDCOUNT table01[]

Output:

RECORDCOUNT :: TABLE01[]
5



RECORDCOUNT tablename[-1]

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

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

Practical example

Command:

RECORDCOUNT table01[-1]

Output:

RECORDCOUNT :: TABLE01[-1]
5



RECORDCOUNT tablename[n]

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

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

Theoretical example

Command:

RECORDCOUNT table01[6]

Output:


Practical example

Command:

RECORDCOUNT table01[6]

Output:

RECORDCOUNT :: TABLE01[6]