Lianja/VFP Command Reference

&

• &&

*

• *

+

• Increment

-

• Decrement

/

• Comment Block
• Double Slash Comment

?

• ?
• ??

A

• ADD TABLE
• ALIAS
• ALTER DATABASE
• ALTER INDEX
• ALTER TABLE
• ALTER VIRTUALTABLE
• APPEND AUTOMEM
• APPEND BLANK
• APPEND FROM
• APPEND FROM ARRAY
• APPEND MEMO
• AVERAGE

B

• BACKUP DATABASE
• BEGIN SEQUENCE
• BEGIN TRANSACTION
• BLANK
• BROWSE

C

• CALCULATE
• CD
• CHDIR
• CHECK DATABASE
• CHECK TABLE
• CLEAR
• CLEAR ALL
• CLEAR AUTOMEM
• CLEAR EVENTS
• CLEAR FCACHE
• CLEAR IOSTATS
• CLEAR LOCKS
• CLEAR MEMORY
• CLEAR NAMESPACE
• CLEAR PROFILE
• CLEAR SMARTQUERY
• CLEAR TIMELINE
• CLOSE
• CLOSE ALL
• CLOSE ALTERNATE
• CLOSE APP
• CLOSE APPLICATION
• CLOSE CLASSLIB
• CLOSE DATABASE
• CLOSE DATABASES
• CLOSE INDEX
• CLOSE PROCEDURE
• CLOSE PROJECT
• CLOSE TABLES
• COMMIT
• COMPARE DATABASE
• COMPARE TABLE
• COMPILE
• COMPILE DATABASE
• CONTINUE
• CONVERTUTF8
• COPY
• COPY DATABASE
• COPY DICTIONARY
• COPY FILE
• COPY INDEXES
• COPY MEMO

C cont.

• COPY STRUCTURE
• COPY STRUCTURE EXTENDED
• COPY TAG
• COPY TO ARRAY
• COPY TO ARRAYOFOBJECTS
• COUNT
• CREATE APP
• CREATE APPLICATION
• CREATE CURSOR
• CREATE DATABASE
• CREATE DICTIONARY
• CREATE FROM
• CREATE INDEX
• CREATE LABEL
• CREATE PAGE
• CREATE PROCEDURE
• CREATE PROJECT
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• CREATE VIRTUALTABLE

D

• DEBUG
• DEBUGGER
• DEBUGOUT
• DECLARE
• DECLARE - DLL
• DECLARE CURSOR
• DECRYPT
• DEFINE
• DEFINE CLASS
• DELETE
• DELETE APP
• DELETE APPLICATION
• DELETE FILE
• DELETE PROJECT
• DELETE TAG
• DELETE TRIGGER
• DIALOG BOX
• DIMENSION
• DIR
• DISPLAY
• DISPLAY CALLS
• DISPLAY CLASSES
• DISPLAY DATABASE
• DISPLAY DATABASES
• DISPLAY DICTIONARY
• DISPLAY FILES
• DISPLAY INDEXES
• DISPLAY IOSTATS
• DISPLAY MEMORY
• DISPLAY PROCEDURE
• DISPLAY PROFILE
• DISPLAY PROTECTION
• DISPLAY SCHEMAS
• DISPLAY STATUS
• DISPLAY STRUCTURE
• DISPLAY TABLES
• DISPLAY TIMELINE
• DISPLAY TRIGGERS
• DO
• DO CASE
• DO FORM
• DO WHILE
• DOEVENTS
• DROP CURSOR
• DROP DATABASE
• DROP INDEX

D cont.

• DROP PROCEDURE
• DROP TABLE
• DROP VIEW

E

• ECHO
• ED
• ENCRYPT
• END TRANSACTION
• ENDFUNC
• ENDPROC
• ERASE
• EXECUTE
• EXECUTE IMMEDIATE
• EXIT
• EXPLAIN

F

• FETCH
• FIND
• FOR
• FOREACH
• FUNCTION

G

• GATHER
• GENERATE
• GOTO
• GRANT

H

• HELP

I

• IF
• IFDEF
• INCLUDE
• INDEX
• INSERT

L

• LABEL FORM
• LIST
• LIST APPS
• LIST BACKUPS
• LIST CALLS
• LIST CLASSES
• LIST CLASSLIB
• LIST DATABASE
• LIST DATABASES
• LIST DICTIONARY
• LIST FILES
• LIST INDEXES
• LIST IOSTATS
• LIST LIBRARY
• LIST MEMORY
• LIST PROCEDURE
• LIST PROFILE
• LIST PROJECTS
• LIST PROTECTION
• LIST SCHEMAS
• LIST STATUS
• LIST STRUCTURE
• LIST TABLES
• LIST TIMELINE
• LIST TRIGGERS
• LOCAL
• LOCATE
• LOCK TABLE
• LOOP
• LPARAMETERS

M

• MC
• MD
• MKDIR
• MODIFY APP
• MODIFY APPLICATION
• MODIFY COMMAND
• MODIFY FILE