Difference between revisions of "DBF()"

Latest revision as of 13:44, 1 March 2019

Purpose

Function to return the table file name

Syntax

DBF([<workarea | alias>])

See Also

ALIAS(), DBD(), FCOUNT(), FIELD(), FILTER(), INDEXKEY(), NDX(), SELECT(), 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.

Example

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