FOXPRO Help tips

All commands SYNTEX

CREATE Command :
Syntax : CREATE[<filename>]

USE Command :
Syntax : USE[<database file>| ?]
[IN <expN>]
[INDEX <index file list>| ?]
[ORDER[<expN>|ddx index file>|[TAG]<tag name>[OF<.CDX FILE>]]]
[ALIAS <alias>]

APPEND Command :
Syntax : APPEND[BLANK]
     
INSERT Command :
Syntax : INSERT [BEFORE][BLANK]

MODIFY STRUCTURE Command  :
Syntax : MODIFY STRUCTURE         OR            MODI STRUC

DISPLAY STRUCTURE Command  :
Syntax : DISPLAY STRUCTURE [TO PRINTER | TO FILE <filename>]

LIST Command  :
Syntax : LIST
                 [SCOPE]
                 [FIELDS <Field1,field2…………Field n>]
                 [FOR <expL1>]
                 [WHILE <expL2>]
                 [OFF]
                 [TO PRINTER | TO FILE <filename>]
DISPLAY Command :
Syntax : DISPLAY
                [SCOPE]
                [FIELDS <field exp list>]
                [FOR <expL1>]
                [WHILE <expL2>]
                [OFF]
                [TO PRINTER | TO FILE <filename>]

LOCATE Command :
Syntax : LOCATE FOR <expL1>
               [<scope>]
               [WHILE <expL2]

 FOUND()  Function ::
 Syntax: FOUND([<alias>|<exp>])
     
 CONTINUE Command ::
 Syntax : CONTINUE

 CLEAR Command :
 Syntax : CLEAR

QUIT Command :
Syntax : QUIT

CLOSE Command :
Syntax : CLOSE ALL  |  DATABASE | INDEX

SET DEFAULT Command :
Syntax : DEFAULT TO <path name>

COPY FILE Command :
Syntax : COPY FILE <filename1> TO <filename2>

RENAME Command ::
Syntax : RENAME <filename1>  TO  <filename2>

DELETE FILE Command  ::
Syntax : DELETE FILE [<filename>\?]

Erase Command ::
Syntax : ERASE <filename|?>

EDIT Command ::
Syntax : [FIELDS<field list>][<scope>]
               [FOR<expL1>]
               [WHILE<expL2>]
               [FREEZE <field name>]
               [NOAPPEND]
               [NODELETE]
               [NOEDIT | NOMODIFY]








CHANGE Command ::
Syntax : CHANGE
               [FIELDS<field list>][<scope>]
               [FOR<expL1>]
               [WHILE<expL2>]
               [FREEZE<field name>]
               [NOAPPEND]
               [NODELETE]
\              [NOEDIT|NOMODIFY]

 BROWSE Command ::
 Syntax : BROWSE
               [FIELDS<field list>]
               [FOR expL1]
               [FREEZE <field name>]
               [LOCK <expN1>]
               [LPARTITION]
               [NOAPPEND]
               [NODELETE]
               [NOEDIT|NOMODIFY]
               [NOLINK]
               [PARTITION<expN2>]

REPLACE Command ::
Syntax : REPLACE[<scope>]<field1>WITH<exp1>
[ADDITIVE]
[<field2>WITH<exp2>[ADDITIVE]…]
[FOR<expL1>]
[WHILE<expL2>]

DELETE Command ::
Syntax : DELETE
              [<scope>]
              [FOR <expL1>]
              [WHILE<expL2>]

RECALL Command ::
Syntax : RECALL
              [<scope>] 
              [FOR <expL1>]
              [WHILE <expL2>]

PACK Command ::
Syntax : PACK[MEMO][DBF]


ZAP Command ::
Syntax : ZAP

      * (28)     SORT Command ::
Syntax : SORT TO <filename>ON<field1>[/A][/C][/D]
               [<field2>[/A][/C][/D]…]
               [ASCENDING|DESCENDING]
               [<scope>]
               [FOR <expL1>]
               [WHILE <expL2>]
               [FIELDS <field list>]

INDEX Command ::
Syntax : INDEX ON <field exp>
              TO <IDX file>|TAG <tag name>[of<CDX file>]
              [FOR<expL>]
              [COMPACT]
              [ASCENDING|DESCENDING]
              [UNIQUE]
              [ADDITIVE]

SET INDEX Command ::
Syntax : SET INDEX TO [<index file list>|?]
               [ASCENDING|DESCENDING]
               [ADDITIVE]

SET ORDER Command ::
Syntax : SET ORDER TO [<expN>|<.IDX>index file>]
               [TAG] <tag name> [OF <.CDX file>]

REINDEX Command ::
Syntax : REINDEX [COMPACT]

FIND Command ::
Syntax : FIND <expC>

SEEK Command ::
Syntax : SEEK<expn>

GO Command ::
Syntax : GO<exp N1>[TOP][BOTTOM]

SKIP Command ::
Syntax : SKIP <exp N1>


SUM Command ::
Syntax : SUM[expr-List scope][FOR condition]

AVERAGE Command ::
Syntax : AVERAGE expr-list scope FOR condition



MODIFY Command ::
Syntax : MODIFY COMMAND [<file> |?]

DO Command ::
Syntax : DO <file>
               [WITH <parm list>]
               [IN <file>]

Wait Command ::
Syntax : [<expC>]
              [TO <memvar>]
              [WINDOW][NOWAIT]]
              [CLEAR]
              [TIMEOUT <expN>]

STORE Command ::
Syntax : STORE <expr> TO <memvar list> | <array list>
        OR
            <memvar> | <array> = <expr>