Difference between revisions of "DBF()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Table Basics
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the table file name
 
Function to return the table file name
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[ALIAS()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[FMT()]], [[INDEXKEY()]], [[NDX ()]], [[READVAR()]], [[SELECT()]], [[SET COMPATIBLE]], [[SET FILECASE]], [[SET FULLPATH]], [[WORKAREA()]]
+
[[ALIAS()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[FMT()]], [[INDEXKEY()]], [[NDX()]], [[READVAR()]], [[SELECT()]], [[SET COMPATIBLE]], [[SET FILECASE]], [[SET FULLPATH]], [[WORKAREA()]]
  
  
Line 39: Line 35:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 16:46, 27 November 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 Server, Recital