home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
dp395.zip
/
MANUAL.EXE
/
DPLUS.MAN
< prev
Wrap
Text File
|
1989-04-21
|
115KB
|
2,756 lines
TABLE OF CONTENTS
_____________________________________________________________________________
U S I N G D A T A + P L U S - Getting Started
Page(s)
Introduction...............................................Cover Page
Help for the First Time User...............................2
How to Create a Database File..............................4-6
Drive Selector.............................................6-7
Adding Records to the Database.............................7,13-15
Displaying and Printing the Database File..................17-20
Saving your Information (Backup and Copying Files).........38-39
_____________________________________________________________________________
U P D A T I N G D A T A + P L U S R E C O R D S
Select File to update......................................6-7
Adding Records.............................................7,13-15
Editing Records............................................16
Deleting Records...........................................32,36-37
_____________________________________________________________________________
H O W T O S E A R C H
Setting Record Pointer.....................................13,15
Locating Records (One at a time)...........................14
Retrieving Groups of Records...............................17-18
_____________________________________________________________________________
H O W T O A R R A N G E R E C O R D S I N D A T A + P L U S
Indexing for a Database....................................24
Sorting records in a Database..............................24-26
Copying Database Structure.................................26-27
_____________________________________________________________________________
H O W T O F I L T E R R E C O R D S I N D A T A + P L U S (QUERY)
Setting Filter for Scan and Edit Modes.....................4
- 1 -
TABLE OF CONTENTS Page 2 of 2
_____________________________________________________________________________
H O W T O C R E A T E R E P O R T S A N D L A B E L S
Create a Report............................................8
Report Title...............................................8
Report Sub-Groups..........................................9
Report Contents............................................9
Report Header..............................................9
Cursor & Function Commands for Create......................10
Printing a Report..........................................20-22
Create a Label.............................................11
Label Size.................................................11-12
Label Contents.............................................12-13
Printing a Label...........................................22,23
_____________________________________________________________________________
H O W T O I M P O R T O R E X P O R T W I T H D A T A + P L U S
Importing Files............................................27,32-33
Exporting Files............................................18,20,22,23
_____________________________________________________________________________
H O W T O S U M A N D A V E R A G E W I T H D A T A + P L U S
Sum Numeric Content For A Database.........................34
Average Numeric Content For A Database.....................35
_____________________________________________________________________________
- 2 -
D A T A + P L U S
USER MANUAL
CONTENTS
A. First Time User
B. Scan Mode
C. Create Database
D. Create Report
E. Create Label
F. Drive Selection
G. Edit Database
H. Append Database
I. Xecute Mode
J. Utilities
K. More Menu
L. Quit Help
NOTE: [F1] command will bring the above HELP INDEX to the screen
when access is initiated from the main menu. Additionally
[F1] will access the MENU-DRIVEN HELP SCREEN, which is an
internal HELP available while working within the REPORT,
and LABEL modes. There are also [H] HELP SCREENS in the
XECUTE mode to provide additional help.
Cover Page
Copyright (c) Plano Computer Sales Co. 1986-1989. ALL Rights Reserved.
HELP FOR THE FIRST TIME USER
If this is your first time to use a database product, Data + Plus will
be an enjoyable experience. If you are an experienced user, you will
find the List, Display, Report, and Label FAST and EASY to use. All
users will like the fact that repeated search on a specific criteria
will not have to be entered each time the search is done. The
experienced user can go on to these functions found in the XECUTE part
of the screen. There is HELP in each one of these functions. The FIRST
TIME USER will need to learn to CREATE a database, create a REPORT, and
create a LABEL.
When you first enter this Program you are presented with the Mode
Selection Header, from here you select the Mode you want by either
pressing the first character of each Mode; or by using the cursor
arrows.
NOTE: If you forget to put in a disk in the drive, you will get the DOS
prompt for ABORT, RETRY, IGNORE. Put the disk in the drive and answer the
prompt with <R> for retry. DP+ will continue with the Drive Select Mode.
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
DRIVE SELECT
PRESS [D] (FOR DRIVE MODE) TO SELECT DRIVE.
╔[DATA FILES]╗╔═════╗ (Note: in versions 3.57 & up there are
<Press Return> ║█DEMO.DBF███║║ A ║ three different drive selection boxes
║ ║║ B ║ for greater versatility.)
║ ║║██C██║
║ ║║ D ║
║ ║║ E ║
║ ║╚═════╝
║ ║ USE C:
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
(Then this box will appear)
╔[INDEX FILE]╗
<Press Return> ║█DEMO.NTX███║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
- 2 -
This box will appear when the [D] is pressed. If you are
going to use the [A] drive, which is a floppy drive
selection, press [A]. C & D are hard drive selections.
Depending on where Data + Plus has been installed, choose
the drive selection that has DEMO.DBF on it. The next BOX
to appear is for you to choose the NAME of the DATABASE to
USE. Pick DEMO.DBF as the database to use.
The next BOX to appear is to choose an INDEX to use with
the DATABASE you chose. Even though there are only two records
in the database press [Y] to the question. Next the index box
appears select DEMO.NTX. The next BOX to appear is to SET A
FILTER to use with the scan mode. This will allow you to view
only the records you want to edit. So answer [Y] and this screen
will appear.
04/17/89 FILTER SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY ║║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝
<---<Esc>--->
╔══════════════════════════════════════════════════════════════════════════════╗
║FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [H]elp, [Q]uit █
Next PRESS [E] to edit the Search Line this will allow you to select
only the records you wish to see in the scan mode.
When you are finished EDITing, press the [Q]uit.
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the MAIN MENU.
- 3 -
TO CREATE A DATABASE
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
PRESS [C] (FOR CREATE MODE) TO CREATE A DATABASE
(This box will appear)
╔═════╗
║ A ║ SELECT THE DRIVE THAT THE DEMO.DBF IS ON!
║ B ║
║██C██║
║ D ║
║ E ║
╚═════╝
USE C:
(Then this box will appear)
╔═════════════╗
║ A-CREATE ║
║ B-MODIFY ║ SELECT [B] "MODIFY"
║ C-STRUCTURE ║
║ Q-QUIT MENU ║
╚═════════════╝
(Then this box will appear)
╔[DATA FILES]╗
<Press Return> ║█DEMO.DBF███║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
We have included an illustration on Disk #2 named
DEMO.DBF. This was built with the CREATE mode.
BELOW is the structure of DEMO:
- 4 -
STRUCTURE OF DEMO.DBF
FIELDNAME TYPE WIDTH DEC
_________________________________________________________________
FIRST_NAME C 15
LAST_NAME C 25
CITY C 15
STATE C 2
ZIP C 10
PHONE C 13
COMMENTS C 40
MEMO M 10
"FIELDNAME" is the name you give to an entry, which is used as
the description (ie name, address, city, state, etc.) The only
way you can leave a space between words in the CREATE Mode is by
the use of the UNDERLINE key (eg, FIRST NAME must be entered as
FIRST_NAME). This is the ONLY SEPARATION SYMBOL ALLOWED.
"TYPE" allows you to determine whether the "Fieldname" is:
C -- Character; N -- Numeric; D -- Date; L -- Logical; M -- Memo.
C -- Character will allow both Alpha and numeric input.
N -- Numeric will allow mathematical functions.
D -- Date will setup an 8 "WIDTH" field as follows --/--/--.
L -- Logical allows 1 "WIDTH" field for T -- True;
or F -- False.
M -- Memo. This Command will take approximately 4OOO bytes
of space. (DO NOT USE THIS FUNCTION IN VERSION 3.32)
"WIDTH" allows you to set the width for the "Fieldname" (eg,
FIRST_NAME has been set for 15 spaces).
"DEC" is for the number of decimal places in a Numeric Field.
- 5 -
CREATE OR MODIFY
The CREATE utility allows you to define the structure of a new
database (.DBF) file or MODIFY the structure of an existing one.
When MODIFY is invoked, it searches the directory for all the
database files present. If it does not find any, you will be told
by a message that there are no databases. In the CREATE mode it
goes in to create a new file and prompts you for the fieldname,
type the width of each field name you wish to create. If the field
is numeric, you are also prompted for the number of decimal places.
(Remember the decimal counts as one byte of field width)
If the field already exists, you will be warned that this is a
duplicate fieldname. When exiting the new structure you will be asked
to name the new database. These are the editing keys for: (CREATE)
1. Up - Down arrow - up-down one field (Also starts a new field)
2. Left/Right - left/right one field at a time
3. PgUp - PgDn - scrolls up or down one screen
4. Home - End - moves to front or end of field
cell(AFTER PRESSING RETURN FIRST)
5. Crtl<END> - goes to the last field
6. Crtl<HOME> - goes to the first field
7. Left - Right arrow - moves cursor inside field cell
(AFTER PRESSING RETURN FIRST)
(HOME goes to front of cell)
(END goes to end of cell)
8. <INS> - <DEL> - insert/delete a field
9. <F6> - finishes the CREATE utility
10. <ESC> - will abort the create utility
11. <SPACE BAR> - will display available field types.
---AFTER CREATING THE NEW DATABASE THERE ARE TWO WAYS TO NOW ADD RECORDS---
DRIVE SELECT
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
PRESS [D] (FOR DRIVE MODE) TO SELECT DRIVE
╔[DATA FILES]╗╔═════╗ (Note: Do this now only if the bottom
<Press Return> ║█DEMO.DBF███║║ A ║ information line says
║ ║║ B ║ "NO DATABASE IN USE ..."
║ ║║██C██║ ║ Use <A:> ║║DEMO.DBF/║<-(CORRECT)
║ ║║ D ║
║ ║║ E ║ This only to illustrate
║ ║╚═════╝
║ ║ USE C:
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
- 6 -
This BOX will appear when the [D] is pressed. If you are going
to use A drive, which is the floppy drive selection, press [A].
C & D are hard drive selections. Depending on where Data + Plus
has been installed, choose the drive selection which has the
databases you want to use and enter the name of the DATABASE file
you wish to use. FLOPPY drive users should always use Data + Plus
Systems Disks in A.
APPEND DATABASE
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
PRESS [A] (FOR ADD MODE) TO ADD RECORDS.
07/O1/88 <ESC>=QUIT TO MAIN MENU 12:OO:OO AM
RECORD NO. 1 {PgUp Previous Record}{PgDn Next Record}
The APPEND mode will start you off with a blank record. Type in
your information and the record number will advance automatically.
The "PgUp" key is a quick way to back-up a few records and the
"PgDn" key will move you forward to the next record; and if you are
finished adding information the "ESC" key; or paging to the next
blank record will EXIT. *<Ctrl Home> is to add to the memo field.
__________________________________________________________________
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
The second method to add records is to press [S] for Scan. When in
the scan mode if it is a new database the first record will already
be appended (means BLANK record).
In the right corner of the screen you will see "Record 1/0 <New>".
Pressing the down arrow will allow you to continue adding new records.
If entering your records you leave one out, press <F10> a box will
appear in the right corner. Choose [Insert] this will insert a blank
record at the record you are currently on. Be sure that you are
on the spot you want the blank record inserted. If you goof just
press the delete key and it will say <Deleted>. When finished and
you wish to remove any records marked <Deleted>. Press <F10> again
and choose [Pack] and answer [Y] to the question. This will remove
the unwanted records. If you are logged in with an INDEX file
Data + Plus will automatically Re-indexed the database.
- 7 -
CREATE REPORT
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
PRESS [R] (FOR REPORT MODE) TO CREATE REPORT
(This box will appear)
╔═════════════╗
║ A-CREATE ║
║ B-MODIFY ║ SELECT [B] TO MODIFY THE DEMO.FRM
║ Q-QUIT MENU ║
╚═════════════╝
╔═════════════════════╗
║ Enter Name:████████ ║<-(This box appears in the CREATE MODE ONLY!!)
╚═════════════════════╝
(Then this box will appear in the MODIFY MODE)
╔[*.*REPORTS]╗
<Press Return> ║█DEMO.FRM███║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
You should already have a database with information in it.
F2 <KEY> First Screen is for you to type a Page Heading for your
REPORT. You can also set the format in which it will print.
These are all self-explanatory. The only one that might throw
you is the one called PLAIN PAGE, which simply means that the
Report will not print with a page number or the date when used.
- 8 -
F3 <KEY> Second Screen is used to select a Report which would allow you
to Sub-Total information. Don't be confused here! This is not
strictly a mathematical function. It can also be used to
group any form of information. For example, you have a database
listing several hundred people living on different streets in
different towns, etc. You want everyone living in HOUSTON --
so you enter the Fieldname CITY in the first BOX, then move
down to where it asks you for the HEADING and type in what you
want to be printed in your REPORT. Your REPORT would then
organize everyone by CITY before it printed. If you want to
sub-group it further, you can do so in the next area of
Sub-Totals. The SECOND SCREEN IS NOT A COMMONLY USED FUNCTION.
F4 <KEY> The Third Screen is for choice of field and column headings.
<<<SEE ADDITIONAL INFORMATION ON PAGE 40>>>
CONTENTS:is the actual Fieldname description in the database
which can be obtained from your printed list. CONTENTS: can
have more than one Fieldname (eg, FIRST_NAME+LAST_NAME+ADDRESS).
Contents also allows mathematical functions (eg, COST/QTY or
AMOUNT-COST or (QTY*AMOUNT)*TAX+(QTY*AMOUNT). There are far
too many possibilities to begin to illustrate them all.
(After Fieldname description has been entered the # decimal
places O Totals? (Y/N)" will appear. This will default to "N"
unless otherwise specified).
HEADER:is a name YOU USE that appears over each column of the
REPORT when printed. All 4 lines can be used.
There are 24 separate screens. USE as many as needed, but
remember the print WIDTH you defined for each column when in
the CREATE A DATABASE mode.
DO NOT MIX the field TYPES! (ie, C - Character, N - Numeric,
D - Date, etc...) IF YOU ARE COMBINING MORE THAN ONE FIELD_NAME
PER SCREEN. Example: LAST_NAME+COST - THIS IS INCORRECT.
(LAST_NAME is a "Character field" -- COST is a "Numeric field")
# decimal places O Totals? (Y/N)N -- For Numeric Fields ONLY!!
The design of the HEADER is your choice, but CONTENTS has
rules to follow. WIDTH :1O The WIDTH would need to be
changed from 1O to at least 2O to have the complete name to
print on one line. If the space is not large enough the
remaining characters will print on the next line.
NOTE: If you are using a dBase III Plustm Report file with
Data + Plus you will need to remove all commas that are not
enclosed inside quote or apostrophe marks.
- 9 -
CREATE OR MODIFY -- REPORTS
You can create a new Report form or modify an existing one. You
are NOT prompted with error tracking when you are working with the
Report, so it would be beneficial to have a printed copy of your
current data files.
If you are setting up an expression where a reference is made to a
file in another work area, you need to make sure that you are
using a current prefix. You will be checked for correct lengths,
decimals, etc. at run time in REPORT(Option in Xecute mode).
One important aspect to remember is that the specifications of the
field length needs to be equal to, or longer, than the actual
database field length in order to run the REPORT properly.
1. Cursor Right - Moves cursor one letter to the right
2. Cursor Left - Moves cursor one letter to the left
3. Ctrl-Home - Moves cursor to the first word
4. Ctrl-End - Moves cursor the the end of last word
5. Ins - Toggles (insert) mode (on/off)
6. Del - Deletes one letter at a time
7. ^Y - Deletes the complete field
8. Backspace - Deletes one character, moves cursor
9. <F1> - Help - (Version 3.90 this also calls
in the fieldnames in a box.) Pg. 40
10. <F2> - Go to Page Heading & Report Format
11. <F3> - Go to Sub-Totals
12. <F4> - Go to Field Contents for the Report
13. <F5> - Delete a Field from the contents
14. <F6> - Insert a Field between an existing one
15. <F7> - Go to a Field by it's number
16. <F10> - Exits the Report generator, or
when asked it will save the Report
- 10 -
CREATE LABEL
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
PRESS [L] (FOR LABEL MODE) TO CREATE LABEL
(This box will appear)
╔═════════════╗
║ A-CREATE ║
║ B-MODIFY ║ SELECT [B] TO MODIFY THE DEMO.LBL
║ Q-QUIT MENU ║
╚═════════════╝
╔═════════════════════╗
║ Enter Name:████████ ║<-(This box appears in the CREATE MODE ONLY!!)
╚═════════════════════╝
(Then this box will appear in the MODIFY MODE)
╔[*.* LABELS]╗
<Press Return> ║█DEMO.LBL███║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
1. The first screen APPEARS VERY MUCH LIKE THE REPORT GENERATOR
SCREEN. This is the default setting for a standard Label
found anywhere.
Enter width of label 35
Enter height of label 5
Enter left margin O
Enter lines between labels O
Enter number of labels across 1
The width (35) and height (5) represent a standard label size of
3 1/2 x 15/16 by 1 [size] This is the actual measurement.
Enter number of labels across allows from 1 - 5 labels to be
printed on a page.
The second Label size:-
Enter width of label 4O
Enter height of label 8
Enter left margin O
Enter lines between labels 1
Enter number of labels across 1
The width (4O) and height (8) represent a standard label size of
4 x 1 7/16 by 1 [size] This is the actual measurement.
- 11 -
Enter number of labels across allows from 1 - 5 labels to be
printed on a page.
The third Label size:-
Enter width of label 32
Enter height of label 5
Enter left margin O
Enter lines between labels 1
Enter number of labels across 3
The width (32) and height (5) represent a standard Label size of
3 2/1O x 11/12 by 1 [size] This is the actual measurement.
Enter number of labels across allows from 1 - 5 labels to be
printed on a page.
You can make a Label any size that you need.
--IF YOU ARE UNSURE ON HOW TO FILL IN THE PROPER DIMENSIONS PRESS <F3>--
--AND YOU WILL GET A BOX OF STANDARD LABEL SIZES, CHOOSE ONE OF THEM AND--
╔══════════════════════════════════╗
║ 3 1/2 x 15/16 by 1 ║
║ ║
║ 3 1/2 x 15/16 by 2 ║
║ ║
║ 4 x 17/16 by 1 ║
║ ║
║ 3 2/10 x 11/12 by 3 (Cheshire) ║
╚══════════════════════════════════╝
--THE SETTINGS WILL BE ENTERED AUTOMATICALLY--
2. The bottom of the screen APPEARS VERY MUCH LIKE THE THIRD SCREEN
IN REPORTS.
Label Contents: Modifying: DEMO.LBL
1. TRIM(FIRST_NAME)+' '+LAST_NAME -- The command TRIM will
REMOVE ALL UNNECESSARY SPACES. However, in order to keep
the LAST_NAME from being pulled up tight to the FIRST_NAME,
a space is inserted by using the ' '(apostrophe-space-apostrophe).
2. ADDRESS
3. TRIM(CITY)+','+STATE+' '+ZIP
A COMMA OR ANY CHARACTER CAN BE ADDED AS LONG AS IT IS ENCLOSED
WITH APOSTROPHE MARKS.
Labels serve many useful purposes other than mailing. Stores can
label items and include prices. You can even use the LABEL
generator to make small specialty Reports shown in rows and
columns. It is up to you!
NOTE: If you are using a dBase III Plustm Label file with
Data + Plus you will need to remove all commas that are not
enclosed inside quote or apostrophe marks.
- 12 -
CREATE OR MODIFY -- LABELS
The ranges that you may specify for your LABEL are outlined below.
The comment line at the bottom of the screen is for any remarks
or information that you may want to insert for you and/or any other
users of the LABEL.
<<<SEE ADDITIONAL INFORMATION ON PAGE 41>>>
Following are the specifications:
Width of label --- 1 <-> 12O
Height of label --- 1 <-> 16
Left Margin --- O <-> 25O
Line between labels --- 1 <-> 16
Spaces between labels --- O <-> 12O
Number of labels across --- 1 <-> 5
NOTE: The total width of all labels across MUST NOT exceed 25O
characters.
SCAN MODE
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
PRESS [S] (FOR SCAN MODE) TO SCAN
<F4> Print Memo
04/17/89 Quit=<Esc> SCAN <F3> Memo Import 12:40:17 pm
╔═══════════════════╦══════════════════╦═══════════════════╦═F10═══════════F10═╗
║ CURSOR Lt Rt║ UP DOWN ║ DELETE ║ ACTION ║
║ Char:<Enter><- ->║ Rec: ║ Char: <Space> ║[Goto, Locate,Seek]║
║ Field: <- ->║ Page: PgUp PgDn ║ Field:<Enter> ^Y ║ Save Memo: ^W ║
║ Pan:^<Home> ^<End>║ File:^PgUp ^PgDn ║ Record:<DEL> Key ║ Write Memo: <F2> ║
╚═══════════════════╩══════════════════╩═══════════════════╩═════╦════════╦════╝
┌────────────────────────────────────────────────────────────────║ Seek ║────┐
│(Press [DEL] key)-> <Deleted> will appear Record 1/2 ║ Goto ║ │
│ FIRST_NAME LAST_NAME ADDRESS ║ Locate ║ │
╞═════════════════════╤══════════════════════╤═══════════════════║ Skip ║════╡
│ JOHN │ DOE │ 100 NOWHERE STREET║ Pack ║ │
│ MARY │ DOE │ 100 NOWHERE STREET║ Insert ║ │
│ │ │ ╚════════╝ │
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
│ [By Pressing either the <Del> key or the <Ins> key the mode is reversed.] │
│ │ │ │
│ │ │ │
│ │ │(This will appear when the <INS> │
│(This is the Information or Status line) │ Key has been pressed).-----> │
└─────────────────────┴──────────────────────┴─────────────────────────────────┘
║ Use <A:> ║SCAN MODE║DEMO.DBF/DEMO.NTX║ Record: 1/2 ║ Ins ║
- 13 -
Scan is a quick way to see several pieces of information from the
database in ROWS and COLUMNS similar to a spreadsheet. You can
EDIT, DELETE, and ADD information. The <RETURN> KEY is the most
important key to remember as it allows you to edit one field at a
time by pressing it. The area above the Field_Names will indicate
if the record is <Deleted>, by pressing the [DEL] key again it will
un-delete or the proper term is "RECALL" the record. Packing the
file will remove all records marked for deletion. To mention again
the DOWN ARROW will add a new record. The <New> indicator will
appear in the right corner. The SCAN is a MORE POWERFUL FUNCTION
in Data + Plus than the "BROWSE" mode in two other will known
products on the market. ALSO REMEMBER: The FILTER function when
first logging in from the drive selection. This was where you were
asked for an index, then if you want to SET A FILTER. The filter
does exactly what it sounds like; it allows you to SCAN only the
records DECLARED by the search criteria you enter. Below is an
example of the LOCATE FUNCTION IN SCAN.
<F4> Print Memo
04/17/89 Quit=<Esc> SCAN <F3> Memo Import 12:40:17 pm
╔═══════════════════╦══════════════════╦═══════════════════╦═F10═══════════F10═╗
║ CURSOR Lt Rt║ UP DOWN ║ DELETE ║ ACTION ║
║ Char:<Enter><- ->║ Rec: ║ Char: <Space> ║[Goto, Locate,Seek]║
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗Memo: ^W ║
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█< Memo: <F2> ║
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║════════╦════╝
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║ Seek ║────┐
║CITY ║║ > Greater Than ║╚════════════════════╝ Goto ║ │
║STATE ║║ >= Greater Than or Equal To ║ ADDRESS >║█Locate█║< │
║ZIP ║╚═════════════════════════════╝═╤═══════════════════║ Skip ║════╡
║PHONE ║╔═════════════════════════════════════════════════════╗ack ║ │
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║nsert ║ │
║MEMO ║╚═════════════════════════════════════════════════════╝══════╝ │
╚═══════════╝ │ │ │
┌──────────────────────────────────────────────────────────────────────────────┐
│Locate in file DEMO.DBF ... │
│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░│
│ │
│Expression to Search For: │
│ │
│FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████│
│ │
└──────────────────────────────────────────────────────────────────────────────┘
║ Use <A:> ║SCAN MODE║DEMO.DBF/DEMO.NTX║ Record: 1/2 ║ Ins ║
The bright area in the field box is indicating that FIRST_NAME was
selected for the start of the search. The second box is the relational
commands to use. The third box will continue the search by adding an
extension. Example: FIRST_NAME = 'MARY' .AND. CITY = 'D'
In the example 'D' was used instead of spelling out the city of
'DALLAS'. This can be done on any of the criteria. The LOCATE function
will find the first record that meets the criteria. By adding more to
the criteria the search will become more specific.
- 14 -
The SEEK FUNCTION is totally different. It works off the index that the
database is indexed on. If you are using the SCAN without an index the
<F10> box will display the SEEK command like this:( -Off- ). If you
are using a multiple index for Example: LAST_NAME+CITY SEEK will
normally return a message "Not Found". SEEK has trouble with the
multiple index. There are databases that are designed that the
multiple works very well. If you can not find the information bring
the power of the LOCATE command to use, IF the record exist!! it will
find it. One more thing about SEEK you must type in the complete what
ever it is in the box provided. Example: MARY. You type only the data
that the index is on. If index where on city TYPE: DALLAS not D.
Watch for upper and lower case. If you have the city like: Dallas,
then type it that way; or you will not be able to LOCATE OR SEEK the
specific record.
*Pointer*The GOTO FUNCTION is to go to a specific record number. It is handy
if you have printed a list of records and want to update just those
specific records. Since the list function gives you the FIELD_NAME
for the HEADER and a Record # in the left margin.
Note: ^PgUp go to TOP of file; ^PgDn go to BOTTOM of file.
*Pointer*The SKIP FUNCTION will simply skip from one record number to another.
Let's say you are on record # 125 and wish to be at record # 7125 it
would take a while to PgDn that far. So in the box type 7000 no comma
and almost instantly you will be at record 7125. Of course it is much
faster if your working on a hard drive and an 80286 or 80386.
The PACK FUNCTION again is to remove any records marked for deletion.
It also Re-Indexes if the index is ON, and also Re-Builds the file on
the disk. This is a function built into the ADD MODE so when you are
finished adding records it automatically PACKS the database so as to
Re-Build it, but it does not use the index at all. The records will
be exactly as you entered them.
The INSERT MODE again is to insert a blank record at the record
number you are on.
- 15 -
EDIT DATABASE
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
PRESS [E] (FOR EDIT MODE) TO EDIT AN EXISTING DATABASE
The EDIT mode will ask for one of two things. The FIRST is do you
wish to go to the first record set by the FILTER. If you choose the
FILTER method it will take you to the first record in the filter and
there it drops you off. The filter then disengages and you can edit
one record after the other in numeric order. The Second way is to go
to the record number you wish to edit. When you enter the record number
you wish to review, that record will be displayed on the screen. The
PgUp KEY is a quick way to back up a few records. The PgDn KEY will
move you forward to the next record. The ESC KEY is the ONLY way to
exit out of the EDIT mode. *<Ctrl Home> is to edit the memo field.*
04/17/89 <ESC>=QUIT TO MAIN MENU 12:00:00 AM
RECORD NO. 1 {PgUp Previous Record}{PgDn Next Record}
FIRST_NAME JOHN
LAST_NAME DOE
ADDRESS 100 NOWHERE STREET
CITY DALLAS
STATE TX
ZIP 75207
PHONE (214) 352-1234
COMMENTS BROTHER-IN-LAW
- 16 -
XECUTE MODE
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
^
PRESS [X] (FOR XECUTE MODE) TO EXECUTE FUNCTIONS FROM DATABASE
When you enter the XECUTE mode you are instructed to select the
function of your choice. From the menu displayed below.
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║<-Shows records on a specific search with the Record #
║ B-DISPLAY ║<-Shows records on a specific search without the Record #
║ C-REPORTS ║<-This runs the REPORT files you have created
║ D-LABELS ║<-This runs the LABEL files you have created
║ E-INDEX ║<-This will create the indexes you want
║ F-SORT TO: ║<-This will organize the database in Ascending/descending order
║ G-COPY TO: ║<-This has two function(Make a Structure)or(DELIMITED/SDF files)
║ H-APPEND TO: ║<-Add records from one database to another
║ I-REPLACE ║<-Replace certain criteria on a specific search
║ Q-QUIT MENU ║<-Just what it implies, go back to the MAIN BAR
╚══════════════╝
We will describe all the functions starting from the top of the menu.
PRESS [A] FOR LIST
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║<-Press the Letter [A] no <Return> required
║ B-DISPLAY ║
║ C-REPORTS ║
║ D-LABELS ║
║ E-INDEX ║
║ F-SORT TO: ║
║ G-COPY TO: ║
║ H-APPEND TO: ║
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
The LIST mode allows you to list the records in your database with
the record number displayed for easy look-up. This information can
be sent to the SCREEN, PRINTER, OR .TXT File. (The .TXT File can
be used by most word processing programs).
The last line on which you enter information is the SEARCH LINE
and is used to enter the Search Criteria.
The first screen presented in the LIST Mode has a command line
which asks the following:
- 17 -
04/17/89 LIST SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY ║║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝ Printer Width = 25 <-Note:(There is NO guess work on
<---<Esc>---> whether or not it will fit)
FIELD LIST(Starts Here) it will go to line 3
╔══════════════════════════════════════════════════════════════════════════════╗
║FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit █
PRESS [F] to select the fields you want displayed. Use the field box
moving the cursor up; down or <End> key will go to the last field in
the database. The <Home> key will return to the first field. If you
know the names of the fields PRESS the First Letter Example: [C]ity
if there are several starting with [C] continuous PRESSING of the
Letter will take you to each occurrence and when there are no more
it will return you to the first one again.
Next PRESS [E] to edit the Search Line this will allow you to select
only the records you wish to see on the screen, or sent to the printer,
or to a text file.
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1]Begin List, [M]ore Commands,
[M]ore Commands will return you to the first command line.
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[1] Begin List will then ask:
[P]rint, [S]creen, [F]ile, [M]ore Commands.
[P] -- Sends the information to the printer.
[S] -- Displays the information on the screen.
* Export * -> [F] -- Creates a .TXT File.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
- 18 -
PRESS [B] FOR DISPLAY
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║<-Press the Letter [B] no <Return> required
║ C-REPORTS ║
║ D-LABELS ║
║ E-INDEX ║
║ F-SORT TO: ║
║ G-COPY TO: ║
║ H-APPEND TO: ║
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
The DISPLAY mode allows you to list the records in your database
with the exception that the record number is not displayed.
The information can then be sent to the SCREEN, PRINTER, OR .TXT
File. (The .TXT File can be used by most word processing programs).
The last line on which you enter information is the SEARCH LINE
and is used to enter the Search Criteria.
The first screen presented in the DISPLAY Mode has a command line
which asks the following:
04/17/89 DISPLAY SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY ║║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝ Printer Width = 25 <-Note:(There is NO guess work on
<---<Esc>---> whether or not it will fit)
FIELD LIST(Starts Here) it will go to line 3
╔══════════════════════════════════════════════════════════════════════════════╗
║FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit █
- 19 -
PRESS [F] to select the fields you want displayed. Use the field box
moving the cursor up; down or <End> key will go to the last field in
the database. The <Home> key will return to the first field. If you
know the names of the fields PRESS the First Letter Example: [C]ity
if there are several starting with [C] continuous PRESSING of the
Letter will take you to each occurrence and when there are no more
it will return you to the first one again.
Next PRESS [E] to edit the Search Line this will allow you to select
only the records you wish to see on the screen, or sent to the printer,
or to a text file.
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1]Begin Display, [M]ore Commands,
[M]ore Commands will return you to the first command line.
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[1] Begin Display will then ask:
[P]rint, [S]creen, [F]ile, [M]ore Commands.
[P] -- Sends the information to the printer.
[S] -- Displays the information on the screen.
* Export * -> [F] -- Creates a .TXT File.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
PRESS [C] FOR REPORTS
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║
║ C-REPORTS ║<-Press the Letter [C] no <Return> required
║ D-LABELS ║
║ E-INDEX ║
║ F-SORT TO: ║
║ G-COPY TO: ║
║ H-APPEND TO: ║
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
- 20 -
The REPORT Mode works similarly to the LIST and DISPLAY Modes,
except that the printed information produced has Page Headings,
Page Numbers, Dates, and Page Breaking. When using Numeric
Fields, you can have them total also. This includes totals on
combined fields. These should have already been set when you were
in CREATE REPORT. The only line on which you enter information is
the SEARCH LINE and it is used to enter the Search Criteria.
Be sure you have picked the correct .FRM that goes with the
database you are using. If you are not sure you should have it
written down before starting. If not return to the MAIN MENU and
run the REPORT GENERATOR. Check to see if the Field Names match
the database you are using. If you goof a box will appear in the
middle of the screen and it will normally give you who the
culprit field is.
04/17/89 REPORT SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY ║║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝
<---<Esc>--->
╔══════════════════════════════════════════════════════════════════════════════╗
║FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
PRESS [E] to EDIT the Search Fields. Use the FIELD BOX to obtain
the FIELD(s) you want; then in the SEARCH LINE enter the criteria
you wish to perform the search by, to meet the requirements of
your specific needs.
- 21 -
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1]Begin Report, [M]ore Commands,
[M]ore Commands will return you to the first command line.
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[1] Begin Report will then ask:
[P]rint, [S]creen, [F]ile, [M]ore Commands.
[P] -- Sends the information to the printer.
[S] -- Displays the information on the screen.
* Export * -> [F] -- Creates a .TXT File.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
PRESS [D] FOR LABEL
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║
║ C-REPORTS ║
║ D-LABELS ║<-Press the Letter [D] no <Return> required
║ E-INDEX ║
║ F-SORT TO: ║
║ G-COPY TO: ║
║ H-APPEND TO: ║
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
The LABEL Mode allows some mathematical functions when using Numeric
Fields, but CANNOT total them. The size and criteria for your Label
should have been setup when you were in CREATE LABEL. The only line
on which you enter information is the SEARCH LINE and is used to
enter the Search Criteria.
Be sure you have picked the correct .LBL that goes with the
database you are using. If you are not sure you should have it
written down before starting. If not return to the MAIN MENU and
run the LABEL GENERATOR. Check to see if the Field Names match
the database you are using. If you goof a box will appear in the
middle of the screen and it will normally give you who the
culprit field is.
- 22 -
04/17/89 LABEL SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY ║║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝
<---<Esc>--->
╔══════════════════════════════════════════════════════════════════════════════╗
║FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
PRESS [E] to EDIT the Search Fields. Use the FIELD BOX to obtain
the FIELD(s) you want; then in the SEARCH LINE enter the criteria
you wish to perform the search by, to meet the requirements of
your specific needs.
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1]Begin Label, [M]ore Commands,
[M]ore Commands will return you to the first command line.
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[1] Begin Label will then ask:
[P]rint, [S]creen, [F]ile, [M]ore Commands.
[P] -- Sends the information to the printer.
[S] -- Displays the information on the screen.
* Export * -> [F] -- Creates a .TXT File.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
- 23 -
PRESS [E] FOR INDEX
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║
║ C-REPORTS ║
║ D-LABELS ║
║ E-INDEX ║<-Press the Letter [E] no <Return> required
║ F-SORT TO: ║
║ G-COPY TO: ║
║ H-APPEND TO: ║
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
The INDEX Mode allows the user to organize the database in
virtually any order that might be required. The database is NOT
physically altered when using this mode. INDEX files facilitate
quick searches for information, and allows ordered viewing of the
database. An INDEX must be Re-built after new records are added
to the database. Use the MORE MENU and press [D] REINDEX MODE.
This adds the new record(s) to the INDEX.
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║
║ B-SUMS ║
║ C-AVERAGE ║
║ D-REINDEX ║<-Press the Letter [D] no <Return> required
║ E-DELETE ║
║ F-RECALL ║
║ Q-QUIT MENU ║
╚══════════════╝
PRESS [F] FOR SORT
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║
║ C-REPORTS ║
║ D-LABELS ║
║ E-INDEX ║
║ F-SORT TO: ║<-Press the Letter [F] no <Return> required
║ G-COPY TO: ║
║ H-APPEND TO: ║
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
(This box will appear)
╔═══════════════════════════════════╗
║ NAME OF FILE TO SORT TO: ████████ ║
╚═══════════════════════════════════╝
- 24 -
The SORT Mode creates a physically reordered database file using
the active database. The order of SORT can be either, Ascending
or Descending A-Z or Z-A. The SORT is done to a new file name of
your choice. If you want you can go to the UTILITY Mode and
Erase your old file and then Rename the new database under the
old file name.
04/17/89 SORT SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME ║║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY███████<║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:DALLAS███████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝ ┌────────────[FIELDS TO SORT]────────────┐
<---<Esc>---> 1. │ LAST_NAME <-Primary Field to Sort on │<-You must
2. │ CITY <-Secondary Field to Sort on │<-select both
└────────────────────────────────────────┘
╔══════════════════════════════════════════════════════════════════════════════╗
║CITY = 'DALLAS'███████████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit █
PRESS [F] to select the fields you want to sort on. Use the field box
moving the cursor up; down or <End> key will go to the last field in
the database. The <Home> key will return to the first field. If you
know the names of the fields PRESS the First Letter Example: [C]ity
if there are several starting with [C] continuous PRESSING of the
Letter will take you to each occurrence and when there are no more
it will return you to the first one again.
Next PRESS [E] to edit the Search Line this will allow you to select
only the records you wish to sort on to a new database.
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1] Sort Ascending, [2] Sort Descending, [M]ore commands
[M]ore will return you to the first command line.
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit
- 25 -
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[1] -- Will then start sorting the records from A-Z to
a new database for the criteria you have asked
for on the Search line.
[G]o, [S]top is the Final command.
[2] -- Will then start sorting the records from Z-A to
a new database for the criteria you have asked
for on the Search line.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
PRESS [G] FOR COPY TO:
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║
║ C-REPORTS ║
║ D-LABELS ║
║ E-INDEX ║
║ F-SORT TO: ║
║ G-COPY TO: ║<-Press the Letter [G] no <Return> required
║ H-APPEND TO: ║
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
Mail-Merge File
CHOOSE PROCEDURE:[D]elimited / SDF, or Copy [S]tructure, [Q]uit:(D/S/Q) █
[Q]uit returns you to the Xecute menu.
(Then this box will appear if you pick [S])
╔═══════════════════════════════════╗
║ NAME OF FILE TO COPY TO: ████████ ║
╚═══════════════════════════════════╝
Enter a name and it will automatically build you a New Structure.
- 26 -
The COPY TO Mode duplicates all the fields in the active database
file and creates a new database file. Now you can go to the
CREATE Mode and add and delete fields as you desire. You could go
to the APPEND Mode and add records from your old database to your
new one. The COPY TO: Mode allows you to create a DELIMITED text
file which can be used by most of the popular word processors to
do MAIL-MERGE. An .SDF text file can be created, which may seem
*Import* difficult for you to read but the IMPORT TXT Mode can add this
data to a completely different database, with different field
names and different field types.
NOTE: In brief to; copy structure from an existing database or to
create a DELIMITED or .SDF text file.
If you select [D]elimited this is the screen you will see next.
04/17/89 COPY TO SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME ║║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY███████<║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:DALLAS███████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝
<---<Esc>--->
╔══════════════════════════════════════════════════════════════════════════════╗
║CITY = 'DALLAS'███████████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1] Begin Copy, [M]ore commands
[M]ore will return you to the first command line.
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[1] Begin Copy (Brings up the line below )
Choose Type File to Write to: [1] SDF or [2] Delimited
You will then be asked for a Name For the type file you
selected.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
- 27 -
PRESS [H] FOR APPEND TO:
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║
║ C-REPORTS ║
║ D-LABELS ║
║ E-INDEX ║
║ F-SORT TO: ║
║ G-COPY TO: ║
║ H-APPEND TO: ║<-Press the Letter [H] no <Return> required
║ I-REPLACE ║
║ Q-QUIT MENU ║
╚══════════════╝
(This box will appear)
╔═══════════════════════════════════════╗
║ NAME OF FILE TO APPEND TO: A:████████ ║
╚═══════════════════════════════════════╝
SELECT DRIVE IF NEEDED!
The APPEND TO Mode it lets you add records from your old database
to the new database you may have created through the COPY TO: Mode.
When you append data from one database to another one be sure you
have compared the STRUCTURES.
(Example: Structure of Database # 1 - This one has the records in it!)
FIELDNAME TYPE WIDTH DEC
_________________________________________________________________
FIRST_NAME C 15
LAST_NAME C 25
CITY C 15
STATE C 10<-Larger than the new
ZIP C 10
PHONE N<-Numeric 13<-This is the one to
COMMENTS C 40 watch for !!!!!!!!
MEMO M 10
(Example: Structure of Database # 2 - This one is new!)
FIELDNAME TYPE WIDTH DEC
_________________________________________________________________
FIRST_NAME C 15
LAST_NAME C 25
CITY C 15
STATE C 2 <-Different size, you
ZIP C 10 may drop some data!
PHONE C<-Character 13<-You realized that
COMMENTS C 40 you needed a Character
MEMO M 10 Field and not a Numeric.
This will occur at times when you are new to using a database product.
Don't despair you can use the COPY TO MODE and generate an SDF text
file. Then go to the MORE-MENU for the function IMPORT TXT.
- 28 -
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║<-Press the Letter [A] no <Return> required
║ B-SUMS ║
║ C-AVERAGE ║
║ D-REINDEX ║
║ E-DELETE ║
║ F-RECALL ║
║ Q-QUIT MENU ║
╚══════════════╝
You will then be asked for the name of the SDF text file.
(Then this box will appear in the IMPORT TXT)
╔[TEXT FILES]╗
<Press Return> ║█DEMO.TXT███║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
(Then this box will appear next)
╔[DATA FILES]╗
║█DEMO.DBF███║< This is the old database
<Press Return> ║█DEMONEW.DBF║<-This is the name you gave the new one, while
║ ║ in the COPY TO MODE
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
Remember that when the FIELD TYPE changes from Numeric to Character,
Date to Character, or Logical to Character you must use the above
procedure to insure a proper transfer of data. Also changing the
FIELD TYPE in reverse you would still need to do the above procedure.
This is giving you the worst of conditions where the APPEND MODE is
NOT used. But if all you have done is add some new fields, or changed
the size of the fields then the APPEND MODE is the proper way to add
your existing data. Take note that if you rename a field-Example:
FIRST_NAME to FNAME the data that is in the old file will not be
added to the new one. Again this could be done with the SDF text
file, and then imported in to your new file. If you are becoming
worried about all this; rejoice the MODIFY MODE discussed earlier
would have handled the ADDING, DELETING, RENAMING, AND WIDTH problems
AUTOMATICALLY with no complaining. It is when you vary the FIELD
TYPE even the MODIFY MODE needs your help.
*Note:If you have been using a Character Field to store your Numeric
Data & you wish to change to a Numeric field-Use the Import Txt Mode.
- 29 -
By this point your are probably beginning to wonder when you will
ever need to use the APPEND function. Let's pose an Example:
You are maintaining a large database that must be archived either
Monthly, Quarterly, or Yearly. Archive meaning that you remove the
old data from the base and only work with the most current records.
Then at some point you need a 5 yr. Report on all the records. You
would then APPEND all the archived data into one Large file to run
this Report. This is just one simple example of some of the uses
for the APPEND function.
04/17/89 APPEND SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY ║║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝
<---<Esc>--->
╔══════════════════════════════════════════════════════════════════════════════╗
║FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1] Begin Append, [M]ore commands
[G]o, [S]top
[S]top will return you to the first command line.
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[G]o -- Will then start appending(adding) the records
you have asked for on the Search line to your
existing database.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
- 30 -
PRESS [I] FOR REPLACE
(XECUTE-MENU)
╔══════════════╗
║ A-LIST ║
║ B-DISPLAY ║
║ C-REPORTS ║
║ D-LABELS ║
║ E-INDEX ║
║ F-SORT TO: ║
║ G-COPY TO: ║
║ H-APPEND TO: ║
║ I-REPLACE ║<-Press the Letter [I] no <Return> required
║ Q-QUIT MENU ║
╚══════════════╝
04/17/89 REPLACE SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═══════════════════════════════════════════════╗
║FIRST_NAME ║║ Do you wish to REPLACE [ CITY ] with ║
║LAST_NAME ║║ another FIELD's content or with a CHARACTER ║
║ADDRESS ║║ string? (Answer [F]ield or [C]haracter) █ ║
║CITY███████<╚═══════════════════════════════════════════════╝
║STATE ║
║ZIP ║
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:DALLAS███████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝
<---<Esc>--->
CITY<-The field you are going to REPLACE is put here.
╔══════════════════════════════════════════════════════════════════════════════╗
║CITY = 'DALLAS'███████████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit █
PRESS [F] to select the field you want to replace. Use the field box
moving the cursor up; down or <End> key will go to the last field in
the database. The <Home> key will return to the first field. If you
know the names of the fields PRESS the First Letter Example: [C]ity
if there are several starting with [C] continuous PRESSING of the
Letter will take you to each occurrence and when there are no more
it will return you to the first one again. The next box to appear
ask if you want to replace the data in one field with data that is in
another field. Secondly you can choose to replace it with you own
character, numeric, or date information. The box that appears for
you to type in has already determined the FIELD TYPE for you.
Next PRESS [E] to edit the Search Line this will allow you to select
only the records you wish to replace.
- 31 -
When you are finished EDITing, press the [M]ore Command. You areì
now asked:
[1]Begin Replace, [M]ore Commands,
[M]ore Commands will return you to the first command line.
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the XECUTE MENU.
[1] Begin Replace will then ask:
[G]o, [S]top
[G] -- Start the Replace Function on the criteria you have
requested.
[S] -- Return the command line.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
MORE MENU
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
PRESS [M] FOR MORE MENU
When you enter the MORE MENU you will be instructed to select the
function of your choice. From the menu displayed below.
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║<-Import any type text file
║ B-SUMS ║<-Add the numeric fields in a database
║ C-AVERAGE ║<-Get an average on any numeric field
║ D-REINDEX ║<-Re-builds an existing index
║ E-DELETE ║<-Marks records for deletion
║ F-RECALL ║<-Recall records marked for deletion
║ Q-QUIT MENU ║<-Return to main menu bar
╚══════════════╝
- 32 -
PRESS [A] FOR IMPORT TXT
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║<-Press the Letter [A] no <Return> required
║ B-SUMS ║
║ C-AVERAGE ║
║ D-REINDEX ║
║ E-DELETE ║
║ F-RECALL ║
║ Q-QUIT MENU ║
╚══════════════╝
You will then be asked for the name of the SDF or other text file.
(Then this box will appear in the IMPORT TXT)
╔[TEXT FILES]╗
<Press Return> ║█DEMO.TXT███║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
The IMPORT TXT works like discussed above. You can IMPORT TXT
into DATA + PLUS through this Mode. You must have a database built
to receive the text file. This may take a little practice to become
efficient at. The database can have different FIELD NAMES AND BE
OF A DIFFERENT TYPE(Character vs Numeric). IMPORTANT!! do not alter
the structure in the MODIFY MODE in the FIELD WIDTH, and do not ADD
or DELETE any FIELDS. The SDF file is already spaced to match the
old Structure. Alter only the FIELD TYPE, or FIELD NAME. After the
IMPORT MODE is finished you can return to the MODIFY MODE and ADD,
DELETE, or change the WIDTH.
BE SURE YOU ARE IN THE PROPER DATABASE BEFORE YOU START THIS
PROCEDURE. LOOK DOWN AT THE COMMAND LINE.
║ Use <A:> ║APPEND TEXT║DEMO.DBF/DEMO.NTX║ Record: 1/2 ║ Ins ║
THE LAST COMMAND YOU SEE IS: [G]o, [S]top
NO EXPLANATION SHOULD BE NECESSARY TO THEIR MEANING.
- 33 -
PRESS [B] FOR SUMS
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║
║ B-SUMS ║<-Press the Letter [B] no <Return> required
║ C-AVERAGE ║
║ D-REINDEX ║
║ E-DELETE ║
║ F-RECALL ║
║ Q-QUIT MENU ║
╚══════════════╝
These will perform mathematical functions on TYPE (N)umeric
FIELDS ONLY.
04/17/89 SUM SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗ ╔═══════════[SUM OF NUMERIC FIELDS]══════════╗
║BASE_SALA ║<-1 ║BASE_SALA ║
║BONUS ║<-2 ║BONUS ║
║TOTAL ║<-3 ║TOTAL ║
║LAST_RAISE ║ ║████████████████████████████████████████████║<-BLANK
║BENEFITS ║ ╚════════════════════════════════════════════╝
║COMPANY_2 ║ There are only 3 Numeric fields in this database.
║TITLE_2 ║ The Field box will only allow you to choose a
║HOW_LON_3 ║ Numeric field.
║TITLE_3 ║
╚═══════════╝
<---<Esc>--->
These fields were taken from our Recruiting Management Program.
We needed an example of a database with Numeric content.
╔══════════════════════════════════════════════════════════════════════════════╗
║CITY = 'DALLAS'███████████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit █
PRESS [F] to select the fields you want to sum. Use the field box
moving the cursor up; down or <End> key will go to the last field that
is numeric. The <Home> key will return to the first numeric field.
As mentioned above only numeric fields can be selected.
Next PRESS [E] to edit the Search Line this will allow you to select
only the records you wish to sum.
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the MORE MENU.
[1] Begin Sum, [M]ore commands
[S]tart -- Start the Sum Function.
[M]ore Commands -- Return the command line.
- 34 -
PRESS [C] FOR AVERAGE
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║
║ B-SUMS ║
║ C-AVERAGE ║<-Press the Letter [C] no <Return> required
║ D-REINDEX ║
║ E-DELETE ║
║ F-RECALL ║
║ Q-QUIT MENU ║
╚══════════════╝
These will perform mathematical functions on TYPE (N)umeric
FIELDS ONLY.
04/17/89 AVERAGE SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗ ╔═══════════[AVERAGE NUMERIC FIELDS]══════════╗
║BASE_SALA ║<-1 ║BASE_SALA ║
║BONUS ║<-2 ║BONUS ║
║TOTAL ║<-3 ║TOTAL ║
║LAST_RAISE ║ ║█████████████████████████████████████████████║<-BLANK
║BENEFITS ║ ╚═════════════════════════════════════════════╝
║COMPANY_2 ║ There are only 3 Numeric fields in this database.
║TITLE_2 ║ The Field box will only allow you to choose a
║HOW_LON_3 ║ Numeric field.
║TITLE_3 ║
╚═══════════╝
<---<Esc>--->
These fields were taken from our Recruiting Management Program.
We needed an example of a database with Numeric content.
╔══════════════════════════════════════════════════════════════════════════════╗
║CITY = 'DALLAS'███████████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [F]ield Selection, [M]ore Commands, [H]elp, [Q]uit █
PRESS [F] to select the fields you want to average. Use the field box
moving the cursor up; down or <End> key will go to the last field that
is numeric. The <Home> key will return to the first numeric field.
As mentioned above only numeric fields can be selected.
Next PRESS [E] to edit the Search Line this will allow you to select
only the records you wish to average.
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT and return to the MORE MENU.
[1] Begin Average, [M]ore commands
[S]tart -- Start the Average Function.
[M]ore Commands -- Return the command line.
- 35 -
PRESS [D] FOR REINDEX
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║
║ B-SUMS ║
║ C-AVERAGE ║
║ D-REINDEX ║<-Press the Letter [D] no <Return> required
║ E-DELETE ║
║ F-RECALL ║
║ Q-QUIT MENU ║
╚══════════════╝
(Then this box will appear)
╔[INDEX FILE]╗
<Press Return> ║█DEMO.NTX███║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
║ ║
╚════════════╝
<---<Exit>--->(Left or Right arrow will exit the selection)
The REINDEX Mode is to rebuild an existing index for the database you
are logged into.
PRESS [E] TO DELETE
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║
║ B-SUMS ║
║ C-AVERAGE ║
║ D-REINDEX ║
║ E-DELETE ║<-Press the Letter [E] no <Return> required
║ F-RECALL ║
║ Q-QUIT MENU ║
╚══════════════╝
The DELETE Mode can mark one or several records to be deleted.
(Then this box will appear)
╔══════════════════════════╗
║ A-DELETE ALL RECORDS ║
║ B-DELETE RECORD NUMBER ║
║ C-DELETE ON SEARCH ║
║ D-RECALL ON SEARCH ║
║ E-RECALL RECORD NUMBER ║
║ Q-QUIT THIS MENU ║
╚══════════════════════════╝
(This box will appear when you Press the Letter [B])
╔════════════════════════════════════════════╗
║ RECORD NUMBER TO DELETE (0=EXIT): ███████1 ║
╚════════════════════════════════════════════╝
(This box will appear when you Press the Letter [E])
╔════════════════════════════════════════════╗
║ RECORD NUMBER TO RECALL (0=EXIT): ███████1 ║
╚════════════════════════════════════════════╝
- 36 -
(This Screen will appear when you Press the Letter [C] or [D])
04/17/89 DELETE OR RECALL SCREEN 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╔[FIELD BOX]╗╔═════════════════════════════╗╔════════════════════╗
║FIRST_NAME█<║█=██Equal To█████████████████<║█No more conditions█<
║LAST_NAME ║║ <= Less Than or Equal To ║║ Extended with .AND.║
║ADDRESS ║║ < Less Than ║║ Extended with .OR. ║
║CITY ║║ > Greater Than ║╚════════════════════╝
║STATE ║║ >= Greater Than or Equal To ║
║ZIP ║╚═════════════════════════════╝
║PHONE ║╔═════════════════════════════════════════════════════╗
║COMMENTS ║║ Enter Criteria without quotes:MARY█████████████████ ║
║MEMO ║╚═════════════════════════════════════════════════════╝
╚═══════════╝
<---<Esc>--->
╔══════════════════════════════════════════════════════════════════════════════╗
║FIRST_NAME = 'MARY'███████████████████████████████████████████████████████████║
╚══════════════════════════════════════════════════════════════════════════════╝
[E]dit Search Line, [M]ore Commands, [H]elp, [Q]uit █
When you are finished EDITing, press the [M]ore Command. You are
now asked:
[1] Begin Function, [M]ore Commands
More Commands -- Returns to the command Line
The other commands [H] and [Q] are simply:
[H] -- HELP - (Bar)
[Q] -- QUIT will ask you to PACK the database which will
remove MARKED records and return to the SUB-MENU.
[G]o -- Will then start MARKING the records for DELETION
or RECALLING the records MARKED for DELETION.
[S]top will return you to the first command line.
Note: When you are trying to retrieve all the
records this formula will generally work
unless you have records with no
information in the FIELD.
FIELD_NAME = ''
(FIELD_NAME being the fields actual name)
(When the Criteria box Pops up enter
nothing just press <Return>)
PRESS [F] TO RECALL
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║
║ B-SUMS ║
║ C-AVERAGE ║
║ D-REINDEX ║
║ E-DELETE ║
║ F-RECALL ║<-Press the Letter [F] no <Return> required
║ Q-QUIT MENU ║
╚══════════════╝
The RECALL Mode reactivates records that are marked for deletion
as long as the database has not been PACKED.
(Refer to the above information on DELETE/RECALL works the same)
- 37 -
PRESS [Q] TO QUIT MENU
(MORE-MENU)
╔══════════════╗
║ A-IMPORT TXT ║
║ B-SUMS ║
║ C-AVERAGE ║
║ D-REINDEX ║
║ E-DELETE ║
║ F-RECALL ║
║ Q-QUIT MENU ║<-Press the Letter [Q] no <Return> required
╚══════════════╝
This returns you to the MAIN MENU BAR.
UTILITY MENU
04/17/89 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
PRESS [U] FOR UTILITY
The UTILITY have been installed for your convenience. So that
many of the functions of (DOS) are at your control without leaving
DATA + PLUS .
When you enter the UTILITY Mode you are instructed to select the
function of your choice. From the menu displayed below.
╔══════════════╗
║ A-SET DRIVE ║
║ B-ERASE ║
║ C-RENAME ║
║ D-BACKUP ║
║ E-COPYFILE ║
║ F-CHG-11-111 ║
║ G-RUN ║
║ H-EDITOR ║
║ I SET COLOR ║
║ Q-QUIT MENU ║
╚══════════════╝
PRESS [A] FOR SET DRIVE
╔═════╗ (Note: in versions 3.57 & up there are
║ A ║ three different drive selection boxes
║ B ║ for greater versatility.)
║██C██║
║ D ║
║ E ║
╚═════╝
USE C:
SET DRIVE changes the disk drive you need to operate with, this
must be selected prior to continuing any of the following
functions.
- 38 -
PRESS [B] TO ERASE
(This filter box appears in all the DOS functions)
╔═════════════════════════════════════════════════════╗
║ COM EXE DBF DBT FRM LBL NTX TXT OTHER QUIT ║
╚═════════════════════════════════════════════════════╝
The ERASE deletes a file from the directory.
If you are Logged into a .DBF File and your are using
an NTX(index) File and the .DBF has a memo Field you
will not be allowed to erase any of it's files until you
log out of that file. This also holds true to the rename
function.
PRESS [C] TO RENAME
(This filter box appears in all the DOS functions)
╔═════════════════════════════════════════════════════╗
║ COM EXE DBF DBT FRM LBL NTX TXT OTHER QUIT ║
╚═════════════════════════════════════════════════════╝
This changes the name of any file you want to change.
PRESS [D] TO BACKUP
BACK UP allows you to move ONLY .DBF files. DO NOT GET THIS
CONFUSED WITH THE BACK UP IN (DOS). If the file is to large to
copy onto one (1) floppy disk this function will split it up over
as many disks it requires to get all the data. THE APPEND MODE
CAN RESTORE THEM. The data can be used on these back up copies
without restoring them. If you have a Memo Field the .DBT File
will be copied automatically for you.
PRESS [E] TO COPY FILE
(This filter box appears in all the DOS functions)
╔═════════════════════════════════════════════════════╗
║ COM EXE DBF DBT FRM LBL NTX TXT OTHER QUIT ║
╚═════════════════════════════════════════════════════╝
This command allows you to copy any type of file.
Note: If your are copying a .DBF file that contains a memo
field be sure your copy the .DBT file of the same name.
The Backup Function automatically does this for you.
Description of the Filter box below
╔═════════════════════════════════════════════════════╗
║ COM EXE DBF DBT FRM LBL NTX TXT OTHER QUIT ║
╚═════════════════════════════════════════════════════╝
THESE REPRESENT FILE EXTENSIONS
The COM and EXE represent the COMMAND and EXECUTION files
you normally DO NOT want to perform any function on these.
DBF = DATABASE STORAGE FILES
DBT = DATABASE TEXT STORAGE FILES (MEMO FIELDS)
FRM = DATABASE REPORT FILES
LBL = DATABASE LABEL FILES
NTX = DATABASE INDEX FILES
TXT = TEXT FILES
OTHER = ALL FILES
QUIT = EXIT THIS FUNCTION
- 39 -
04/17/89 ADDITIONAL HELP ON REPORT CONTENTS 12:40:17 pm
╔══════════════════════════════════════════════════════════════════════════════╗
║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║
╚══════════════════════════════════════════════════════════════════════════════╝
╒[FIELD BOX]╕ File C:DEMO.FRM
│FIRST_NAME█<Select by pressing <Enter> Field 1
│LAST_NAME │ ═══ Field Definitions ═══ Total 4
│ADDRESS │(FIRST_NAME)+' '+LAST_NAME███████████████████████████████████████
│CITY │
│STATE │
│ZIP │
│PHONE │
│COMMENTS │
│COMMENTS2 │
│ │ As you build your Report watch the Width Used to be sure your
╘═<-<Esc>->═╛ Report is wide enough. Select<F2>->Layout to change this info.
═══ Field & Total Report Formatting ═══
Width 35 Width Used-> 63/ 17<-Un-used Page Width-> 80
Decimals 0
Totals N
F1 F2 F3 F4 F5 F6 F7 F10
Select Layout Groups Fields Delete Insert Go To Exit
║Use <A:>║MODIFY REPORT ║DEMO.DBF/DEMO.NTX║ Record:1/2 ║
The HELP key [F1] will bring in the field_names of the database you
are logged into from the start. If no database is in use a box will
appear to remind you of this. If you are modifying a Report be sure
you have selected the proper database. The movement keys in the field
box are the same as in the rest of the program. *Remember* if you are
combining more than one field to the content area you can call the
field box to get the correct spelling and by using the Left or Right
arrow key this will exit the box. It is still a good practice to have
a printed structure of the database in front of you to get the proper
widths and decimal settings for numeric fields. You can modify the
widths to suit your needs. On numeric fields the width will be
inserted for you just like on LOGICAL; CHARACTER; and DATE fields.
But you will need to set the decimal setting, and if you want the
numeric field to total. **IMPORTANT DO NOT MIX FIELDS TYPES**
Example: You have a database with a field name->DATE and it's TYPE
is {DATE}; and field name FIRST_NAME and it's TYPE is {CHARACTER}.
DATE+TRIM(FIRST_NAME)+' '+LAST_NAME<--THIS IS INCORRECT***********
Keep all field contents the same TYPE CHARACTER vs CHARACTER etc.