Supported Visual FoxPro Commands and Functions in OLE DB Provider

Visual FoxPro contains language you can use with the OLE DB Provider for Visual FoxPro. Some of these language elements are for use only against the OLE DB Provider; while others can be used in stored procedures, triggers, rules, and default values.

Note

You can determine the state of many SET commands, supported and unsupported except for SET ANSI, by querying the database. For example, the following line of code returns the value for SET PATH in the resultant cursor:

Note

SELECT SET('PATH') FROM Table WHERE RECNO()=1

Commands Called Against the Visual FoxPro OLE DB Provider

The Visual FoxPro OLE DB Provider supports native Visual FoxPro language syntax for commands you can execute against the provider. The following tables list these commands.

For more information about the syntax for these commands, see the Visual FoxPro Language Reference.

SQL Commands

ALTER TABLE - SQL Command	CREATE TABLE - SQL Command	DELETE - SQL Command
INSERT - SQL Command (Using the SQL INSERT command with an array, memory variable, or an object is not supported.)	SELECT - SQL Command	UPDATE - SQL Command

Other Commands

DROP TABLE Command	SET ANSI Command	SET AUTOINCERROR Command
SET BLOCKSIZE Command	SET COLLATE Command	SET DELETED Command
SET ENGINEBEHAVIOR Command	SET EXACT Command	SET EXCLUSIVE Command
SET FULLPATH Command	SET MULTILOCKS Command	SET NULL Command
SET PATH Command	SET REPROCESS Command	SET UNIQUE Command

Commands and Functions for Stored Procedures, Rules, Triggers, and Default Values

You can use a larger set of commands in stored procedures, rules, triggers, and defalut values. The following tables list these commands and functions.

$ Operator	% Operator	& Command
&& Command	* Command	= Command

A

ABS( ) Function	ACOPY( ) Function	ACOS( ) Function
ADATABASES( ) Function	ADBOBJECTS( ) Function	ADD TABLE Command
ADEL( ) Function	AELEMENT( ) Function	AERROR( ) Function
AFIELDS( ) Function	AINS( ) Function	ALEN( ) Function
ALIAS( ) Function	ALLTRIM( ) Function	ALTER TABLE - SQL Command
AND Operator	APPEND Command	APPEND FROM ARRAY Command
APPEND GENERAL Command	APPEND GENERAL Command	APPEND MEMO Command
APPEND PROCEDURES Command	ASC( ) Function	ASCAN( ) Function
ASIN( ) Function	ASORT( ) Function	ASQLHANDLES( ) Function
ASUBSCRIPT( ) Function	AT( ) Function	AT_C( ) Function
ATAN( ) Function	ATC( ) Function	ATCC( ) Function
ATCLINE( ) Function	ATLINE( ) Function	ATN2( ) Function
AUSED( ) Function	AVERAGE Command

B

BEGIN TRANSACTION Command	BETWEEN( ) Function	BITAND( ) Function
BITCLEAR( ) Function	BITLSHIFT( ) Function	BITNOT( ) Function
BITOR( ) Function	BITRSHIFT( ) Function	BITSET( ) Function
BITTEST( ) Function	BITXOR( ) Function	BLANK Command
BOF( ) Function

C

CALCULATE Command	CANDIDATE( ) Function	CDX( ) Function
CEILING( ) Function	CHR( ) Function	CHRTRAN( ) Function
CHRTRANC( ) Function	CLEARRESULTSET( ) Function	CLOSE Commands
CMONTH( ) Function	CONTINUE Command	COPY INDEXES Command
COPY PROCEDURES Command	COPY STRUCTURE Command	COPY STRUCTURE EXTENDED Command
COPY TO Command	CURSORGETPROP("AutoIncError") Function	CURSORTOXML( ) Function

D

DATE( ) Function	DATETIME( ) Function	DAY( ) Function
DBC( ) Function	DBF( ) Function	DBUSED( ) Function
DELETE - SQL Command	DELETE Command	DELETE TAG Command
DELETED( ) Function	DESCENDING( ) Function	DIFFERENCE( ) Function
DIMENSION Command	DISKSPACE( ) Function	DMY( ) Function
DO CASE ... ENDCASE Command	DO Command	DO WHILE ... ENDDO Command
DOW( ) Function	DTOC( ) Function	DTOR( ) Function
DTOS( ) Function	DTOT( ) Function

E

EMPTY( ) Function	END TRANSACTION Command	EOF( ) Function
ERROR( ) Function	EVALUATE( ) Function	EXIT Command
EXECSCRIPT( ) Function	EXP( ) Function

F

FCOUNT( ) Function	FDATE( ) Function	FIELD( ) Function
FILE( ) Function	FILTER( ) Function	FLDLIST( ) Function
FLOCK( ) Function	FLOOR( ) Function	FLUSH Command
FOR ... ENDFOR Command	FOR( ) Function	FOUND( ) Function
FREE TABLE Command	FSIZE( ) Function	FTIME( ) Function
FULLPATH( ) Function	FUNCTION Command	FV( ) Function

G

GATHER Command	GETCP( ) Function	GETFLDSTATE( ) Function
GETNEXTMODIFIED( ) Function	GETRESULTSET( ) Function	GO | GOTO Command
GOMONTH( ) Function

H

HEADER( ) Function

HOUR( ) Function

I

ICASE( ) Function	IDXCOLLATE( ) Function	IF ... ENDIF Command
IIF( ) Function	INDBC( ) Function	INDEX Command
INLIST( ) Function	INSERT - SQL Command	INT( ) Function
ISALPHA( ) Function	ISBLANK( ) Function	ISDIGIT( ) Function
ISEXCLUSIVE( ) Function	ISLEADBYTE( ) Function	ISLOWER( ) Function
ISREADONLY( ) Function	ISUPPER( ) Function

