Difference between revisions of "RECSIZE()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→RECSIZE()) |
||
Line 1: | Line 1: | ||
− | + | ==Purpose== | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | ==Purpose== | + | |
Function to return record size | Function to return record size | ||
Revision as of 15:59, 28 October 2009
==Purpose==
Function to return record size
Contents
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