home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Du Jour
/
SoftwareDuJour.iso
/
BUSINESS
/
DBASE
/
VIEWGEN.ARC
/
DEMOFULL.VGT
< prev
next >
Wrap
Text File
|
1985-10-01
|
11KB
|
756 lines
ClearBox( 19,10,21,72 )
Color( 14 )
Say( 20,24,'Press the SPACEBAR to continue.' )
GetChar( ' ' )
ClearBox( 5,10,20,72 );
Text( 6,10 )
PURPOSE: ViewGen is a screen design tool and program
generator for dBASE III version 1.1, Clipper
(Summer, 1985), and the Developer's Release.
FEATURES: ViewGen produces a dBASE III DATA ENTRY
application complete with Append, Edit/View,
and Pack operations. The Edit/View option
has Find, Goto, Locate, and several other
selections. ViewGen can also produce Format
Files (.FMT).
EndText
GetChar( ' ' )
ClearBox( 11,10,20,72 );
Text( 11,10 )
FEATURES: The data entry screens are designed by:
(1) Loading the fields of a dBASE III
database file, and
(2) SELECTing and DRAGging these fields
to achieve the desired format.
(3) Also, PICTURE and RANGE clauses can
be entered.
EndText
GetChar( ' ' )
Returnkey
Delay( 10 )
ClearBox( 12,38,16,76,112 )
Color( 112 )
BoxText( 12,38)
This is the
File Specifications view.
EndText
Delay( 40 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
In this view we can EDIT the
Datafile, INDEX, Key Expression,
and SET RELATION TO command.
EndText
Delay( 70 )
* INDEX file.
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
Let us enter an INDEX filename.
EndText
Delay( 50 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
Please TYPE the following index
filename:
NAMES
EndText
' '
GetChar( 'N' )
GetChar( 'A' )
GetChar( 'M' )
GetChar( 'E' )
GetChar( 'S' )
Delay( 3 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
Now, press the RETURN key.
EndText
GetKey( Returnkey )
Delay( 8 )
Rightarrow
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
Notice, the Key Expression is
automatically loaded.
EndText
Delay( 50 )
* HELP screens.
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
ViewGen has context sensitive
HELP screens.
EndText
Delay( 50 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
We can view these HELP screens
by pressing the F1 key.
EndText
Delay( 50 )
ClearBox( 12,38,16,76,112 )
F1
Delay( 25 )
* In HELP table of contents.
ClearBox( 9,20,15,60,112 )
BoxText( 9,20 )
We can view the Table of Contents
by pressing the F1 key a second
time.
EndText
Delay( 50 )
F1
Delay( 30 )
* Examples.
ClearBox( 15,20,20,60,112 )
BoxText( 15,20 )
Let us look at two other HELP
screens before we return to the
File Specifications view.
EndText
Delay( 60 )
PutDelay( 10 )
Downarrow
Downarrow
Delay( 20 )
Returnkey
Delay( 60 )
F1
Delay( 10 )
PutDelay( 5 )
Downarrow
Downarrow
Downarrow
Downarrow
Downarrow
Delay( 10 )
Returnkey
Delay( 50 )
Esc
* Exit to Forms View.
Delay( 5 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
Remember,
these HELP screens are
CONTEXT SENSITIVE:
EndText
Delay( 60 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
This means you can always get
HELP on what you are CURRENTLY
working on.
EndText
Delay( 60 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
Now, let us look at
the Forms View screen.
EndText
Delay( 50 )
ClearBox( 12,38,16,76,112 )
BoxText( 12,38 )
Please press the F10 key.
EndText
GetKey( F10 )
* ---FORMS VIEW.
Delay( 20 )
ClearBox( 2,45,6,79,112 )
Color( 112 )
BoxText( 2,45 )
This is the Forms View screen.
EndText
Delay( 40 )
CtrlPgUp
ClearBox( 2,50,12,79,112 )
BoxText( 2,50 )
In Forms View you can:
EDIT,
SELECT,
DRAG,
Toggle,
Insert TEXT,
Center, and
RESEQUENCE
EndText
Delay( 100 )
CtrlPgUp
ClearBox( 2,45,6,79,112 )
BoxText( 2,45 )
First, let us EDIT the fields.
EndText
Delay( 60 )
PutDelay( 3 )
CtrlPgUp
* Firstname.
' '
Rightarrow
Rightarrow
Rightarrow
Rightarrow
Rightarrow
' '
Returnkey
Downarrow
PutDelay( 1 )
* Lastname.
' '
Rightarrow
Rightarrow
Rightarrow
Rightarrow
' '
Returnkey
Downarrow
* Jobtitle.
' '
Rightarrow
Rightarrow
Rightarrow
' '
Endkey
' '
' '
' '
' '
' '
Returnkey
Downarrow
* Deptcode.
' '
Rightarrow
Rightarrow
Rightarrow
'a'
'r'
Rightarrow
'm'
'e'
'n'
't'
' '
Endkey
Backspace
Returnkey
Downarrow
* Salary.
' '
'C'
'u'
'r'
'r'
'e'
'n'
't'
' '
Endkey
Backspace
Backspace
Returnkey
Downarrow
* Startdate.
' '
Rightarrow
Rightarrow
Rightarrow
Rightarrow
Rightarrow
'i'
'n'
'g'
' '
Endkey
' '
' '
Returnkey
Downarrow
* Address.
' '
Endkey
Backspace
Backspace
Returnkey
Downarrow
* City
' '
Endkey
Backspace
Backspace
Returnkey
Downarrow
* State
' '
Endkey
Backspace
Backspace
Returnkey
Downarrow
* Zip
' '
Endkey
Backspace
Backspace
Returnkey
Downarrow
* Areacode
' '
Rightarrow
Rightarrow
Rightarrow
Rightarrow
Del
Del
Del
Del
Del
Returnkey
Downarrow
* Phone.
' '
Endkey
Backspace
Backspace
Backspace
Backspace
Returnkey
Home
* SELECT and DRAG the groups.
Delay( 30 )
ClearBox( 2,45,5,79,112 )
BoxText( 2,45 )
Next, let us SELECT and DRAG
the fields.
EndText
Delay( 60 )
CtrlPgUp
PutDelay( 2 )
* DRAG Area and Phone.
Endkey
F6
Uparrow
F3
CtrlRightarrow
CtrlRightarrow
CtrlRightarrow
CtrlRightarrow
CtrlRightarrow
Rightarrow
Uparrow
Uparrow
Uparrow
Uparrow
Uparrow
Returnkey
Downarrow
F3
CtrlRightarrow
Uparrow
Returnkey
Delay( 10 )
Endkey
* DRAG Address...Phone
Uparrow
Uparrow
Uparrow
Uparrow
Uparrow
F6
Endkey
F3
Downarrow
Downarrow
Downarrow
Downarrow
CtrlRightarrow
Rightarrow
Returnkey
* DRAG Jobtitle...Startdate.
Home
Downarrow
Downarrow
F6
Downarrow
Downarrow
Downarrow
F3
Downarrow
Downarrow
Rightarrow
Rightarrow
Rightarrow
Rightarrow
Returnkey
* DRAG entire screen.
Home
F6
Endkey
F3
Downarrow
Downarrow
Returnkey
Home
* Toggle Area and Phone.
Delay( 40 )
Color( 112 )
ClearBox( 3,45,6,79,112 )
BoxText( 3,45 )
Field GETs can be placed
below the field labels.
EndText
Delay( 60 )
CtrlPgUp
Delay( 10 )
* Toggle Area and Phone.
Endkey
F6
Uparrow
Returnkey
Delay( 15 )
AltT
Delay( 20 )
* DRAG Phone beside Area.
Downarrow
F3
Leftarrow
Leftarrow
Leftarrow
Returnkey
Home
* Inserting Text.
Delay( 30 )
Color( 112 )
ClearBox( 3,45,5,79,112 )
BoxText( 3,45 )
We can insert free TEXT.
EndText
Delay( 50 )
CtrlN
Uparrow
Uparrow
PutDelay( 1 )
* Add text to text object.
'E'
'M'
'P'
'L'
'O'
'Y'
'E'
'E'
' '
'D'
'A'
'T'
'A'
'B'
'A'
'S'
'E'
Returnkey
* Centering text.
Delay( 40 )
CtrlPgUp
ClearBox( 3,45,5,79,112 )
BoxText( 3,45 )
We can CENTER the text.
EndText
Delay( 50 )
ClearBox( 3,45,6,79,112 )
BoxText( 3,45 )
Please hold down the ALT key
and press the letter 'C'.
EndText
GetKey( AltC )
* RESEQ.
Delay( 30 )
ClearBox( 3,45,5,79,112 )
BoxText( 3,45 )
We can RESEQUENCE the labels.
EndText
Delay( 50 )
ClearBox( 3,45,6,79,112 )
BoxText( 3,45 )
This allows field selection
to progress by Row or Column.
EndText
Delay( 60 )
CtrlPgUp
F5
Delay( 40 )
'R'
* Move to Table View.
Delay( 30 )
ClearBox( 3,45,6,79,112 )
BoxText( 3,45 )
Now, let us look at
the Table View screen.
EndText
Delay( 60 )
CtrlPgUp
ClearBox( 3,45,5,79,112 )
BoxText( 3,45 )
Please press the F10 key.
EndText
GetKey( F10 )
* Inside Table View.
Delay( 20 )
ClearBox( 7,23,9,58,112 )
BoxText( 7,23 )
This is the Table View screen.
EndText
Delay( 50 )
* Table introduction.
ClearBox( 7,23,10,58,112 )
BoxText( 7,23 )
In this view we can add
PICTURE and RANGE clauses.
EndText
Delay( 50 )
* PICTURE.
ClearBox( 7,23,10,58,112 )
BoxText( 7,23 )
Let us first add the PICTURE
clauses.
EndText
Delay( 50 )
CtrlHome
PutDelay( 2 )
Downarrow
Downarrow
Downarrow
Downarrow
Downarrow
Rightarrow
Rightarrow
Rightarrow
Rightarrow
Rightarrow
* Salary picture.
' '
F1
ClearBox( 10,29,13,64,112 )
BoxText( 10,29 )
HELP is available for Numeric
field PICTURE clauses.
EndText
Delay( 60 )
F1
Delay( 10 )
PutDelay( 2 )
'9'
'9'
'9'
','
'9'
'9'
'9'
'.'
'9'
'9'
PutDelay( 3 )
Returnkey
Downarrow
Downarrow
* Areacode picture.
PutDelay( 1 )
' '
'9'
'9'
'9'
PutDelay( 3 )
Returnkey
Downarrow
* Phone picture.
' '
F1
ClearBox( 17,29,20,64,112 )
BoxText( 17,29 )
This is the HELP available
for Character fields.
EndText
Delay( 80 )
F1
Delay( 10 )
PutDelay( 1 )
'9'
'9'
'9'
'-'
'9'
'9'
'9'
'9'
PutDelay( 3 )
Returnkey
Downarrow
Downarrow
Downarrow
* State picture.
' '
PutDelay( 1 )
'@'
'!'
'A'
PutDelay( 3 )
Returnkey
Downarrow
* Zip picture.
' '
PutDelay( 1 )
'9'
'9'
'9'
'9'
'9'
PutDelay( 2 )
Returnkey
* RANGE.
Delay( 50 )
ClearBox( 7,23,11,58,112 )
BoxText( 7,23 )
We can also add RANGE clauses.
EndText
Delay( 60 )
CtrlPgUp
Endkey
Downarrow
Downarrow
Downarrow
Downarrow
Downarrow
PutDelay( 1 )
* Salary range.
' '
'5'
'0'
'0'
'0'
','
'2'
'5'
'0'
'0'
'0'
'0'
Returnkey
Downarrow
* Startdate range.
' '
'C'
'T'
'O'
'D'
'('
'"'
'0'
'5'
'/'
'1'
'5'
'/'
'8'
'2'
'"'
')'
','
'D'
'A'
'T'
'E'
'('
')'
Returnkey
PutDelay( 0 )
* CODE generation.
Delay( 30 )
ClearBox( 7,23,10,58,112 )
BoxText( 7,23 )
We are now ready to generate
the dBASE III programs.
EndText
Delay( 70 )
CtrlHome
ScrollLock
ClearBox( 8,41,12,75,112 )
BoxText( 8,41 )
We select ViewGen Programs
(from the Gen pull-down menu)
and enter a filename.
EndText
Delay( 80 )
Returnkey
ClearBox( 8,41,12,75,112 )
BoxText( 8,41 )
Please TYPE the following
filename:
DEMO
EndText
* Generate ViewGen Programs.
GetChar( 'D' )
GetChar( 'E' )
GetChar( 'M' )
GetChar( 'O' )
Delay( 3 )
ClearBox( 8,41,12,73,112 )
BoxText( 8,41 )
Now, press the RETURN key.
EndText
GetKey( Returnkey )
Delay( 10 )
ScrollLock
Delay( 8 )
ClearBox( 6,10,16,70,112 )
BoxText( 6,10 )
ViewGen has just created a DATA ENTRY application
complete with the screen we designed in Forms View
and the PICTURE and RANGE clauses we entered in
Table View. The dBASE III programs generated are
Demo.PRG (main program) and several small programs
beginning with DEM_ followed by the function name
(PROC, MENU, APPE, EDIT, HELP, LABE, PACK, & REPO).
Press RETURN to continue.
EndText
GetKey( Returnkey )
CtrlHome
ClearBox( 7,23,9,53,112 )
BoxText( 7,23 )
We will now QUIT ViewGen.
EndText
Delay( 40 )
CtrlHome
ScrollLock
PutDelay( 10 )
Leftarrow
Delay( 10 )
Endkey
ClearBox( 7,32,9,66,112 )
BoxText( 7,32 )
Please TYPE the letter 'Q'.
EndText
GetChar( 'Q' )
PutDelay( 0 )
'N'
ClearBox( 7,23,9,58,112 )
BoxText( 7,23 )
Finally, TYPE the letter 'Y'.
EndText
GetChar( 'Y' )
*
*
*
*
*
*