Unsupported Visual FoxPro Commands and Functions in OLE DB Provider

  • Article

Certain Visual FoxPro commands and functions are not supported by the OLE DB Provider. The OLE DB Provider supports data-related Visual FoxPro language, and does not support object or user interface language.

The following tables list the most commonly used commands and functions not supported by the OLE DB Provider.

#, ::, !, ?, \, @

#DEFINE ... #UNDEF

#IF ... #ENDIF Preprocessor Directive

#IFDEF | #IFNDEF

#INCLUDE Preprocessor Directive

:: Scope Resolution Operator

! Command (see RUN | ! Command)

? | ?? Command

??? Command

\ | \\ Command

@ ... BOX Command

@ ... CLASS Command

@ ... CLEAR Command

@ ... EDIT - Edit Boxes Command

@ ... FILL Command

@ ... GET

@ ... MENU Command

@ ... PROMPT Command

@ ... SAY Command

@ ... SCROLL Command

@ ... TO Command

 

A

_ALIGNMENT System Memory Variable

ACCEPT Command

ACLASS( ) Function

ACTIVATE MENU Command

ACTIVATE POPUP Command

ACTIVATE SCREEN Command

ACTIVATE WINDOW Command

ActivateCell Method

ADD CLASS Command

ADIR( ) Function

AFONT( ) Function

AINSTANCE( ) Function

AMEMBERS( ) Function

ANSITOOEM( ) Function

APRINTERS( ) Function

ASELOBJ( ) Function

ASSIST Command

ATAGINFO( ) Function

B

_BEAUTIFY System Memory Variable

_BOX System Memory Variable

_BROWSER System Memory Variable

_BUILDER System Memory Variable

BAR( ) Function

BARCOUNT( ) Function

BARPROMPT( ) Function

BROWSE Command

BUILD APP Command

BUILD EXE Command

BUILD PROJECT Command

 

C

_CALCVALUE System Memory Variable

_CLIPTEXT System Memory Variable

_CONVERTER System Memory Variable

_CUROBJ System Memory Variable

CALL Command

CANCEL Command

CAPSLOCK( ) Function

CAST( ) Function

CD Command

CHANGE Command

CHDIR Command

CHRSAW( ) Function

CLOSE MEMO Command

CNTBAR( ) Function

CNTPAD( ) Function

COL( ) Function

COMPILE Command

COMPOBJ( ) Function

Container Object

Control Object

COPY FILE Command

COPY MEMO Command

CREATE CLASS Command

CREATE CLASSLIB Command

CREATE COLOR SET Command

CREATE Command

CREATE CONNECTION Command

CREATE DATABASE Command

CREATE FORM Command

CREATE FROM Command

CREATE LABEL Command

CREATE MENU Command

CREATE PROJECT Command

CREATE QUERY Command

CREATE REPORT Command

CREATE SCREEN Command

CREATE SQL VIEW Command

CREATE TRIGGER Command

CREATE VIEW Command

CREATEOBJECT( ) Function

CURDIR( ) Function

 

D

_DBLCLICK System Memory Variable

_DIARYDATE System Memory Variable

DBSETPROP( ) Function

DDE Functions

DEACTIVATE MENU Command

DEACTIVATE POPUP Command

DEACTIVATE WINDOW Command

DECLARE - DLL Command

DECLARE Command

DEFINE BAR Command

DEFINE BOX Command

DEFINE CLASS Command

DEFINE MENU Command

DEFINE PAD Command

DEFINE POPUP Command

DEFINE WINDOW Command

DELETE CONNECTION Command

DELETE DATABASE Command

DELETE FILE Command

DELETE TAG Command

DELETE TRIGGER Command

DELETE VIEW Command

DIR Command

DIRECTORY Command

DISPLAY Command

DISPLAY CONNECTIONS Command

DISPLAY DATABASE Command

DISPLAY DLLS Command

DISPLAY FILES Command

DISPLAY MEMORY Command

DISPLAY OBJECTS Command

DISPLAY PROCEDURES Command

DISPLAY STATUS Command

DISPLAY STRUCTURE Command

DISPLAY TABLES Command

DISPLAY VIEWS Command

DO FORM Command

 

 

E

EDIT Command

EJECT Command

EJECT PAGE Command

ERASE Command

ERROR Command

EXPORT Command

EXTERNAL Command

 

 

F

_FOXDOC System Memory Variable

_FOXGRAPH System Memory Variable

FCHSIZE( ) Function

FCLOSE( ) Function

FCREATE( ) Function

FEOF( ) Function

FERROR( ) Function

FFLUSH( ) Function

FGETS( ) Function

FILER Command

FIND Command

FKLABEL( ) Function

FKMAX( ) Function

FONTMETRIC( ) Function

FOPEN( ) Function

FPUTS( ) Function

FREAD( ) Function

FSEEK( ) Function

FWRITE( ) Function

 

 

G

