home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR7
/
DBONL102.ZIP
/
SYNTAX.DOC
< prev
Wrap
Text File
|
1993-10-20
|
5KB
|
260 lines
dB Online 1.0 Beta. Syntax file. September 10, 93
===============================================================================
The following document indicates the commands and functions that are working
in the current release of dB Online 1.0 Beta.
<var> is a variable name
<field> is a field identifier
<expr> is an expression
<nexpr> is a numeric expression
<sexpr> is a string expression
<lexpr> is a logical expression
<dexpr> is a date expression
[item] indicates optional item
<scope> allows record specification (ALL, NEXT n, RECORD n, REST)
| indicates multiple choices
*<command> indicates command has not been implemented yet.
Any filename, tagname, aliasname may be macro substituted. &var.
--------
COMMANDS
--------
?|?? <expr list>
@ <row,col> [[SAY<expr> [PICTURE <sexpr>]][GET <var/field> [PICTURE <sexpr>]
[RANGE [expr],[expr]]]] | [CLEAR]
@ <row1,col1> [CLEAR] TO <row2,col2> [DOUBLE]
ACCEPT [<sexpr>] TO <var>
APPEND BLANK
AVERAGE <expr list> [<scope>] TO <var list> [WHILE <lexpr>] [FOR <lexpr>]
CANCEL
CLEAR [ALL/GETS/TYPEAHEAD]
CLOSE [ALTERNATE/DATABASES/INDEX]
CONTINUE
COUNT TO <var> [<scope>] [WHILE <lexpr>] [FOR <lexpr>]
DELETE [<scope>] [WHILE <lexpr>] [FOR <lexpr>]
DISPLAY [OFF] [<scope>] [<expr list>] [WHILE <lexpr>] [FOR <lexpr>]
*{TO PRINT not implemented}
DO <procedure name> [WITH <expr list>]
Procedure must be defined with PROCEDURE command. procedures are included
at the bottom of the main file, or can be in separate file indicated by
SET PROCEDURE TO <file> command.
DO CASE
CASE <lexpr>
<commands>
[CASE <lexpr>]
<commands>
[OTHERWISE]
<commands>
ENDCASE
DO WHILE <lexpr>
<commands>
[EXIT]
<commands>
[LOOP]
<commands>
ENDDO
*EJECT
*FIND
GO|GOTO <nexpr> | TOP | BOTTOM
IF <lexpr>
<commands>
[ELSE]
<commands>
ENDIF
INPUT [<sexpr>] to <var>
LIST [OFF] [<scope>] [<expr list>] [WHILE <lexpr>] [FOR <lexpr>]
*{TO PRINT not implemented}
LOCATE <scope> [FOR <lexpr>] [WHILE <lexpr>]
ON ERROR|ESCAPE DO <procedure name> [WITH <expr list>]
ON
PACK
PRIVATE <var list>
PROCEDURE <procedure name>
PARAMETERS <var list>
can be defined after main program or in separate 'include' files using
SET PROCEDURE COMMAND
PUBLIC <var list>
QUIT
READ [SAVE]
RECALL [<scope>] [WHILE <lexpr>] [FOR <lexpr>]
REINDEX
REPLACE <field> WITH <expr> [,<field> WITH <expr> ...] [WHILE <lexpr>]
[FOR <lexpr>]
RESTORE FROM <file>
RETRY
RETURN
RUN <dos command>
SAVE [ALL LIKE|EXCEPT] TO <file>
SEEK <sexpr> | <dexpr> | <nexpr>
SELECT <a..j> | <1..10> | <alias>
SET commands see below
SKIP <nexpr>
STORE <expr> TO <var list>
SUM <expr list> [<scope>] TO <var list> [WHILE <lexpr>] [FOR <lexpr>]
TEXT
Any text to output
ENDTEXT
TYPE
USE <filename> [INDEX <index file list>] [ALIAS <alias name>] [IN <nexpr>]
WAIT [<sexpr>] [TO <var>]
------------
SET COMMANDS
------------
SET ALTERNATE on|OFF
SET ALTERNATE TO [<filename>]
SET BELL ON|off
SET CENTURY on|OFF
SET COLOR TO <color code> , <color code>
SET CONFIRM on|OFF
*SET CONSOLE ON|off
SET DECIMALS TO <nexpr>
SET DEFAULT TO <drive>
SET DELETED on|OFF
SET DELIMETERS on|OFF
SET DELIMETERS TO [<sexpr> | DEFAULT]
*SET DEVICE TO PRINT|SCREEN
SET ESCAPE ON|off
SET EXACT on|OFF
SET FIXED on|OFF
SET INDEX TO [<index file list>]
SET INTENSITY ON|off
*SET MARGIN TO <nexpr>
SET MEMOWIDTH TO <nexpr>
SET ORDER TO [<nexpr>] | [TAG tag]
SET PATH TO [<path list>]
*SET PRINT on|OFF
*SET PRINTER TO <DOS device>
SET PROCEDURE TO <procedure filename>
{used to include multiple procedure files}
SET RELATION TO [<key expression>] | <nexpr> INTO <alias>
*SET TYPEAHEAD TO
---------
FUNCTIONS
---------
& {macro substitution}
ABS()
ASC()
AT()
BOF()
CDOW()
CDX()
CHR()
CMONTH()
CMONTH()
COL()
CTOD()
DATE()
DAY()
DBF()
DELETED()
DISKSPACE()
DOW()
DTOC()
EOF()
ERROR()
EXP()
FIELD()
FILE()
FOUND()
GETENV()
IIF()
INKEY()
INT()
ISALPHA()
ISCOLOR()
ISLOWER()
ISUPPER()
LASTKEY()
LEFT()
LEN()
LOG()
LOWER()
LTRIM()
LUPDATE()
MAX()
MDX()
MESSAGE()
MIN()
MOD()
MONTH()
NDX()
OS()
*PCOL()
*PROW()
READKEY()
RECCOUNT()
RECNO()
RECSIZE()
REPLICATE()
RIGHT()
ROUND()
ROW()
RTRIM()
SPACE()
SQRT()
STR()
STUFF()
SUBSTR()
TAG()
TIME()
TRANSFORM()
TRIM()
*TYPE()
UPPER()
VAL()
VERSION()
YEAR()