fbpx

Some people have asked for a list that indicates which features of FoxPro are supported in X#.
The list below represents the status of build 2.08.
Some of what FoxPro calls commands are built into the compiler. We call these statements.
Others are implemented in so called User Defined Commands (UDCs). These are defined in an external header file. The compiler compiles these into function calls in the runtime library. For example the SEEK command is translated into a call to the DbSeek() function and the SKIP command is translated into a call to the DbSkip() function.

This list will be updated for each build that adds VFP features.

Statements (built into the compiler)

Feature Available
& supported
? | ?? supported
??? NOT supported
\ | \\ supported
= supported
DECLARE supported
DEFINE CLASS supported
DIMENSION supported
DO CASE supported
DO supported
DO WHILE supported
EXIT supported
FOR .. ENDFOR supported
FOR EACH .. ENDFOR supported
IF .. ELSE .. ENDIF supported
LOCAL supported.
LOOP supported
LPARAMETERS supported
MEMVAR supported
PARAMETERS supported
PRIVATE supported
PUBLIC supported
RETURN supported
TEXT .. ENDTEXT supported
TRY .. CATCH .. FINALLY supported
WITH .. ENDWITH supported

 

Database and Workarea commands.

Some of these only apply to an interactive environment such as VFP.
Some of the not supported commands will be relatively easy to implement
using a UDC and already available functions in the X# runtime.

Feature Available
APPEND n/a
APPEND FROM supported
APPEND (other variations) NOT supported
AVERAGE supported
BEGIN TRANSACTION NOT supported
BLANK NOT supported
CALCULATE NOT supported
CHANGE n/a
CLEAR n/a
CLOSE supported
CLOSE MEMO n/a
CONTINUE supported
COPY FILE supported
COPY STRUCTURE supported
COPY STRUCTURE EXTENDED supported
COPY (other variations) NOT supported
COPY TO supported
COUNT supported
DELETE - SQL NOT supported
DELETE supported
DELETE FILE supported
DROP TABLE/VIEW NOT supported
EDIT n/a
ERASE supported
EXPORT NOT supported
FLUSH NOT supported
FREE TABLE NOT supported
GATHER NOT supported
GO | GOTO supported
IMPORT NOT supported
INDEX ON supported
INSERT - SQL NOT supported
LOCATE supported
OPEN DATABASE NOT supported
PACK supported
RECALL supported
REINDEX supported
REPLACE supported
REPLACE FROM ARRAY NOT supported
SCAN .. ENDSCAN supported
SCATTER NOT supported
SEEK supported
SELECT - SQL NOT supported
SELECT supported
SET (ORDER, SKIP, RELATION etc) partially supported
SKIP supported
SORT supported
SUM supported
TOTAL supported
UNLOCK supported
UPDATE - SQL NOT supported
USE supported
VALIDATE DATABASE NOT supported
ZAP supported

 

Other Commands

Most of these have either to do with the VFP IDE or with the VFP UI Classes

Feature Available
ACTIVATE (all variations) NOT supported
APPEND (other variations) NOT supported
BEGIN TRANSACTION NOT supported
BROWSE n/a
BUILD n/a
CANCEL n/a
CD / CHDIR NOT supported
CHANGE n/a
CLEAR supported
CLOSE MEMO n/a
COMPILE n/a
COPY (other variations) NOT supported
CREATE (all variations) n/a
DEACTIVATE (all variations) NOT supported
DEBUG n/a
DEBUGOUT n/a
DEFINE (other variations) supported
DELETE (other variations) n/a
DISPLAY (all variations) n/a
DO FORM n/a
DOCK n/a
DOEVENTS n/a
EJECT NOT supported
ERASE supported
ERROR NOT supported
EXPORT NOT supported
EXTERNAL n/a
FLUSH NOT supported
GETEXPR NOT supported
HELP NOT supported
HIDE (all variations) n/a and NOT supported
KEYBOARD NOT supported
LABEL NOT supported
LIST (all variations) NOT supported
MD | MKDIR NOT supported
MENU NOT supported
MODIFY (all variations) n/a
NODEFAULT supported
ON (all variations) NOT supported
PLAY MACRO NOT supported
POP (all variations) NOT supported  
PRINTJOB NOT supported  
PUSH (all variations) NOT supported 
QUIT supported  
RD | RMDIR NOT supported  
READ EVENTS NOT supported  
RELEASE memvars supported
RELEASE (other variations) NOT supported  
REMOVE (all variations) NOT supported  
RENAME (all variations) NOT supported  
REPORT FORM NOT supported 
RESTORE FROM supported  
RESTORE (other variations) NOT supported  
RESUME NOT supported  
RETRY NOT supported  
ROLLBACK NOT supported  
RUN supported 
SAVE TO supported 
SAVE (other variations) NOT supported 
SCROLL supported
SET (global state) partially supported
SHOW (all variations) NOT supported 
SIZE (all variations) NOT supported 
STORE supported 
SUSPEND NOT supported 
TYPE NOT supported 
WAIT supported 
ZOOM WINDOW NOT supported 

 

Functions

Most of the workarea related functions and conversion and string manipulation functions are already available in X#.
A list will follow shortly