Controls compatibility with Microsoft FoxBASE+ and other Xbase languages.
Syntax
SET COMPATIBLE FOXPLUS | OFF | DB4 | ON
[PROMPT | NOPROMPT]
Arguments
FOXPLUS | OFF
(Default) These two keywords can be used interchangeably. Each allows programs created in FoxBASE+ to run in Microsoft Visual FoxPro without changes.
DB4 | ON
These two keywords can be used interchangeably. Including either keyword affects the behavior of the commands and functions listed below.
PROMPT | NOPROMPT
These options determine whether Visual FoxPro displays a dialog box when you open a dBASE table containing a memo field.
Include the PROMPT option to display the Convert Memos dialog box. If you open a dBASE table containing a memo field, Visual FoxPro by default displays the Convert Memos dialog box, which enables you to convert the dBASE memo file to a Visual FoxPro format. You must convert the memo file to a Visual FoxPro format to open the table in Visual FoxPro. You can later convert the memo file to a dBASE format by including the TYPE FOXPLUS option in the COPY command.
If you include NOPROMPT, the Convert Memos dialog box is not displayed when you open a dBASE table containing a memo field. The dBASE memo file is automatically converted to a Visual FoxPro format.
Remarks
Commands and functions affected by SET COMPATIBLE include LIKE( ), PLAY MACRO, SELECT( ), and STORE (when STORE is used with arrays).
SET COMPATIBLE doesn't create compatibility with other Xbase commands, functions, or features not supported in Visual FoxPro. For example, it doesn't allow you to open a report form created in other Xbase products with the Report Designer.
The following table lists the commands affected by SET COMPATIBLE.
| Commands | ||
| @ ... GET with a RANGE clause | READ with an @ ... GET VALID clause | |
| @ ... SAY with CHR(7) | Nested READs | |
| @ ... SAY scrolling | READ | |
| @ ... SAY when STATUS is ON | RUN | ! | |
| ACTIVATE SCREEN | SET COLOR TO | |
| ACTIVATE WINDOW | SET BORDER | |
| APPEND MEMO | SET FIELDS | |
| DECLARE | SET MESSAGE | |
| DIMENSION | SET MEMOWIDTH | |
| GO | GOTO with SET TALK ON | SET PRINTER TO <file> | |
| FSIZE( ) | STORE | |
| INKEY( ) | SUM | |
| LASTKEY( ) | TRANSFORM( ) with a numeric PICTURE clause | |
| LIKE( ) | SELECT( ) | |
| Menu commands | SYS(2001, "COLOR") | |
| PLAY MACRO | ||