|
|
|
Comenzi Visual FoxPro
Comanda CREATE DATABASE
Sintaxa comenzii: CREATE DATABASE [ <nume-baza-de-date | ? ]
Comanda OPEN DATABASE
Sintaxa comenzii:
OPEN DATABASE [<nume-baza-date>| ?]
[EXCLUSIVE | SHARED] [NOUPDATE]
SET DATE TO <tip-data>.
SET DATE TO AMERICAN | ANSI | BRITISH | FRENCH | GERMAN | ITALIAN | JAPAN | USA | MDY | DMY | YMD
SET CLOCK ON/OFF
SET CLOCK TO [<rand> ,<coloana>]
DTOC(<exprD>)
CTOD (<exprC>)
DTOS (<exprD>)
Comanda CREATE
Sintaxa comenzii: CREATE [ < nume- tabela >
Comanda MODIFY STRUCTURE
Sintaxa comenzii: MODIFY STRUCTURE
Comanda DISPLAY STRUCTURE
Sintaxa comenzii:
DISPLAY STRUCTURE [ NOCONSOLE]
[TO PRINTER | TO FILE <nume-fisier>]
Comanda LIST STRUCTURE
Sintaxa comenzii:
LIST STRUCTURE [NOCONSOLE]
[TO PRINTER | TO FILE <nume-fisier>]
Comanda COPY STRUCTURE
Sintaxa comenzii: COPY STRUCTURE TO < nume-tabela> [FIELDS < nume-campuri]
Comanda COPY STRUCTURE EXTENDED
Sintaxa comenzii:
COPY TO <nume-tabela> STRUCTURE EXTENDED
[FIELDS <lista-campuri>]
Comanda CREATE FROM
Sintaxa comenzii: CREATE [<tabela1>] FROM [<tabela2>]
Comanda COPY TO
Sintaxa comenzii:
COPY TO <nume-tabela> [FIELDS <lista- campuri>] [<domeniu>]
FOR<conditie1>] [WHILE <conditie>] [TYPE] [FOXPLUS SDF
DELIMITED [WITH <delimitator> WITH BLANK WITH TAB]]
Comanda COPY FILE
Sintaxa comenzii:
COPY FILE <nume-fisier1> TO <nume-fisier2>
Comanda SORT
Sintaxa comenzii:
SORT TO <nume-tabela> ON <camp1>[/ A| /D] [ /C]
[,<camp2> [/ A| /D] [/C]] [ASCENDING DESCENDING]
[ FIELDS <lista campuri>] [<domeniu>]
[FOR <conditie>] [WHILE <conditie>] [NOOPTIMIZE]
Comanda INDEX
Sintaxa comenzii:
INDEX ON <expresie-cheie> TO <nume fisier.IDX>
|TAG<reper index> [OF<nume fisier. CDX>]
[FOR<conditie>][COMPACT][ASCENDING] [DESCENDING]
[UNIQUE] [ADDITIVE]
Comanda USE
Sintaxa comenzii:
USE [ <nume-tabela>|?] [IN<zona de lucru>]
[AGAIN] [ INDEX <lista fisiere index> | ?]
[ORDER <expN1> <fisier.IDX> | TAG <nume-cheie>]
[OF <fisier.CDX> ] [ASCENDING] [DESCENDING]
[ALIAS <nume-alias> ] [ EXCLUSIVE] [ NOUPDATE]
Comanda CLOSE
Sintaxa comenzii:
CLOSE ALTERNATE
CLOSE DATABASE
CLOSE INDEX
CLOSE FORMAT
CLOSE PROCEDURE
CLOSE ALL
Comanda SET INDEX
Sintaxa comenzii:
SET INDEX TO [<lista fisiere index> | ?]
[ORDER<exprN>|<fisier.IDX>|TAG <nume reper> |
OF <fisier.CDX>][ASCENDING | DESCENDING]
Comanda SET ORDER
Stabileste fisierul index sau tagul activ pentru o tabela.
Sintaxa comenzii:
SET ORDER TO [<expN1> | <FisierIDX> | [TAG] <NumeTag> [OF <FisierCDX>] [IN <expN2> | <alias>] [ASCENDING | DESCENDING]
Comanda REINDEX
Sintaxa comenzii: REINDEX
Comanda SELECT
Sintaxa comenzii: SELECT < zona lucru > | < nume alias >
Comanda APPEND
Sintaxa comenzii: APPEND [ BLANK ]
Comanda APPEND FROM
Sintaxa comenzii:
APPEND FROM <nume fisier> ? [FIELDS <lista campuri>]
[FOR <conditie>] [TYPE] [DELIMITED WITH <delimitator>
WITH TAB WITH BLANK MOD PDOX SDF
WK1 WK3 WR1 WRK XLK ]
Comanda APPEND FROM ARRAY
Sintaxa comenzii:
APPEND FROM ARRAY <nume-tablou>
[FOR<conditie>] [FIELDS <lista-campuri>]
Comanda BROWSE
Sintaxa comenzii:
BROWSE [FIELDS <lista-campuri>] [FOR <conditie>]
[FREEZE <camp>] [KEY <expr1>, <expr2>]
[LOCK <exprN1>] [NOAPPEND] [NODELETE] [NOEDIT] [VALID<conditie>] [ERROR <exprC> ]
Comanda CHANGE
Sintaxa comenzii:
CHANGE [FIELDS <lista-campuri>] [<domeniu>] [FOR <conditie>] [WHILE <conditie>] [ FREEZE <camp> ] [KEY <expr1> [,<expr2> ]]
[VALID <conditie>] [ERROR <exprC>]
Comanda EDIT
Comanda INSERT
Sintaxa comenzii: INSERT [BEFORE] [BLANK]
Comanda REPLACE
Sintaxa comenzii:
REPLACE <camp1> WITH <expr1> [ADDITIVE]
[, <camp2> WITH <expr2> [ADDITIVE]]
[<domeniu>][FOR <conditie>][WHILE <conditie>]
[NOOPTIMIZE]
Comanda UPDATE
Sintaxa comenzii:
UPDATE ON <camp-cheie> FROM <alias>
REPLACE <camp1>WITH<expr1>
[,<camp2> WITH <expr2> ] [RANDOM]
Comanda DELETE
Sintaxa comenzii:
DELETE[<domeniu>][FOR<conditie>]
[WHILE<conditie>][NOOPTIMIZE]
Comanda RECALL
Sintaxa comenzii:
RECALL [<domeniu>] [FOR <conditie>]
[WHILE <conditie>] [NOOPTIMIZE]
Comanda PACK
Sintaxa comenzii: PACK [MEMO] [DBF]
Comanda ZAP
Sintaxa comenzii: ZAP
Comanda DELETE FILE
Sintaxa comenzii: DELETE FILE [<nume-fisier> |?]
Comanda SKIP
Sintaxa comenzii: SKIP [<exprN1>] [ IN <exprN2> | <alias>]
Comanda GO
Sintaxa comenzii:
GO [ RECORD] <exprN1> [ IN <exprN2>| <ALIAS>]
GO TOP | BOTTOM [ IN <exprN2>| <ALIAS>]
Comenzile LOCATE si CONTINUE
Sintaxa comenzii:
LOCATE FOR <conditie> [ <domeniu> ]
WHILE <conditie> ] [ NOOPTIMIZE ]
Comanda FIND
Sintaxa comenzii: FIND <expresie-cheie>
Comanda SEEK
Sintaxa comenzii: SEEK < expresie >
<nume-variabila> = <expresie>
Comanda STORE
Sintaxa comenzii: STORE <expresie> TO <lista-variabile> | <masiv>
Comanda RELEASE
Sintaxa comenzii: RELEASE < lista de variabile de memorie >
Comanda SAVE
Sintaxa comenzii:
SAVE TO <nume-fisier> | TO MEMO <camp memo>
[ ALL LIKE <masca> | ALL EXCEPT <masca> ]
Comanda RESTORE
Sintaxa comenzii:
RESTORE FROM <nume-fisier> |
[FROM MEMO <camp memo> ADDITIVE ]
DIMENSION si DECLARE
Sintaxa comenzilor:
DIMENSION <nume-tablou1> ( <exprN1> [ , <exprN2>])
[ , <nume-tablou2> ( <exprN3> [ , <exprN4>] ) ]
DECLARE <nume-tablou1> ( <exprN1> [ , <exprN2>] )
[ , <nume-tablou2> ( <exprN3> [ , <exprN4>] ) ]
ALEN( )
Sintaxa comenzilor: ALEN ( <tablou> [ , <exprN> ] )
AINS ( )
Sintaxa: AINS ( <tablou> , <exprN> [ , 2 ])
ADEL ( )
Sintaxa: ADEL ( <tablou> , <exprN> [ , 2 ])
AELEMENT ( <tablou> , (, <exprN1> [, <exprN2> ])
ASUBSCRIPT ( <tablou> , <exprN1> , <exprN2>)
ACOPY(<tablou1>,<tablou2>,[,<exprN1>[, exprN2>[,<exprN3> ]]])
ADIR ( <nume-tablou> [ , <exprC1>[ , <exprC2>] ] )
AFIELDS ( <tablou>
ASCAN ( <tablou> , <exprN1> , [ , <exprN2>])
ASORT ( <tablou> [ , <exprN1>[ , <exprN2>][ <exprN3>] ] ] )
Comanda DISPLAY MEMORY | LIST MEMORY
Sintaxa comenzii:
DISPLAY | LIST MEMORY [ LIKE <masca>]
[ TO PRINTER | TO FILE <fisier>] [ NOCONSOLE ]
Comanda ACCEPT
Sintaxa comenzii: ACCEPT [<exprC>] TO <variabila memorie>
Comanda INPUT
Sintaxa comenzii: INPUT [<exprC>] TO <variabila memorie>
Comanda @
Sintaxa comenzii @ formatul 1:
@<linie>,<coloana>[SAY<expr1>[PICTURE <exprC1>]
[ FUNCTION <cod functie1>]]
[ GET <nume-variabila> [ PICTURE <exprC2>]
[ FUNCTION <cod functie2>]]
[ RANGE [<exprN1>] [, <exprN2>]]
[ SIZE <exprN1>, <exprN2>]
[ VALID <exprL1> [ ERROR <exprC3>]]
[ DEFAULT <expr2>] [ MESSAGE <exprC4>]
[ WHEN <exprL2>] [ ENABLE | DISABLE ]
[[ OPEN ] WINDOW <nume-fereastra>]
[ COLOR <lista perechi culori> | COLOR SCHEME <exprN4>]
Comutatoare (CHECK BOX)
Sintaxa comenzii @ formatul 2:
@ <linie>, <coloana> GET <variabila> | <camp>
FUNCTION <exprC1> | PICTURE <exprC2>
[DEFAULT <expr>] [SIZE <exprN1>, <exprN2>]
[ENABLE | DISABLE] [MESSAGE <exprC3>]
[VALID <exprL1>] [WHEN <exprL2>]
[COLOR SCHEME <exprN3> | COLOR <lista perechi culori>]
Sintaxa comenzii @ formatul 3:
@ <linie>, <coloana> GET <variabila> | <camp> FROM <masiv>
[RANGE <exprN1> [,<exprN2>]] | POPUP <nume-submeniu>
[FUNCTION <exprC1> | PICTURE <exprC2>]
[DEFAULT <expr>] [SIZE <exprN3>, <exprN4>]
[ENABLE | DISABLE] [MESSAGE <exprC3>]
[VALID <exprL1> ] [WHEN <exprL2>]
[COLOR SCHEME <exprN5> | COLOR <lista pereci culori>]
Sintaxa comenzii @ formatul 4:
@ <linie>, <coloana> GET <variabila> | <camp>
FUNCTION <exprC1> | PICTURE <exprC2>
[DEFAULT<expr>] [FROM<masiv>]
[RANGE<exprN1>[,<exprN2>]]
[SIZE <exprN3>,<exprN4>] [ENABLE/DISABLE]
[MESSAGE <exprC3>] [VALID <exprL1>]
[WHEN <exprL2>]
[COLOR SCHEME <exprN5> | COLOR <lista perechi culori>]
Sintaxa comenzii @ formatul 5:
@ <linie>, <coloana> GET <variabila> | <camp>
FUNCTION <exprC1> | PICTURE <exprC2>
[DEFAULT <expr>] [SIZE <exprN1>, <exprN2>[,<exprN3>]]
[ENABLE | DISABLE] [MESSAGE <exprC3>]
[VALID <exprL1>] [WHEN <exprL2>]
[COLOR SCHEME <exprN4> | COLOR <lista perechi culori>]
Sintaxa comenzii @ formatul 6:
@<linie>, <coloana> GET <variabila> | <camp>
FUNCTION <exprC1> | PICTURE <exprC2>
[ DEFAULT <expr>][ SIZE <exprN1>, <exprN2> [,<exprN3>]
[ ENABLE | DISABLE] [MESSAGE <exprC3>]
[ VALID <exprL1> ] [ WHEN <exprL2> ]
[ COLOR SHEME <exprN5> | COLOR <lista perechi culori> ]
Sintaxa comenzii @ formatul 7:
@ <linie>, <coloana> GET <variabila> | <camp>
FUNCTION <exprC1> | PICTURE <exprC2>
[ DEFAULT <expr> ]
[ SIZE <exprN1>, <exprN2> [, <exprN3> ] ]
[ ENABLE | DISABLE ] [ MESSAGE <exprC3> ]
[ VALID <exprL1> ] [ WHEN <exprL2> ]
[ COLOR SCHEME <exprN4> | COLOR<lista perechi culori>]
Sintaxa comenzii @ formatul 8:
@ <linie>, <coloana> EDIT <variabila> | <camp>
[FUNCTION <exprC1> ][ DEFAULT <expr>]
[SIZE <exprN1>,<exprN2> [, <exprN3> ] ]
[ENABLE | DISABLE ] [MESSAGE <exprC2> ]
[VALID <exprL1> [ERROR <exprC3> ] ]
[WHEN <exprL2> ] [NOMODIFY ] [ SCROLL ] [ TAB ]
[COLOR SCHEME <exprN4> | COLOR <lista perechi culori>]
Comanda READ
Sintaxa comenzii:
READ [ CYCLE ] [ACTIVATE <exprL1> ]
[ DEACTIVATE <exprL2>
[ MODAL] [ WITH <lista- nume-ferestre>]
[ SHOW <exprL3> [ VALID <expr L4> | <exprN1>]
[ OBJECT <exprN2>] [ TIMEOUT <exprN3>]
[ WHEN <exprL5> ] [ SAVE ]
[NOCONSOLE] [ NOMOUSE ] [ LOCK ] [ NOLOCK ]
[COLOR <lista-perechi-culori> | COLOR SCHEME <exprL4> ]
Comanda ?/??
Sintaxa comenzii:
?/?? <expr1> [ PICTURE <exprC1>][ FUNCTION <exprC2>]
[ AT <exprN>][, <expr2>][STYLE <exprC3>| <expr2>]
Comanda ,
Sintaxa comenzii: <linie de text> <linie de text >
SET TEXMERGE
Sintaxa:
SET TEXMERGE [ ON/OFF]
[ TO [ <fisier>] [ADDITIVE]]
[ WINDOW <nume fereastra>]
[ SHOW | NOSHOW]
Comanda TEXTENDTEXT
Sintaxa comenzii:
TEXT
<linii de text >
ENDTEXT
Comanda SET COLOR OF SCHEME
Sintaxa comenzii:
SET COLOR OF SCHEME <exprN1>TO
[<lista perechi culori> | SCHEME <exprN2>]
Sintaxa comenzii:
MODIFY COMMAND | FILE <nume_fisier> [NOEDIT] [NOWAIT]
[RANGE <exprN1>, <exprN2>] [[WINDOW<nume_fereastra_1>]
[ IN [WINDOW], <nume_fereastra_2> | SCREEN]] [SAVE]
Comanda DO
Sintaxa comenzii:
DO <nume-program | nume-procedura>
[WITH <lista_parametrii>] [IN <nume_fisier>]
Comanda PROCEDURE
Sintaxa comenzii:
PROCEDURE <nume_procedura>
[ PARAMETERS <lista_parametri>]
<comenzi>
RETURN
Comanda RETURN
Sintaxa comenzii : RETURN <expresie> | TO MASTER | TO < nume-procedura >
Comanda IFENDIF
Sintaxa comenzii:
IF <conditie>
<comenzi1>
[ ELSE
<comenzi2> ]
ENDIF
Comanda IIF
Sintaxa comenzii:
IIF (<conditie>, <expresie1>, <expresie2>)
Comanda DO CASEENDCASE
Sintaxa comenzii:
DO CASE
CASE <conditie1>
<comenzi1>
CASE <conditie2>
<comenzi2>
...............
CASE <conditieX>
<comenziX>
[ OTHERWISE
<comenziY> ]
ENDCASE
Comanda DO WHILEENDDO
Sintaxa comenzii:
DO WHILE <conditie>
<comenzi>
[LOOP]
[EXIT]
ENDDO
Comanda FORENDFOR
Sintaxa comenzii:
FOR<variabila>=<expresie1>TO<expresie2> [STEP<expresie3>]
<comenzi>
[EXIT]
[LOOP]
ENDFOR
Comanda SCANENDSCAN
Sintaxa comenzii:
SCAN [<domeniu>] [FOR <conditie>][WHILE <conditie>]
<comenzi>
[LOOP]
[EXIT]
ENDSCAN
Comanda CANCEL
Sintaxa comenzii : CANCEL
Comanda QUIT
Sintaxa comenzii : QUIT
Comanda JOIN
Sintaxa comenzii:
JOIN WITH <alias> TO <tabela-rezultata> FOR <conditie>
FIELDS < lista-campuri > NOOPTIMIZE
Comanda SET RELATION
Sintaxa comenzii :
SET RELATION TO <expresie1> INTO <alias> | <exprN>
ADDITIVE , <expresie2> INTO <alias> | <exprN> ADDITIVE
Comanda CREATE VIEW
Sintaxa comenzii : CREATE VIEW <nume - fisier .VUE >
Comanda SET VIEW
Sintaxa comenzii : SET VIEW TO < nume - fisier .VUE >
Comanda AVERAGE
Sintaxa comenzii:
AVERAGE [<lista-expresii-numerice>][<domeniu>]
[FOR <conditie> ] [WHILE <conditie>]
[ TO <lista-variabile-memorie> |
TO ARRAY <nume-tablou> ] [NOOPTIMIZE]
Comanda CALCULATE
Sintaxa comenzii:
CALCULATE [ <domeniu>] <lista-expresii>
[FOR <conditie> ] [WHILE <conditie>] [TO <lista-var-memorie>]
[TO ARRAY <nume-tablou>] [NOOPTIMIZE]
Comanda COUNT
Sintaxa comenzii:
COUNT[<domeniu>][FOR<conditie>][WHILE<conditie>]
[TO<var-memorie>] [NOOPTIMIZE]
Comanda SUM
Sintaxa comenzii:
SUM [<lista-expresii> ] [<domeniu>]
[FOR <conditie> ] [WHILE <conditie>]
[TO <lista-var-mem>|TO ARRAY <nume-tablou>]
[NOOPTIMIZE]
Comanda TOTAL
Sintaxa comenzii:
TOTAL ON <camp-cheie> TO <nume-tabela>
[FIELDS <lista-campuri>] [<domeniu>]
[FOR <conditie> ] [WHILE <conditie>
[NOOPTIMIZE]
Comanda SET ALTERNATE
Sintaxele comenzii:
a) SET ALTERNATE TO [<fisier-text>][ ADDITIVE]
b) SET ALTERNATE ON | OFF
Comanda
SET
Sintaxele comenzii:
a) SET BELL ON | OF
b) SET BELL TO [ <frecventa> , <durata> ]
Comanda SET CARRY
a) SET CARRY ON | OFF
b) SET CARRY TO [ < lista - campuri > [ ADDITIVE ] ]
Comanda SET CLEAR
Sintaxa comenzii: SET CLEAR ON | OFF
Comanda SET CONSOLE
Sintaxa comenzii: SET
Comanda SET DEFAULT TO
Sintaxa comenzii: SET DEFAULT TO [ [ disc ] : [ director ] ]
Comanda SET DELETED
Sintaxa comenzii: SET DELETED ON | OFF
Comanda SET ESCAPE
Sintaxa comenzii: SET
Comanda SET EXCLUSIVE
Sintaxa comenzii: SET EXCLUSIVE ON | OFF
Comanda SET EXACT
Sintaxa comenzii: SET EXACT ON | OFF
Comanda SET FIELDS
a) SET FIELDS ON | OFF
b) SET FIELDS TO [ [ < camp1 > [ , < camp2 > ] ] | ALL ]
Comanda SET FUNCTION
Sintaxa comenzii: SET FUNCTION <exprN> | < eticheta cheie > TO <sir caractere >
Comanda SET INTENSITY
Sintaxa comenzii: SET INTENSITY ON / OFF
Comanda SET MARGIN
Sintaxa comenzii: SET MARGIN TO <exprN>
Comanda SET MESSAGE
a) SET MESSAGE TO [ <exprC>]
b) SET MESSAGE TO [ <exprN>[ LEFT | CENTER | RIGHT ] ].
c) SET MESAGE TO WINDOW [<nume - fereastra>]
Comanda SET MOUSE
Sintaxa :
a) SET MOUSE ON | OFF
b) SET MOUSE TO <exprN>
Comanda SET NEAR
Sintaxa :SET NEAR ON | OFF
Comanda SET OPTIMIZE
Sintaxa comenzii: SET OPTIMIZE ON | OFF
Comanda SET PATH
Sintaxa comenzii: SET PATH TO <cale>
Comanda SET POINT
Sintaxa comenzii: SET POINT <exprC>
Comanda SET PRINTER
Sintaxa:
a) SET PRINTER ON | OFF
b) SET PRINTER TO [ <fisier> [ ADDITIVE ] | <port> ]
TO [ <fisier> [ ADDITIVE ] | <port> ]
Comanda SET PROCEDURE
Sintaxa este: SET PROCEDURE TO [ <nume - fisier> | <nume - procedura> ]
Comanda SET SAFETY
Sintaxa comenzii: SET SAFETY ON | OFF
Comanda SET SCOREBOARD
Sintaxa comenzii: SET
Comanda SET SHADOWS
Sintaxa comenzii: SET SHADOWS ON | OFF
Comanda SET SKIP
Sintaxa:
a) SET SKIP TO [ <alias1> [ , <alias2> ] ]
b) SET SKIP OF MENU <nume meniu> <exprL>.
c) SET MESSAGE TO WINDOW <nume optiune bara> OF
<nume meniu> <exprL>.
d) SET SKIP OF POPUP <nume submeniu> <exprL>.
Comanda SET SPACE
Sintaxa comenzii: SET
Comanda SET SYSMENU
Sintaxa comenzii: SET
Comanda SET STATUS
Sintaxa comenzii: SET
Comanda SET TALK
Sintaxa comenzii: SET
Comanda SET UNIQUE
Sintaxa comenzii: SET UNIQUE ON | OFF
SET SYSMENU
Sintaxa :
SET SYSMENU ON | OFF| AUTOMATIC| TO
<lista - nume - meniuri - popup> |
<lista - optiuni - meniu - orizontal>
| TO DEFAULT
Comanda @BOX
Sintaxa comenzii: @ <linie1>, <coloana1>, <linie2>, <coloana2> BOX [<exprC>]
Comanda @TO
Sintaxa comenzii:
@ <linie1>,<coloana1> TO <linie2>, <coloana2>
[DOUBLE|PANEL|<lista chenar>]
[COLOR <lista perechi culor> | COLOR SCHEME <exprN>]
Comanda @CLEAR
Sintaxa comenzii:
@ <linie1>,<coloana1>
[CLEAR |CLEAR TO <linie2>,<coloana2>]
Comanda @FILL
Sintaxa comenzii:
@ < linie1>,<coloana1> FILL TO < linie2 >,< coloana2 >
[COLOR SCHEME <exprN>| COLOR <lista perechi culori>]
Comanda DEFINE BOX
Sintaxa comenzii:
DEFINE BOX FROM <coloana1>TO <coloana2>
HEIGHT <exprN1>[AT LINE <exprN2>]
[SINGLE | DOUBLE | <caractere bordura>]
Comanda @PROMPT
Sintaxa comenzii:
@ <linie>, <coloana> PROMPT <exprC1>
[ MESSAGE <exprC2>]
Comanda MENU TO
Sintaxa comenzii: MENU TO <variabila memorie>
Comanda DEFINE MENU
Sintaxa comenzii:
DEFINE MENU <nume-meniu-orizontal>
[BAR [ AT LINE <exprN1>] }
[IN[ WINDOW] <nume-fereasta> | [ IN SCREEN ]
[ KEY <definire-tasta> ]
[ MARK <exprC1>] [ MESSAGE <exprC2>]
[ NOMARGIN ]
[ COLOR <lista - culori> | COLOR SCHEME <exprN2>]
Comanda DEFINE PAD
Sintaxa comenzii:
DEFINE PAD <nume - optiune> OF <nume-meniu-orizontal>
PROMPT <exprC1>[AT < linie , <col> ]
[KEY <optiune - tasta> [, <exprC2> ] ]
[MARK <exprC3>] [ SKIP [ FOR <exprL>]]
[MESSAGE <exprC4>]
[COLOR <lista - culori> | COLOR SCHEME <exprN>]
Sintaxa comenzii:
ON PAD <nume - optiune> OF <nume-meniu-orizontal>
[ACTIVATE POPUP <nume-meniu-vertical>
Sintaxa comenzii: ON SELECTION PAD <nume - optiune> OF <nume-meniu-orizontal> [<comanda> ]
Sintaxa comenzii: ON SELECTION MENU <nume - meniu - orizontal> | ALL [ <comanda> ]
Comanda ACTIVATE MENU
Sintaxa comenzii:
ACTIVATE MENU <nume - meniu - orizontal> [ NOWAIT ]
[ PAD <nume - optiune> ]
Comanda DEACTIVATE MENU
Sintaxa comenzii: DEACTIVATE MENU <lista-meniuri-orizontale>| ALL
Comanda SHOW MENU
Sintaxa comenzii:
SHOW MENU <lista-meniuri-orizontale> | ALL
[ PAD <optiune> ] [ SAVE ]
Comanda HIDE MENU
Sintaxa comenzii: HIDE MENU <lista-meniuri-orizontale> | ALL [ SAVE ]
Comanda RELEASE MENU | PAD
Sintaxele comenzii:
a) RELEASE MENU [ <lista-meniuri-orizontale> [ EXTENDED ]
b) RELEASE PAD <optiune> OF <nume-meniu-orizontal>
Comanda DEFINE POPUP
Sintaxa comenzii:
DEFINE POPUP <nume-meniu-vertical>
FROM <line1> , <col1> [ TO <line2>, <col2> ]
[IN [ WINDOW ] <nume-fereastra> | IN SCREEN ]
[FOOTER <exprC1>] [KEY <eticheta - tasta> ]
[MARGIN ] [ MARK <exprC2>] [ MESSAGE <exprC3>]
[MOVER ] [ MULTISELECT ] PROMPT FIELD <expr> |
PROMPT FILES [ LIKE <sablon> ] |
PROMPT STRUCTURE ] [RELATIVE ] [ SCROLL ]
[SHADOW ] [ TITLE <exprC4>]
[COLOR SCHEME <exprN> | COLOR < lista-paleta-culori> ]
Comanda DEFINE BAR
Sintaxa comenzii:
DEFINE BAR <exprN1> | <nume - optiune - sistem>
OF <nume - meniu - vertical> PROMPT <exprC1>
[ BEFORE <exprN2>| AFTER <exprN2>]
[ KEY <define - tasta> [ <exprC2>] ]
[ MARK <exprC3>]
[ MESSAGE <exprC4>] [ SKIP [ FOR <exprL>] ]
[ COLOR SCHEME <exprN> | COLOR <lista-paleta-culori> ]
Sintaxa comenzii:
ON BAR <exprN> OF <nume-meniu-vertical-1>
[ACTIVATE POPUP <nume-meniu-vertical-2> |
<ACTIVATE MENU <nume-meniu-orizontal>]
Comanda ON SELECTION BAR
Sintaxa comenzii:
ON SELECTION BAR <exprN> OF <nume-meniu-vertical>
[<comanda>]
Sintaxa comenzii:
ON SELECTION POPUP <nume-meniu-vertical>| ALL
[<comanda> ]
Comanda ACTIVATE POPUP
Sintaxa comenzii:
ACTIVATE POPUP <nume-meniu-vertical> [AT <linie>, <col> ]
[BAR <exprN>] [NOWAIT] [REST]
Comanda DEACTIVATE POPUP
Sintaxa comenzii:
DEACTIVATE POPUP <nume-meniu-vertical-1>
[, <nume-meniu-vertical-2>] | ALL
Comanda SHOW POPUP
Sintaxa comenzi:
SHOW POPUP
<nume-meniu-vertical-1>
[,<nume-meniu-vertical-2>] | ALL [SAVE]
Comanda HIDE POPUP
Ascunde unul, mai multe sau toate meniurile verticale de pe ecran sau dintr-o fereastra.
Sintaxa comenzii:
HIDE POPUP <nume-meniu-vertical-1>
[, <nume-meniu-vertical-2>] |ALL [SAVE]
Comanda MOVE POPUP
Sintaxa comenzii:
MOVE POPUP <nume-meniu-vertical> TO <linie>, <col> |
BY <exprN1>, <exprN2>
Comanda SIZE POPUP
Sintaxa comenzii:
SIZE POPUP <nume-meniu-vertical> TO <exprN1>, <exprN2>|
BY <exprN3>, <exprN4>
Comanda RELEASE POPUP | BAR
Sintaxa comenzii:
RELEASE POPUP [<lista-meniuri-verticale> [ EXTENDED ] ]
RELEASE BAR <exprN> OF <nume-meniu-vertical> |
BAR ALL OF <nume-meniu-vertical>
Comanda MENU
Sintaxa comenzii:
MENU BAR <tablou1>, <exprN1>
MENU <exprN2>, <tablou2>, <exprN3> [,exprN4]
READ MENU BAR TO <variabila-memorie1>,
<variabila-memorie2> [SAVE]
Comanda DEFINE WINDOW
Sintaxa comenzii:
DEFINE WINDOW <nume-fereastra1>
FROM <linie1>, <col1> TO <linie2>, <col2>
[ IN [WINDOW] <nume-fereastra2> |IN SCREEN]
[FOOTER <expr C1>] [ TITLE <expr C2>]
[DOUBLE | PANEL | NONE | SYSTEM | <caractare-bordura>]
[CLOSE | NOCLOSE] [FLOAT | NOFLOAT]
[GROW | NOGROW] [MINIMIZE] [SHADOW]
[ZOOM | NOZOOM] [FILL <expr C3>]
[COLOR SCHEME <exprN> | COLOR <lista-culori>]
Comanda SET BORDER
Sintaxa comenzii:
SET BORDER TO
[SINGLE| DOUBLE| PANEL| NONE| <sir-contur 1>
[,<sir-contur-2>] ]
Comanda ACTIVATE WINDOW
Sintaxa comenzii:
ACTIVATE WINDOW [<nume-fereastra1> [,<nume-fereastra2>] ]
| ALL [IN WINDOW] <nume-fereastra3> | SCREEN]
[BOTTOM | TOP | SAME] [NOSHOW]
Comanda DEACTIVATE WINDOW
Sintaxa comenzii:
DEACTIVATE WINDOW [< nume-fereastra1>
[,<nume-fereastra2>] ] | ALL
Comanda SHOW WINDOW
Sintaxa comenzii:
SHOW WINDOW <nume-fereastra1> [, <nume-fereastra2>] | ALL
[ IN [WINDOW] <nume-fereastra3> | IN SCREEN]
[REFRESH] [TOP | BOTTOM | SAME] [SAVE]
Comanda HIDE WINDOW
Sintaxa comenzii:
HIDE WINDOW [<nume-fereastra1> [, <nume-fereastra2>] . ] | ALL [IN [WINDOW] [<nume-fereastra3> | SCREEN] [SAVE]
Comanda RELEASE WINDOW
Sintaxa comenzii: RELEASE WINDOW [<nume-fereastra1> [, <nume-fereastra2>] ]
Comanda MOVE WINDOW
Sintaxa comenzii:
MOVE WINDOW <nume-fereastra> TO <linie>, <coloana> |
BY <exprN1>, <exprN2>
Comanda CLEAR WINDOWS
Sintaxa comenzii: CLEAR WINDOWS
Comanda SAVE WINDOW
Sintaxa comenzii:
SAVE WINDOW <lista de ferestre> | ALL
TO <nume fisier> | TO MEMO <camp memo>
Comanda RESTORE WINDOW
Sintaxa comenzii:
RESTORE WINDOW <lista-de-ferestre> |ALL
FROM < fisier> | FROM MEMO <camp memo>
Comanda ZOOM WINDOW
Sintaxa comenzii:
ZOOM WINDOW <nume-fereastra> MIN [AUTO]
| MAX| NORM [AT <linie 1>, <coloana1> |
FROM <linie1> , <coloana1>
[SIZE <linie2>, <coloana2> | TO <linie2>, <coloana2>] ]
Comanda SCROLL WINDOW
Sintaxa comenzii:
SCROLL <linie1, coloana1>, <linie2, coloana2>
,<exprN1> [,<exprN2>]
Comanda SET WINDOW OF MEMO
Sintaxa comenzii: SET WINDOW OF MEMO TO <nume-fereastra>
Functia WTITLE ( )
Sintaxa functiei: WTITLE ( <nume-fereastra>)
Comanda CREATE TABLE
Sintaxa simplificata a comenzii:
CREATE TABLE | DBF <nume-tabela>;
(<nume camp1> <tip> [<dimensiune>][, <nume camp2> <tip> ..])
Comanda INSERT
Sintaxa comenzii:
INSERT INTO < nume tabela > [<fisier 1>[, <fisier 2>[,]]]
VALUES (<expresie 1> [, <expresie 2> [, ]])
Comanda UPDATE
Sintaxa comenzii:
UPDATE <tabela>;
SET <nume camp1> = <expresie1> [, <nume camp2> = <expresie2>, ..];
WHERE <conditii>
Comanda SELECT
Sintaxa simplificata a comenzii:
SELECT [ALL|DISTINCT] <lista campuri, expresii | *> ;
FROM <lista tabele>;
[WHERE <conditii de join si de selectie>] ;
[ORDER BY <lista campuri de sortare>];
[GROUP BY <lista campuri de grupare>];
[HAVING <conditie pentru grup>];
[UNION (SELECT.)]
