Tag Archives: DBFSIZE

CT_DBFSIZE

Posted on by vivaclipper 
DBFSIZE()
 Determines the size of a selected (.dbf) file in memory
------------------------------------------------------------------------------
 Syntax

     DBFSIZE() --> nFileSize

 Returns

     DBFSIZE() returns the byte size of the current database in working
     memory.

 Description

     DBFSIZE() determines how much room a database occupies, before you write
     this file to a disk.  The function is also useful when used in
     conjunction with DBFDSKSIZE().  When the results for both functions
     indicate there is a deviation in the size of a database, this means a
     portion of the data is not yet written to the floppy/hard disk.  You can
     also determine if and when new input is written to a floppy/hard disk.

 Note

     .  This function always operates on the currently SELECTed work
        area.

 Example

     Can a (.dbf) file be copied to the target disk?

     USE DATA
     IF DISKFREE("A") < DBFSIZE()
        ? "The file can not be copied."
        ? "Insufficient space remaining on disk."
     ELSE.
        COPY TO A:COPY
     ENDIF

See Also: DBFDSKSIZE() DISKFREE()

Tools — Database Functions

Posted on by vivaclipper 
Introduction Database Functions
DBFDSKSIZE() Determines the size of a selected (.dbf) file on a disk drive
DBFSIZE()    Determines the size of a selected (.dbf) file in memory
FIELDDECI()  Determines the number of decimal places in a field
FIELDNUM()   Determines field number for a specific field in a database file
FIELDSIZE()  Determines the size of a field
FIELDTYPE()  Determines the data type for a field
ISDBT()      Determines if a memo file (.dbt) is present