Difference between revisions of "RECSIZE()"

From Recital Documentation Wiki
Jump to: navigation, search
(RECSIZE())
Line 1: Line 1:
==Purpose==
+
==Purpose==
 
Function to return record size
 
Function to return record size
  

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