Difference between revisions of "RECSIZE()"

Revision as of 16:00, 28 October 2009

Purpose

Function to return record size

Syntax

RECSIZE([<workarea | alias>])

See Also

RECCOUNT(), HEADER(), DBF(), NDX(), FIELD(), FCOUNT()

Description

The RECSIZE() function returns a number representing the size of each record in the currently selected table. The size will be the sum of all the field storage sizes plus one character for the deletion marker in the record. If the optional <workarea | alias> is specified, then the function will operate in the required location. When used with the HEADER() function and the RECCOUNT() function, the RECSIZE() function allows you to calculate the space which your table occupies.

Example

use accounts
if header() + reccount() * recsize() > 100000
dialog box "Database too big for backup disk."
endif

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer