Category : Dbase (Clipper, FoxBase, etc) Languages Source Code
Archive   : DBROW20.ZIP
Filename : DBROWSHR.HLP

* ±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±± !TWSS Help System for DBROWSHR.HLP TOADWare Software Systems 12138 Persimmon Terrace Auburn, CA 95603 $Last update : Monday October 8, 1990 "Copyright 1990 All rights reserved * ±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±±
2dBrowse will allow you to easily view the records
2in a dBase III or IV ".DBF" file. The records are 2displayed in an easy to read horizontal format of 220 records at a time. 2 2If a memo file is found for the DBF file you can 2also view a memo for any record with the press 2of a key. 2 2All of the displayed records can be exported to 2another DBF file, a plain ASCII text file, or a 2"DIF" (Data Interchange Format) for import into 2other programs that support this format. 2 2Main Menu 

dBrowse Introduction
(uŽ:ôj2":2:2At the press of a single key you can view the 2header file for the current DBF file. This will 
2show you all of the inportant information you may 2need to know. 2 2Use your cursor keys to manipulate the display 
2window or a mouse if one is detected.

2 2 2 2 2 2 2 2Main Menu 


Introduction continued(uŽ:ôj2":2:2Introduction A brief description of the

2 dBrowse program. 2Cursor Keys Cursor key operation 
2 2Function Keys Function key commands 
2 2Mouse Mouse operations

2 2Search Searching operations

2 2Export Export operations 
2 2Header Header information 
2 2Shareware Shareware and Ordering 

Main Help Menu0t
(uŽ:ôj2":2:2The display window is moved through the record and2field data with the cursor keys. These functions 2can also be performed with a mouse.
#2 2Up Arrow Move the highlight bar up one line.2 If it is at the top of the window 2 and not on the first record the 2 window will be scrolled. 2 2Down Arrow Move the highlight bar down one 2 line. If it is at the bottom of the2 window and not on the last record 2 the window will be scrolled. 2 2 Cursor Keys1t
(uŽ:ôj2":2:2Left Arrow Shift the display window left 2 1 field at a time. This will 2 continue until the first field 2 is reached. 2 2Ctrl Left Arrow Move to column 1 of the display2 window. 2 2Right Arrow Shift the display window right 2 1 field at a time until the 2 last field of the record is 2 reached. 2 2Ctrl Right Arrow Move to the last field of the 2 display window. Cursor Keys Continued(uŽ:ôj2":2:2PgUp Move the display up 20 records. 2 2PgDn Move the display down 20 records. 2 2Home Move to the first record. No column 2 change. 2 2Ctrl Home Move to the first column of the first2 record. 2 2End Move to the last record. No column 2 change. 2 2Ctrl End Move to the last field of the last 2Main Menu record. 

Cursor Keys Continued(uŽ:ôj2":2:2F1 This help sub system. 2 2F5 Display the DBF header information. 2 2F6 Displays a directory window and allows 2 you to select a new DBF file to be 2 browsed. 2 2F7 If a memo file exists display the memo for2 the record the highlight bar is on. 2 2F8 Export the current data to another dBase 2 III compatible DBF file. The default file 2 extension is ".DB". 2 
Function Keys1t
(uŽ:ôj2":2:2Ctrl F8 Export the current records to an ASCII 
2 text file. The default file name is 2 [DBF File.TXT] 2 2Alt F8 Export the current records to a DIF file.
2 The default file name is [DBF File.DIF]. 2 2F9 Search records for entered data.

2 2 2 2 2 2 2  Function Keys Continued(uŽ:ôj2":2: 2F10 This key will activate the menu system2 for users that are more comfortible 2 with a menu type of operation. Or 2 non-mouse users. All of the menu 2 functions have direct function key 2 operations. 2 2ESC Leave the current function and return 2 to the previous one. If you are in the2 display window the program will return2 to DOS. This can also be done by 2 placing the mouse cursor in the upper 2 right corner of the display window and2 pressing the right mouse button. 2Main Menu 

Function Keys Continued(uŽ:ôj2":2:
2The display window can be controlled by the mouse 2by placing it on one of the following characters 2along the border and pressing the left button. If 2a character cannot be seen then no further 2movement can be made in that direction. 2 2  Move the display 1 field left until the 2 first field is reached. 2 2  Move the display 1 field right until the 2 the last field is reached. 2 2  Move the screen up one page. 2 2  Move the screen down one page. Mouse Operations
(uŽ:ôj2":2:2Two special characters are placed in the corners 2at the top of the window. They act in the same 2manner as the Help key and the ESC key. 2 2 ð This character is in the upper left 2 hand corner of the window. Place the 2 mouse cursor on this character and 2 press the left button to call up the 2 help system. 2 2  This character is in the upper right 2 hand corner of the window. Place the 2 mouse cursor on this character and 2 press the left button to activate the 2Main Menu menu system. 


Mouse Operations Continued(uŽ:ôj2":2: 2The mouse can also be used to tag records. Simply 2place the mouse cursor on the record you wished 2tagged (or cleared) and press the right button. 2 2 2 2 2 2 2 2 2 2 2 2Main Menu 

Mouse Operations Continued(uŽ:ôj2":2:
2Searching 2 2One of the unique features of dBrowse is allowing 2you to search the records of a DBF file for fields2with data matching the data you select. You select2which fields to search and what to search for. You2can even search for blank (or not blank) fields! 2 2When you press the F9 function key a window with #2all of the field names will be displayed. Also you2will see a window with all 10 of the compare 2options available. Now you simply select the field2and compare option then enter the data to be 2compared with. 2 Search Operations
(uŽ:ôj2":2:2When using the search option the commands must 2be in the following format: 2 [Field name] [Compare option] [Match value] 2 2The Field Name can be either the actual field 2name or the field number (example : #3). 2 2Each of the search command parts must be seperated2by at least one space. 2 2 2 2 2 2Main Menu 

Search Operations Continued(uŽ:ôj2":2:2Records can be exported to any of three different 2file types. This allows a great deal of freedom 2in dealing with the data. 2 2The first type is another dBase compatable data- 2base file. This allows you to build up smaller 2databases containing only the desired data. 2 2The next type is a plain ASCII text file. This 2will contain the same header string used by the 2display window, the record number for each record 2and all of the tagged records. 2 2 2  Exporting(1t
(uŽ:ôj2":2:2The plain ASCII file can be used by text editors, 2word processors, and desk top publishing packages.2 2The last export format is the Data Interchange 2Format (DIF) used by other database programs, 2spreadsheet packages, and many other programs. 2 2The last two formats save the records as viewable 2ASCII text. The only difference is in the way the 2data is delimited. 2 2 2 2 2 Exporting Continued
(uŽ:ôj2":2:2Future exporting options : 2 2TOADWare Software Systems is currently working on 2expanding the export options to include the 2following : 2 2 Lotus ".WKS" files. 2 Paradox database format. 2 WordPerfect Table format. 2 File Express database format. 2 2If you have any other ideas drop us a line, your 2ideas are wanted. 2 2Main Menu 

Exporting Continued
(uŽ:ôj2":2:2Header Format 2 2When you press the F5 key you will be shown the 2dBase header for the current DBF file. The header 2contains information used by dBase and other 2programs (such as dBrowse) to read manipulate the 2file. 2 2The header contains the following information : 21. The dBase version of the DBF file. 22. The number of records in the DBF file. 23. The date the DBF file was created or last 2 written to (updated). 24. If a memo file (".DBT") was created for the 2 DBF file. 
Header Format1t
(uŽ:ôj2":2:2The header also contains all of the information 2for the fields. This information contains the 2following : 2 2Field Name : 10 Characters Upper case. 2Field Type : 1 Character 'C' Character 2 'N' Numeric 2 'L' Logical 2 'D' Date 2 'M' Memo field 2Field Length : The number of bytes used by the 2 field. 2Field Decimal: Then number of decimal places used 2 by a numeric field. 2Main Menu 

Header Format Continued(uŽ:ôj2":2:2Shareware Notice : 2 2This is an un-registered Shareware copy of dBrowse2that you may use for evaluation purposes for a 2period not to exceed 30 days. If you use this 2product after the intial 30 days you are expected 2to register with TOADWare Software Systems. 2 2If you received this copy from a Shareware or 2Disk distributor you have not purchased this copy 2and are not registered! 2 2Please press the PgDn key for ordering information2 2 Shareware Information(uŽ:ôj2":2:2To order a registered copy of dBrowse please 2send $24.95 to : 2 2 TOADWare Software Systems 2 12138 Persimmon Terrace 2 Auburn, CA 95603 2 2 Please allow 4-6 weeks for delivery. 2 2When you order dBrowse you will also receive a 2registerd copy of dBSort. For more information 2please see the README.TXT file that came with the 2Shareware version of dBrowse. 2 2Main Menu 

Ordering Information
(uŽ:ôj2":2: