ID: Q115175
The information in this article applies to:
The information below describes the command and function differences between dBASE and FoxPro. This information is also found in the "Switching from dBASE" topic in FoxPro 2.6 Help.
To go directly to this topic in FoxPro, choose dBASE Help from the Help menu.
Almost all of the hundreds of commands and functions in dBASE IV work exactly the same way in FoxPro. The degree of compatibility is extremely high, and even more so with dBASE IV 1.0 and 1.1. However, there are commands, functions, or keywords where dBASE and FoxPro differ.
@ ... GET
In FoxPro, the REQUIRED keyword in @ ... GET is ignored.
In FoxPro, the REINDEX keyword in APPEND FROM is ignored.
In FoxPro, the REINDEX keyword in APPEND FROM ARRAY is ignored.
While dBASE looks for the characters ", (quotation mark, followed by a
comma) in an appended ASCII text file, FoxPro looks only for the "
(quotation mark). As a result, files containing these delimiters do not
append correctly in any version of FoxPro.
BARCOUNT() in dBASE calculates the number of bars of defined
popups, regardless of whether or not the popup has been activated.
BARCOUNT() in FoxPro calculates the number of bars of active
popups. If a popup has been defined, but not activated,
BARCOUNT(<popup name>) in FoxPro returns 0.
In FoxPro, the NOORGANIZE keyword in BROWSE is ignored.
In FoxPro, CHANGE() always returns false (.F.).
In FoxPro, COMPLETED() always returns false (.F.).
In dBASE IV, the second parameter in the FCREATE() and FOPEN()
functions can be "R" (read-only), "W" (write-only), "A" (append-
only), "RW" or "WR (read and write) or "RA" or "AR" (read and
append). FoxPro supports these file attributes. The following
tables list the FoxPro behavior for these dBASE parameters.
FCREATE()
dBASE FoxPro
Parameter Behavior
----------------------------------------------------------------------
RW or WR Creates a file with read and write privileges and sets the
MS-DOS Archive attribute.
A Creates a file with read and write privileges and sets the
MS-DOS Archive attribute.
RA or AR Creates a file with read and write privileges and sets the
MS-DOS Archive attribute.
R Creates a file with read only privileges and sets the
MS-DOS Read-Only attribute.
FOPEN()
dBASE FoxPro
Parameter Behavior
----------------------------------------------------------------------
RW or WR Opens the file with read and write privileges and
positions the file pointer at the beginning of the file.
A Opens the file with read only privileges and positions the
file pointer at the end of the file.
RA or AR Opens the file with read and write privileges and
positions the file pointer at the end of the file.
R Opens the file with read only privileges and positions the
file pointer at the beginning of the file.
In dBASE, FLDLIST() returns a field name followed by the ->
operator and the table/.DBF alias. In FoxPro, FLDLIST() returns a
field name followed by a period and the table/.DBF alias.
ID() in dBASE returns the name of the machine that dBASE is
running on. ID() in FoxPro returns the name of the machine that
FoxPro is running on and the number of the machine in the network.
If no network is present, ID() in FoxPro returns the machine name
and 1.
In FoxPro, the BLANK keyword in ON SELECTION POPUP is ignored.
In FoxPro, RESET is ignored.
The dBASE RUN() function is not supported in FoxPro. Use FoxPro's
RUN command instead.
In FoxPro, the border characters are returned. In dBASE,
SET('BORDER') returns ASCII values for the border characters.
In dBASE you can add /R to a field in the SET FIELDS command to
make it read-only. This switch is ignored in FoxPro 2.6.
When FIELDS is set to LOCAL and COMPATIBLE is set to FOXPLUS or
OFF, aliases are not returned with the fields names.
In FoxPro, the AT clause in SET MESSAGE is ignored.
In FoxPro, the NOSAVE and NOLOG keywords in USE are ignored.
Last Reviewed: June 28, 1995