_GENGRAPH System Memory Variable

_GENMENU System Memory Variable

_GENPD System Memory Variable

_GENSCRN System Memory Variable

_GENXTAB System Memory Variable

GETBAR( ) Function

GETCOLOR( ) Function

GETDIR( ) Function

GETENV( ) Function

GETEXPR Command

GETFILE( ) Function

GETFONT( ) Function

GETOBJECT( ) Function

GETPAD( ) Function

GETPICT( ) Function

GETPRINTER( ) Function

 

 

H

HELP Command

HIDE MENU Command

HIDE POPUP Command

HIDE WINDOW Command

HOME( ) Function

 

I

_INDENT System Memory Variable

IMESTATUS( ) Function

IMPORT Command

INDEX ON Command

INKEY( ) Function

INPUT Command

INSERT - SQL Command (Applies only to using the SQL INSERT command with an array, memory variable, or an object.)

INSERT Command

INSMODE( ) Function 

ISCOLOR( ) Function

ISMOUSE( ) Function

 

J

JOIN Command

 

 

K

KEYBOARD Command

 

 

L

_LMARGIN System Memory Variable

LABEL Command

LASTKEY( ) Function

LINENO( ) Function

LIST Commands

LIST CONNECTIONS Command

LOAD Command

LOCFILE( ) Function

 

M

MCOL( ) Function

MD Command

MDOWN( ) Function

MEMORY( ) Function

MENU Command

MENU TO Command

MENU( ) Function

MESSAGEBOX( ) Function

MKDIR Command

MODIFY CLASS Command

MODIFY COMMAND Command

MODIFY CONNECTION Command

MODIFY DATABASE Command

MODIFY FILE Command

MODIFY FORM Command

MODIFY GENERAL Command

MODIFY LABEL Command

MODIFY MEMO Command

MODIFY MENU Command

MODIFY PROCEDURE Command

MODIFY PROJECT Command

MODIFY QUERY Command

MODIFY REPORT Command

MODIFY SCREEN Command

MODIFY STRUCTURE Command

MODIFY VIEW Command

MODIFY WINDOW Command

MOUSE Command

MOVE POPUP Command

MOVE WINDOW Command

MRKBAR( ) Function

MRKPAD( ) Function

MROW( ) Function

MWINDOW( ) Function

 

 

N

NEWOBJECT( ) Function

NUMLOCK( ) Function

 

O

OBJNUM( ) Function

OBJTOCLIENT( ) Function

OBJVAR( ) Function

OEMTOANSI( ) Function

ON APLABOUT Command

ON BAR Command 

ON ESCAPE Command

ON EXIT BAR Command

ON EXIT MENU Command

ON EXIT PAD Command

ON EXIT POPUP Command

ON KEY = Command

ON KEY LABEL Command

ON MACHELP Command

ON PAD Command

ON PAGE Command

ON READERROR Command

ON SELECTION BAR Command

ON SELECTION MENU Command

ON SELECTION PAD Command

ON SELECTION POPUP Command

ON SHUTDOWN Command

 

 

P

_PADVANCE System Memory Variable

_PAGENO System Memory Variable

_PBPAGE System Memory Variable

_PCOLNO System Memory Variable

_PCOPIES System Memory Variable

_PDRIVER System Memory Variable

_PDSETUP System Memory Variable

_PECODE System Memory Variable

_PEJECT System Memory Variable

_PEPAGE System Memory Variable

_PLENGTH System Memory Variable

_PLINENO System Memory Variable

_PLOFFSET System Memory Variable

_PPITCH System Memory Variable

_PQUALITY System Memory Variable

_PRETEXT System Memory Variable

_PSCODE System Memory Variable

_PSPACING System Memory Variable

_PWAIT System Memory Variable

PACK DATABASE Command

PAD( ) Function

PCOL( ) Function

PEMSTATUS( ) Function

PLAY MACRO Command

POP KEY Command

POP MENU Command

POP POPUP Command

POPUP( ) Function

PRINTJOB ... ENDPRINTJOB Command

PRINTSTATUS( ) Function

PRMBAR( ) Function

PRMPAD( ) Function

PROMPT( ) Function

PROW( ) Function

PRTINFO( ) Function

PUSH KEY Command

PUSH MENU Command

PUSH POPUP Command

PUTFILE( ) Function

Q

QUIT Command

 

 

R

_RMARGIN System Memory Variable

RD Command

RDLEVEL( ) Function

READ Command

READ MENU Command

READKEY( ) Function

REFRESH() Function

REINDEX Command

RELEASE BAR Command

RELEASE CLASSLIB Command

RELEASE Command

RELEASE LIBRARY Command

RELEASE MENUS Command

RELEASE MODULE Command

RELEASE PAD Command

RELEASE POPUPS Command

RELEASE PROCEDURE Command

RELEASE WINDOWS Command

REMOVE CLASS Command

RENAME CLASS Command

