Difference between revisions of "DBF()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ALIAS()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[INDEXKEY()]], [[NDX()]], [[SELECT()]], [[SET FILECASE]], [[SET FULLPATH]], [[WORKAREA()]] | + | [[ALIAS()]], [[DBD()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[INDEXKEY()]], [[NDX()]], [[SELECT()]], [[SET FILECASE]], [[SET FULLPATH]], [[WORKAREA()]] |
==Description== | ==Description== |
Latest revision as of 13:44, 1 March 2019
Contents
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