home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
World of Shareware - Software Farm 2
/
wosw_2.zip
/
wosw_2
/
DATABASE
/
POPDBF40.ZIP
/
POPDBF.DOC
< prev
next >
Wrap
Text File
|
1991-08-14
|
106KB
|
3,009 lines
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 . . . . . . . . . . . . . 8
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 . . . . . . . . . 19
i
PopDBF User's Manual
Table of Contents
3 Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
3.1 Generic Help (Alt-F1) . . . . . . . . . . . . . . . . 20
3.2 Context Sensitive Help (F1) . . . . . . . . . . . . . 20
4 Alt Menu (Alt) . . . . . . . . . . . . . . . . . . . . . . . 21
4.1 Alt Action Keys . . . . . . . . . . . . . . . . . . . 21
4.2 Alt Toggle Keys . . . . . . . . . . . . . . . . . . . 22
4.3 Toggle Indicator Summary . . . . . . . . . . . . . . 23
5 Cursor and Lite-Bar Movement . . . . . . . . . . . . . . . . 24
5.1 The "Wordstar" Diamond . . . . . . . . . . . . . . . 24
6 Pick File (Alt-P) . . . . . . . . . . . . . . . . . . . . . 25
6.1 Select Directory/File/Index (Enter) . . . . . . . . . 25
6.2 Move to Parent Directory (BackSpace) . . . . . . . . 25
6.3 Change Directory and/or Drive (F2) . . . . . . . . . 25
6.4 Enter A Specific File (F3) . . . . . . . . . . . . . 26
6.5 Change File Specification (F4) . . . . . . . . . . . 26
6.6 Change Default Action (F5) . . . . . . . . . . . . . 26
6.7 Delete File (F6) . . . . . . . . . . . . . . . . . . 27
6.8 Move to Current DOS Drive & Directory (F10) . . . . . 27
6.9 Frequent Database Access (Alt-1 thru Alt-=) . . . . . 27
6.10 Show Names of Frequently Accessed Databases (Ctrl-
N) . . . . . . . . . . . . . . . . . . . . . . . . . 28
6.11 Program Information . . . . . . . . . . . . . . . . 28
7 Setup View (Alt-S) . . . . . . . . . . . . . . . . . . . . . 29
7.1 Return To Data (Enter) . . . . . . . . . . . . . . . 29
7.2 Number/Un-Number Fields (Space) . . . . . . . . . . . 29
7.3 Clear Field Numbers (F2) . . . . . . . . . . . . . . 29
7.4 Assign a Specific Field Number (F3) . . . . . . . . . 30
7.5 Order Fields Using Field Numbers (F4) . . . . . . . . 30
7.6 Tag/Un-Tag Field for Exclusive Find (F6) . . . . . . 30
7.7 Clear Exclusive Find Tags (F7) . . . . . . . . . . . 30
7.8 Copy File Structure (F8) . . . . . . . . . . . . . . 30
7.9 Print the File Structure (F9) . . . . . . . . . . . . 31
8 Browse Records (Alt-B) . . . . . . . . . . . . . . . . . . . 32
8.1 Current Record and Delete Status . . . . . . . . . . 32
8.2 Toggle Vertical Separator Bars On/Off (Shift-|) . . . 32
8.3 Pan the Browse Window (LeftArrow/RightArrow) . . . . 32
8.4 View Large Fields (Tab/Shift-Tab) . . . . . . . . . . 32
8.5 Zoom the Browse Window (F2) . . . . . . . . . . . . . 32
8.6 Goto a Specific Record (F3) . . . . . . . . . . . . . 32
ii
PopDBF User's Manual
Table of Contents
8.9 Find Text (F7) . . . . . . . . . . . . . . . . . . . 33
8.10 Find Next Occurrence of Text (F8) . . . . . . . . . 34
8.11 Print Records (F9) . . . . . . . . . . . . . . . . . 34
8.12 Turn Century On/Off (Ctrl-K) . . . . . . . . . . . . 35
8.13 Mark Record as Deleted (Ctrl-U) . . . . . . . . . . . 35
9 Edit/Append Records (Alt-E/Alt-A) . . . . . . . . . . . . . 36
9.1 Copy a Record (F2) . . . . . . . . . . . . . . . . . 36
9.2 Goto a Specific Record (F3) . . . . . . . . . . . . . 36
9.3 Cut Field into Keyboard Paste Buffer (F4) . . . . . . 36
9.4 Clear Keyboard Paste Buffer (Shift-F4) . . . . . . . 37
9.5 Find Text (F7) . . . . . . . . . . . . . . . . . . . 37
9.6 Find Next Occurrence of Text (F8) . . . . . . . . . . 37
9.7 Print Records (F9) . . . . . . . . . . . . . . . . . 37
9.8 Field Information (F10) . . . . . . . . . . . . . . . 38
9.9 Restore Field Data (Ctrl-J) . . . . . . . . . . . . . 38
9.10 Turn Century On/Off (Ctrl-K) . . . . . . . . . . . . 38
9.11 System Date (Ctrl-M) . . . . . . . . . . . . . . . . 38
9.12 Move to Last Field Position (Ctrl-N) . . . . . . . . 38
9.13 Restore Entire Record (Ctrl-O) . . . . . . . . . . . 38
9.14 Paste Data (Ctrl-P) . . . . . . . . . . . . . . . . . 39
9.15 Abort and Lose Changes (Ctrl-Q/ESCAPE) . . . . . . . 39
9.16 Mark Record as Deleted (Ctrl-U) . . . . . . . . . . . 39
9.17 Toggle Verify Mode On/Off (Ctrl-V) . . . . . . . . . 39
9.18 Quit and Save Changes (Ctrl-W/Ctrl-End) . . . . . . . 39
9.19 Blank Current Field (Ctrl-Y) . . . . . . . . . . . . 39
9.20 Blank to End of Field (Ctrl-Delete) . . . . . . . . . 40
9.21 Move to End of Data (End) . . . . . . . . . . . . . . 40
9.22 Move to First Position (Home) . . . . . . . . . . . . 40
9.23 Move Word (Ctrl-LeftArrow/Ctrl-RightArrow) . . . . . 40
9.24 Move to First/Last Field (Ctrl-UpArrow/Ctrl-
DownArrow) . . . . . . . . . . . . . . . . . . . . . 40
9.25 Previous Record/Next Record, Same Page (Alt-PgUp/Alt-
PgDn) . . . . . . . . . . . . . . . . . . . . . . . . 40
10 Common Questions and Answers . . . . . . . . . . . . . . . 41
11 Error Messages . . . . . . . . . . . . . . . . . . . . . . 43
iii
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.
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 replacement for the many
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 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 from
the Public (software) Library (PsL) 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.
To insure that you get the latest version, PsL will notify us the
day of your order and we will ship the product directly to you. 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 PsL at 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.
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.
1.8 Trademark Acknowledgements
Copyright (c) 1989-91 Bowen Software Page 8
PopDBF User's Manual
Introduction
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.
Failure to make this payment after the evaluation period is
considered to violate this license.
Copyright (c) 1989-91 Bowen Software Page 9
PopDBF User's Manual
Introduction
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 20.
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 to around 45K of RAM. This may be a
desirable mode if no EMS is available, the local hard disk is very
slow and the lower 640K of RAM is mostly 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
the 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 27.
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
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.
Pressing the PopDBF hotkey will cause the resident
version to pop up over the Pass-Thru version.
Copyright (c) 1989-91 Bowen Software Page 16
PopDBF User's Manual
Getting Started
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.
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
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 at E:, use the following command line:
Copyright (c) 1989-91 Bowen Software Page 17
PopDBF User's Manual
Getting Started
POPDBF /SD /XE:\POPDBF.SWP
/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
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 32.
Copyright (c) 1989-91 Bowen Software Page 18
PopDBF User's Manual
Getting Started
For more information on toggle indicators, see "Alt
Toggle Keys" on page 22.
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.
/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 only
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 19
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 21. 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 20
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 39.
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
27.
Copyright (c) 1989-91 Bowen Software Page 21
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 33.
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 22
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 23
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 24
PopDBF User's ManualPick 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 26). 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
colon (C:), a directory path (\DBASE\PAYROLL), or both
(C:\DBASE\PAYROLL).
Copyright (c) 1989-91 Bowen Software Page 25
PopDBF User's ManualPick File
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 26
PopDBF User's ManualPick 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 26 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)
A MILEAGE.DBF (open database in Append mode)
Copyright (c) 1989-91 Bowen Software Page 27
PopDBF User's ManualPick File
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 28
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.
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 29
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 23), the text being searched for MUST be
found entirely within ONE field. For more information see "Find
Text" on page 33.
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.
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
Copyright (c) 1989-91 Bowen Software Page 30
PopDBF User's Manual
Setup View
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 31
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 32
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 33
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 34
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 33
for a tip on how to find deleted records.
Copyright (c) 1989-91 Bowen Software Page 35
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 32.
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 36
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 33.
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 34.
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 37
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 35.
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 38
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 33
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 39
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 40
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 41
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. NET3, IPX, RPRINTER).
Copyright (c) 1989-91 Bowen Software Page 42
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 43
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 44
PopDBF User's Manual
Index
A C
Action Keys 21 Change
Alt-A (Append) 21 Default Action 26
Alt-B (Browse) 21 Directory 25
Alt-E (Edit) 21 Disk Drive 25
Alt-F5 (Screen) 22 File Specification
Alt-P (Pick) 21 26
Alt-S (Setup) 21 Clipper 1, 9, 15
Alt Menu 21 Command Line Options 13
Alt-A 21, 36 /A 13
Alt-B 21, 32 /C 14
Alt-BackSpace 1, 11, 13, /D 14
41 /E 14
Alt-E 21, 36 /F 15
Alt-F1 20 /G 15
Alt-P 21, 25, 36, 41 /H 16
Alt-S 15, 21, 29, 33, 42, /I 16
43 /L 16
Append 1, 3, 13, 14, 17, /P 16
21, 22, 26-29, /R 17
36, 37 /S 17
Append Records 36 /T 18
Applications 2 /U 19
for Anybody 2 /X 19
for Consultants 2 /Y 19
for Programmers 2 CONFIG.SYS 8
for Secretaries 2 Configuration 12, 35, 41
ASP 7, 9 Copy
ASP Ombudsman 7 File Structure 30
AUTOEXEC.BAT 8, 12 Record 36
Cursor and Lite-Bar
B Movement 24
Cut 1, 36, 37
Blank
Current Field 39 D
to End of Field 40
Browse 1, 3, 14-18, 21, Date fields
26, 29, 30, 32, searching 33
33, 34-39, 41, Dates
43 Turn Century On/Off
Browse Records 32 35
Browse Window dBASE 1, 4, 9, 14, 17,
Panning 32 19, 25, 41, 43
Zooming 32 dBASE III 1, 9
dBXL 1, 9
Copyright (c) 1989-91 Bowen Software Page 45
PopDBF User's Manual
Index
Delete I
current record 35
File 27 Index files
Disclaimer 9 Updating 4
using 4
E Installation 11
Edit 1, 3, 4, 12-15, 17, J
18, 19, 21-23,
26-30, 35, 36, K
37, 39, 41, 43
Edit Records 36 L
EMS 12, 17
Enter A Specific File 26 License 6, 9, 10
Exit 1, 12, 17, 39 Registered Version
License 10
F Shareware Version
License 9
Field Limitations 3
exclusive find in 30
selection 29 M
Find
deleted records 34 Memo fields
Exclusive 30 searching 33
Next 34 Memory Consumption 12
Text 33 Memory Resident 1, 3, 11,
Foxbase+ 1, 9, 43 12, 13, 19, 42
FoxPro 1, 9, 43 Modifying AUTOEXEC.BAT 12
Frequent Database Access Move to
27 Current DOS Drive &
Directory 27
G Parent Directory 25
H N
Help 3, 7, 11, 13, 20, O
21, 28
context sensitive Options 12, 13, 16, 19
11, 20 Overview 1
Generic Help 20
Hotkey 1, 11-13, 16, 27, P
36, 41
default hotkey 1 Pack Database 33
Invoking PopDBF 13 Pass-Thru 3, 6, 11, 12,
16, 17, 19
Copyright (c) 1989-91 Bowen Software Page 46
PopDBF User's Manual
Index
Paste 1, 12, 36, 37, 39, S
41
clearing buffer 37 Select Directory/File/Inde
inside PopDBF 39 x 25
into underlying Setup View 29
application 36 Shareware 1, 5-9
PC-FILE 1, 9 Swap to Disk|EMS|None 17
Pick 3, 15, 21, 25, 26, Swapping 12, 17, 19
29, 30, 41, 43 specifying name of
Pick File 25 disk file 19
Print when to avoid 12
File Structure 31
from Browse 34 T
from Edit 37
Technical Support 8
Q Toggle Keys 22
Alt-C (Case) 22
Questions and Answers 41 Alt-D (Borders) 22
Quicksilver 1, 9 Alt-I (Insert) 22
Quit 39 Alt-M (Mode) 22
quit Edit and abort TSR 42
any changes 39
quit Edit and save U
39
V
R
Verify Mode 39
RAM Consumption 12 Viewing specific fields
Registration 5, 6, 9 29
How to Register 5
Registration Benefits W
6
registration fee 5 Warranty 9, 10
Removing PopDBF from Wordstar commands 24
Memory 13, 19
Restore X
Entire Record 38
Field Data 38 Y
Running PopDBF
Memory Resident Mode Z
11
Non-Resident Mode 12 Zap Database 33
Copyright (c) 1989-91 Bowen Software Page 47