RENAME Command

RENAME CONNECTION Command

RENAME TABLE Command

RENAME VIEW Command

REPORT FORM Command

REQUERY( ) Function

RESTORE FROM Command

RESTORE MACROS Command

RESTORE SCREEN Command

RESTORE WINDOW Command

RESUME Command

RGB( ) Function

RGBSCHEME( ) Function

RMDIR Command

ROW( ) Function

RUN | ! Command

S

_SCREEN System Memory Variable

_SHELL System Memory Variable

_SPELLCHK System Memory Variable

_STARTUP System Memory Variable

SAVE MACROS Command

SAVE SCREEN Command

SAVE TO Command

SAVE WINDOWS Command

SCHEME( ) Function

SCOLS( ) Function

SCROLL Command

SET ALTERNATE Command

SET APLABOUT Command

SET AUTOSAVE Command

SET BELL Command

SET BLINK Command

SET BORDER Command

SET BRSTATUS Command

SET CARRY Command

SET CLASSLIB Command

SET CLEAR Command

SET CLOCK Command

SET COLOR OF Command

SET COLOR OF SCHEME Command

SET COLOR SET Command

SET COLOR TO Command

SET Command

SET COMPATIBLE Command

SET CONFIRM Command

SET CONSOLE Command

SET CPCOMPILE

SET CPDIALOG

SET CURRENCY Command

SET CURSOR Command

SET DATASESSION Command

SET DATE Command

SET DATE Command

SET DEBUG Command

SET DECIMALS Command

SET DELIMITERS Command

SET DEVELOPMENT Command

SET DEVICE Command

SET DISPLAY Command

SET DOHISTORY Command

SET ECHO Command

SET ESCAPE Command

SET FORMAT Command

SET FUNCTION Command

SET HEADINGS Command

SET HELP Command

SET HELPFILTER Command

SET INTENSITY Command

SET KEY Command

SET KEYCOMP Command

SET LOGERRORS Command

SET MACDESKTOP Command

SET MACHELP Command

SET MACKEY Command

SET MARGIN Command

SET MARK OF Command

SET MARK TO Command

SET MEMOWIDTH Command

SET MESSAGE Command

SET MOUSE Command

SET ODOMETER Command

SET OLEOBJECT Command

SET PALETTE Command

SET PDSETUP Command

SET POINT Command

SET PRINTER Command

SET READBORDER Command

SET REFRESH Command

SET RESOURCE Command

SET SAFETY Command

SET SCOREBOARD Command

SET SECONDS Command

SET SEPARATOR Command

SET SHADOWS Command

SET SKIP OF Command

SET SPACE Command

SET STATUS BAR Command

SET STATUS Command

SET STEP Command

SET STICKY Command

SET SYSFORMATS Command

SET SYSMENU Command

SET TALK Command

SET TEXTMERGE Command

SET TEXTMERGE DELIMITERS Command

SET TOPIC Command

SET TOPIC ID Command

SET TRBETWEEN Command

SET TYPEAHEAD Command

SET VIEW Command

SET WINDOW OF MEMO Command

SET XCMDFILE Command

SHOW GET Command

SHOW GETS Command

SHOW MENU Command

SHOW OBJECT Command

SHOW POPUP Command

SHOW WINDOW Command

SIZE POPUP Command

SIZE WINDOW Command

SKPBAR( ) Function

SKPPAD( ) Function

SOUNDEX( ) Function

SQL functions

SROWS( ) Function

STRTOFILE( ) function

SUSPEND Command

SYSMETRIC( ) Function

 

 

T

_TABS System Memory Variable

_THROTTLE System Memory Variable

_TRANSPORT System Memory Variable

TEXT ... ENDTEXT Command

TRANSFORM( ) Function

TXTWIDTH( ) Function

TYPE Command

 

 

U

UPDATED( ) Function

 

 

V

VALIDATE DATABASE Command

VARREAD( ) Function

 

W

_WINDOWS System Memory Variable

_WIZARD System Memory Variable

_WRAP System Memory Variable

WAIT Command

WBORDER( ) Function

WCHILD( ) Function

WCOLS( ) Function

WEXIST( ) Function

WFONT( ) Function

WITH ... ENDWITH Command

WLAST( ) Function

WLCOL( ) Function

WLROW( ) Function

WMAXIMUM( ) Function

WMINIMUM( ) Function

WONTOP( ) Function

WOUTPUT( ) Function

WPARENT( ) Function

WREAD( ) Function

WROWS( ) Function

WTITLE( ) Function

WVISIBLE( ) Function

 

 

Z

ZOOM WINDOW Command

 

 

See Also

Reference

Language Reference for OLE DB Development

Visual FoxPro OLE DB Provider Data Support

Supported Visual FoxPro Commands and Functions in OLE DB Provider

Supported OLE DB Objects

Standard and Custom OLE DB Properties

OLE DB Provider for Visual FoxPro