COMPRESS
Creates a Zip File
Syntax:
COMPRESS [ FILES ] <afiles>
TO <cZipFile>
BLOCK <bBlock>
[ OVERWRITE ]
DECODE
Decodes Database Records Or Files
Syntax:
DECODE [FROM <(file)>] ON <key>
FIELDS <fields,...>
[ PASSWORD <password> ]
[ FOR <for> ]
[ WHILE <while> ]
[ ALL ]
DECODE <file1> TO <file2> [ PASSWORD <password>] [DELETE]
DECODE FILE <file> [ PASSWORD <password> ]
DISPLAY HELP
Display Windows Help
Syntax:
DISPLAY HELP
MAIN | CONTEXT <nTopic> | POPUP <nTopic>
DO EVENTS
Forces System Event Processing
Syntax:
DO EVENTS
DO REPORT
Creates a Report Based Upon Given Parameters
Syntax:
DO REPORT
TITLE <ctitle>
HEADERS <aheaders1> , <aheaders2>
FIELDS <aFields>
WIDTHS <aWidths>
[ TOTALS <aTotals> ]
[ NFORMATS <aformats> ]
WORKAREA <WorkArea>
LPP <nLinesPerPage>
CPL <nCahractersPerLine>
[ LMARGIN <nLeftmargin> ]
[ PAPERSIZE <nPaperSize> ]
[ NOFIXED ]
[ DOSMODE ]
[ PREVIEW ]
[ SELECT ]
[ IMAGE <cgraphic> AT <nfi> , <nci> TO <nff> , <ncf> ]
[ MULTIPLE ]
[ GROUPED BY <cGroupBy> ]
[ HEADRGRP <cHeaderGroup> ]
[ LANDSCAPE ]
DO REPORT FORM
Executes a Report From a Given Report Definition File
Syntax:
DO REPORT FORM <cReportFormName[.rpt>
DRAW \/ ERASE \/ PRINT GRAPH
Drawing Commands
Syntax:
Bar\/Lines\/Points Chart:
DRAW GARPH
IN WINDOW <WindowName>
AT <nRow>,<nCol>
TO <nRow>,<nCol>
TITLE <cTitle>
TYPE [ BARS | LINES | POINTS ]
SERIES <aSeries>
YVALUES <aYValues>
DEPTH <nDepth>
BARWIDTH <nBarWidth>
HVALUES <nHorizaontalValues>
SERIENAMES <aSeriesNames>
COLORS <anColors>
[ 3DVIEW ]
[ SHOWGRID ]
[ SHOWXVALUES ]
[ SHOWYVALUES ]
[ SHOWLEGENDS ]
[ LEGENDSWIDTH <nWidth> ]
Pie Chart:
DRAW GRAPH IN WINDOW <window>
AT <nT>,<nL>
TO <nB>,<nR>
TITLE <cTitle>
TYPE PIE
SERIES <aSer>
DEPTH <nD>
SERIENAMES <aName>
COLORS <aColor>
[ 3DVIEW ]
[ SHOWXVALUES ]
[ SHOWLEGENDS ]
Draw Line:
DRAW LINE IN WINDOW <WindowName> AT <nRow>,<nCol>
TO <nRow>,<nCol>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <nPenWidth> ]
Draw Rectangle:
DRAW RECTANGLE IN WINDOW <WindowName> AT <nRow>,<nCol>
TO <nRow>,<nCol>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <nPenWidth> ]
[ FILLCOLOR <anFillColor> ]
Draw RoundRectangle:
DRAW ROUNDRECTANGLE IN WINDOW <WindownNme>
AT <nRow> , <nCol>
TO <nRow> , <nCol>
ROUNDWIDTH <nWidth>
ROUNDHEIGHT <nHeight>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <nPenWidth> ]
[ FILLCOLOR <anFillColor> ]
Draw Ellipse
DRAW ELLIPSE IN WINDOW <WindowName> AT <nRow>,<nCol>
TO <nRow>,<nCol>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <nPenWidth> ]
[ FILLCOLOR <anFillColor> ]
Draw Arc:
DRAW ARC IN WINDOW <WindowName> AT <nRow>,<nCol>
TO <nRow>,<nCol>
FROM RADIAL <nRow>,<nCol>
TO RADIAL <nRow>,<nCol>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <anFillColor> ]
Draw Pie:
DRAW PIE IN WINDOW <windowname> AT <nRow>,<nCol>
TO <nRow>,<nCol>
FROM RADIAL <nRow>, <nCol>
TO RADIAL <nRow>, <nCol>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <nPenWidth> ]
[ FILLCOLOR <anFillColor> ]
Draw Polygon:
DRAW POLYGON IN WINDOW <WindowName> ;
POINTS <anPoints>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <nPenWidth> ]
[ FILLCOLOR <anFillColor> ]
Draw Polybezier:
DRAW POLYBEZIER IN WINDOW <WindowName>
POINTS <anPoints>
[ PENCOLOR <anPenColor> ]
[ PENWIDTH <nPenWidth> ]
Erase:
ERASE [ IN ] WINDOW <WindowName>
Print Graph:
PRINT GRAPH [ OF ] <cWindowname> [ PREVIEW ] [ DIALOG ]
'Print Graph' command, prints BARS, POINTS, LINES or PIE graph previously drawn using DRAW GRAPH command in the specified window.
Alternatively, BosTaurus library which is exclusively for drawing and image manipulation can also be used.
EDIT
Edits Database Records In The Specified WorkArea
Syntax:
EDIT
WORKAREA <workarea>
[ TITLE <cTitle> ]
[ FIELDS <acFields> ]
[ READONLY <alReadOnlyFields> ]
[ SAVE <bSave> ]
[ SEARCH <bSearch> ]
EDIT EXTENDED
[ WORKAREA <cWorkArea> ]
[ TITLE <cTitle> ]
[ FIELDNAMES <acFieldNames> ]
[ FIELDMESSAGES <acFieldMessages> ]
[ FIELDENABLED <alFieldView> ]
[ TABLEVIEW <alTableView> ]
[ OPTIONS <aOptions> ]
[ ON SAVE <bSave> ]
[ ON FIND <bFind> ]
[ ON PRINT <bPrint> ]
ENCODE
Encodes Database Records Or Files
Syntax:
ENCODE [ FROM < file > ] ON < key >
FIELDS <fields,...>
[ PASSWORD <password> ]
[ FOR <ForExpression> ]
[ WHILE <WhileExpression> ]
[ ALL ]
ENCODE <file1> TO <file2> [ PASSWORD <password> ] [ DELETE ]
ENCODE FILE <file> [ PASSWORD <password> ]
EXECUTE
Opens Or Prints Specified Files
EXECUTE
[ OPERATION <operation> ]
[ FILE <file> ]
[ PARAMETERS <parameters> ]
[ DEFAULT <default> ]
[ MAXIMIZE | MINIMIZE | HIDE ]
EXECUTE
[ FILE <file> ]
[ MAXIMIZE | MINIMIZE | HIDE ]
WAIT
The file can be an executable file or a document file.
GRAPH BITMAP
Draw Graph in Bitmap Memory
GRAPH BITMAP PIE ;
SIZE <nWidth>, <nHeight> ;
SERIEVALUES <aSerieValues> ;
SERIENAMES <aSerieNames> ;
SERIECOLORS <aSerieColors> ;
TITLE <cTitle> ;
TITLECOLOR <aTitleColor>;
DEPTH <nDepth> ;
3DVIEW <l3DView> ;
SHOWXVALUES <lShowXValues> ;
SHOWLEGENDS <lShowLegends> ;
NOBORDER <lNoBorder> ;
STOREIN <hBitmapVar>
GRAPH BITMAP BARS|LINES|POINTS ;
SIZE <nWidth>, <nHeight> ;
SERIEVALUES <aSerieValues> ;
SERIENAMES <aSerieNames> ;
SERIECOLORS <aSerieColors> ;
SERIEYNAMES <aSerieYNames> ;
PICTURE <cPicture> ;
TITLE <cTitle> ;
TITLECOLOR <aTitleColor> ;
HVALUES <nHValues> ;
BARDEPTH <nBarDepth> ;
BARWIDTH <nBarWidth> ;
SEPARATION <nSeparation> ;
LEGENDWIDTH <nLegendWindth> ;
3DVIEW <l3DView> ;
SHOWGRID <lShowGrid> ;
SHOWXGRID <lShowXGrid> ;
SHOWYGRID <lShowYGrid> ;
SHOWVALUES <lShowValues> ;
SHOWXVALUES <lShowXValues> ;
SHOWYVALUES <lShowYValues> ;
SHOWLEGENDS <lShowLegends> ;
NOBORDER <lNoBorder> ;
STOREIN <hBitmapVar>
Note:
Assign a bitmap to an image control, e.g.:
Form_1.Image_1.HBITMAP := hBitmapVarSave a bitmap to disk, e.g.:
BT_BitmapSaveFile( hBitmapVar, "Graph.PNG", BT_FILEFORMAT_PNG )See demo \SAMPLES\Controls\Graph\GRAPH_Bitmap
ON KEY
Defines a Keyboard Shortcut
ON KEY <Key>
[ OF <ParentWindow> ]
ACTION <ActionProcedureName> | <bBlock>
<Key> must be one of the following:
Basic Keys
F1...F12
BACK,TAB,RETURN,ESCAPE,END,HOME,LEFT,UP,RIGHT,DOWN,INSERT,DELETE,PRIOR,NEXT
Alt Keys
ALT+A...ALT+Z
ALT+0...ALT+9
ALT+F1...ALT+F12
ALT+BACK,ALT+TAB,ALT+RETURN,ALT+ESCAPE,ALT+END,ALT+HOME,ALT+LEFT,ALT+UP,
ALT+RIGHT,ALT+DOWN,ALT+INSERT,ALT+DELETE,ALT+PRIOR,ALT+NEXT
Shift Keys
SHIFT+A...SHIFT+Z
SHIFT+0...SHIFT+9
SHIFT+F1...SHIFT+F12
SHIFT+BACK,SHIFT+TAB,SHIFT+RETURN,SHIFT+ESCAPE,SHIFT+END,SHIFT+HOME,
SHIFT+LEFT,SHIFT+UP,SHIFT+RIGHT,SHIFT+DOWN,SHIFT+INSERT,SHIFT+DELETE
SHIFT+PRIOR,SHIFT+NEXT
Control Keys
CONTROL+A...CONTROL+Z
CONTROL+1...CONTROL+9
CONTROL+F1...CONTROL+F12
CONTROL+BACK,CONTROL+TAB,CONTROL+RETURN,CONTROL+ESCAPE,CONTROL+END,
CONTROL+HOME,CONTROL+LEFT,CONTROL+UP,CONTROL+RIGHT,CONTROL+DOWN,
CONTROL+INSERT,CONTROL+DELETE,CONTROL+PRIOR,CONTROL+NEXT
PLAY WAVE
Plays a Wave From File Or Resource
PLAY WAVE <cWaveName>
[ FROM RESOURCE ]
[ SYNC ]
[ NOSTOP ]
[ LOOP ]
[ NODEFAULT ]
RELEASE KEY
Releases a Key Defined Via ON KEY Command
RELEASE KEY <Key> OF <WindowName>
Refer to ON KEY command for a list of available keys.