ProfitPress Mega CDROM2 Shareware Freeware (MSDOS)(1992)(Eng)

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

/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / APPS / DATABASE / DBFED120.ZIP / DBFEDIT.DOC next >

Wrap

Text File | 1990-09-15 | 116.8 KB | 3,181 lines

D B F E D I T D b a s e E d i t o r CopyRight (C) 1989, 1990 by Preston Lau Version 1.2 FOR EVALUATION ONLY! September 1990 R E F E R E N C E M A N U A L 1309 Spring Street Apt. 303 Madison, WI 53715 (608) 257 - 0233 Dbase Editor T A B L E O F C O N T E N T S ----------------------------------- 1. License Information 2. Registration Form 3. Introduction 4. Features 5. Requirements 6. Running the Program 7. Special features in DBFEDIT (a) The Status Line (b) Pull-Down Menu (c) Moving around in the database (d) Block Commands (e) Window Commands (f) Edit and Append Record (g) Cut and Paste (h) Statistical Functions (i) Sort File (j) Filter File (k) Graph Plotting (l) Special Commands Dbase Editor L I C E N S E I N F O R M A T I O N -------------------------------------- This program is a 'shareware' program. It represens many, many hours of work. You are granted a limited license to make copies of the program distribution diskettes for the sole purpose of evaluation. If, after 10 days, you find that the program meet your needs, you are expected to pay the registration fee of $30.00 per copy. Registered users will receive the latest version of DBFEDIT by mail. There will be many new features coming in the next version, so please register NOW!!! All the coming features will be described later!! However, if you do not find the program of value, you must discontinue to use the program after the trial period. You are encouraged to make complete copies of the original distribution diskettes to other interested people. Checks should be made payable to Preston Lau and mailed to me at: 1309 Spring Street Apt. 303 Madison, WI 53715 U.S.A. A convenient mailer form is shown below. If you have any problem, just send me a letter. Every effort is made to support registered users. ^^^^^^^^^^ If you are in Madison, you can also contact me through the following BBS: DILHR Madison PC User Group Selene My user name of the above BBS is Preston Lau or you can send e-mail to me through the following address wun@garfield.cs.wisc.edu Dbase Editor DBFEDIT Version 1.2 Copyright (C) 1989, 1990 by Preston Lau Registration Form ------------------ Date_________________ Name_________________________________________________________________ Address______________________________________________________________ City_________________________________State____________Zip____________ Telephone Number (Voice)_____________________(Data)__________________ QTY AMOUNT TOTAL Basic Registration ____ $30.00 ea ___.__ (include documentation on disk, author support) Std. Shipping & Handling (U.S.A.) $ 3.00 Overseas orders add $5.00 $ ___.__ --------------- Total Enclosed (Check or Money Order ONLY) $ ___.__ Diskette ( 3 1/2 or 5 1/4 ) Circle one. Make checks payable to: Preston Lau Mail to: 1309 Spring Street Apartment 303 Madison, WI 53715 U.S.A. Your Suggestions or comments : 1) _____________________________________________________________________ 2) _____________________________________________________________________ 3) _____________________________________________________________________ 4) _____________________________________________________________________ 5) _____________________________________________________________________ 6) _____________________________________________________________________ 7) _____________________________________________________________________ Dbase Editor I N T R O D U C T I O N ----------------------- Dbase Editor is designed to access and edit multiple database files created by the program Clipper, Dbase III Plus, Dbase IV or FoxPro. This program is mainly written in Turbo C 2.0 and it make use of Full windowing functions and pop down menu in order to help the novice users. You can use DBFEDIT to: - View and edit several database files at the same time. - Cut and Paste between different database files and different fields - Sort the database in any fields order - Reorder fields for edit and append function - View the file structure - Send the file structure to a printer - Mark a block for delete and recall - Delete and Recall a block of records - Copy a block of records in the same file - Print a block of records - Draw a line graph on a block of records - Draw a bar graph on a block of records - Draw a stack graph on a block of records - Draw a HILO graph on a block of records - Draw a Cubic Spline Curve on a block of records - Save the block of record as ASCII text file. - Search a file for certain string - Change the default color. - Use a pop-up calculator. - Calculate the sum. - Calculate the mean. - Calculate the maximum and minimum. - Calculate the standard deviation. - Calculate the variance. - Calculate the mode. - View an index expression of an index file. - Copy file structure to another file. - Filter a record. - View the filter expression. - Append a record - Goto anywhere in the database through the use of simply key combinations. - Delete a record - Recall a record - Exit to DOS shell I hope you will find them useful. Dbase Editor F E A T U R E S --------------- In the following paragraphs, I will describe some of the special features you will enjoy while using DBFEDIT: - Full Windowing Features. You can open, close or go to a particular window easily. You can also resize or move any window you like. - Browse at most 20 database files at the same time with windows that you can change their size or move it anywhere. - Allow you to sort the database file and save it to the disk in another name. You can specify the order of fields that you want to sort. - Plot a graph of several fields in the database. At most 7 fields can be plot on a graph at the same time. You can compare values in different fields easily. Five types of graph are provided at this time. They are line graph, bar graph, stack graph, HILO graph and Cubic Spline Curve. - A cut and paste function is provided to copy one field to another between different database files. - Mark any block of records for deleting, recalling and printing. You can also copy block of records from one position to another position in the same file. - Pop-up a calculator to do simple calculation. (+, -, *, /, %) - Do simple statistical calculation, such as sum, mean, mode, standard deviation, variance, maximum and minimum. - A pull-down menu is install to help the novice user, by pressing a <ESC> key, the menu will pop up and allow you to choose the command you want to execute. Dbase Editor - A Pop-Up directory allows you to choose the file. With this particular features, you can choose any file in your harddisk or floppy disk easily. - You can print the file structure you are editing with good formatted output. Or, you can see it on the screen. - Change the windows to your favorite colors. You can load the old color set or save the new color set as you like. - View the index expression of a particular index file. You can choose the index file from the pop-up directory. - Copy the structure of the current file to another database for further use. - Filter a file for certain record and view the filter expression on screen. - An on-screen help is also available. As usual, you can press <F1> to pop-up the help window. - Allows temporary exit to DOS (or usually called DOS shell) You can execute other program when you are running DBFEDIT. - Faster performance than the Dbase III+ or Dbase IV - Easy to use. No need to remember any command. You can use the pull-down menu or press F1 to see an on-screen help. Dbase Editor R E Q U I R E M E N T S ----------------------- DBFEDIT will run on the IBM PS/2, PC/AT, PC/XT, PC and on IBM compatible computers including the Compaq, NCR, Tandy 1000, and WYSE PC's. Minimum requirements are: PC-DOS or MS-DOS 2.0 or greater. One diskette drive. (hard disk is preferred) An EGA monitor or A monochrome monitor with 80-column display (You cannot see the colorful window using a monochrome monitor) Dbase Editor R u n n i n g t h e P r o g r a m ------------------------------------- To run the DBFEDIT, you can simply type C>dbfedit at the DOS prompt. The progrm will automatically check whether the monitor you are using is a monochrome or an EGA monitor. If you are using some kind of plasma screen (Laptop user). Then you have to pass the parameter /mono to the program to force the monochrome display. i.e. C>dbfedit /mono Note that if this is the first time you run the program, the program will check your monitor type and save the corresponding color set to the disk in the save directory as the program. The config filename is dbfedit.cfg. After changing the window color to your favourate color, you can save the result to the disk by choosing <Save Config> in the pull-down menu. Later if you want to change your monitor type, you can delete the file dbfedit.cfg and when you run the program again, it will create the config file again with the new monitor type. Dbase Editor After the program started, you can see the following logo. (Actually in inverse attribute) -------------------------------------------------------------------------------- ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ░░░░░░░░░░╒═══════════════════════════════════════════════════════════╕░░░░░░░░░ ░░░░░░░░░░│ Dbase Editor Version 1.2 │░░░░░░░░░ ░░░░░░░░░░│ │░░░░░░░░░ ░░░░░░░░░░│ Copyright (C) 1989, 1990 Preston Lau │░░░░░░░░░ ░░░░░░░░░░│ │░░░░░░░░░ ░░░░░░░░░░│ Serial number : not registered! │░░░░░░░░░ ░░░░░░░░░░│ │░░░░░░░░░ ░░░░░░░░░░╘═══════════════════════════════════════════════════════════╛░░░░░░░░░ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ░░░░╒══════════════════════════════════════════════════════════════════════╕░░░░ ░░░░│ If you find any problem with the program, feel free │░░░░ ░░░░│ to send me a letter to the following address : │░░░░ ░░░░│ │░░░░ ░░░░│ 1309 Spring Street │░░░░ ░░░░│ Apartment 303 │░░░░ ░░░░│ Madison, WI 53715 │░░░░ ░░░░│ Thank you very much for your support. │░░░░ ░░░░│ │░░░░ ░░░░│ Press any key to continue │░░░░ ░░░░╘══════════════════════════════════════════════════════════════════════╛░░░░ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ -------------------------------------------------------------------------------- You can now press any key to continue. Dbase Editor After pressing a key, the program will ask you the name of file you want to edit. At this time you can enter the file name which is in the default directory. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : Total : ╔══════════════════════════════ Get File ══════════════════════════════╗ ║ ║ ║ Name of file to READ : sample1.dbf ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════╝ Press <Up Arrow> or <Down Arrow> to choose the file F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit ", color.foot, 24, 0); -------------------------------------------------------------------------------- If you want to pass the file name when running the program instead of entering it in the program, you can do the following C>dbfedit sample1.dbf where sample1.dbf is one of the sample database file provided in the package. If you miss out the .dbf like this C>dbfedit sample1 then the program will automatically add the extension .dbf to the end of the filename. Dbase Editor If you want also to force the monochrome display, you can type the following: C>dbfedit /mono filename.ext You should note that the parameter /mono must be the first parameter you pass to the program. If the filename you gave is not a valid filename or that file is not exist or that file is not a Dbase file. Then an error message will pop up and ask you for another name. At that time, you can enter the correct filename or press <ESC> to abort the program execution and return to DOS. ┌──────────── Message ────────────┐ │ This is not a DBASE format file │ │ ╔════╗ │ │ ║ OK ║ │ │ ╚════╝ │ └─────────────────────────────────┘ Dbase Editor Actually, there is another easy way to choose the file you want to edit. Press <Up Arrow> or <Down Arrow> when the program ask you to enter the filename. A pop up window will appear with all the filename in the default directory. To choose, you simply use <Up Arrow> and <Down Arrow> to move about and press <RETURN> to choose the highlighted filename. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : Total : ┌─── Files ────┐ │ =DRIVE= │ <.> ░ │ <..> ▒ │ <SQLHOME> ▒ │ <SAMPLES> ▒ │ <SOURCE> ▒ ╔══════════════════════════════│ SAMPLE1.DBF ▒════════════════════════╗ ║ │ SAMPLE2.DBF ▒ ║ ║ Name of file to READ : │ TEST.DBF ▒ ║ ║ │ FLIGHT1.DBF ▒ ║ ╚══════════════════════════════│ FLIGHT2.DBF ▒════════════════════════╝ │ FLIGHT3.DBF ▒ │ ▒ │ ▒ │ └──────────────┘ C:\DBFEDIT\ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- In the above diagram, choosing =DRIVES= allow you to choose a drive letter. <.> means the current directory. Choosing it mean nothing because you are already in current directory. <..> means the previous directory. Choosing it will move you back one directory. <SQLHOME> and <SAMPLES> are the directories. Choosing it will move you to that directory. SAMPLE1.DBF, SAMPLE2.DBF and .... are the filename you can choose to edit. Dbase Editor To change the default drive name. You have to choose the option "=DRIVE=" from the listing. After choosing it, a window will pop up asking you the drive you want to change to. You can now use arrow keys, <TAB>, <SPACE> to move to the final drive letter. To confirm your selection, you have to press <ENTER> once. To abort the operation, you can press <ESC> to return to the previous window. Shown below is a sample output screen. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : Total : ┌─── Files ────┐ │ =DRIVE= │ <.> ░ │ <..> ▒ │ <SQLHOME> ▒ ┌───────────────────────────────────────┐ │ Press <Enter> to accept │ ╔═══════════════│ Press <ESC> to abort │══════════════╗ ║ │ │ ║ ║ Name of file│ ┌───┐ ┌───┐ ╔═══╗ ┌───┐ ┌───┐ ┌───┐ │ ║ ║ │ │ A │ │ B │ ║ C ║ │ D │ │ E │ │ F │ │ ║ ╚═══════════════│ └───┘ └───┘ ╚═══╝ └───┘ └───┘ └───┘ │══════════════╝ │ Select Drive using arrows │ └───────────────────────────────────────┘ │ ▒ │ └──────────────┘ C:\DBFEDIT\ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- If you accidentally choose a not ready drive from the list, an error message will pop up. Just press any key to choose another valid drive letter for database reading. ┌────────────────────── Message ──────────────────────┐ │ Drive A is not ready. Choose another drive please. │ │ ╔════╗ │ │ ║ OK ║ │ │ ╚════╝ │ └─────────────────────────────────────────────────────┘ Dbase Editor Shown below is a sample screen editing a file. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE 5OZX12 ║LEE SENG HING SAUCE 650MLx18 ▒ ║LEE SENG HING SAUCE 340MLx36 ▒ ║GAI FAT HONG POWDER 6LBX6 ▒ ║YAU SHING HONG NOODLE CUP ▒ ║SUN FUNG PROVISIONS S.FISH ▒ ║TAI SHING PROVISIONS D.SQUID ▒ ║CHAN YEE JAI CAKE ALMOND ▒ ║AU'S FL 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor T h e S t a t u s L i n e ----------------------------- Under the header there is a one line status line. -------------------------------------------------------------------------------- Current : 46 Del C:\DBFEDIT\SAMPLE1.DBF Total : 63 -------------------------------------------------------------------------------- | | | | | | | | | | | | | | | This shows the total record number | | | of the active database file. | | | | | | | | This shows the path and filename of the active | | database file. | | | | | This shows the status of the current record whether it is | deleted or not. If the current record (highlighted bar) is | already deleted, then it will show "Del", otherwise, it will | show nothing! | | This shows the current record no. of the active database file. Dbase Editor P u l l - D o w n M e n u --------------------------- When you press <ESC>, there will be a pull-down menu appear on the top part of the screen. Most of the functions you use in this editor can be found in the pull-down menu. In the following, I will list all the commands in each menu. 1) Open File - Open a new database file. 2) Close File - Close a database file. 3) Save as text - Save the marked block of records in the current database to a text file. 4) View Index - View the index expression of an index file. 5) Help - A on-screen help. 6) Shell - Go to the DOS prompt. 7) Quit - Quit the Program and return to DOS. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └───┌────────────────┐─────────────────────────────────────────────────────────┘ ║LEE│ Open File │E 650MLx18 ▒ ║LEE│ Close File │E 340MLx36 ▒ ║GAI│ Save as text │ER 6LBX6 ▒ ║YAU│ View Index │LE CUP ▒ ║SUN│ Help │ISIONS S.FISH ▒ ║TAI│ sHell │ISIONS D.SQUID ▒ ║CHA│ Quit │ ALMOND ▒ ║AU'└────────────────┘ 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 1) Previous - Go to Previous Window. 2) Next - Go to Next Window. 3) Goto - Goto any Window by filename. 4) Resize - Resize the current Window. 5) Move - Move the current Window. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └──────────┌────────────┐──────────────────────────────────────────────────────┘ ║LEE SENG H│ Previous │ 650MLx18 ▒ ║LEE SENG H│ Next │ 340MLx36 ▒ ║GAI FAT HO│ Goto │ 6LBX6 ▒ ║YAU SHING │ Resize │ CUP ▒ ║SUN FUNG │ Move │ONS S.FISH ▒ ║TAI SHING └────────────┘ONS D.SQUID ▒ ║CHAN YEE JAI CAKE ALMOND ▒ ║AU'S FL 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 1) Cut Field - Cut a field of the marked block of records in the current database. (This function is not available for non registered user) 2) Paste Field - Paste the field cut previously starting from the current record. (This function is not available for non registered user) 3) Edit Current Record - Edit highlighted record. 4) Append records - Append mutiple records to the current database file. 5) Change Order - This change the order of the fields shown on the screen during the EDIT and APPEND function. 6) Delete/Recall record - Delete or Recall the current record. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └───────────────────┌────────────────────────┐─────────────────────────────────┘ ║LEE SENG HING SA│ Cut field │ ▒ ║LEE SENG HING SA│ Paste field │ ▒ ║GAI FAT HONG PO│ Edit current record │ ▒ ║YAU SHING HONG NO│ Append record │ ▒ ║SUN FUNG PR│ change Order │ ▒ ║TAI SHING PR│ Delete/recall record │ ▒ ║CHAN YEE JAI CA└────────────────────────┘ ▒ ║AU'S FL 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 1) Goto any record - Goto any record in the current file by record number. 2) Top of file - Goto top of the file in the current window. 3) Bottom of file - Goto bottom of the file in the current window. 4) Top Screen - Goto top of the screen in the current window. 5) Bottom Screen - Goto bottom of the screen in the current window. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └──────────────────────────┌────────────────────┐──────────────────────────────┘ ║LEE SENG HING SAUCE │ Goto any record │ ▒ ║LEE SENG HING SAUCE │ Top of file │ ▒ ║GAI FAT HONG POWDER │ Bottom of file │ ▒ ║YAU SHING HONG NOODLE │ toP of screen │ ▒ ║SUN FUNG PROVISION│ bottoM of screen │ ▒ ║TAI SHING PROVISION└────────────────────┘ ▒ ║CHAN YEE JAI CAKE ALMOND ▒ ║AU'S FL 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 1) Mark Beginning Block - Mark the begining of the block. 2) Mark Ending Block - Mark the end of the block. 3) Mark All records - Mark all the record in the current file. 4) Hide/Display Block - Hide/Display the current marked block. 5) Delete Marked Block - Delete the current highlighted block. 6) Recall Marked Block - Delete the current highlighted block. 7) Copy Marked Block - Copy the current highlighted block. 8) Print Block - Print the current highlighted block. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └─────────────────────────────────┌────────────────────────┐───────────────────┘ ║LEE SENG HING SAUCE │ mark Beginning block │ ▒ ║LEE SENG HING SAUCE │ mark Ending block │ ▒ ║GAI FAT HONG POWDER │ mark All records │ ▒ ║YAU SHING HONG NOODLE │ Hide/display block │ ▒ ║SUN FUNG PROVISIONS │ Delete marked block │ ▒ ║TAI SHING PROVISIONS │ Recall marked block │ ▒ ║CHAN YEE JAI CAKE │ Copy marked block │ ▒ ║AU'S FL │ Print marked block │ ▒ ║ON LEE NOODLE └────────────────────────┘ ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 1) Sort File - This function allow sorting of a database file ordered by any combination of fields. 2) Search File - Search the file for a string. 3) Search Next - Continue to search the string in the file. 4) Filter File - Filter the file for certain condition. 5) Filter Next - Goto next record satisfying the condition. 6) Show Expression - View the filtering expression on the screen. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └─────────────────────────────────────────┌───────────────────┐────────────────┘ ║LEE SENG HING SAUCE 650MLx1│ Sort file │ ▒ ║LEE SENG HING SAUCE 340MLx3│ sEarch file │ ▒ ║GAI FAT HONG POWDER 6LBX6 │ seArch next │ ▒ ║YAU SHING HONG NOODLE CUP │ Filter file │ ▒ ║SUN FUNG PROVISIONS S.FISH │ fIlter next │ ▒ ║TAI SHING PROVISIONS D.SQUID│ sHow expression │ ▒ ║CHAN YEE JAI CAKE ALMOND └───────────────────┘ ▒ ║AU'S FL 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 1) Get Info - Get the information of the current file. 2) Print Info - Print the information of the current file. 3) Copy Structure - Copy the structure of the current file to another file. 4) Change Color - Change the color setting of the program. 5) Load Config - Load the color setting from the disk. 6) Save Config - Save the color setting to the disk. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └──────────────────────────────────────────────────┌──────────────────┐────────┘ ║LEE SENG HING SAUCE 650MLx18 │ Get info │ ▒ ║LEE SENG HING SAUCE 340MLx36 │ Print info │ ▒ ║GAI FAT HONG POWDER 6LBX6 │ Copy structure │ ▒ ║YAU SHING HONG NOODLE CUP │ cHange color │ ▒ ║SUN FUNG PROVISIONS S.FISH │ Load config │ ▒ ║TAI SHING PROVISIONS D.SQUID │ Save config │ ▒ ║CHAN YEE JAI CAKE ALMOND └──────────────────┘ ▒ ║AU'S FL 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 1) Calculator - Pop-up a on-screen calculator. 2) Max & Min - Calculate the maximum and minimum value in the current file. 3) Sum & Mean - Calculate the Sum and Mean in the current file. 4) Std.Dev & Variance - Calculate the standard deviation and the variance in the current file. 5) Mode - Calculate the mode of any field in the current file. 6) Change Graph Title - Change the name of title, x-axis and and y-axis of the graph. 7) Draw line Graph - Plot a line graph of the current database file. 8) Draw bar Graph - Plot a bar graph of the current database file. (This function is not available for non registered user) 9) Draw stack Graph - Plot a stack graph of the current database file. (This function is not available for non registered user) 10) Draw HILO Graph - Plot a HILO graph of the current database file. (This function is not available for non registered user) 11) Draw Cubic Spline Graph - Plot a cubic spline graph of the current database file. (This function is not available for non registered user) -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ ┌──────────────────────────────────────────────────────────────────────────────┐ │ File Window Edit Goto Block Search Options Math │ └────────────────────────────────────────────────────┌────────────────────────┐┘ ║LEE SENG HING SAUCE 650MLx18 │ Calculator │▒ ║LEE SENG HING SAUCE 340MLx36 │ Max & min │▒ ║GAI FAT HONG POWDER 6LBX6 │ Sum & mean │▒ ║YAU SHING HONG NOODLE CUP │ sTd. dev. & variance │▒ ║SUN FUNG PROVISIONS S.FISH │ Mode │▒ ║TAI SHING PROVISIONS D.SQUID │ cHange graph title │▒ ║CHAN YEE JAI CAKE ALMOND │ draw Line graph │▒ ║AU'S FL 365-6 │ draw Bar graph │▒ ║ON LEE NOODLE 500GX50 │ draw stAck graph │▒ ║TIEN CHU SAUCE 650MLX24 │ draw HILO graph │░ ║SHING CHEONG WICKS WICKS │ draw cubic sPline │▒ ║LAIN LAIN PRAWN CRACKERS GP └────────────────────────┘▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor Moving around in the database ----------------------------- DBFEDIT provide easy way for you to move around in the database. You can move one line or one page, or you can go to specific record in the database. In the following, I will describe all the command you can use to move around in the database. 1) <PgUp> Move up one page, the page length depends on the size of the current active window. 2) <PgDn> Move down one page, the page length depends on the size of the current active window. 3) <Ctrl-PgUp> Move to the top of the file. 4) <Ctrl-PgDn> This command will move you to the bottom of the file. 5) Up arrow Move up one line. 6) Down arrow Move down one line. 7) Home This command will move you to the top of the screen. 8) End This command will move you to the bottom of the screen. 9) Ctrl-J/goto record This command will ask you the line number(record number) you want to go. By entering the line number and press <Enter>, DbfEdit will jump to that line number and highlight that line. ╔═════ Goto Record ══════╗ ║ ║ ║ Enter record no. 100 ║ ║ ║ ╚════════════════════════╝ Dbase Editor If the line number you entered is larger than the total records in the database, an error message will pop-up to warn you. ┌────────────── Message ──────────────┐ │ The value exceed the total recrods │ │ ╔════╗ │ │ ║ OK ║ │ │ ╚════╝ │ └─────────────────────────────────────┘ 10) <Ctrl-QF> This command will search the whole database file for one specific string of characters. The program will ask you for the string of characters you want to search. You can see the following screen. ╔════════════════════════════════ Find ════════════════════════════════╗ ║ ║ ║ Enter string to SEARCH : noodle ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════╝ After entering the desired string of characters and press <Enter>, the program will ask you what field in the database file you want to search. At this time you can see the following window. ┌── Fields ──┐ │ =ALL= │ │ NAME │ │ NATURE │ │ ART │ │ COMMODITY │ │ SPECIFIC │ │ MEASURE │ │ NTWT │ │ GRWT │ │ UNIT │ │ COST │ │ SALES │ │ DATE │ │ REMARKS │ └────────────┘ You can now choose a particular field to search or you can choose =ALL= to choose the whole file for the specified string. Dbase Editor Note that this command always ignore the case that is the capital or lowercase of the search string. In the next version, I will add a command allows you to specific what kind of search you want to perform. If the program cannot find that string, an error message will pop-up to warn you. ┌──────────── Message ────────────┐ │ Cannot find the key in the file │ │ ╔════╗ │ │ ║ OK ║ │ │ ╚════╝ │ └─────────────────────────────────┘ 11) <F6>/<Ctrl-L> This command will continue to search the database file for the string you entered in the previous search. If there is a match, it will as usual position the highlight bar on that record. Otherwise, the same error message will pop-up. Dbase Editor B l o c k C o m m a n d s --------------------------- Key Action ------------------------------------------------ CTRL-KB Mark beginning of block CTRL-KK Mark end of block CTRL-KA Mark all records CTRL-KH Toggle block marking on and off CTRL-KD Delete marked block CTRL-KR Recall marked block CTRL-KC Copy marked block CTRL-KP Print marked block To facilitate the manipulation of the data in the database, a family of block commands is provided. DBFEDIT contains a complete set of block commands. This includes the commands to mark the beginning of line, the end of line and all of the lines. You can then issue the command to delete the marked block, recall them, copy them or print them to printer. The very first step is to choose the required block by marking the beginning and ending of it on the screen using the keys CTRL-KB and CTRL-KK. The beginning and ending line can be marked in either order. There is no effect when only one of the beginning and an end is marked. However, if the beginning mark is after the ending mark, then nothing will happen on the screen. The block is shown by a reversal of video attributes. If you don't want the marked block be shown on the screen, you can press CTRL-KH to toggle the display of marked block on and off. You can also mark the entire file by choose <Mark all> in the menu or press Ctrl-KA. The program will highlight all the records in the file. Dbase Editor What can be done with a block once it is marked ? You can use the delete block, recall block, copy block or print block commands to manipulate the blocks directly. The keyboard command are CTRL-KD, CTRL-KR, CTRL-KC and CTRL-KP respectively. You can also choose these commands from the pull-down menu. When you press the delete block command (CTRL-KD), the highlighted block will be marked as deleted. When you later move the highlighted bar on those records, you can see 'Del' in the center of the status line. You can press <Ctrl-KR> to recall all the records in the marked block. If records are not previously deleted then no action will be done on those records. You can also press <Ctrl-KC> to copy the marked block to the current line of record. Note that because of different fields between database files, you cannot copy the whole block from one database file to another. However, you can use the command CUT & PASTE to copy fields between different database files. If you want to print the marked block to the printer, you can press the key <Ctrl-KP>. If the printer is not ready, a pop-up message will appear and allow you to choose the action - try again or abort. Dbase Editor W i n d o w C o m m a n d s ----------------------------- DBFEDIT allows you to view several files at the same time through the use of windows. Each window can be resize to any size you like and you can also move them to different position on the screen. At the present version, totally 20 database files are allowed to open at the same time. To create a window, you can press <F3> or choose the Open command from the pull-down menu. The file you choose will show on the screen with full size. You can then resize it to suit your needs. Note that you can browse one file on diferent window, the changes in one window will be shown on the other window. Note that if you open more than one file, the program will automatically adjust the size of screen of the first file you open so that you can see both of them at the same time. The first file will be on the top part of the screen and the second file will be on the second part of the screen. All file open later will also open on the lower part of the screen. To move to the next window, you can simply press <F8>. If the currently active window is already the last window you load, then no action will be taken. To move to the previous window, you can simply press <F7>. If the currently active window is the first window you opened, then no active will be taken. In version 1.2 of DBFEDIT, I have added the vertical scroll bar on the right of the window to give the user an idea which part of text they are in. This is a very helpful features since the user may get lost after scrolling around the long text. Dbase Editor To resize the window, you can press <Ctrl-S> or choose the Resize command in the pull-down menu. Upon entering this command, you can press Up arrow, Down arrow, Left arrow and Right arrow to move the bottom line and the right line. To move the top line and left line, you can press space bar once. Pressing the space bar again allows you to change the top line and right line again. To confirm your change, press <Enter> once, to abort it, press <ESC> instead. To move the window, you can press <Ctrl-M> or choose the Move command in the pull-down mnu. Upon entering this command, you can see the window frame on the screen. You can move it by press the arrow keys. To confirm your change, press <Enter>, to abort it, press <ESC> Actually, there is another command to facilitate your moving from one window to another window. You can press <Ctrl-G> or choose the appropriate option in the pull-down menu. After that, you will see a window showing all the filename you have opened. You can go to any file by using the up arrow and down arrow keys to choose the filename you want to edit. To close the current active window, you can press <F2> or choose the appropriate function in the pull-down menu. All the memory allocated for that file will be released. Dbase Editor E d i t a n d A p p e n d R e c o r d ------------------------------------------- If you want to edit a record, you can move the highlight bar to that record and press <Enter>. After you press <Enter> a pop-up window will appear with all the fields on the left hand side and the contents of that field on the right hand side. The following is the sample edit window. Note the difference of help line at the bottom of the screen. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PH╔════════════════════ DBASE EDITOR ═════════════════════╗ ║LEE SENG H║ ║ ▒ ║LEE SENG H║ NAME HARBOUR PHONIX ║ ▒ ║GAI FAT HO║ NATURE SAUCE ║ ▒ ║YAU SHING ║ ART 5OZX12 ║ ▒ ║SUN FUNG ║ COMMODITY WORCESTER SAUCE ║ ▒ ║TAI SHING ║ SPECIFIC 5OZX12 ║ ▒ ║CHAN YEE J║ MEASURE 20.719.3X15.5 ║ ▒ ║AU'S ║ NTWT 1.7 ║ ▒ ║ON LEE ║ GRWT 4.3 ║ ▒ ║TIEN CHU ║ UNIT DOZ ║ ░ ║SHING CHEO║ ║ ▒ ║LAIN LAIN ╚════════════════════════════════════════════════════════╝ ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ C:\DBFEDIT\ F1-Help F10-End ESC-Abort Home End PgUp PgDn Ctl-PgUp Ctl-PgDn INS DEL -------------------------------------------------------------------------------- There are several keys you can use to edit the record. 1) <F1> To pop-up a help screen, listing all the commands you can use. 2) <Ctrl-T> To delete a word in the fields Dbase Editor 3) <Ctrl-Right Arrow> To move to the right of word. If there is no more word on the right, then you will move to the next field. 4) <Ctrl-Left Arrow> To move to the left of word. If there is not more word on the left, then you will move to the previous field. If you are already in the first field, then no action will be taken. 5) <PgUp> Move up one field 6) <PgDn> Move down one field 7) <Ctrl-PgUp> Move to the first field 8) <Ctrl-PgDn> Move to the last field 9) <TAB> Move donw one field 10) <Enter> Move down one field 11) Up Arrow Move up one field 12) Down Arrow Move down one field 13) <DEL> Delete the character on the current cursor position 14) <INS> Toggling the insert mode 15) <Home> move to the leftmost of the current field 16) <End> Move to the rightmost of the current field 17) <F10> To confirm your change and return to browse 18) <ESC> To abort the change and return to browse, the part you have changed will be lost. Dbase Editor Here show one of the help screen you will see in edit mode. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PH╔════════════════════ DBASE EDITOR ═════════════════════╗ ║LEE SENG ┌─────────────────Dbase Editor Help Screen─────────────────┐ ▒ ║LEE SENG │ │ ▒ ║GAI FAT H│ Dbase Editor - by Preston Lau │ ▒ ║YAU SHING│ ----------------------------------------------------- │ ▒ ║SUN FUNG │ Up one field │ ▒ ║TAI SHING│ Down one field │ ▒ ║CHAN YEE │ Left one character │ ▒ ║AU'S │ Right one character │ ▒ ║ON LEE │ F10 Exit with change │ ▒ ║TIEN CHU │ ESC Exit without change │ ░ ║SHING CHE│ HOME Left most character │ ▒ ║LAIN LAIN│ END Right most character │ ▒ ║LAIN YOU │ │ ▒ ║LAIN YOU │ Press <PgDn> for next page │ ▒ ║TONG FOOK└──────────────────────────────────────────────────────────┘ ╚══════════════════════════════════════════════════════════════════════════════╝ C:\DBFEDIT\ F1-Help F10-End ESC-Abort Home End PgUp PgDn Ctl-PgUp Ctl-PgDn INS DEL -------------------------------------------------------------------------------- Special points you should note when you are in the edit mode. 1) If the field is CHARACTER, then characters, numbers and spaces are also allowed to enter in the field. 2) Only numbers and spaces are allowed in the Numberic field. 3) You can only enter numeric numbers in the Date fields 4) If the day of Date field is greater than 31, then the program will automatically change it to 31. 5) If the month of Date field is greater than 12, then the program will automatically change it to 12. 6) If nothing is entered in the numeric field, 0 is assumed. for example, if the length of the nubmer field is 7 and the decimal places are 3 then 0.000 is assumed. 7) There is a maximum 80 character in the fields. If the database file contain a field with more than 80 characters, then you are not allowed to edit any record in that file. 8) You are not allowed to enter anything in the memo field. That means you cannot edit the memo data. Dbase Editor Note that if you previously use the change order function to change the order of fields in the current file. Or you choose only part of the fields to display. The append record screen will be different. Here is the sample screen for changing the order of fields. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE ┌──── Fields ─────┐ ║LEE SENG HING SAUCE │ NAME ▒ ║LEE SENG HING SAUCE │ NATURE ▒ ▒ ║GAI FAT HONG POWDER │ 1 ART ▒ ▒ ║YAU SHING HONG NOODLE │ 2 COMMODITY ▒ ▒ ║SUN FUNG PROVISIONS │ SPECIFIC ░ ▒ ║TAI SHING PROVISIONS │ MEASURE ▒ ▒ ║CHAN YEE JAI CAKE │ NTWT ▒ ▒ ║AU'S FL │ GRWT ▒ ▒ ║ON LEE NOODLE │ 3 UNIT ▒ ▒ ║TIEN CHU SAUCE │ 5 COST ▒ ░ ║SHING CHEONG WICKS │ SALES ▒ ▒ ║LAIN LAIN PRAWN CRACKER│ 4 DATE ▒ ▒ ║LAIN YOU PRAWN CRACKER│ REMARKS ▒ ║LAIN YOU PRAWN CRACKER└─────────────────┘ ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ Press <F10> to confirm or press <ESC> to abort F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- The order in this case is 1) ART 2) COMMODITY 3) UNIT 4) DATE 5) COST If you want to append a new record to the database, you can choose the append function in the pull-down menu. A pop-up window will then appear with all the fields left blank. After appending a new record to the database, another blank fields will appear which allows you to enter another new record. You can enter as many as records you like to the database. If you want to end the append function, just press <F10> to confirm the current appending record. Otherwise, press <ESC> to abort the current appending record. Dbase Editor C u t a n d P a s t e ------------------------- This cut and paste function is very easy to use. It allows you to cut a particular field for serveral records and then paste them to another database file. To cut a field, you can press <Ctrl-X> or choose the appropriate function in the pull-down menu. You will be asked for the field number you want to cut. If you don't know the field number, then you can press <Up Arrow> or <Down Arrow> to get a list of fields. Note that before choosing the cut options, you have to mark the records to cut. <Ctrl-KB> to mark the beginning of block and <Ctrl-KK> to mark the ending of block. After cutting the data, you can then move to another database file to paste them. Move to the location of recrods from which you want to paste the previous cutting. You can press <Ctrl-V> or choose the appropriate function in the pull-down menu. Note that you cannot paste to different fields. For example, if you cut a character field, you MUST paste it to a character field also. Note also that without the previous cut, you cannot execute the paste command. Dbase Editor S t a t i s t i c a l F u n c t i o n s ----------------------------------------- You can use the DBFEDIT to find out the maximum and minimum value in the particular numeric field of the current database. You can also find out the sum, mean, standard deviation and variance by pressing just one key! Note that you have to specify the range of operation before issuing the command. Shown below are the sample calculation using the sample file SAMPLE2.DBF on the field UNITPRICE of all the records in the database. ┌─────────────────── Max & Min ───────────────────┐ │ │ │ Max Rec : 24 Max Value : 5238.00 │ │ Min Rec : 146 Min Value : 2.20 │ │ │ │ Press any key to continue │ └─────────────────────────────────────────────────┘ ┌────────────────── Sum & Mean ───────────────────┐ │ │ │ Sum : 51269.30 │ │ Mean : 256.35 │ │ │ │ Press any key to continue │ └─────────────────────────────────────────────────┘ ┌───────── Standard Deviation & Variance ─────────┐ │ │ │ Std. Deviation : 572.67 │ │ Variance : 327953.87 │ │ │ │ Press any key to continue │ └─────────────────────────────────────────────────┘ ┌───────────────────── Mode ──────────────────────┐ │ │ │ Mode : PLASTIC │ │ No. of count : 28 │ │ │ │ Press any key to continue │ └─────────────────────────────────────────────────┘ Dbase Editor S o r t F i l e ----------------- To sort a file, you can choose the Sort File option from the pull-down menu. After that you will see two pop-up windows, one asking for the name to save the sorted database, another asking for the order in which the database is sorted. Here shown the sample order window for the sorting function. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE ┌──── Fields ─────┐ ║LEE SENG HING SAUCE │ 1 NAME ▒ ║LEE SENG HING SAUCE │ 6 NATURE ▒ ▒ ║GAI FAT HONG POWDER │ ART ░ ▒ ║YAU SHING HONG NOODLE │ COMMODITY ▒ ▒ ║SUN FUNG PROVISIONS │ 2 SPECIFIC ▒ ▒ ║TAI╔════════════════════ Save │ MEASURE ▒ as ═════════════════════╗ ▒ ║CHA║ │ NTWT ▒ ║ ▒ ║AU'║ Name of file to SAVE : │ GRWT ▒ ║ ▒ ║ON ║ │ UNIT ▒ ║ ▒ ║TIE╚══════════════════════════│ 3 COST ▒═════════════════════════╝ ░ ║SHING CHEONG WICKS │ 4 SALES ▒ ▒ ║LAIN LAIN PRAWN CRACKER│ 5 DATE ▒ ▒ ║LAIN YOU PRAWN CRACKER│ REMARKS ▒ ║LAIN YOU PRAWN CRACKER└─────────────────┘ ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ Press <F10> to confirm or press <ESC> to abort F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor F i l t e r F i l e --------------------- To filter a file, you can choose the Filter File option from the pull-down menu or Press Alt-T from the keyboard. After that you will see a pop-up window asking for the field number to filter. 1 represent the first field etc. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE 5OZX12 ║LEE SENG HING SAUCE 650MLx18 ▒ ║LEE SENG HING SAUCE 340MLx36 ▒ ║GAI FAT HONG POWDER 6LBX6 ▒ ║YAU SHING HONG NOODLE CUP ▒ ║SUN FUNG PROVISIONS S.FISH ▒ ║TAI SHING PROVISION╔════════ Filter ════════╗ ▒ ║CHAN YEE JAI CAKE ║ ║ ▒ ║AU'S FL ║ Enter Field no. : 11 ║ ▒ ║ON LEE NOODLE ║ ║ ▒ ║TIEN CHU SAUCE ╚════════════════════════╝ ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ Press <Up Arrow> or <Down Arrow> to choose the field F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor If you don't know the exact field number, you can press <Up Arrow> or <Down Arrow> to pop-up a window of fields to choose. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE ┌── Fields ──┐ ║LEE SENG HING SAUCE │ NAME ▒ ║LEE SENG HING SAUCE │ NATURE ░ ▒ ║GAI FAT HONG POWDER │ ART ▒ ▒ ║YAU SHING HONG NOODLE │ COMMODITY ▒ ▒ ║SUN FUNG PROVISIONS │ SPECIFIC ▒ ▒ ║TAI SHING PROVISION╔═════│ MEASURE ▒═════╗ ▒ ║CHAN YEE JAI CAKE ║ │ NTWT ▒ ║ ▒ ║AU'S FL ║ Ente│ GRWT ▒ ║ ▒ ║ON LEE NOODLE ║ │ UNIT ▒ ║ ▒ ║TIEN CHU SAUCE ╚═════│ COST ▒═════╝ ░ ║SHING CHEONG WICKS │ SALES ▒ ▒ ║LAIN LAIN PRAWN CRACKERS │ DATE ▒ ▒ ║LAIN YOU PRAWN CRACKERS │ REMARKS ▒ ║LAIN YOU PRAWN CRACKERS └────────────┘ ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor After that you can choose the method to compare. You can choose Greater than, Smaller than, Greater than or equal to, Smaller than or equal to, equal to. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE 5OZX12 ║LEE SENG HING SAUCE 650MLx18 ▒ ║LEE SENG HING SAUCE 340ML┌──── Comparison ────┐ ▒ ║GAI FAT HONG POWDER 6LBX6│ Greater Than │ ▒ ║YAU SHING HONG NOODLE CUP │ Smaller Than │ ▒ ║SUN FUNG PROVISIONS S.FIS│ Greater Than Equal │ ▒ ║TAI SHING PROVISIONS D.SQU│ Smaller Than Equal │ ▒ ║CHAN YEE JAI CAKE ALMON│ Equal To │ ▒ ║AU'S FL 365-6└────────────────────┘ ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor After that another window will pop-up to ask for the string to filter. Show below is a sample pop-up window. ╔═══════════════════════════════ Filter ═══════════════════════════════╗ ║ ║ ║ Enter string to FILTER : 1000 ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════╝ Note that every time you type F9, the program will search for the next record satifying the condition until no more record can be found. Therefore, you can first go to the first record, specify the condition and keep on pressing F9 to view continuously the records satisfying your given condition. If you want to know the current filter expression, you can choose <View Expression> in the pull-down menu or press Alt-Y. The window may appear like this. ┌──────────────────────── Filter Expression ─────────────────────────┐ │ │ │ Expression : SALES is smaller than 1000 │ │ │ │ Press any key to continue │ └────────────────────────────────────────────────────────────────────┘ Dbase Editor G r a p h P l o t t i n g --------------------------- To plot a graph of a particular field in the currently active database file, you can choose the <Draw line Graph> function in the pull-down menu. All you need to do is choose the field you want to plot at the same time on the graph. If you choose a field, a tick will be shown on the left of the chosen field. After finish choosing the field, you can choose the last object =PLOT= to draw the graph. Note that only numeric fields will be shown in the field listing and you can plot at most 7 different fields on the same graph. One sample screen is shown below. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE ┌─── Fields ───┐ ║LEE SENG HING SAUCE │ COST ▒ ║LEE SENG HING SAUCE │ SALES ░ ▒ ║GAI FAT HONG POWDER │ =PLOT= ▒ ║YAU SHING HONG NOODLE └──────────────┘ ▒ ║SUN FUNG PROVISIONS S.FISH ▒ ║TAI SHING PROVISIONS D.SQUID ▒ ║CHAN YEE JAI CAKE ALMOND ▒ ║AU'S FL 365-6 ▒ ║ON LEE NOODLE 500GX50 ▒ ║TIEN CHU SAUCE 650MLX24 ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor At present, five different kinds of graph are supporting. They are line graph, bar graph, stack graph, HILO graph and Cubic spline graph. If you want other specific graphing technique, you can send me the suggestions through mail. Note that the Bar, stack, HILO and Cublic Spline graphs are disabled in the shareware version. After drawing the graph, the program will ask you whether you want to save the graph to the disk. If so, you can press <F2>, otherwise, you can press other key to continue. After pressing the <F2> key, you will be asked for the file name to save. After entering the filename, the program will start saving the graph in GIF format. If you want to change the name of the title, x-axis or y-axis of the graph, you can choose the appropriate function in the pull-down menu. You will be allowed to change the title which is up to 30 characters. The sample screen is shown below. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE 5OZX12 ║LEE SENG HING SAUCE 650MLx18 ▒ ║LEE SENG HING SAUCE 340MLx36 ▒ ║GAI FAT HONG POWDER 6LBX6 ▒ ║YAU SHING HONG NOODLE CUP ▒ ║SUN FUNG PROVISIONS S.FISH ▒ ║TAI SHING ╔═══════════════════ Change Graph Title ════════════════════╗ ▒ ║CHAN YEE J║ Press F10 to return, ESC to abort ║ ▒ ║AU'S ║ ║ ▒ ║ON LEE ║ Enter new graph title : Dbase Editor Version 1.2 ║ ▒ ║TIEN CHU ║ Enter new x-axis title : X-AXIS ║ ░ ║SHING CHEO║ Enter new y-axis title : Y-AXIS ║ ▒ ║LAIN LAIN ╚═══════════════════════════════════════════════════════════╝ ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor S p e c i a l C o m m a n d s ------------------------------- 1) When you press 'F1', a help screen will pop-up and you can press PAGE-DOWN to see next page or PAGE-UP to see the previous page. One of the help screen is shown below. ┌──────────────── Dbase Editor Help Screen ────────────────┐ │ │ │ Dbase Editor - by Preston Lau │ │ ----------------------------------------------------- │ │ Up one field │ │ Down one field │ │ Left one character │ │ Right one character │ │ F10 Exit with change │ │ ESC Exit without change │ │ HOME Left most character │ │ END Right most character │ │ │ │ Press <PgDn> for next page │ └──────────────────────────────────────────────────────────┘ 2) When you choose the Shell-to-DOS command in the pull-down menu or press Alt-O. You can see the following screen. -------------------------------------------------------------------------------- Enter <exit> to return to the editor The IBM Personal Computer DOS Version 3.30 (C)Copyright International Business Machines Corp 1981, 1987 (C)Copyright Microsoft Corp 1981, 1986 C:\DBFEDIT> C:\DBFEDIT>exit | | | If you type 'exit' here, you will be back to the dbase editor. -------------------------------------------------------------------------------- Dbase Editor 3) To change the default color setting, you can press <Alt-S> or choose the <Change Color> function in the pull-down menu. After press the key, the following screen will pop-up. | | | ---------------------- | ------------------------------------------------------- ╒═════════════════════ | ══════════════════════════════════════════════════════╕ │ D B | E E D I T O R V E R S I O N 1.2 │ │ | Program written by Preston Lau │ ╘═════════════════════ | ══════════════════════════════════════════════════════╛ Current : 46 v C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME══════════┌─── Colors ────┐═══ART═════════════════════════════════════════╗ ║HARBOUR PHONIX│ Normal Text │ 5OZX12 ║LEE SENG HING │ Marked Block │ 650MLx18 ▒ ║LEE SENG HING │ Current Line │ 340MLx36 ▒ ║GAI FAT HONG │ Prompt Line │ 6LBX6 ▒ ║YAU SHING HONG│ Prompt Frame │ CUP ▒ ║SUN FUNG │ Entry Line │ S.FISH ▒ ║TAI SHING │ Error Message │ D.SQUID ▒ ║CHAN YEE JAI │ Menu Text │ ALMOND ▒ ║AU'S │ Menu Select │ 365-6 ▒ ║ON LEE │ Menu Frame │ 500GX50 ▒ ║TIEN CHU │ Logo Text │ 650MLX24 ░ ║SHING CHEONG │ Logo Frame │ WICKS ▒ ║LAIN LAIN │ Header Line │ GP ▒ ║LAIN YOU │ Footer Line │ HM ▒ ║LAIN YOU │ Help Line │ PIGEON ▒ ║TONG FOOK └───────────────┘ 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- You can now use up arrow and down arrow to choose one and change it to you favourite color! After that, you can choose <Save Config> to save it. Dbase Editor 4) Get Info - You can press <Alt-I> or choose the appropriate function in the pull-down menu. After choosing it, a window will pop-up and it show you all the information of the current active database. You can press <PgDn> to go to next page or <PgUp> to go to previous page. A sample window is shown below. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 C:\DBFEDIT\SAMPLE1.DBF Total : 63 ╔NAME═════┌──────────── Dbase Editor Information Screen ─────────────┐═════════╗ ║HARBOUR P│ │ ║LEE SENG │ Filename : C:\DBFEDIT\SAMPLE1.DBF │ ▒ ║LEE SENG │ Fields : 13 │ ▒ ║GAI FAT H│ Record Size : 178 │ ▒ ║YAU SHING│ Records : 63 │ ▒ ║SUN FUNG │ Last Update : 01/21/90 │ ▒ ║TAI SHING│ Free memory : 169480 bytes (165 K) │ ▒ ║CHAN YEE │----------------------------------------------------------│ ▒ ║AU'S │ # FIELD NAME TYPE LEN DEC │ ▒ ║ON LEE │ 6 MEASURE C 15 0 │ ▒ ║TIEN CHU │ 7 NTWT C 5 0 │ ░ ║SHING CHE│ 8 GRWT C 5 0 │ ▒ ║LAIN LAIN│ 9 UNIT C 8 0 │ ▒ ║LAIN YOU │ 10 COST N 8 2 │ ▒ ║LAIN YOU │ │ ▒ ║TONG FOOK│ <PgUp> for prior page, or <PgDn> for next page │ ╚═════════└──────────────────────────────────────────────────────────┘═════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 5) Pop-up Calculator - You can press <Alt-C> or choose the appropriate function in the pull-down menu. After choosing it, a window will pop-up and you can now enter the expression to calulate. Note that parenthesis are allowed in the expression. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 sample1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE 5OZX12 ║LEE SENG HING SAUCE 650MLx18 ▒ ║LEE SENG HING SAUCE 340MLx36 ▒ ║GAI FAT HONG POWDER 6LBX6 ▒ ║YAU SHING HONG NOODLE CUP ▒ ║SUN FUNG PROVISIONS S.FISH ▒ ║TAI╒═════════════════════════════ Calculator ═════════════════════════════╕ ▒ ║CHA│ │ ▒ ║AU'│ Enter Expression : 6+(12*2-20)*3 │ ▒ ║ON │ The result is : 18.00 │ ▒ ║TIE│ │ ░ ║SHI│ Press <ESC> to quit │ ▒ ║LAI╘══════════════════════════════════════════════════════════════════════╛ ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 6) If you want to copy the structure of the current active file, you can choose <Copy Structure> in the pull-down menu. One sample screen is shown below. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 sample1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE 5OZX12 ║LEE SENG HING SAUCE 650MLx18 ▒ ║LEE SENG HING SAUCE 340MLx36 ▒ ║GAI FAT HONG POWDER 6LBX6 ▒ ║YAU SHING HONG NOODLE CUP ▒ ║SUN FUNG PROVISIONS S.FISH ▒ ║TAI╔═══════════════════════════ Copy Structure ═══════════════════════════╗ ▒ ║CHA║ ║ ▒ ║AU'║ Name of file to WRITE : test.dbf ║ ▒ ║ON ║ ║ ▒ ║TIE╚══════════════════════════════════════════════════════════════════════╝ ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor 7) Save as text - This function allows you to save the marked block of records to a given file name in ASCII text. Note that you have to mark the block before issuing the command. -------------------------------------------------------------------------------- ╒══════════════════════════════════════════════════════════════════════════════╕ │ D B A S E E D I T O R V E R S I O N 1.2 │ │ Program written by Preston Lau │ ╘══════════════════════════════════════════════════════════════════════════════╛ Current : 46 sample1.DBF Total : 63 ╔NAME═════════════NATURE═══════════ART═════════════════════════════════════════╗ ║HARBOUR PHONIX SAUCE 5OZX12 ║LEE SENG HING SAUCE 650MLx18 ▒ ║LEE SENG HING SAUCE 340MLx36 ▒ ║GAI FAT HONG POWDER 6LBX6 ▒ ║YAU SHING HONG NOODLE CUP ▒ ║SUN FUNG PROVISIONS S.FISH ▒ ║TAI╔═════════════════════════ Save as text file ══════════════════════════╗ ▒ ║CHA║ ║ ▒ ║AU'║ Name of file to SAVE : test.txt ║ ▒ ║ON ║ ║ ▒ ║TIE╚══════════════════════════════════════════════════════════════════════╝ ░ ║SHING CHEONG WICKS WICKS ▒ ║LAIN LAIN PRAWN CRACKERS GP ▒ ║LAIN YOU PRAWN CRACKERS HM ▒ ║LAIN YOU PRAWN CRACKERS PIGEON ▒ ║TONG FOOK VERMICELLI 50gx500 ╚══════════════════════════════════════════════════════════════════════════════╝ F1-Help F2-Close F3-Open F4-Mark Beg F5-Mark End F6-Find Next F10-Exit -------------------------------------------------------------------------------- Dbase Editor DBASE EDITOR Development History -------------------------------- Version 1.2 - Released September 15, 1990 ----------------------------------------- 1) Allow you to sort the database file and save it to the disk in another name. You can specify the order of fields you want to sort. 2) The mode of a particular field can be easily calculated. All kind of fields are now supported. The number of occurrence of the value is also shown. 3) You can now reorder the fields in the edit mode. Any combination of fields can be choosed for editing. You can also go to the next record and previous record using the <PgDn> and <PgUp> keys in the EDIT mode. This helps you a lot when you want to edit a lot of data. 4) Add the Vertical Scroll bar in the window to indicate the position of record in the file. 5) Easy scrolling in the get-info function. You can now use <PgUp> and <PgDn> to scroll the page of database information up and down easily. 6) Allow you to add multiple records. After pressing the <F10> key to confirm the change, another empty record will pop up. As soon as all new records have been added. You can press <ESC> to abort. 7) Even faster calculating the sum, mean, standard deviation and mode. 8) Add the HI Lo graph to the graphics functinos. 9) Add the Cublic Splien Graph to the graphics functions. 10) Even better user interface - Use Dialog and new error message window. Different method to open a window (open up in the middle). 11) Fix the stop searching bug in version 1.0 12) Fix some minor bugs. Version 1.0 - Released January 8, 1990 -------------------------------------- 1) Cut and Paste function are supported. Easy manipulation of data between different database file. 2) Add the draw bar graph function. 3) Add the draw stack graph function. 4) Add the change title function. 5) Add the Save Graph function. Save as GIF format. 6) You can now save the block of records in the database file as ASCII text format. 7) Add the copy marked block function. 8) Change the function F4 to Mark beginning block. and F5 to Mark ending block. 9) Some minor modifications. Version 0.9 - Released October 8, 1989 -------------------------------------- 1) Owning to a programming bug, the speed of screen output is proportional to the number of fields present. Now, the bug is fixed and so the screen output is faster. 2) Use a larger file buffer, i.e. faster file access. 3) A graph plotting function is included. 4) A copy structure function is included. 5) Now, the search function can search a particular field. 6) Show current file name in the status line. Dbase Editor 7) Add the Mark all records function. 8) When you edit more than one file, the program will automatically change the window size for you. 9) Support Dbase IV and FOXPRO database files. 10) Fix a bug in memo field. 11) Allow you to choose a drive letter from A - Z. 12) Add the record filtering function. 13) Different opening screen. 14) Many minor modification. Version 0.82 - Released September 8, 1989 ----------------------------------------- 1) Faster screen output. More than three times faster. 2) Faster file read. Use a larger file buffer so that the file access is very much faster. When you press 'PGUP' or 'PGDN', the screen update time is less than a second! 3) The file search algorithm is improved and faster. 4) Add the view index expression function. 5) Add the calculator function. 6) Add the maximum and minimum function. 7) Add the Sum and Mean function. 8) Add the Standard Deviation and Variance function. 9) Fast calculation. When using a PS-2 model 50 to sum up a field in a database with 500 records. It takes only 3 SECONDS!!! 10) Fix a bug in the search function. 11) Show free memory space in Get Info. 12) Use Large memory model instead of Small. 13) Many minor bugs. Dbase Editor Version 0.8 - Released on August 25, 1989 (1st release) ------------------------------------------------------- Original Release!