K

KEY( ) Function

KEYMATCH( ) Function

L

LEFT( ) Function	LEFTC( ) Function	LEN( ) Function
LENC( ) Function	LIKE( ) Function	LIKEC( ) Function
LOCAL Command	LOCATE Command	LOCK( ) Function
LOG( ) Function	LOG10( ) Function	LOOKUP( ) Function
LOWER( ) Function	LPARAMETERS Command	LTRIM( ) Function
LUPDATE( ) Function

M

_MLINE System Variable	MAKETRANSACTABLE( ) Function	MAX( ) Function
MDX( ) Function	MDY( ) Function	MEMLINES( ) Function
MESSAGE( ) Function	MIN( ) Function	MINUTE( ) Function
MLINE( ) Function	MOD( ) Function	MONTH( ) Function
MTON( ) Function

N

NDX( ) Function	NORMALIZE( ) Function	NOT Operator
NOTE Command	NTOM( ) Function	NVL( ) Function

O

OCCURS( ) Function	OLDVAL( ) Function	ON ERROR Command
ON KEY Command	ON( ) Function	OPEN DATABASE Command
OR Operator	ORDER( ) Function	OS( ) Function

P

PACK Command	PADL( ) | PADR( ) | PADC( ) Functions	PARAMETERS Command
PARAMETERS( ) Function	PAYMENT( ) Function	PI( ) Function
PRIMARY( ) Function	PRIVATE Command	PROCEDURE Command
PROGRAM( ) Function	PROPER( ) Function	PUBLIC Command
PV( ) Function

R

RAND( ) Function	RAT( ) Function	RATC( ) Function
RATLINE( ) Function	RECALL Command	RECCOUNT( ) Function
RECNO( ) Function	RECSIZE( ) Function	RELATION( ) Function
REMOVE TABLE Command	REPLACE Command	REPLACE FROM ARRAY Command
REPLICATE( ) Function	RETRY Command	RETURN Command
RIGHT( ) Function	RIGHTC( ) Function	RLOCK( ) Function
ROLLBACK Command	ROUND( ) Function	RTOD( ) Function
RTRIM( ) Function

S

SCAN ... ENDSCAN Command	SCATTER Command	SEC( ) Function
SECONDS( ) Function	SEEK Command	SEEK( ) Function
SELECT - SQL Command	SELECT Command	SELECT( ) Function
SET AUTOINCERROR Command	SET BLOCKSIZE Command	SET COLLATE Command
SET DATABASE Command	SET DEFAULT Command	SET DELETED Command
SET ENGINEBEHAVIOR Command	SET EXACT Command	SET EXCLUSIVE Command
SET FDOW Command	SET FIELDS Command	SET FILTER Command
SET FIXED Command	SET FULLPATH Command	SET FWEEK Command
SET HOURS Command	SET INDEX Command	SET LOCK Command
SET MULTILOCKS Command	SET NEAR Command	SET NOCPTRANS Command
SET NOTIFY Command	SET NULL Command	SET OPTIMIZE Command
SET ORDER Command	SET PATH Command	SET PROCEDURE Command
SET REFRESH Command	SET RELATION Command	SET RELATION OFF Command
SET REPROCESS Command	SET SKIP Command	SET UDFPARMS Command
SET UNIQUE Command	SET VOLUME Command	SET( ) Function
SETFLDSTATE( ) Function	SETRESULTSET( ) Function	SIGN( ) Function
SIN( ) Function	SKIP Command	SORT Command
SPACE( ) Function	SQRT( ) Function	STORE Command
STR( ) Function	STRCONV( ) Function	STRTRAN( ) Function
STUFF( ) Function	STUFFC( ) Function	SUBSTR( ) Function
SUBSTRC( ) Function	SUM Command	SYS(0) - Network Machine Information
SYS(1) - Julian System Date	SYS(2) - Seconds Since Midnight	SYS(3) - Legal File Name
SYS(5) - Default Drive	SYS(10) - String from Julian Day Number	SYS(11) - Julian Day Number
SYS(12) - Available Memory in Bytes	SYS(1104) - Purge Memory Cache	SYS(2001) – SET ... Command Status
SYS(2003) – Current Directory	SYS(2004) – Visual FoxPro Start Directory	SYS(2007) - Checksum Value
SYS(2011) - Current Lock Status	SYS(2015) - Unique Procedure Name	SYS(2029) - Table Type
SYS(3050) - Set Buffer Memory Size

T

_TALLY System Variable	_TRIGGERLEVEL System Variable	TABLEREVERT( ) Function
TABLEUPDATE( ) Function	TAG( ) Function	TAGCOUNT( ) Function
TAGNO( ) Function	TAN( ) Function	TARGET( ) Function
TIME( ) Function	TOTAL Command	TRIM( ) Function
TTOC( ) Function	TTOD( ) Function	TXNLEVEL( ) Function
TYPE( ) Function

U

UNIQUE( ) Function	UNLOCK Command	UPDATE - SQL Command
UPDATE Command	UPPER( ) Function	USE Command
USED( ) Function

V

VAL( ) Function

VERSION( ) Function

W

WEEK( ) Function

X

XMLTOCURSOR( ) Function

XMLUPDATEGRAM( ) Function

Y

YEAR( ) Function

Z

ZAP Command

See Also

Reference

Language Reference for OLE DB Development
Visual FoxPro OLE DB Provider Data Support
Unsupported 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