Difference between revisions of "DBF()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the table file name | Function to return the table file name | ||
− | |||
==Syntax== | ==Syntax== | ||
DBF([<workarea | alias>]) | DBF([<workarea | alias>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ALIAS()]], [[FCOUNT()]], [[FIELD()]], [[FILTER | + | [[ALIAS()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[INDEXKEY()]], [[NDX()]], [[SELECT()]], [[SET FILECASE]], [[SET FULLPATH]], [[WORKAREA()]] |
− | + | ||
==Description== | ==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. | 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== | ==Example== | ||
Line 33: | Line 27: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] |
Revision as of 07:44, 10 February 2012
Contents
Purpose
Function to return the table file name
Syntax
DBF([<workarea | alias>])
See Also
ALIAS(), 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