Share via


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