Shareware Overload

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Overload / ShartewareOverload.cdr / database / dp395.zip / DPLUS.MAN < prev next >

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. - 40 - 04/17/89 ADDITIONAL HELP ON LABEL CONTENTS 12:40:17 pm ╔══════════════════════════════════════════════════════════════════════════════╗ ║░░QUIT░░SCAN░░CREATE░░REPORT░░LABEL░░DRIVE░░EDIT░░ADD░░XECUTE░░MORE░░UTILITY░░║ ╚══════════════════════════════════════════════════════════════════════════════╝ ╒[FIELD BOX]╕ Formatting File C:DEMO.LBL │FIRST_NAME │ 35 Margin 0 │LAST_NAME │ 5 Lines 1 │ADDRESS │ 1 Spaces 0 │CITY │ │STATE │ *<Use the F3 key to assist you in the formatting area>* │ZIP │ │PHONE │ │COMMENTS │CONTENTS │COMMENTS2 │═══════════════════════════════════════════════════════════════════ │ │TRIM(FIRST_NAME)+' '+LAST_NAME ╘═<-<Esc>->═╛ADDRESS TRIM(CITY)+', '+STATE+' '+ZIP F1 F2 F3 F10 Fields Toggle Formats Exit ║Use <A:>║MODIFY LABEL ║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. You will be doing more of the typingì in the Label since you will want to combine fields and TRIM out theì dead air spaces. ***AGAIN DO NOT MIX FIELD TYPES:(DATE vs NUMERIC).ì ******************************************************************************* - 41 - ******************************************************************************* A P P L I C A T I O N S G E N E R A T O R ******************************************************************************* The first step to using the applications generator is to have already made a database file. Refer to page 4-6 of the manual to learn how to create a database, if you do not know how. If step one is completed decide whether are not you wish to have an Index, Reports, or Labels with your application. If you do wish to use these options it will be easier for your first time to already have them created before starting the generator. Indexing refer to page 24 Reports refer to page 8 Labels refer to page 11 You are now ready to start the generator; from the main menu of Data + Plus press the <Esc> key this will bring you to the dot prompt system. ------------------------------------------------------------------------------ The screen will appear like this below F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 Help DP Edit Add Scan Structure List Display Report Label Files in Use on Drive C: DEMO.DBF/DEMO.NTX Record:15/49 AT THE DP>. PROMPT TYPE:> <Filename> <Enter> Monday 04/17/89 9:05pm OR TYPE:>MENU <Enter> FOR ASSISTANCE or To Run Data + Plus TYPE:><DP> <Enter> <COMMANDS:> <DIR> or <CLS> or <MENU> or <QUIT> or <DP> or <CONFIG> or <DRIVE> DP>. Type the command: MENU and press <Enter> as illustrated. The next screen to appear will be the generator screen below. 04/17/89 9:05:39 am ╔══════════════════════════════════════════════════════════════════════════════╗ ║ D A T A + P L U S ║ ║ A P P L I C A T I O N S G E N E R A T O R M E N U Ver:2.0 ║ ╚══════════════════════════════════════════════════════════════════════════════╝ STEP # 1 ------>1. CREATE SCREEN FORM STEP # 2 ------>2. TEST SCREEN FORM STEP # 3 ------>3. SELECT DRIVE DEFAULT STEP # 4 ------>4. CREATE REPORT MENU STEP # 5 ------>5. CREATE LABEL MENU STEP # 6 ------>6. SELECT INDEX FOR APPLICATION STEP # 7 ------>7. RUN APPLICATION STEP # 8 ------>8. SELECT APPLICATION COLORS ADVANCED USAGE 9 ------>9. GENERATE STAND-ALONE APPLICATIONS RETURN TO DOT ------>0. EXIT TO DOT PROMPT Step # 1 is to create the screen form. Select 1, when the [DATA FILES] box appears select the name of the database by either pressing the first letter of the file or moving the cursor up or down and pressing <Enter>. ╔[DATA FILES]╗ ║AIRCRAFT.DBF║ ║APEX.DBF ║ ║BUILD.DBF ║ ║CA.DBF ║ ║CLEM.DBF ║ ║CREDIT.DBF ║ ║CUSTOM.DBF ║ ║DAMAGES.DBF ║ ║DEALERS.DBF ║ <Enter>-----> ║DEMO.DBF ║ ╚════════════╝ - 1 - - CONTINUED - ****** D O T C O M M A N D S ****** To return to Main Data + Plus Screen type DP and press <Enter>. To see a list of the screen files you have created type DIR and press <Enter>. To clear the screen at any time type CLS and press <Enter>. To make a file to start your application type CONFIG and press <Enter>. Then type the name of the application - Exp. type DEMO and press <Enter>. When Data + Plus is next run the application will run instead. ****** RUN - TIME GENERATOR ****** The run-time generator can be purchased for the stand-alone applications for a nominal price. This will allow your customer to run any program you have built for him with out Data + Plus. The program cannot be changed except by the author of the program. Each Run-Time system has password locking after being developed. ******************************REFER TO DP395-2.MAN*****************************