Map and Table Calculation

TBLRECS( ) function

Returns the number of records in a table.

Syntax

TBLRECS(Table)

Input

Table

is a table or any other object which is stored as a table, e.g. histograms, two-dimensional tables, a georef tiepoints, a segment map, a point map, a representation class

Output

TBLRECS returns:	a value
Domain:	system domain Value

Note:

By default, this function works on tables with extension .tbt; you can omit the extension .tbt. To use this function on other objects, you need to specify the object's extension.

Tips:

This function may be handy to use in DDE applications
When the definition symbol = is used, a dependent output map or dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output map/column has been calculated.

Usable in

Simple calculators, MapCalc, TabCalc

Examples

Pocket line calculator examples:

? TBLRECS(InTable)	returns the total number of records in table InTable, e.g. 9
? TBLRECS(Point.mpp)	returns the total number of records in the table of point map Point.mpp, e.g. 717

TabCalc example:

OutCol = TBLRECS(InTable)

InTable

InCol	OutCol
10	9
35	9
20	9
35	9
15	9
40	9
?	9
40	9
30	9

MapCalc example:

OutMap = InMap * TBLRECS(InTable)

InMap

OutMap

10	35	20
35	15	40
?	40	30

90	315	180
315	135	360
??	360	270

MAPMAX	PIXSIZE
MAPMIN	PIXAREA
MAPROWS	TBLCOLS
MAPCOLS	TBLVALUE