Supported Visual FoxPro Commands and Functions

The following commands and functions are supported in rules, triggers, default values and stored procedures.

$ 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	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	CLOSE Commands	CMONTH( ) Function
CONTINUE Command	COPY INDEXES Command	COPY PROCEDURES Command
COPY STRUCTURE Command	COPY STRUCTURE EXTENDED Command	COPY TO Command
CALCULATE Command	CANDIDATE( ) Function	CDX( ) Function
CEILING( ) Function	CHR( ) Function	CHRTRAN( ) Function
CHRTRANC( ) Function	CLOSE Commands	CMONTH( ) Function
CONTINUE Command	COPY INDEXES Command	COPY PROCEDURES Command
COPY STRUCTURE Command	COPY STRUCTURE EXTENDED Command

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
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	GETENV( ) Function
GETFLDSTATE( ) Function	GETNEXTMODIFIED( ) Function	GO | GOTO Command
GOMONTH( ) Function

H

HEADER( ) Function

HOUR( ) Function

I

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	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	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	REGIONAL Command
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 BLOCKSIZE Command	SET CARRY Command	SET CENTURY Command
SET COLLATE Command	SET DATABASE Command	SET DATE Command
SET DEFAULT Command	SET DELETED 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 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	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(2001) - SET ... Command Status

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

Y

YEAR( ) Function

Z

ZAP Command

See Also

Language Reference for OLE DB Development | Visual FoxPro OLE DB Provider Data Support | Supported Visual FoxPro SET Commands | Unsupported Visual FoxPro Commands and Functions | Supported OLE DB Objects | Standard and Custom OLE DB Properties | OLE DB Provider for Visual FoxPro