RECSIZE()

From Lianjapedia
Revision as of 11:12, 7 December 2009 by Helengeorge (Talk)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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, Recital Server