js editor
Web development
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 |
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 |
В |
В |