3363 lines
114 KiB
Plaintext
3363 lines
114 KiB
Plaintext
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF (tm)
|
||
"Instant Access to X-Base Files"
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Version 4.0
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
User's Manual
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
_______
|
||
____|__ | (R)
|
||
--| | |------------------
|
||
| O___|__ | Association of
|
||
| | |_| Shareware
|
||
|__| O | Professionals
|
||
-----| | |--------------------
|
||
|___|___| MEMBER
|
||
|
||
|
||
|
||
Copyright (c) 1989-1991 Bowen Software, All Rights Reserved
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Table of Contents
|
||
|
||
|
||
|
||
|
||
1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . 1
|
||
1.1 Overview of PopDBF . . . . . . . . . . . . . . . . . 1
|
||
1.2 Limitations . . . . . . . . . . . . . . . . . . . . . 3
|
||
1.3 Cautions . . . . . . . . . . . . . . . . . . . . . . 4
|
||
1.4 Registration . . . . . . . . . . . . . . . . . . . . 5
|
||
1.4.1 How to Register . . . . . . . . . . . . . . . 5
|
||
1.4.2 Registration Benefits . . . . . . . . . . . . 6
|
||
1.5 What is "Shareware" . . . . . . . . . . . . . . . . . 6
|
||
1.6 ASP Ombudsman Information . . . . . . . . . . . . . . 7
|
||
1.7 Technical Support . . . . . . . . . . . . . . . . . . 8
|
||
1.8 Trademark Acknowledgements . . . . . . . . . . . . . 9
|
||
1.9 License Agreement, Disclaimer and Warranty . . . . . 9
|
||
1.9.1 Shareware Version License . . . . . . . . . . 9
|
||
1.9.2 Registered Version License . . . . . . . . . . 10
|
||
1.9.3 Warranty . . . . . . . . . . . . . . . . . . . 10
|
||
|
||
2 Getting Started . . . . . . . . . . . . . . . . . . . . . . 11
|
||
2.1 Installing PopDBF . . . . . . . . . . . . . . . . . . 11
|
||
2.2 Executing PopDBF . . . . . . . . . . . . . . . . . . 11
|
||
2.2.1 Running PopDBF in Memory Resident Mode . . . . 11
|
||
2.2.2 Running PopDBF in Non-Resident Mode . . . . . 12
|
||
2.3 Modifying AUTOEXEC.BAT to Load PopDBF . . . . . . . . 12
|
||
2.4 Removing PopDBF from Memory . . . . . . . . . . . . . 13
|
||
2.5 How to Invoke PopDBF (Using the "Hotkey") . . . . . . 13
|
||
2.6 Command Line Options . . . . . . . . . . . . . . . . 13
|
||
/A<A|B|E|S> Default action . . . . . . . . . . . . 13
|
||
/C<C|M|O> Color scheme . . . . . . . . . . . . . 14
|
||
/D<dir> Initial PopDBF Directory . . . . . . . 14
|
||
/E<size> Edit buffer of size bytes . . . . . . 14
|
||
/F<num> Maximum of num fields . . . . . . . . 15
|
||
/G<num> Maximum of num files . . . . . . . . . 15
|
||
/H Command line syntax and options . . . 16
|
||
/I Ignore hotkey, toggles on and off . . 16
|
||
/L<dir> Directory where master .FRQ file is
|
||
located . . . . . . . . . . . . . . . 16
|
||
/[!]P[file] Use "Pass-Thru" non-resident mode . . 16
|
||
/R<size> Read buffer of size bytes . . . . . . 17
|
||
/S<D|E|N> Swap to Disk|EMS|None . . . . . . . . 17
|
||
/T<B,C,I,V,W,Z>
|
||
Toggle indicator defaults . . . . . . . . . . . 18
|
||
/U Uninstall (remove) from memory . . . . 19
|
||
/X<file> File name for swapping to Disk . . . . 19
|
||
/Y<file> Initial PopDBF File . . . . . . . . . 20
|
||
|
||
i
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Table of Contents
|
||
|
||
|
||
|
||
3 Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
|
||
3.1 Generic Help (Alt-F1) . . . . . . . . . . . . . . . . 21
|
||
3.2 Context Sensitive Help (F1) . . . . . . . . . . . . . 21
|
||
|
||
4 Alt Menu (Alt) . . . . . . . . . . . . . . . . . . . . . . . 22
|
||
4.1 Alt Action Keys . . . . . . . . . . . . . . . . . . . 22
|
||
4.2 Alt Toggle Keys . . . . . . . . . . . . . . . . . . . 23
|
||
4.3 Toggle Indicator Summary . . . . . . . . . . . . . . 24
|
||
|
||
5 Cursor and Lite-Bar Movement . . . . . . . . . . . . . . . . 25
|
||
5.1 The "Wordstar" Diamond . . . . . . . . . . . . . . . 25
|
||
|
||
6 Pick File (Alt-P) . . . . . . . . . . . . . . . . . . . . . 26
|
||
6.1 Select Directory/File/Index (Enter) . . . . . . . . . 26
|
||
6.2 Move to Parent Directory (BackSpace) . . . . . . . . 26
|
||
6.3 Change Directory and/or Drive (F2) . . . . . . . . . 26
|
||
6.4 Enter A Specific File (F3) . . . . . . . . . . . . . 27
|
||
6.5 Change File Specification (F4) . . . . . . . . . . . 27
|
||
6.6 Change Default Action (F5) . . . . . . . . . . . . . 27
|
||
6.7 Delete File (F6) . . . . . . . . . . . . . . . . . . 28
|
||
6.8 Move to Current DOS Drive & Directory (F10) . . . . . 28
|
||
6.9 Frequent Database Access (Alt-1 thru Alt-=) . . . . . 28
|
||
6.10 Show Names of Frequently Accessed Databases (Ctrl-
|
||
N) . . . . . . . . . . . . . . . . . . . . . . . . . 29
|
||
6.11 Program Information . . . . . . . . . . . . . . . . . 29
|
||
|
||
7 Setup View (Alt-S) . . . . . . . . . . . . . . . . . . . . . 30
|
||
7.1 Return To Data (Enter) . . . . . . . . . . . . . . . 30
|
||
7.2 Number/Un-Number Fields (Space) . . . . . . . . . . . 30
|
||
7.3 Clear Field Numbers (F2) . . . . . . . . . . . . . . 30
|
||
7.4 Assign a Specific Field Number (F3) . . . . . . . . . 31
|
||
7.5 Order Fields Using Field Numbers (F4) . . . . . . . . 31
|
||
7.6 Tag/Un-Tag Field for Exclusive Find (F6) . . . . . . 31
|
||
7.7 Clear Exclusive Find Tags (F7) . . . . . . . . . . . 31
|
||
7.8 Copy File Structure (F8) . . . . . . . . . . . . . . 32
|
||
7.9 Print the File Structure (F9) . . . . . . . . . . . . 32
|
||
|
||
8 Browse Records (Alt-B) . . . . . . . . . . . . . . . . . . . 33
|
||
8.1 Current Record and Delete Status . . . . . . . . . . 33
|
||
8.2 Toggle Vertical Separator Bars On/Off (Shift-|) . . . 33
|
||
8.3 Pan the Browse Window (LeftArrow/RightArrow) . . . . 33
|
||
8.4 View Large Fields (Tab/Shift-Tab) . . . . . . . . . . 33
|
||
8.5 Zoom the Browse Window (F2) . . . . . . . . . . . . . 33
|
||
8.6 Goto a Specific Record (F3) . . . . . . . . . . . . . 33
|
||
|
||
ii
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Table of Contents
|
||
|
||
|
||
|
||
8.9 Find Text (F7) . . . . . . . . . . . . . . . . . . . 34
|
||
8.10 Find Next Occurrence of Text (F8) . . . . . . . . . . 35
|
||
8.11 Print Records (F9) . . . . . . . . . . . . . . . . . 35
|
||
8.12 Turn Century On/Off (Ctrl-K) . . . . . . . . . . . . 36
|
||
8.13 Mark Record as Deleted (Ctrl-U) . . . . . . . . . . . 36
|
||
|
||
9 Edit/Append Records (Alt-E/Alt-A) . . . . . . . . . . . . . 37
|
||
9.1 Copy a Record (F2) . . . . . . . . . . . . . . . . . 37
|
||
9.2 Goto a Specific Record (F3) . . . . . . . . . . . . . 37
|
||
9.3 Cut Field into Keyboard Paste Buffer (F4) . . . . . . 37
|
||
9.4 Clear Keyboard Paste Buffer (Shift-F4) . . . . . . . 38
|
||
9.5 Find Text (F7) . . . . . . . . . . . . . . . . . . . 38
|
||
9.6 Find Next Occurrence of Text (F8) . . . . . . . . . . 38
|
||
9.7 Print Records (F9) . . . . . . . . . . . . . . . . . 38
|
||
9.8 Field Information (F10) . . . . . . . . . . . . . . . 39
|
||
9.9 Restore Field Data (Ctrl-J) . . . . . . . . . . . . . 39
|
||
9.10 Turn Century On/Off (Ctrl-K) . . . . . . . . . . . . 39
|
||
9.11 System Date (Ctrl-M) . . . . . . . . . . . . . . . . 39
|
||
9.12 Move to Last Field Position (Ctrl-N) . . . . . . . . 39
|
||
9.13 Restore Entire Record (Ctrl-O) . . . . . . . . . . . 39
|
||
9.14 Paste Data (Ctrl-P) . . . . . . . . . . . . . . . . . 40
|
||
9.15 Abort and Lose Changes (Ctrl-Q/ESCAPE) . . . . . . . 40
|
||
9.16 Mark Record as Deleted (Ctrl-U) . . . . . . . . . . . 40
|
||
9.17 Toggle Verify Mode On/Off (Ctrl-V) . . . . . . . . . 40
|
||
9.18 Quit and Save Changes (Ctrl-W/Ctrl-End) . . . . . . . 40
|
||
9.19 Blank Current Field (Ctrl-Y) . . . . . . . . . . . . 40
|
||
9.20 Blank to End of Field (Ctrl-Delete) . . . . . . . . . 41
|
||
9.21 Move to End of Data (End) . . . . . . . . . . . . . . 41
|
||
9.22 Move to First Position (Home) . . . . . . . . . . . . 41
|
||
9.23 Move Word (Ctrl-LeftArrow/Ctrl-RightArrow) . . . . . 41
|
||
9.24 Move to First/Last Field (Ctrl-UpArrow/Ctrl-
|
||
DownArrow) . . . . . . . . . . . . . . . . . . . . . 41
|
||
9.25 Previous Record/Next Record, Same Page (Alt-PgUp/Alt-
|
||
PgDn) . . . . . . . . . . . . . . . . . . . . . . . . 41
|
||
|
||
10 Common Questions and Answers . . . . . . . . . . . . . . . 42
|
||
|
||
11 Error Messages . . . . . . . . . . . . . . . . . . . . . . 44
|
||
|
||
12 Configuring PopDBF . . . . . . . . . . . . . . . . . . . . 46
|
||
12.1 The Configuration Main Menu . . . . . . . . . . . . 46
|
||
12.2 Configuring Colors . . . . . . . . . . . . . . . . . 46
|
||
12.3 Configuring Date/Number Formats . . . . . . . . . . 47
|
||
12.4 Configuring Main Hotkey . . . . . . . . . . . . . . 47
|
||
|
||
iii
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Table of Contents
|
||
|
||
|
||
|
||
12.5 Configuring Paste Options . . . . . . . . . . . . . 48
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
iv
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
1 Introduction
|
||
|
||
1.1 Overview of PopDBF
|
||
|
||
PopDBF is a pop-up memory resident program that uses only 4K of RAM!
|
||
PopDBF allows you to have "Instant Access" to any dBase compatible
|
||
.DBF database file. This includes, but is not limited to, files
|
||
used by Clipper, dBASE III, dBASE IV, dBXL, FoxBASE+, FoxPro, PC-
|
||
File/db and Quicksilver. The term X-base (which is in the public
|
||
domain) refers to all of the different dialects referred to above.
|
||
|
||
Memory resident programs, also call TSRs (Terminate Stay Resident),
|
||
are special programs that stay in memory after you run them. To use
|
||
a memory resident program that is in memory, you press the
|
||
designated hotkey. It is this hotkey that causes the program, which
|
||
is hibernating in memory, to "spring" to life and pop-up for you to
|
||
use.
|
||
|
||
After PopDBF has been loaded, you can access your database files
|
||
from anywhere by pressing the hotkey (the default hotkey is
|
||
Alt-BackSpace). To return to where you came from just press the
|
||
hotkey again. It's that simple!
|
||
|
||
There are many reasons why PopDBF is the best tool available for
|
||
accessing your database files. Some of the reasons include:
|
||
|
||
* Faster than using dBASE or a compatible program! You
|
||
don't have to wait while a bulky database program loads
|
||
just to take a quick look at a database file. "Instant
|
||
Access" means just that - INSTANT!
|
||
|
||
* Easier to use than dBASE! You don't have to know dBASE
|
||
commands. Switching from append to browse to edit is a
|
||
matter of pressing one key!
|
||
|
||
* Access database files without leaving another application!
|
||
You no longer have to exit your word processor, load your
|
||
database program, look at the database file, exit the
|
||
database program and reload your word processor - just
|
||
press the PopDBF hotkey!
|
||
|
||
* Cut and Paste information from a database directly into
|
||
another application! Save time typing in name and address
|
||
information to your word processor - let PopDBF do it for
|
||
you!
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 1
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
* Searches on a database for ANY text are lightning fast.
|
||
This means you don't have to know what field the text is
|
||
in, PopDBF takes care of it for you!
|
||
|
||
|
||
The applications for PopDBF are just as numerous. After just a few
|
||
minutes of using PopDBF you will be thinking up your own ways of how
|
||
to use its many features to improve your productivity. Here are
|
||
just a few examples to spark your creativity.
|
||
|
||
Great for Anybody who uses a phone:
|
||
|
||
* Maintain and search a rolodex database of all the people
|
||
you know with their place of business, address(es) and
|
||
phone number(s). This could be applied to any type of
|
||
information you need "instant" access to.
|
||
|
||
Great for Secretaries and Order Operators
|
||
|
||
* Take messages for people or log problems with products in
|
||
the field without having to leave the program you are
|
||
currently running.
|
||
|
||
* Add an order to the order database or search the database
|
||
to see the current status of the order.
|
||
|
||
Great for Programmers:
|
||
|
||
* Find out the name, type or length of a field.
|
||
|
||
* Find out the key used to create any .IDX, .NDX or .NTX
|
||
index file.
|
||
|
||
* Pack or Zap a database file without having to get out of
|
||
the application to use a database program.
|
||
|
||
Great for Consultants:
|
||
|
||
* Print the structure of any or all databases in a directory
|
||
with ease.
|
||
|
||
* Quickly get into any database to see what the data looks
|
||
like.
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 2
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
PopDBF provides an easy way to move throughout your hard disk(s) and
|
||
networks to find your database files. It also has context sensitive
|
||
help for novice (or forgetful) users, but you probably won't need
|
||
it. PopDBF is that easy to use!
|
||
|
||
|
||
You can use PopDBF to:
|
||
|
||
* pick a database file
|
||
* delete a database file
|
||
* view file structure
|
||
* print file structure
|
||
* append and edit records
|
||
* browse records
|
||
* delete or undelete records
|
||
* print records (design your own mini-report)
|
||
* search for strings anywhere in a database
|
||
* pack or zap a database
|
||
* specify fields and assign their order for the above
|
||
features
|
||
* view index expressions of index files
|
||
|
||
|
||
And if you don't feel comfortable using memory resident programs,
|
||
PopDBF has a non-resident "pass-thru" mode so that you can run it
|
||
from the DOS prompt like any other program.
|
||
|
||
Programmers can even set up macros in some program editors (BOXER,
|
||
Qedit, etc.) to execute PopDBF and have it automatically open the
|
||
database the cursor is positioned on.
|
||
|
||
PopDBF has four main areas:
|
||
|
||
1. Pick File
|
||
2. Setup View
|
||
3. Browse Records
|
||
4. Append/Edit Records
|
||
|
||
Each of these areas is described more fully below along with the
|
||
actions available from each.
|
||
|
||
|
||
1.2 Limitations
|
||
|
||
Though PopDBF has many features, it does not do everything, yet!.
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 3
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
Currently PopDBF does not do the following:
|
||
|
||
* view or edit memo fields
|
||
* use index files (it does display the expression used to
|
||
create them)
|
||
* view more than one database file at a time
|
||
* handle database files with more 65,535 records
|
||
* handle fields larger than 254 characters
|
||
* lock individual records in a database on the network
|
||
|
||
Also, PopDBF is not meant to be a complete replacement for the
|
||
relational database management systems (RDBMS) many people are
|
||
currently using (i.e. dBASE). In some instances the function being
|
||
done with the RDBMS can be fulfilled entirely by PopDBF. However,
|
||
in general PopDBF is meant to enhance those programs and improve
|
||
productivity by providing "instant access" to your valuable database
|
||
information.
|
||
|
||
|
||
1.3 Cautions
|
||
|
||
When using PopDBF from within any RDBMS or application that allows
|
||
dBASE compatible records to be changed, it is important to remember
|
||
that most of those products do internal record buffering. This
|
||
means that if a record is changed and resides in an internal buffer,
|
||
the change will NOT be reflected when viewed from within PopDBF.
|
||
|
||
Likewise, if a record is changed in PopDBF while that same record is
|
||
in an internal buffer, the change will be overwritten by the RDBMS
|
||
or application when it closes the file and/or flushes the internal
|
||
buffer.
|
||
|
||
As a general rule, do not use PopDBF to change records in a database
|
||
that might be opened by an RDBMS or similar application.
|
||
|
||
It should also be pointed out that because PopDBF does not currently
|
||
use index files, no indexes will be updated. Care should be taken
|
||
when changing databases that have associated indexes which need to
|
||
stay up to date. For these types of databases, as long as you don't
|
||
change key fields (fields used to create an index), add or delete
|
||
records there will be no problem.
|
||
|
||
Should you need to change information in databases falling into the
|
||
category mentioned above, just make sure that you reindex the
|
||
database.
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 4
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
1.4 Registration
|
||
|
||
1.4.1 How to Register
|
||
|
||
PopDBF is not FREE! You may try it out at no charge for an initial
|
||
trial period to determine if it fits your needs. If you want to
|
||
continue to use PopDBF after the initial trial period you must
|
||
register. This method of software distribution is known as
|
||
Shareware.
|
||
|
||
The registration fee for a single copy of PopDBF is $35US. All
|
||
checks or money orders must be payable in US dollars. For a
|
||
description of what you get when you register see "Registration
|
||
Benefits" on page 6.
|
||
|
||
Registration of PopDBF is mandatory for commercial and government
|
||
users.
|
||
|
||
To register your copy of PopDBF, send your registration fee of $35,
|
||
payable in US funds (see the file ORDER.FRM), to:
|
||
|
||
Bowen Software
|
||
P.O. Box 2134
|
||
East Peoria, Illinois 61611
|
||
|
||
You can order by sending check, cash or money order to Bowen
|
||
Software at the address listed above.
|
||
|
||
You can also register with Master Card, Visa, Amex, or Discover by
|
||
calling (800) 242-4775 or (713) 524-6394 or by FAX to (713) 524-6398
|
||
or by CompuServe Email to 71355,470. THESE NUMBERS ARE FOR ORDERS
|
||
ONLY.
|
||
|
||
Any questions about the status of the shipment of the order,
|
||
refunds, product details, technical support, volume discounts,
|
||
dealer pricing, site licenses, etc, must be directed to Bowen
|
||
Software at 309-699-0950. You can also mail credit card orders to
|
||
Bowen Software c/o PsL, P.O. Box 35705, Houston, TX 77235-5705.
|
||
|
||
There is a cash discount, which is waived for credit card orders.
|
||
|
||
You can also order PopDBF by calling your local software distributor
|
||
(i.e. Computerland, Egghead).
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 5
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
PopDBF must be registered for EACH USER at your site; alternatively,
|
||
contact Bowen Software for current SITE LICENSE information.
|
||
|
||
It is our desire at Bowen Software that you be completely satisfied
|
||
with our software products and services. To insure this we offer a
|
||
complete money back guarantee!
|
||
|
||
|
||
1.4.2 Registration Benefits
|
||
|
||
The following benefits apply to all registered users of PopDBf:
|
||
|
||
* FREE technical support over the phone for at least six
|
||
months.
|
||
|
||
* Notified of program updates and provided the first update
|
||
absolutely FREE!
|
||
|
||
* Registered version of PopDBF does NOT contain the
|
||
registration information screen, which pops up on the
|
||
screen twice during each 24 hour period (it does pop up
|
||
when exiting each time if run in Pass-Thru mode).
|
||
|
||
* FREE introductory subscription to CompuServe Information
|
||
Service - the biggest national BBS! You will receive: a
|
||
private user ID number and Password, a $15 usage credit
|
||
(over 1 hour connect time at 2400 baud), a complimentary
|
||
subscription to CompuServes's monthly computing magazine:
|
||
'Compuserve'.
|
||
|
||
* Significant discount on Shareware Magazine where you can
|
||
find out about the best shareware and how to get it.
|
||
|
||
|
||
1.5 What is "Shareware"
|
||
|
||
"Shareware" is a term used to describe a system for distribution of
|
||
software. Under the shareware concept, software may be freely
|
||
copied and passed along to others, or distributed through bulletin
|
||
board systems, etc.
|
||
|
||
As a recipient of a shareware program, you may use the software for
|
||
a short trial period to determine if it meets your needs. If it
|
||
does, you pay the registration fee. By paying the fee, you are
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 6
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
granted the right to retain the software for your use. If the
|
||
software is not suitable, then you may discard it.
|
||
|
||
The shareware system provides significant benefits to the computing
|
||
community (of which YOU are a member):
|
||
|
||
1) You get to try out the software BEFORE you buy it so you
|
||
know exactly what you're buying.
|
||
|
||
2) Shareware is substantially less expensive than most
|
||
commercial programs. You don't pay for costly marketing
|
||
programs and fancy packaging.
|
||
|
||
3) You get access to a MUCH broader base of available
|
||
programs. Thousands of excellent programs have been
|
||
written by expert programmers who would never consider
|
||
marketing commercially. Through the concept of shareware,
|
||
these people make their programs available to the
|
||
community. Usually, all they ask in return is a small fee
|
||
to reward them for the time and effort they've put into
|
||
the program.
|
||
|
||
The system is based entirely on the honor system, and generally
|
||
works quite well (Most people are honest and wouldn't violate the
|
||
trust placed in them by the author of the software!). Shareware is
|
||
NOT free software - the author counts on your integrity.
|
||
|
||
|
||
1.6 ASP Ombudsman Information
|
||
|
||
Bowen Software is an author member of the Association of Shareware
|
||
Professionals (ASP). ASP wants to make sure that the shareware
|
||
principle works for you. If you are unable to resolve a
|
||
shareware-related problem with an ASP member by contacting the
|
||
member directly, ASP may be able to help. The ASP Ombudsman can
|
||
help you resolve a dispute or problem with an ASP member, but does
|
||
not provide technical support for members' products. Please write
|
||
to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a
|
||
Compuserve message via Compuserve Mail to ASP Ombudsman 70007,3536.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 7
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
1.7 Technical Support
|
||
|
||
You can contact Bowen Software by leaving messages on Compuserve to
|
||
76665,736. The latest version of PopDBF can be found on Compuserve
|
||
in the IBMAPP forum Data Library 3. We recommend that anyone who
|
||
accesses Compuserve frequently use another Shareware program called
|
||
TapCIS to automate the online processes. TapCIS can save users both
|
||
time and money. To learn more about TapCIS when on Compuserve, type
|
||
GO TAPCIS when online.
|
||
|
||
Bowen Software shareware products can be found on many Bulletin
|
||
Board Systems (BBS) across the country. We directly upload our
|
||
products to the Exec-PC bulletin board located in Milwaukee,
|
||
Wisconsin. The Exec-PC phone number is (414) 789-4210. Electronic
|
||
messages can be left on Exec-PC and should be addressed to Don
|
||
Bowen.
|
||
|
||
To contact Bowen Software via Internet, leave messages to
|
||
76665.736@COMPUSERVE.COM.
|
||
|
||
Contacting us using the above methods is preferred. If you do not
|
||
have access to electronic communication you can contact us by phone
|
||
at (309) 699-0950. Messages are usually returned within 24 hours.
|
||
|
||
The cheapest way to ask questions or make suggestions is by mail.
|
||
Send inquiries or recommendations to:
|
||
|
||
Bowen Software
|
||
P. O. Box 2134
|
||
East Peoria, IL 61611
|
||
|
||
Registered and commercial users are provided free technical support
|
||
on the phone for at least six months. No support is guaranteed for
|
||
non-registered users, but we are happy to answer questions about our
|
||
products and consulting services. Bowen Software can be reached at
|
||
(309) 699-0950. Registered users will be asked for their serial
|
||
number.
|
||
|
||
Also, if you are having problems, be prepared to describe the
|
||
hardware and operating system you are using as well as the
|
||
CONFIG.SYS and AUTOEXEC.BAT files.
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 8
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
1.8 Trademark Acknowledgements
|
||
|
||
Association of Shareware Professionals and the ASP Logo are
|
||
trademarks of the Association of Shareware Professionals.
|
||
CLIPPER is a trademark of Nantucket Corporation.
|
||
COMPAQ is a registered trademark of COMPAQ Computers, Inc.
|
||
dBASE and dBASE III are registered trademarks of Ashton Tate, Inc.
|
||
dBASE III Plus and dBASE IV are trademarks of Ashton Tate, Inc.
|
||
dBXL and Quicksilver are trademarks of Wordtech Systems, Inc.
|
||
Desqview and QEMM are trademarks of Quarterdeck Office Systems.
|
||
FoxBASE+ is a registered trademark of Fox Software, Inc.
|
||
FoxPro is a trademark of Fox Software, Inc.
|
||
PC-FILE is a registered trademark of Buttonware, Inc.
|
||
PopDBF is a trademark of Bowen Software.
|
||
Sidekick is a trademark of Borland International, Inc.
|
||
|
||
Other product names mentioned in this document may be trademarks or
|
||
registered trademarks of their respective companies.
|
||
|
||
|
||
1.9 License Agreement, Disclaimer and Warranty
|
||
|
||
BY INSTALLING PopDBF ON YOUR SYSTEM YOU INDICATE YOUR AGREEMENT TO
|
||
THE FOLLOWING TERMS AND CONDITIONS. IF YOU DO NOT AGREE TO THEM YOU
|
||
ARE NOT ALLOWED TO USE THIS PROGRAM.
|
||
|
||
PopDBF, its documentation and supplementary files and programs are
|
||
Copyright (c) 1989-91 Bowen Software. All rights reserved world
|
||
wide.
|
||
|
||
PopDBF is not now, nor was it ever, public domain or free software.
|
||
PopDBF is currently available in shareware and commercial versions.
|
||
|
||
1.9.1 Shareware Version License
|
||
|
||
The Shareware evaluation (trial use) version is provided AS IS.
|
||
Bowen Software MAKES NO WARRANTY OF ANY KIND, EXPRESSED OR IMPLIED,
|
||
INCLUDING WITHOUT LIMITATION, ANY WARRANTIES OF MERCHANTABILITY
|
||
AND/OR FITNESS FOR A PARTICULAR PURPOSE.
|
||
|
||
You are granted a limited license to use PopDBF for evaluation
|
||
purposes for a period not to exceed sixty (60) days. If you
|
||
continue to use PopDBF after the sixty (60) day evaluation period,
|
||
you must make a registration payment of $35US to Bowen Software.
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 9
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Introduction
|
||
|
||
|
||
Failure to make this payment after the evaluation period is
|
||
considered to violate this license.
|
||
|
||
|
||
1.9.2 Registered Version License
|
||
|
||
If you are a registered user of PopDBF, you may use the registered
|
||
version on one computer at a time and make copies for backup (for
|
||
your own use ONLY) as needed.
|
||
|
||
You may not distribute the registered version of PopDBF to any other
|
||
person via any form of media.
|
||
|
||
|
||
1.9.3 Warranty
|
||
|
||
This software is provided "as is" without any warranty of any kind,
|
||
either expressed or implied, including, but not limited to, the
|
||
implied warranties of merchantability and fitness for a particular
|
||
purpose. The entire risk as to the quality and performance of the
|
||
software is with you. Should the software prove defective, the
|
||
user, NOT Bowen Software, assumes the entire cost of all necessary
|
||
servicing, repair or correction.
|
||
|
||
In no event shall Bowen Software be liable to the user for any
|
||
damages, including lost profits, lost savings or other incidental or
|
||
consequential damages arising out of the use or inability to use
|
||
this software, even if Bowen Software has been advised of the
|
||
possibility of such damages, or for any claim by any other party.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 10
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
2 Getting Started
|
||
|
||
2.1 Installing PopDBF
|
||
|
||
To load the PopDBF and its associated programs and files on your
|
||
hard disk, you use the installation program called INSTALL.EXE. To
|
||
run the installation program, do the following:
|
||
|
||
1. Place the PopDBF diskette in drive A:
|
||
|
||
2. Type A:INSTALL and press ENTER.
|
||
(If you are using drive B, substitute B: for A: above)
|
||
|
||
3. Make sure that the name of the installation directory is
|
||
correct and press ENTER. The installation directory is
|
||
where the PopDBF files will be copied. If the directory
|
||
you specify does not exist, it will be created.
|
||
|
||
4. You will see the names of each of the files as it is being
|
||
copied to the destination directory. When all the files
|
||
have been copied, the message "press any key..." will be
|
||
displayed in the lower left corner of the screen. Press
|
||
any key and you will be returned to DOS and will be in the
|
||
directory you specified as the installation directory.
|
||
|
||
NOTE: When PopDBF is executed it assumes that POPDBF.HLP, the
|
||
context sensitive help file, is in the same directory as
|
||
POPDBF.EXE. If POPDBF.HLP is not in that directory,
|
||
context sensitive help will not be available. See "Help"
|
||
on page 21.
|
||
|
||
2.2 Executing PopDBF
|
||
|
||
PopDBF can be run in two modes. Normally, when PopDBF is executed
|
||
it installs itself into memory for access from anywhere by pressing
|
||
its hotkey. Alternatively, you can run PopDBF in non-resident
|
||
"pass-thru" mode like any other DOS program.
|
||
|
||
2.2.1 Running PopDBF in Memory Resident Mode
|
||
|
||
To run PopDBF in memory resident mode, just type POPDBF at the DOS
|
||
prompt and press ENTER. It is in this mode that PopDBF can become
|
||
an invaluable tool. Once loaded into memory, pressing the hotkey
|
||
(the default hotkey is Alt-BackSpace) will give you "instant access"
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 11
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
to your X-Base files! See "Command Line Options" on page 13 for a
|
||
list of configuration options.
|
||
|
||
PopDBF does not need to be the last memory resident program.
|
||
However, it can NOT be uninstalled from memory if it is not the last
|
||
memory resident program or if another memory resident program has
|
||
recaptured one of PopDBF's interrupts.
|
||
|
||
When PopDBF is installed in memory it requires only 4K of RAM!
|
||
|
||
If the /SN command line option is used to prevent swapping to disk
|
||
or EMS, PopDBF will require around 45K of RAM. This may be a
|
||
desirable mode if no EMS is available, the local hard disk is very
|
||
slow and most of the lower 640K of RAM is available for application
|
||
programs.
|
||
|
||
|
||
2.2.2 Running PopDBF in Non-Resident Mode
|
||
|
||
The second mode of operation is to run PopDBF in "Pass-Thru" mode.
|
||
In "Pass-Thru" mode, PopDBF works like most other programs. To do
|
||
this type POPDBF /p at the DOS prompt and press ENTER.
|
||
|
||
In this mode the hotkey is ignored. To exit PopDBF in this mode
|
||
press the ESCAPE key until you return to the DOS prompt.
|
||
|
||
When using this mode, the Ctrl-P paste key in Edit mode is disabled.
|
||
|
||
Memory consumption in "Pass-Thru" mode depends on command line
|
||
options, but will default to using 45K of RAM.
|
||
|
||
|
||
2.3 Modifying AUTOEXEC.BAT to Load PopDBF
|
||
|
||
To have PopDBF load each time you start your computer, add the
|
||
following line to your AUTOEXEC.BAT file:
|
||
|
||
.
|
||
[path\]POPDBF [options] <load PopDBF into memory>
|
||
.
|
||
|
||
If the optional path is not specified, POPDBF.EXE must either be in
|
||
the current directory or in the PATH.
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 12
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
For help on which options to use when loading PopDBF see "Command
|
||
Line Options" on page 13.
|
||
|
||
|
||
2.4 Removing PopDBF from Memory
|
||
|
||
To remove PopDBF from memory use the /U command line option by
|
||
typing the following at the DOS prompt:
|
||
|
||
POPDBF /U
|
||
|
||
PopDBF must be the last memory resident program or you will receive
|
||
an error message indicating that PopDBF was unable to unload. See
|
||
/U under "Command Line Options" below for further information on
|
||
this option.
|
||
|
||
|
||
2.5 How to Invoke PopDBF (Using the "Hotkey")
|
||
|
||
By default the hotkey to invoke PopDBF is Alt-BackSpace. To invoke
|
||
PopDBF, press and hold the Alt key and at the same time press the
|
||
BackSpace key.
|
||
|
||
As soon as you press the hotkey, PopDBF will "pop" onto the screen.
|
||
Pressing the hotkey again will take you right back to the
|
||
interrupted program. You can pop out of PopDBF from anywhere in
|
||
PopDBF, except a few places when you are being prompted for
|
||
information. At those times, pressing the hotkey will abort that
|
||
action just as if you had pressed ESCAPE.
|
||
|
||
When you press the hotkey to leave PopDBF, any open database is
|
||
automatically closed. Pressing the hotkey again will return you to
|
||
the same location in PopDBF with the file being opened automatically
|
||
as if it had never been closed. You can even pop out and back in
|
||
while in the middle of using Edit or Append!
|
||
|
||
2.6 Command Line Options
|
||
|
||
To load or execute PopDBF type the following at the DOS prompt:
|
||
|
||
PopDBF [options], where options can be:
|
||
|
||
/A<A|B|E|S> Default action, where:
|
||
|
||
A>ppend <B>rowse E>dit S>tructure
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 13
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
The default is to open databases in Browse mode. To
|
||
load PopDBF so that databases are opened in Edit
|
||
mode, use the following command line:
|
||
|
||
POPDBF /AE
|
||
|
||
/C<C|M|O> Color scheme, where:
|
||
|
||
M>ononchrome O>riginal
|
||
|
||
The original colors option is provided for those
|
||
people who liked the colors used in versions of
|
||
PopDBF before 3.7.
|
||
|
||
To load or run PopDBF so that monochrome colors are
|
||
displayed, use the following command line:
|
||
|
||
POPDBF /CM
|
||
|
||
/D<dir> Initial PopDBF Directory
|
||
|
||
The format of <dir> is [d:\]path, where d: is the
|
||
optional disk drive identifier.
|
||
|
||
The initial PopDBF directory is set to the current
|
||
DOS directory the first time PopDBF invoked, if this
|
||
option is not specified.
|
||
|
||
The PopDBF directory changes only when a move is made
|
||
from within PopDBF. Each time PopDBF is invoked, the
|
||
current DOS directory is saved and the PopDBF
|
||
directory becomes the current directory. When
|
||
leaving PopDBF the DOS directory is restored. See
|
||
also "Move to Current DOS Directory" on page 28.
|
||
|
||
To load or run PopDBF so that the starting directory
|
||
is C:\DBASE, use the following command line:
|
||
|
||
POPDBF /DC:\DBASE
|
||
|
||
/E<size> Edit buffer of size bytes (default = 512)
|
||
|
||
If a file has a record size larger than the edit
|
||
buffer size, you will not be allowed to Edit or
|
||
Append. Should this occur an error message will be
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 14
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
displayed. To determine the minimum size that you
|
||
will need to specify to allow Editing on the file,
|
||
press Alt-S to view the record size.
|
||
|
||
To load or run PopDBF so that you can Edit a record
|
||
1024 bytes long, use the following command line:
|
||
|
||
POPDBF /E1024
|
||
|
||
/F<num> Maximum of num fields (default = 64, max = 1024)
|
||
|
||
The default value should handle most needs, however
|
||
Clipper databases can have up to 1024 fields.
|
||
|
||
Should you try to Browse or Edit a database with too
|
||
many fields, an error message will be displayed. To
|
||
determine the minimum number of fields you will need
|
||
to specify to allow Browsing or Editing the file,
|
||
press Alt-S to view the number of fields.
|
||
|
||
To load or run PopDBF so that you can Browse or Edit
|
||
a file with 95 fields, use the following command
|
||
line:
|
||
|
||
POPDBF /F95
|
||
|
||
/G<num> Maximum of num files (default = 100, min = 3)
|
||
|
||
The default value should handle most directories,
|
||
unless the file specification is changed to *.*.
|
||
Files matching the file specification are loaded
|
||
first, then any sub-directories in the current
|
||
directory.
|
||
|
||
If too many files are found, you will be notified by
|
||
an error message that the /G option should be used to
|
||
correct the problem. Just press any key to respond
|
||
to the error. Only the specified number of files
|
||
will be displayed.
|
||
|
||
To load or run PopDBF so that 200 files can be
|
||
displayed in the Pick File window, use the following
|
||
command line:
|
||
|
||
POPDBF /G200
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 15
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
/H Command line syntax and options
|
||
|
||
This will list all of PopDBF's command line options.
|
||
You can also specify a single question mark (?).
|
||
|
||
/I Ignore hotkey, toggles on and off
|
||
|
||
To use this option, run PopDBF from the DOS prompt
|
||
with this option. This can be used if for some
|
||
reason you want to disable the PopDBF hotkey
|
||
temporarily. To reactivate the hotkey run PopDBF
|
||
using this option again.
|
||
|
||
/L<dir> Directory where master .FRQ file is located
|
||
|
||
Normally, the frequent database access list file is
|
||
located in the same directory as the PopDBF
|
||
executable. However, when PopDBF is loaded from a
|
||
Network drive, users will probably want to specify a
|
||
local drive and directory where their personal
|
||
frequent database access list file is located using
|
||
this option.
|
||
|
||
To load or run PopDBF and specify that the master
|
||
.FRQ file is located in F:\PUBLIC, use the following
|
||
command line:
|
||
|
||
POPDBF /LF:\PUBLIC
|
||
|
||
/[!]P[file] Use "Pass-Thru" non-resident mode
|
||
|
||
This option will NOT load PopDBF into memory, but
|
||
will execute it and allow you to use all of its
|
||
features.
|
||
|
||
If a file is also specified (no brackets are
|
||
necessary), PopDBF will automatically come up in that
|
||
file in Browse, unless the /A option is used to
|
||
specify a different action.
|
||
|
||
Pass-Thru mode is indicated on the screen by the word
|
||
"PASSTHRU" in the upper left-hand corner. The /P
|
||
option can also be used even if PopDBF is already in
|
||
memory without affecting the resident version.
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 16
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
Pressing the PopDBF hotkey will cause the resident
|
||
version to pop up over the Pass-Thru version.
|
||
|
||
Preceding the P with an exclamation point (!) will
|
||
cause PopDBF to exit when ESCAPE is pressed from
|
||
Append, Browse, Edit, or Setup. This is a nice
|
||
feature to use from batch files, so that users only
|
||
have to press ESCAPE once to exit PopDBF.
|
||
|
||
To run PopDBF in "Pass-Thru" mode and automatically
|
||
open C:\DBASE\ROLODEX in Edit mode, use the following
|
||
command line:
|
||
|
||
POPDBF /AE /PC:\DBASE\ROLODEX
|
||
|
||
/R<size> Read buffer of size bytes (default = 4096)
|
||
|
||
If a file's record size is larger than the read
|
||
buffer size, you will not be allowed to Browse the
|
||
file.
|
||
|
||
The larger the read buffer the faster scrolling and
|
||
finding will be done when in Browse and Edit.
|
||
|
||
Specifying a larger read buffer will not affect
|
||
memory consumption unless PopDBF is run using the /SN
|
||
option to prevent swapping.
|
||
|
||
To load or run PopDBF using a 16K read buffer, use
|
||
the following command line:
|
||
|
||
POPDBF /R16184
|
||
|
||
/S<D|E|N> Swap to Disk|EMS|None
|
||
|
||
D for Disk swap, E for EMS swap, N for No swap.
|
||
|
||
If this option is not specified, swapping to EMS will
|
||
be attempted first and swapping to Disk will be
|
||
attempted second. If both fail, no swapping will be
|
||
done.
|
||
|
||
If Disk swapping is done, it can be helpful to use
|
||
the /X option to specify that the swap file be
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 17
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
located on a RAM drive or a Network drive. This can
|
||
greatly decrease swap time.
|
||
|
||
To load PopDBF so that it does disk swapping to a RAM
|
||
drive E: and a swap file name called POPDBF.SWP in
|
||
the root directory, use the following command line:
|
||
|
||
POPDBF /SD /XE:\POPDBF.SWP
|
||
|
||
To load PopDBF so that it does NOT swap to disk or
|
||
EMS and resided entirely in memory, use the following
|
||
command line:
|
||
|
||
POPDBF /SN
|
||
|
||
/T<B,C,I,V,W,Z>
|
||
Toggle indicator defaults
|
||
|
||
Any or all of the toggle indicator letters may be
|
||
specified to override the defaults. The letters and
|
||
the toggle indicator they modify are discussed below.
|
||
The /W option should be specified as /TW. However,
|
||
it will still function to provide backward
|
||
compatibility.
|
||
|
||
B - Borders for fields ON
|
||
|
||
Specifying this option forces all finds to be
|
||
successful only if WITHIN field borders.
|
||
|
||
C - Case sensitive
|
||
|
||
Specifying this option forces all finds to be
|
||
sensitive to upper and lower case letters.
|
||
|
||
I - Insert mode
|
||
|
||
When insert mode is on and you are entering
|
||
information or editing a record, characters to the
|
||
right will move to the right as you enter data.
|
||
|
||
V - Verify mode in Edit
|
||
|
||
When verify mode is on you will be required to press
|
||
ENTER in Edit to move to the next field. When verify
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 18
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
mode is on a "V" is displayed in the upper right
|
||
border of the Edit window.
|
||
|
||
W - Write file access
|
||
|
||
Specifying this option will cause each database to be
|
||
opened with read-write access.
|
||
|
||
Z - Zoom the Browse window
|
||
|
||
By default the Browse window shows only 12 records.
|
||
When zoomed it will show 18 records. See also "Zoom
|
||
Browse Window" on page 33.
|
||
|
||
For more information on toggle indicators, see "Alt
|
||
Toggle Keys" on page 23.
|
||
|
||
To load or run PopDBF so that read-write mode is on
|
||
and finds are done with case sensitivity, use the
|
||
following command line:
|
||
|
||
POPDBF /TCW (you can combine options)
|
||
|
||
/U Uninstall (remove) from memory
|
||
|
||
This will remove PopDBF from memory, but ONLY if it
|
||
is the last memory resident program.
|
||
|
||
In some special cases, even when PopDBF is the last
|
||
memory resident program it can't be removed from
|
||
memory. This occurs if another resident program
|
||
recaptures one of the interrupt vectors after PopDBF
|
||
has chained into it. Sidekick is an example of this
|
||
type of program.
|
||
|
||
/X<file> File name for swapping to Disk
|
||
|
||
If PopDBF swaps to Disk, it can be very beneficial to
|
||
use this option to direct the swap file to a RAM
|
||
drive or Network drive (if faster than local hard
|
||
disk). This can greatly decrease the swap time. The
|
||
default is POPDBF.SWP in the root directory on the
|
||
current drive.
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 19
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Getting Started
|
||
|
||
|
||
/Y<file> Initial PopDBF File
|
||
|
||
This is very similar to the Pass-Thru option, but is
|
||
used for memory resident mode. This is the file that
|
||
will be opened when PopDBF is first activated. It is
|
||
an especially nice feature to use for people who
|
||
usually access one file.
|
||
|
||
To load PopDBF so that the first time it is popped up
|
||
it opens C:\DBASE\ROLODEX in Edit mode with read-
|
||
write mode on, use the following command line:
|
||
|
||
POPDBF /AE /TW /YC:\DBASE\ROLODEX
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 20
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Help
|
||
|
||
|
||
3 Help
|
||
|
||
Help is available in PopDBF only if the file POPDBF.HLP is in the
|
||
same directory as POPDBF.EXE, the main program.
|
||
|
||
While in Help you can press the up and down arrow keys as well as
|
||
PgUp and PgDn to scroll the help text. To get out of Help, press
|
||
ESCAPE.
|
||
|
||
|
||
3.1 Generic Help (Alt-F1)
|
||
|
||
You can get generic help about the system by pressing Alt-F1 from
|
||
any area of the program.
|
||
|
||
The generic help explains the Alt Action and Toggle Keys and the
|
||
toggle indicators. See "Alt Menu" on page 22. It also explains
|
||
cursor and lite-bar movement.
|
||
|
||
|
||
3.2 Context Sensitive Help (F1)
|
||
|
||
Pressing F1 will provide specific help for any area of PopDBF. The
|
||
help provided is basically the same text found in this manual and in
|
||
some cases is even more thorough.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 21
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Alt Menu
|
||
|
||
|
||
4 Alt Menu (Alt)
|
||
|
||
Pressing the Alt key will show the Alt menu on the status line.
|
||
Releasing the Alt key will restore the previous status line. The Alt
|
||
menu is divided into two parts, "Action Keys" and "Toggle Keys".
|
||
Pressing Alt and one of the highlighted Action Keys will cause the
|
||
appropriate action to occur. Pressing Alt and one of the
|
||
highlighted Toggle Keys will toggle the appropriate indicator in the
|
||
indicator window located in the lower left border of the main
|
||
window.
|
||
|
||
4.1 Alt Action Keys
|
||
Alt Action Keys will have no effect when responding to an error, a
|
||
prompt, or inside of Help. They also have no effect while
|
||
positioned on a directory in the Pick File window.
|
||
|
||
The Alt Action Keys are:
|
||
|
||
Alt-A Append records in the current database. Ignored if
|
||
file access mode is read-only.
|
||
|
||
Alt-B Browse records in the current database. If pressed
|
||
while in Edit or Append is the same as pressing
|
||
ESCAPE to abort. See "Abort and Lose Changes" on
|
||
page 40.
|
||
|
||
Alt-E Edit records in the current database. If the file
|
||
access mode is read-only, Edit acts as a full screen
|
||
record viewer.
|
||
|
||
Alt-P Pick a different database or directory. If pressed
|
||
while in Edit or Append is the same as pressing
|
||
ESCAPE to abort.
|
||
|
||
Alt-S Setup View of current database. If pressed while in
|
||
Edit or Append is the same as pressing ESCAPE to
|
||
abort.
|
||
|
||
There are potentially 12 other Alt Action keys. These keys are used
|
||
to access frequently used databases. For more information on
|
||
Frequent Database Access keys, see FREQUENT DATABASE ACCESS on page
|
||
28.
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 22
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Alt Menu
|
||
|
||
|
||
4.2 Alt Toggle Keys
|
||
Alt Toggle Keys will function regardless of where you are in the
|
||
program.
|
||
|
||
The Alt Toggle Keys are:
|
||
|
||
Alt-C Toggles the case sensitivity indicator between "IC",
|
||
ignore case, and "CS", case sensitive. This
|
||
indicator affects how the Find function does its
|
||
search. See "Find Text" on page 34.
|
||
|
||
Alt-D Toggles the field border indicator between "NB", no
|
||
borders, and "BO", borders on. This indicator also
|
||
affects how the Find function behaves.
|
||
|
||
Alt-I Toggles the insert/overstrike indicator between "IN",
|
||
insert mode, and "OV", overstrike mode. This
|
||
indicator affects how text is placed into fields in
|
||
Edit. It can also be toggled by pressing Insert.
|
||
|
||
Alt-M Toggles the file access mode indicator between "RO",
|
||
read-only mode, and "RW", read-write mode. When the
|
||
file access mode is read-only, you will not be
|
||
allowed to Edit or Append.
|
||
|
||
On a NETWORK read-write mode will open files for
|
||
EXCLUSIVE access. Read-only will open files so that
|
||
multiple users can have access. Record level locking
|
||
is not currently implemented.
|
||
|
||
If opening a file in read-write mode fails, an
|
||
attempt to open the file in read-only mode will
|
||
automatically be made. If successful, when the file
|
||
is closed, the mode will automatically return to
|
||
read-write.
|
||
|
||
Alt-F5 Toggle viewing underlying application screen. This
|
||
avoids having to swap out and back.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 23
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Alt Menu
|
||
|
||
|
||
4.3 Toggle Indicator Summary
|
||
|
||
The default values for the toggle indicators are given below.
|
||
|
||
--| RW IC BO OV |--
|
||
| | | |
|
||
| | | -- IN/OV: edit mode is insert/overstrike
|
||
| | ----- BO/NB: field borders are on/off
|
||
| -------- IC/CS: case sensitivity is off/on
|
||
----------- RO/RW: file access mode is read-only/read/write
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 24
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Alt Menu
|
||
|
||
|
||
5 Cursor and Lite-Bar Movement
|
||
|
||
UpArrow/DownArrow Move up or down one entry or line
|
||
Ctrl-UpArrow/Home First entry or line in current window
|
||
Ctrl-DownArrow/End Last entry or line in current window
|
||
PgUp Move up one "screen"
|
||
PgDn Move down one "screen"
|
||
Ctrl-PgUp Move to first entry or record
|
||
Ctrl-PgDn Move to last entry or record
|
||
|
||
|
||
5.1 The "Wordstar" Diamond
|
||
|
||
Many of the basic Wordstar control key combinations have been
|
||
implemented to maintain some compatibility with other programs.
|
||
These keystrokes are found in many of the editors users have become
|
||
familiar with.
|
||
|
||
Ctrl-Q Abort
|
||
Ctrl-E Move up one entry or line (like UpArrow)
|
||
Ctrl-R Move up one page or screen (like PgUp)
|
||
Ctrl-A Move one word to the left (like Ctrl-LeftArrow)
|
||
Ctrl-S Move one character or field to the left (like LeftArrow)
|
||
Ctrl-D Move one character or field to the right (like RightArrow)
|
||
Ctrl-F Move one word to the right (like Ctrl-RightArrow)
|
||
Ctrl-X Move down one entry or line (like DownArrow)
|
||
Ctrl-C Move down one page or screen (like PgDn)
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 25
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Pick File
|
||
|
||
|
||
6 Pick File (Alt-P)
|
||
|
||
Pressing any letter will move the lite-bar to the first file or
|
||
directory that begins with that letter. Successive presses of the
|
||
same letter will move to the next file or directory that begins with
|
||
that letter. If no file or directory begins with the letter
|
||
pressed, no movement will occur.
|
||
|
||
|
||
6.1 Select Directory/File/Index (Enter)
|
||
|
||
Pressing ENTER will cause one of the following to occur:
|
||
|
||
* If the file is a directory, you will move to that
|
||
directory. Once in that directory the Pick File window is
|
||
refreshed with the names of files that match the file
|
||
specification.
|
||
|
||
* If the file is a database, the action taken corresponds to
|
||
the currently specified Action letter. This can be
|
||
changed by pressing F5 (see "Change Default Action" on
|
||
page 27). It is the same as pressing Alt-<action letter>.
|
||
|
||
* If the file is an index (.NDX, .IDX, .NTX only), you will
|
||
view the index expression used to create it. You can
|
||
press Ctrl-I to change the file specification to show only
|
||
index files. Pressing Ctrl-B will change the file
|
||
specification back to show only database files.
|
||
|
||
|
||
6.2 Move to Parent Directory (BackSpace)
|
||
|
||
Pressing BackSpace will take you to the parent of the current
|
||
directory, unless you are currently in the root directory. This
|
||
feature is especially useful on a network, where no parent directory
|
||
will be shown in the Pick File window, but the function still works.
|
||
The lite bar will be positioned on the name of the directory you
|
||
came from.
|
||
|
||
|
||
6.3 Change Directory and/or Drive (F2)
|
||
|
||
Pressing F2 will allow you to change the current PopDBF directory
|
||
and/or drive. The name supplied can be a drive letter followed by a
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 26
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Pick File
|
||
|
||
|
||
colon (C:), a directory path (\DBASE\PAYROLL), or both
|
||
(C:\DBASE\PAYROLL).
|
||
|
||
If the new directory is invalid, an error message will be displayed.
|
||
If it is valid the file selection window will be filled with files
|
||
matching the current file specification.
|
||
|
||
|
||
6.4 Enter A Specific File (F3)
|
||
|
||
Pressing F3 will allow you to enter a specific file name. If the
|
||
file is not found or is not a valid database or index, an error
|
||
message will be displayed. If no extension is entered, the
|
||
extension in the file specification will be used. This will cause
|
||
an error if that extension contains a wildcard (*/?) and you will
|
||
need to enter the file extension as well.
|
||
|
||
|
||
6.5 Change File Specification (F4)
|
||
|
||
Pressing F4 will allow you to modify the file specification located
|
||
in the upper right corner of the main window. The file
|
||
specification is used to determine which files in the current PopDBF
|
||
directory you are allowed to pick from. Entering a file
|
||
specification of *.* will allow you to pick from all files, while
|
||
*.DBF will allow only files with an extension of .DBF.
|
||
|
||
The names of any sub-directories in the current PopDBF directory are
|
||
included for possible selection regardless of the file
|
||
specification.
|
||
|
||
|
||
6.6 Change Default Action (F5)
|
||
|
||
The current default action is displayed in the upper left portion of
|
||
the file selection window. The default action determines what
|
||
happens when you press Enter and the selection bar is on a valid
|
||
database file. Each press of F5 will change the action as follows:
|
||
|
||
Append -> Browse -> Edit -> Setup -> Append, etc.
|
||
|
||
The result is the same as holding the Alt key and pressing the first
|
||
letter of the appropriate action. You can override the default
|
||
action by holding the Alt key and pressing a different action key
|
||
while the lite bar is positioned on the desired database.
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 27
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Pick File
|
||
|
||
|
||
|
||
6.7 Delete File (F6)
|
||
|
||
Pressing F6 will allow you to delete a file. You will be asked to
|
||
verify that you really want to delete the file. If you answer with
|
||
a Y for yes, the file will be deleted. Pressing ESCAPE or N for no,
|
||
will cancel the delete.
|
||
|
||
When the lite bar is on a directory, this function is ignored.
|
||
|
||
|
||
6.8 Move to Current DOS Drive & Directory (F10)
|
||
|
||
Pressing F10 will move you to the current DOS directory. The
|
||
current DOS directory is the directory you were in before the PopDBF
|
||
hotkey was pressed or when you loaded PopDBF. If that directory is
|
||
on a drive other than the current drive, that drive becomes the
|
||
current drive as well.
|
||
|
||
This is a handy function to use when you want to move from wherever
|
||
you were using PopDBF last to the directory where you are currently.
|
||
|
||
|
||
6.9 Frequent Database Access (Alt-1 thru Alt-=)
|
||
|
||
To use this feature you must have already created an ASCII file
|
||
named POPDBF.FRQ containing the names of up to 12 frequently used
|
||
databases. Multiple POPDBF.FRQ files can exist. PopDBF will look
|
||
first in the current directory and then in the directory from which
|
||
it was executed, unless the /L option was specified on the command
|
||
line.
|
||
|
||
Each database name can include a drive identifier and path. It MUST
|
||
include file name and extension. Optionally, each file can be
|
||
preceded by an action letter and a space. See "Change Default
|
||
Action" on page 27 for more information on action letters.
|
||
|
||
Pressing Alt-1 will access the database whose name is on the first
|
||
line of this file, Alt-2 will access the second, and so on. If more
|
||
than 12 lines are included POPDBF.FRQ they are ignored.
|
||
|
||
Examples of lines in POPDBF.FRQ:
|
||
|
||
C:\ME\DBF\ROLODEX.DBF (use default action)
|
||
E C:\PERSONAL\MILEAGE.DBF (open database in Edit mode)
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 28
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Pick File
|
||
|
||
|
||
A MILEAGE.DBF (open database in Append mode)
|
||
|
||
Using this feature while in the middle of Edit or Append, will save
|
||
any current changes.
|
||
|
||
The mode and current record number is maintained on each frequently
|
||
accessed database. If you press Alt-1, then go off and use other
|
||
files and press Alt-1 again you will be returned to the same mode
|
||
and positioned at the same record. This is very handy for toggling
|
||
between any of the 12 possible frequent databases.
|
||
|
||
|
||
6.10 Show Names of Frequently Accessed Databases (Ctrl-N)
|
||
|
||
Pressing Ctrl-N will pop up a window to show the names of the files
|
||
in the current frequent database access file. Each name will be
|
||
preceded by an action letter, if it was specified. Currently, you
|
||
can not change these names from within PopDBF.
|
||
|
||
|
||
6.11 Program Information
|
||
|
||
Pressing Ctrl-H will pop up a window to show you the version of the
|
||
context sensitive help file, along with other information on PopDBF
|
||
and Bowen Software.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 29
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Setup View
|
||
|
||
|
||
7 Setup View (Alt-S)
|
||
|
||
Setup View can be used to create a customized view of the currently
|
||
opened database. You can select only the fields you want to view in
|
||
Browse or Edit. You can even order the fields differently than they
|
||
are physically laid out in the database. This ordering (as
|
||
described below) is not permanent.
|
||
|
||
Pressing any letter will move the lite-bar to the first field that
|
||
begins with that letter. Successive presses of the same letter will
|
||
move to the next field that begins with that letter. If no field
|
||
begins with the letter pressed, no movement will occur.
|
||
|
||
|
||
7.1 Return To Data (Enter)
|
||
|
||
Pressing ENTER will return you to either Browse or Edit/Append,
|
||
depending on which you were in last. This makes changing the Setup
|
||
View (by pressing Alt-S) and returning to data (Browse or Edit) a
|
||
little easier.
|
||
|
||
|
||
7.2 Number/Un-Number Fields (Space)
|
||
|
||
Pressing the SPACE bar will number/un-number the field at the
|
||
selection bar. If any fields are numbered, only those fields will
|
||
be shown when you Browse or Edit records. The number beside the
|
||
field determines the order in which it will be displayed. Two
|
||
fields with the same number will remain in the same relative
|
||
position to each other.
|
||
|
||
Pressing SPACE will automatically move the selection bar down to the
|
||
next field, unless it is on the last field.
|
||
|
||
|
||
7.3 Clear Field Numbers (F2)
|
||
|
||
Pressing F2 will clear all field numbers, but leave the file
|
||
structure in the present order. This means that you can assign
|
||
field numbers, press F4 to order the fields, and then remove all
|
||
field numbers by pressing F2. This will allow you to view all
|
||
fields but in an order different from the original. Field numbers
|
||
are also cleared when a new file is selected from the Pick File
|
||
window.
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 30
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Setup View
|
||
|
||
|
||
7.4 Assign a Specific Field Number (F3)
|
||
|
||
Pressing F3 will allow you to assign a specific number (0-1024) to a
|
||
field to affect its order. Assigning a zero will un-number the
|
||
field.
|
||
|
||
|
||
7.5 Order Fields Using Field Numbers (F4)
|
||
|
||
Pressing F4 will reorder the fields in the structure based on their
|
||
field numbers. THIS NEW ORDER IS NOT PERMANENT. The actual
|
||
structure of the file on disk is NOT affected. To restore the
|
||
original field order either return to the Pick File window and re-
|
||
select the file or clear all field numbers by pressing F2 and press
|
||
F4 again.
|
||
|
||
|
||
7.6 Tag/Un-Tag Field for Exclusive Find (F6)
|
||
|
||
Pressing F6 will tag/un-tag the field at the selection bar for
|
||
exclusive find. When any fields are tagged for exclusive find, only
|
||
those fields are used when doing a Find or Find Next from Browse or
|
||
Edit. Also, if the field border indicator is on (see "Toggle
|
||
Indicators Summary" on page 24), the text being searched for MUST be
|
||
found entirely within ONE field. For more information see "Find
|
||
Text" on page 34.
|
||
|
||
Pressing F6 will automatically move the selection bar down to the
|
||
next field, unless it is on the last field.
|
||
|
||
|
||
7.7 Clear Exclusive Find Tags (F7)
|
||
|
||
Pressing F7 will turn off the exclusive find indicator for all
|
||
fields.
|
||
|
||
This will allow Find and Find Next to locate text anywhere in the
|
||
record, unless field borders are on, in which case it must be
|
||
entirely within ONE field. Exclusive find tags are also cleared
|
||
when a new file is selected from the Pick File window.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 31
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Setup View
|
||
|
||
|
||
7.8 Copy File Structure (F8)
|
||
|
||
Pressing F8 will allow you to copy the current database file
|
||
structure to another file. You will be prompted for the new
|
||
database file name. Pressing ESCAPE will abort this function. If
|
||
any fields are marked, only those fields, and in their specified
|
||
order, will be copied.
|
||
|
||
If the specified file already exists, you will be asked if you want
|
||
to overwrite it. NO CHECK IS DONE TO INSURE THAT YOU DO NOT SPECIFY
|
||
THE SAME FILE YOU ARE CURRENTLY VIEWING.
|
||
|
||
|
||
7.9 Print the File Structure (F9)
|
||
|
||
Pressing F9 will print the file structure. If any fields are
|
||
numbered only those fields will be printed. The file statistics are
|
||
printed first followed by the field structure.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 32
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Browse Records
|
||
|
||
|
||
8 Browse Records (Alt-B)
|
||
|
||
|
||
8.1 Current Record and Delete Status
|
||
|
||
The current record number and delete status are displayed in the
|
||
bottom border of the Browse window. See below for directions on how
|
||
to delete a record.
|
||
|
||
|
||
8.2 Toggle Vertical Separator Bars On/Off (Shift-|)
|
||
|
||
Pressing Shift-| (pipe symbol) will toggle the vertical separator
|
||
bars on and off. The default is off. Viewing can be a little
|
||
easier with them on, but printing is best done with the separators
|
||
off.
|
||
|
||
|
||
8.3 Pan the Browse Window (LeftArrow/RightArrow)
|
||
|
||
The LeftArrow and RightArrow will allow you to pan to the left and
|
||
right, respectively.
|
||
|
||
|
||
8.4 View Large Fields (Tab/Shift-Tab)
|
||
|
||
Tab and Shift-Tab change the offset of fields that are wider than
|
||
the Browse window. The offset is incremented or decremented by 10
|
||
characters. The current offset is displayed in the upper right-hand
|
||
corner of the Browse window.
|
||
|
||
|
||
8.5 Zoom the Browse Window (F2)
|
||
|
||
Pressing F2 will either expand or contract the Browse window. When
|
||
expanded the window shows 18 records and when contracted shows only
|
||
12, but has the advantage of allowing you to see the file statistics
|
||
as well.
|
||
|
||
|
||
8.6 Goto a Specific Record (F3)
|
||
|
||
Pressing F3 will prompt you for a new record position. If the
|
||
record number specified is greater than the number of records in the
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 33
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Browse Records
|
||
|
||
|
||
file, an error will occur and the lite-bar will stay on the same
|
||
record.
|
||
|
||
|
||
8.7 Zap Database (F4)
|
||
|
||
Pressing F4 will Zap the current database. When a database is
|
||
zapped, all records are deleted AND physically removed. Because
|
||
this is potentially a dangerous function, you will be prompted to
|
||
make sure you really want to zap the database. Pressing ESCAPE or
|
||
entering N will abort. If the database is currently opened in read-
|
||
only (RO) mode, this function will cause an audible beep.
|
||
|
||
|
||
8.8 Pack Database (F5)
|
||
|
||
Pressing F5 will Pack the current database. When a file is packed,
|
||
all logically deleted records are physically removed. Because this
|
||
is potentially a dangerous function, you will be prompted to make
|
||
sure you really want to pack the database. Pressing ESCAPE or
|
||
entering N will abort. If the database is currently opened in read-
|
||
only (RO) mode, this function will cause an audible beep.
|
||
|
||
8.9 Find Text (F7)
|
||
|
||
Pressing F7 will prompt you for the text you want to locate.
|
||
Type in the text to find and press ENTER to begin the find.
|
||
|
||
Memo fields are not currently searched.
|
||
|
||
Date fields need to be searched as follows. If the date you are
|
||
looking for is 11/03/89 you would enter: "891103" or "19891103"
|
||
(don't enter the quotes).
|
||
|
||
When the case sensitivity indictor is off (IC) finding "don" will
|
||
locate records containing "Don", "DON", and other combinations. To
|
||
find only occurrences of "don", you must first turn on the case
|
||
sensitivity indicator (CS) by pressing Alt-C.
|
||
|
||
There may be times that you want to find text only if it occurs in a
|
||
specific field or fields, not just anywhere in the record. To do
|
||
this press Alt-S for the Setup View window. Now tag the fields you
|
||
want searched exclusively by pressing F6. When you have tagged the
|
||
fields to be searched, press ENTER to return to the Browse window.
|
||
Now Find will search only the fields you tagged.
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 34
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Browse Records
|
||
|
||
|
||
By default, Find will locate text even if it crosses field
|
||
boundaries. To prevent this you can turn on the field border
|
||
indicator by pressing Alt-D. When field borders are on (BO), text
|
||
must be found entirely within ONE field. Field borders are on by
|
||
default.
|
||
|
||
Find can also be used to locate deleted records. Do a find for "*"
|
||
and make sure that field borders are off (NB) and no fields have
|
||
been tagged for exclusive find. This will only work if an asterisk
|
||
is not actually found in one of the database fields.
|
||
|
||
Find always begins with the first record in the file. See "Find
|
||
Next Occurrence of Text" below to see how to start Find at the
|
||
current record.
|
||
|
||
If Find fails an audible beep will sound.
|
||
|
||
|
||
8.10 Find Next Occurrence of Text (F8)
|
||
|
||
Pressing F8 will do a Find Next. Find Next always begins with the
|
||
next record in the file.
|
||
|
||
To start a Find at the current record you can use Find Next. Press
|
||
F7 and enter the text to find and then press ESCAPE. This will
|
||
cause the find text window to disappear. Now press F8 and the
|
||
search will begin at the next record.
|
||
|
||
If Find Next fails an audible beep will sound.
|
||
|
||
|
||
8.11 Print Records (F9)
|
||
|
||
Pressing F9 prompts for print parameters and then prints the data.
|
||
The parameters you will be asked for are the starting record, ending
|
||
record, if only records matching the find text should be used, and
|
||
the width of the print line. Data is printed exactly as it is seen
|
||
in the Browse window, but more text may be printed if a longer print
|
||
width is specified (this is how you print the additional data to the
|
||
right of the Browse window).
|
||
|
||
Print can be used in conjunction with the find text string to print
|
||
only records that contain certain text. Find behaves here as
|
||
described above under "Find Text".
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 35
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Browse Records
|
||
|
||
|
||
The maximum print width is 250 characters.
|
||
|
||
|
||
8.12 Turn Century On/Off (Ctrl-K)
|
||
|
||
Pressing Ctrl-K will toggle the century on or off. When on, the
|
||
year of the date displays using four positions as in MM/DD/YYYY
|
||
(unless the date format was changed using the configuration program)
|
||
to show the century.
|
||
|
||
|
||
8.13 Mark Record as Deleted (Ctrl-U)
|
||
|
||
Pressing Ctrl-U will toggle the delete status of the current record.
|
||
The delete status of the current record is displayed in the bottom
|
||
border of the Browse (and Edit) window. See "Find Text" on page 34
|
||
for a tip on how to find deleted records.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 36
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Edit/Append Records
|
||
|
||
|
||
9 Edit/Append Records (Alt-E/Alt-A)
|
||
|
||
|
||
9.1 Copy a Record (F2)
|
||
|
||
Pressing F2 will prompt you for the number of the record you want to
|
||
copy into the current record. To append a duplicate of a current
|
||
record you must first go into Append by pressing Alt-A. Then press
|
||
F2 and specify the number of the record to copy. To complete the
|
||
operation, press PgDn.
|
||
|
||
Pressing Ctrl-F2 will also copy a record, but will use the last
|
||
record you specified to be copied instead of prompting you.
|
||
|
||
|
||
9.2 Goto a Specific Record (F3)
|
||
|
||
Pressing F3 works the same as it does in Browse. See "Goto a
|
||
Specific Record" on page 33.
|
||
|
||
|
||
9.3 Cut Field into Keyboard Paste Buffer (F4)
|
||
|
||
Pressing F4 will "cut" the current field into the keyboard paste
|
||
buffer for later pasting inside PopDBF (using Ctrl-P) or outside
|
||
PopDBF (using Ctrl-Alt-P). If data has been cut it will be
|
||
indicated by a "P" in the upper right border of the Edit window.
|
||
|
||
Trailing blanks are not cut. Each cut field is terminated by a user
|
||
selected key. The termination key is placed into the paste buffer
|
||
after the cut field, unless it is ESCAPE. If a comma (,) is
|
||
pressed, an additional space is placed in the paste buffer after it.
|
||
This is for use with City, State cuts, as well as Lastname,
|
||
Firstname cuts.
|
||
|
||
If there is not enough room to cut the current field, a beep will
|
||
sound indicating that the field was NOT placed into the buffer.
|
||
|
||
The entire contents of the keyboard paste buffer can be pasted
|
||
inside PopDBF using Ctrl-P or into an underlying application using
|
||
the paste hotkey Ctrl-Alt-P (the default). Data can be pasted
|
||
multiple times.
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 37
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Edit/Append Records
|
||
|
||
|
||
The keyboard paste buffer is cleared when a cut is made and the
|
||
previous paste buffer had been pasted at least once. It can also be
|
||
pasted by pressing Shift-F4.
|
||
|
||
|
||
9.4 Clear Keyboard Paste Buffer (Shift-F4)
|
||
|
||
Pressing Shift-F4 will clear the keyboard paste buffer.
|
||
|
||
If data has been cut into the keyboard paste buffer, it is indicated
|
||
by a "P" in the upper right border of the Edit window. Pressing
|
||
Shift-F4 will turn this indicator off.
|
||
|
||
|
||
9.5 Find Text (F7)
|
||
|
||
Pressing F7 works the same as it does in Browse. See "Find Text" on
|
||
page 34.
|
||
|
||
|
||
9.6 Find Next Occurrence of Text (F8)
|
||
|
||
Pressing F8 works the same as it does in Browse. See "Find Next
|
||
Occurrence of Text" on page 35.
|
||
|
||
|
||
9.7 Print Records (F9)
|
||
|
||
Pressing F9 will prompt you for the print parameters and then print
|
||
the data. Data is printed exactly as it appears in the Edit/Append
|
||
window. Blank fields product blank lines.
|
||
|
||
The extra lines parameter can be used to print labels even if the
|
||
data you are using doesn't fill up all the lines on the label. It
|
||
defaults to one to space between records (or labels).
|
||
|
||
Records requiring multiple pages of fields currently have to be
|
||
printed separately.
|
||
|
||
Print can be used in conjunction with the find text string to print
|
||
only records that contain certain text. Find behaves here as
|
||
described above.
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 38
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Edit/Append Records
|
||
|
||
|
||
9.8 Field Information (F10)
|
||
|
||
|
||
Pressing F10 will pop-up a window containing information about the
|
||
field in which the cursor is currently positioned. This can be
|
||
helpful if you forget the field type or want to know exactly how
|
||
long it is.
|
||
|
||
|
||
9.9 Restore Field Data (Ctrl-J)
|
||
|
||
Pressing Ctrl-J will restore the field's original data. Once you
|
||
have moved to another record any changes that were made become
|
||
permanent and can NOT be restored.
|
||
|
||
|
||
9.10 Turn Century On/Off (Ctrl-K)
|
||
|
||
Pressing Ctrl-K works the same as it does in Browse. See "Turn
|
||
Century On/Off" on page 36.
|
||
|
||
|
||
9.11 System Date (Ctrl-M)
|
||
|
||
Pressing Ctrl-M while in a date field will place the system date in
|
||
the field. It will only work in a character field if enough room
|
||
remains from the cursor to the end of the field. It will also
|
||
overwrite any existing data in the field at those positions.
|
||
|
||
|
||
9.12 Move to Last Field Position (Ctrl-N)
|
||
|
||
Pressing Ctrl-N will move the cursor to the last possible position
|
||
in a field.
|
||
|
||
|
||
9.13 Restore Entire Record (Ctrl-O)
|
||
|
||
Pressing Ctrl-O will restore the entire record's original data. See
|
||
"Restore Field Data" above for when changes in the current record
|
||
become permanent.
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 39
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Edit/Append Records
|
||
|
||
|
||
9.14 Paste Data (Ctrl-P)
|
||
|
||
Pressing Ctrl-P will paste any data currently in the Paste buffer.
|
||
If there is data to paste, a "P" will be displayed in the upper
|
||
right border of the Edit window.
|
||
|
||
This feature can be used to copy information from one part of a
|
||
record to another or from one record to another. You can even copy
|
||
data from a record in one database to a record in another database.
|
||
|
||
|
||
9.15 Abort and Lose Changes (Ctrl-Q/ESCAPE)
|
||
|
||
Pressing Ctrl-Q or ESCAPE will quit Edit and abort any changes made
|
||
to the current record will be lost. If any changes have been made
|
||
you will be asked if you want to lose the changes. Pressing ESCAPE
|
||
will abort and leave you in Edit. Pressing N will save the changes
|
||
and then exit, while pressing Y will exit and the changes will be
|
||
lost.
|
||
|
||
|
||
9.16 Mark Record as Deleted (Ctrl-U)
|
||
|
||
Pressing Ctrl-U will toggle the delete status of the current record.
|
||
The delete status of the current record is displayed in the bottom
|
||
border of the Edit (and Browse) window. See "Find Text" on page 34
|
||
for a tip on how to find deleted records.
|
||
|
||
|
||
9.17 Toggle Verify Mode On/Off (Ctrl-V)
|
||
|
||
Pressing Ctrl-V will toggle verify mode. When verify mode is on you
|
||
will be forced to press ENTER to move on to the next field. Verify
|
||
mode is indicated by a "V" in the upper right border of the Edit
|
||
window.
|
||
|
||
9.18 Quit and Save Changes (Ctrl-W/Ctrl-End)
|
||
|
||
Pressing Ctrl-W or Ctrl-End will quit Edit and save any changes made
|
||
to the current record.
|
||
|
||
|
||
9.19 Blank Current Field (Ctrl-Y)
|
||
|
||
Pressing Ctrl-Y will fill the current field with spaces.
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 40
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Edit/Append Records
|
||
|
||
|
||
|
||
9.20 Blank to End of Field (Ctrl-Delete)
|
||
|
||
Pressing Ctrl-Delete will delete from the current cursor position in
|
||
the current field to the end of the field.
|
||
|
||
|
||
9.21 Move to End of Data (End)
|
||
|
||
Pressing the End key will move the cursor to the first blank
|
||
position after any data entered in the current field. If the entire
|
||
field is full, the cursor will move to the last position.
|
||
|
||
|
||
9.22 Move to First Position (Home)
|
||
|
||
Pressing the Home key will move the cursor to the first position of
|
||
the current field.
|
||
|
||
|
||
9.23 Move Word (Ctrl-LeftArrow/Ctrl-RightArrow)
|
||
|
||
Pressing Ctrl-LeftArrow or Ctrl-RightArrow will move one word to the
|
||
left or right, respectively. You can also use the Wordstar commands
|
||
Ctrl-A and Ctrl-F to do the same functions.
|
||
|
||
|
||
9.24 Move to First/Last Field (Ctrl-UpArrow/Ctrl-DownArrow)
|
||
|
||
Pressing Ctrl-UpArrow and Ctrl-DownArrow will move to the first and
|
||
last field respectively, on the current screen.
|
||
|
||
|
||
9.25 Previous Record/Next Record, Same Page (Alt-PgUp/Alt-PgDn)
|
||
|
||
Pressing Alt-PgUp or Alt-PgDn will move to the previous or next
|
||
record, but stay on the same page. This is very helpful when a
|
||
database has more fields than will fit on one page.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 41
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Common Questions
|
||
|
||
10 Common Questions and Answers
|
||
|
||
10.1 How can I change the PopDBF hotkey?
|
||
|
||
You can change both the main PopDBF hotkey (defaults to Alt-
|
||
Backspace) and the Paste hotkey (defaults to Ctrl-Alt-P) by
|
||
using the PopCFG configuration program.
|
||
|
||
10.2 Why doesn't PopDBF pop up in the right directory?
|
||
|
||
By default PopDBF pops up in the first directory in which the
|
||
hotkey is pressed. To load PopDBF so that it pops up in a
|
||
specific directory, regardless of where you are when you first
|
||
press the hotkey, use the /D<dir> command line option (POPDBF
|
||
/Dc:\dbase).
|
||
|
||
10.3 Why are files always opened in Browse mode?
|
||
|
||
PopDBF uses the default action, displayed in the upper left
|
||
corner of the Pick File window, whenever a database file is
|
||
selected. To change the default action you can press F5 from
|
||
the Pick File window or use the /A<action> command line option
|
||
(POPDBF /Ae).
|
||
|
||
10.4 Why doesn't PopDBF display on my Monochrome monitor?
|
||
|
||
If you have problems getting PopDBF to display on your monitor,
|
||
use the /Cm option to force PopDBF to use monochrome colors.
|
||
You could also use the configuration program to force the
|
||
current colors to be monochrome.
|
||
|
||
10.5 How can I change the PopDBF colors?
|
||
|
||
To change the PopDBF colors you use the configuration program
|
||
PopCFG.
|
||
|
||
10.6 How can I use my extended memory?
|
||
|
||
Load the device driver RAMDRIVE.SYS or VDISK.SYS, following
|
||
directions in your DOS manual. Then use the /X command line
|
||
option and specify the name of the swap file on the RAM drive.
|
||
This will cause PopDBF to swap in and out exceptionally fast.
|
||
|
||
10.7 How can I limit displayed fields in Edit or Browse?
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 42
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Common Questions
|
||
|
||
After selecting a database file, press Alt-S to go to Setup
|
||
View. To mark the fields you want to use press the SPACE bar.
|
||
Press F4 to see the order the fields will be displayed in and
|
||
use F3 to change the order to suit your needs.
|
||
|
||
10.8 Why does PopDBF hang when I pop it up on a network?
|
||
|
||
When loading PopDBF in memory resident mode, it must be loaded
|
||
after any network TSR programs (i.e. IPX, NET3, RPRINTER).
|
||
|
||
PopDBF can be loaded first if it resides entirely in memory.
|
||
This can be done using the /SN switch.
|
||
|
||
When loading PopDBF in swap mode (to disk or EMS) it is
|
||
important to load it AFTER programs which must be able to
|
||
operate at all times.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 43
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Error Messages
|
||
|
||
11 Error Messages
|
||
|
||
11.1 Too many files, Re-install using new /G parm.
|
||
|
||
The default number of files that will fit into the Pick File
|
||
window is 100. This can be changed using the /G command line
|
||
option. Another way to avoid this error message is to change
|
||
the default file specification to something other than *.DBF
|
||
(which is the default).
|
||
|
||
11.2 Too many fields, Re-install using new /F parm.
|
||
|
||
The default maximum number of fields a file can have is 64. To
|
||
change this use the /F command line option. Until this is
|
||
fixed, you will not be able to load any databases that have
|
||
more fields than were specified (64 if none specified).
|
||
|
||
11.3 EDIT buffer too small, Re-install using new /E option.
|
||
|
||
If the record size of a database is larger than the Edit buffer
|
||
size you will not be allowed to Edit the database. To correct
|
||
this problem, press Alt-S to see the record size and reinstall
|
||
PopDBF using the /E command line option.
|
||
|
||
11.4 READ buffer too small, Re-install using new /R option.
|
||
|
||
If the read buffer size is smaller than the record size of a
|
||
database, you will not be allowed to Browse or Edit the file.
|
||
To correct this problem, press Alt-S to see the record size and
|
||
reinstall PopDBF using the /R command line option. A multiple
|
||
of at LEAST 12 times the size of the biggest record is
|
||
recommended.
|
||
|
||
11.5 Not a dBASE compatible file.
|
||
|
||
If this message is displayed, the first byte of the file is not
|
||
one of the following:
|
||
|
||
03h - dBASE3, dBASE4, Foxbase+, FoxPro
|
||
43h - dBASE4
|
||
63h - dBASE4
|
||
83h - dBASE3, Foxbase+ (with memos)
|
||
8bh - dBASE4 (with memos)
|
||
f5h - FoxPro (with memos)
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 44
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Error Messages
|
||
|
||
11.6 Sharing Violation.
|
||
|
||
If this error message is displayed, it probably means that
|
||
someone else is using the database on the network.
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 45
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Configuring PopDBF
|
||
|
||
12 Configuring PopDBF
|
||
|
||
The program PopCFG is provided to allow customized configuration of
|
||
the PopDBF program. You can use PopCFG to change the colors,
|
||
date/number formats, hotkeys and paste options.
|
||
|
||
To execute the PopDBF configuration program, type the following
|
||
command line at the DOS prompt:
|
||
|
||
POPCFG
|
||
|
||
To force monochrome attributes use the command line option /M by
|
||
typing the following command line at the DOS prompt:
|
||
|
||
POPCFG /M
|
||
|
||
12.1 The Configuration Main Menu
|
||
|
||
------| Configuration Options |------
|
||
| Colors |
|
||
| Date/Numbers Formats |
|
||
| main Hotkey |
|
||
| Paste Options |
|
||
| Quit - Do NOT Save Changes |
|
||
| eXit - Save Changes |
|
||
-------------------------------------
|
||
|
||
To execute any menu option, type the first capital letter in that
|
||
option or move the selection bar using the arrow keys and press
|
||
ENTER.
|
||
|
||
If you press ESCAPE or select the Quit option from the menu and
|
||
changes have been made, you will see the prompt "Abort and lose
|
||
changes [N]?". To quit and lose changes you must then press the
|
||
letter "Y". Pressing ENTER or the letter "N" will return you to the
|
||
main menu.
|
||
|
||
Changes made using the configuration program are written directly
|
||
into the POPDBF.EXE file.
|
||
|
||
|
||
12.2 Configuring Colors
|
||
|
||
To change colors use the up and down arrow keys to change the
|
||
category. Use the left and right arrows to change the foreground
|
||
color. Use Ctrl-left and Ctrl-right (press and hold the Ctrl key
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 46
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Configuring PopDBF
|
||
|
||
and then press the left or right arrow key) to change the background
|
||
color.
|
||
To restore the default color for the current category, press the
|
||
letter "D". The default color is the "factory default", meaning it
|
||
is the way PopDBF was when you first received it.
|
||
|
||
To restore the color for the current category to what it is
|
||
currently in the POPDBF.EXE file, press the letter "O".
|
||
|
||
To restore all "factory default" colors, press the letter "R".
|
||
|
||
Press ESCAPE when you are done making color changes to return to the
|
||
main menu.
|
||
|
||
|
||
12.3 Configuring Date/Number Formats
|
||
|
||
---------- Date/Number Formats ----------
|
||
| Date Format: U.S. (MM/DD/YY) |
|
||
| date Separator: / |
|
||
| decimal Point: . |
|
||
| Return to Main Menu |
|
||
-----------------------------------------
|
||
press ENTER to toggle an option
|
||
|
||
The date format rotates through one of the following:
|
||
U.S. (MM/DD/YY)
|
||
ANSI (YY/MM/DD)
|
||
European (DD/MM/YY)
|
||
|
||
The date separator toggles between a slash (/), dash (-) and period
|
||
(.). When the separator is changed the format correctly reflects
|
||
what the date will look like in PopDBF.
|
||
|
||
The decimal point toggles between a period (.) and comma (,).
|
||
|
||
Press "R" or ESCAPE to return to the main menu.
|
||
|
||
|
||
12.4 Configuring Main Hotkey
|
||
|
||
The main PopDBF hotkey defaults to Alt-Backspace. It can be changed
|
||
to almost any key combination. At least one of the shift keys, Alt
|
||
or Ctrl must be included. It can include Alt, Ctrl and both shift
|
||
keys, but must include at least one of those keys.
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 47
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Configuring PopDBF
|
||
|
||
The left and right shift keys are treated differently. Left and
|
||
right Alt and Ctrl keys are treated as being the same key.
|
||
|
||
After selecting this option you will see:
|
||
|
||
-------------------------------------------------------------------
|
||
| Main Hotkey Selection: <Alt>Backspace |
|
||
| |
|
||
| Enter new hotkey selection (press ESCAPE to cancel): |
|
||
-------------------------------------------------------------------
|
||
|
||
Of course the main hotkey selection will display the current main
|
||
hotkey, which may be different if you have changed it.
|
||
|
||
To cancel changing the hotkey, press ESCAPE at this point.
|
||
|
||
After you have pressed the new main hotkey, you will be asked to
|
||
confirm your selection. Press "Y" if the hotkey selection is
|
||
correct. Press "N" or ESCAPE if you want to change your selection.
|
||
|
||
NOTE: Though it is possible to have <LShift>A or other similar
|
||
keys as the PopDBF hotkey, it is recommended that this be
|
||
avoided.
|
||
|
||
|
||
12.5 Configuring Paste Options
|
||
|
||
---------| Paste Options |---------
|
||
| Paste Rate |
|
||
| Paste Frequency |
|
||
| Paste Hotkey |
|
||
| Return to Main Menu |
|
||
-----------------------------------
|
||
|
||
Changing the paste rate, affects the number of keys that are pasted
|
||
per timer tick. This is a number between 1 and 15 and defaults to
|
||
15, the maximum paste rate.
|
||
|
||
Changing the paste frequency determines how many timer ticks to wait
|
||
between each group of pasted keys. There are 18.2 timer ticks per
|
||
second. The default is 0, which means keys are pasted every timer
|
||
tick. This can be any value between 0 and 255 (approximately 14
|
||
seconds).
|
||
|
||
Changing the paste hotkey is the same as changing the main hotkey.
|
||
See "Configuring Main Hotkey" above.
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 48
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Index
|
||
|
||
A C
|
||
|
||
Action Keys 22 Change
|
||
Alt-A (Append) 22 Default Action 27
|
||
Alt-B (Browse) 22 Directory 26
|
||
Alt-E (Edit) 22 Disk Drive 26
|
||
Alt-F5 (Screen) 23 File Specification
|
||
Alt-P (Pick) 22 27
|
||
Alt-S (Setup) 22 Clipper 1, 9, 15
|
||
Alt Menu 22 Colors
|
||
Alt-A 22, 37 configuration 46
|
||
Alt-B 22, 33 Command Line Options 13
|
||
Alt-BackSpace 1, 11, 13, /A 13
|
||
42, 47 /C 14
|
||
Alt-E 22, 37 /D 14
|
||
Alt-F1 21 /E 14
|
||
Alt-P 22, 26, 37, 42 /F 15
|
||
Alt-S 15, 22, 30, 34, 43, /G 15
|
||
44 /H 16
|
||
Append 1, 3, 13, 14, 17, /I 16
|
||
22, 23, 27, 29, /L 16
|
||
30, 37, 38 /P 16
|
||
Append Records 37 /R 17
|
||
Applications 2 /S 17
|
||
for Anybody 2 /T 18
|
||
for Consultants 2 /U 19
|
||
for Programmers 2 /X 19
|
||
for Secretaries 2 /Y 20
|
||
ASP 7, 9 Compuserve 5-8
|
||
ASP Ombudsman 7 CONFIG.SYS 8
|
||
AUTOEXEC.BAT 8, 12 Configuration 12, 36, 42,
|
||
46
|
||
B Configuring PopDBF 46
|
||
Copy
|
||
Blank File Structure 32
|
||
Current Field 40 Record 37
|
||
to End of Field 41 Cursor and Lite-Bar
|
||
Browse 1, 3, 14-17, 19, Movement 25
|
||
22, 27, 30, 31, Cut 1, 37, 38
|
||
33, 34-40, 42,
|
||
44 D
|
||
Browse Records 33
|
||
Browse Window Date fields
|
||
Panning 33 searching 34
|
||
Zooming 33 Date format
|
||
configuration 47
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 49
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Index
|
||
|
||
Dates context sensitive
|
||
Turn Century On/Off 11, 21
|
||
36 Generic Help 21
|
||
dBASE 1, 4, 9, 14, 17, Hotkey 1, 11-13, 16, 17,
|
||
20, 27, 42, 44 28, 37, 42, 46,
|
||
dBASE III 1, 9 47, 48
|
||
dBXL 1, 9 configuration 47
|
||
Delete default hotkey 1
|
||
current record 36 Invoking PopDBF 13
|
||
File 28
|
||
Disclaimer 9 I
|
||
|
||
E Index files
|
||
Updating 4
|
||
Edit 1, 3, 4, 12-15, 17, using 4
|
||
18, 19, 20, 22, Installation 11
|
||
23, 24, 27-31,
|
||
36-38, 40, 42, J
|
||
44
|
||
Edit Records 37 K
|
||
EMS 12, 17, 18, 43
|
||
Enter A Specific File 27 L
|
||
Exit 1, 12, 17, 40, 46
|
||
License 6, 9, 10
|
||
F Registered Version
|
||
License 10
|
||
Field Shareware Version
|
||
exclusive find in 31 License 9
|
||
selection 30 Limitations 3
|
||
Find Load order 43
|
||
deleted records 35
|
||
Exclusive 31 M
|
||
Next 35
|
||
Text 34 Memo fields
|
||
Foxbase+ 1, 9, 44 searching 34
|
||
FoxPro 1, 9, 44 Memory Consumption 12
|
||
Frequent Database Access Memory Resident 1, 3, 11,
|
||
28 12, 13, 19, 20,
|
||
43
|
||
G Modifying AUTOEXEC.BAT 12
|
||
Move to
|
||
H Current DOS Drive &
|
||
Directory 28
|
||
Help 3, 7, 11, 13, 21, Parent Directory 26
|
||
22, 29
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 50
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Index
|
||
|
||
N Quit 40, 46
|
||
quit Edit and abort
|
||
Network 4, 16, 18, 19, any changes 40
|
||
23, 26, 43, 45 quit Edit and save
|
||
Number format 40
|
||
configuration 47
|
||
R
|
||
O
|
||
RAM Consumption 12
|
||
Options 12, 13, 16, 19, Registration 5, 6, 9
|
||
46, 48 for commercial and
|
||
Ordering government 5
|
||
form 5 How to Register 5
|
||
How to 5 Registration Benefits
|
||
using a credit card 6
|
||
5 registration fee 5
|
||
Overview 1 Removing PopDBF from
|
||
Memory 13, 19
|
||
P Restore
|
||
Entire Record 39
|
||
Pack Database 34 Field Data 39
|
||
Pass-Thru 3, 6, 11, 12, Running PopDBF
|
||
16, 17, 20 Memory Resident Mode
|
||
Paste 1, 12, 37, 38, 40, 11
|
||
42, 46, 48 Non-Resident Mode 12
|
||
changing frequency
|
||
48 S
|
||
changing hotkey 48
|
||
changing rate 48 Select Directory/File/Inde
|
||
clearing buffer 38 x 26
|
||
inside PopDBF 40 Setup View 30
|
||
into underlying Shareware 1, 5-9
|
||
application 37 Swap to Disk|EMS|None 17
|
||
PC-FILE 1, 9 Swapping 12, 17-19
|
||
Pick 3, 15, 22, 26, 27, specifying name of
|
||
30, 31, 42, 44 disk file 19
|
||
Pick File 26 when to avoid 12
|
||
Print
|
||
File Structure 32 T
|
||
from Browse 35
|
||
from Edit 38 TapCIS 8
|
||
Technical Support 8
|
||
Q Toggle Keys 23
|
||
Alt-C (Case) 23
|
||
Questions and Answers 42 Alt-D (Borders) 23
|
||
Quicksilver 1, 9 Alt-I (Insert) 23
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 51
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
PopDBF User's Manual
|
||
Index
|
||
|
||
Alt-M (Mode) 23
|
||
TSR 43
|
||
definition 1
|
||
|
||
U
|
||
|
||
V
|
||
|
||
Verify Mode 40
|
||
Viewing specific fields
|
||
30
|
||
|
||
W
|
||
|
||
Warranty 9, 10
|
||
Wordstar commands 25
|
||
|
||
X
|
||
|
||
Y
|
||
|
||
Z
|
||
|
||
Zap Database 34
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
Copyright (c) 1989-91 Bowen Software Page 52
|
||
|