Difference between revisions of "RECSIZE()"
From Lianjapedia
(→Products) |
Yvonne.milne (Talk | contribs) |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return record size | Function to return record size | ||
− | |||
==Syntax== | ==Syntax== | ||
RECSIZE([<workarea | alias>]) | RECSIZE([<workarea | alias>]) | ||
− | |||
==See Also== | ==See Also== | ||
[[RECCOUNT()]], [[HEADER()]], [[DBF()]], [[NDX()]], [[FIELD()]], [[FCOUNT()]] | [[RECCOUNT()]], [[HEADER()]], [[DBF()]], [[NDX()]], [[FIELD()]], [[FCOUNT()]] | ||
− | |||
==Description== | ==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. | 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== | ==Example== | ||
Line 23: | Line 19: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] |
Latest revision as of 11:30, 10 February 2012
Contents
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