Difference between revisions of "DBF()"

Revision as of 14:56, 27 October 2009

Purpose

Function to return the table file name

Syntax

DBF([<workarea | alias>])

See Also

ALIAS(), FCOUNT(), FIELD(), FILTER(), FMT(), INDEXKEY(), NDX(), READVAR(), SELECT(), SET COMPATIBLE, SET FILECASE, SET FULLPATH, WORKAREA()

Description

The DBF() function returns the file name of the currently active table or a null string if none is active. If the optional <workarea | alias> is specified, then the function will return the table name from the specified workarea. The DBF() function returns a character string in lower case, including the file extension. If the command FULLPATH is set ON, then the DBF() function will return the node, disk and directory name with the table name.

If SET COMPATIBLE is set to FOXPRO or VFP the DBF() return value format differs in the following way: if SET FULLPATH is ON the full path to the database table is returned, if SET FILECASE is OFF then the return value is converted to upper case (Windows only).

Example

use patrons
? dbf()
patrons.dbf
dbfname = dbf()
? dbfname
patrons.dbf
? len(dbfname)
        11
use
dbfname = dbf()
? len(dbfname)
         0

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer