Tag Archives: ISDBT

CT_ISDBT

Posted on by vivaclipper 
 ISDBT()
 Determines if a memo file (.dbt) is present

 Syntax

     ISDBT() --> lPresent

 Returns

     ISDBT() returns .T., if a database has a memo file associated with it.

 Description

     ISDBT() determines if a database has a memo file associated with it, and
     allows you to compress that memo file.

 Example

     If the database has a memo file, the database is copied to minimize the
     memo file:

     USE DATA
     IF ISDBT()
        COPY TO TEMP
        CLOSE DATABASES
        DELETEFILE("DATA.DBF")
        DELETEFILE("DATA.DBT")
        RENAMEFILE("TEMP.DBF", "DATA.DBF")
        RENAMEFILE("TEMP.DBT", "DATA.DBT")
     ENDIF

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