ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng)/ProfitPress-MegaCDROM2.B6I/APPS/DATABASE/RECAP21.ZIP/RECAP.DOC

Text File | 1991-03-15 | 6.8 KB | 126 lines

                                   RECAP
                  (c) Copyright 1990, 1991 Rosemary West
                            All Rights Reserved

                           R.K. West Consulting
                               P.O. Box 8059
                       Mission Hills, CA 91346, USA

It can be very frustrating to find that some of your database records have
been entered in all caps when you didn't want them that way, or that some
have not been entered in all caps when you did want them that way!

RECAP will go through any dBase III-compatible database file and make the
desired adjustment. Many software applications use this kind of data file,
most often identified by the DBF extension after the filename.

Note that only character fields are affected by RECAP. A character field is
a field into which you can enter alphanumeric data. Date fields, number
fields, and logical fields (those which contain .t. or .f. to indicate true
or false) are not affected. However, be aware that some applications may be
written in such a way that you are entering dates, numbers, or logical
operators into character fields.

Note that memo fields are not affected by RECAP. A memo field is a special
type of character field which allows you to enter large amounts of
alphanumeric data, often in a "window" on screen. These fields are commonly
used for "comments".

When you select "Change all words to all uppercase", every word of every
character field will be placed in all caps. For example, "The Quick Brown
Fox" will become "THE QUICK BROWN FOX".

When you select "Capitalize first letter of each word", the first letter of
each word of every character field will be capitalized, with the exception
of a few words, such as "a" and "the", which are not normally capitalized
when they occur in the middle of a title. For example, "THE UNITED STATES
OF AMERICA" will become "The United States of America".

When you select "Change all words to all lowercase", every word of every
character fields will be placed in all lowercase. For example, "George
Washington's Birthday" will become "george washington's birthday".

Normally, fields which are only one character in length are assumed to be
initials or special codes, and are left unchanged. However, if you select
"Customized Capitalization" from the main menu, you can change this default
so that one-character fields will not be ignored.

Normally, a two-character field whose title is STATE will be assumed to be
a two-letter state abbreviation and will be put in all caps, no matter what
other selections you have made. However, if you select "Customized
Capitalization" from the main menu, you can change this default so that the
STATE field will not be singled out for special treatment.

Normally, a two-character field whose title is not STATE is treated just
like any other field. However, if you select "Customized Capitalization"
from the main menu, you can change this default to that two-character
fields will be ignored.

Normally, all character fields are affected by RECAP, with the exception of
those special fields singled out for different treatment, as described
above. However, if you select "Customized Capitalization", you can also
select which fields will be affected. First, you will have the opportunity
to change the defaults for one- and two-character fields, as described
above. Then, if you answer "Y" to  "Do you want to select specific fields
to be changed?", you will be shown a list of all the character fields in
your database. Enter the letter "Y" next to the names of the fields you
want changed. Note that when you select fields, all defaults are ignored,
and only the fields you have selected are affected by RECAP.

You may need to reindex your data files after changing them with RECAP.

RECAP has been thoroughly tested on a number of different computers and
with dozens of different database files. However, no software can be
guaranteed compatible with every possible system configuration. Be smart:
backup your data BEFORE you use this or any other application.

If you are using DOS version 4.x, before using RECAP, you may need to enter
the following command at the DOS prompt or in your AUTOEXEC.BAT file:

                                CLIPPER=E0

(That's the number 0, not an uppercase "o".) If you use other Clipper-
compiled applications, you may already have a Clipper system variable in
your AUTOEXEC.BAT file. If so, please, add ;E0 to the end of that variable,
if you have not already done so.

RECAP is copyrighted software and may not be sold. You may copy this
software for others, as long as you do not charge any fee of any kind. Disk
vendors who charge a fee must obtain the author's written permission before
distributing this software. Vendors who are members of the Association  of
Shareware Professionals, in good standing, automatically have permission to
distribute. All others must contact the author first. All copies must
include all original documentation and may not be changed in any way.
Permission to copy and distribute this software may be revoked at any time.
For additional information, see the VENDOR.DOC file included on the
distribution disk.

If you found this program useful, please become a registered user. We offer
two levels of registration for this product:

    1. Send us a self-addressed, stamped envelope. You will receive:
Instructions to make this a "registered" copy of the program; a sample copy
of our newsletter; technical support by mail for a period of three months
from the date of registration.

    2. Send a registration payment of $15.00. (Foreign users, please add
$6.00 shipping.) You will receive: Instructions to make this a "registered"
copy; a three-issue subscription to our newsletter; technical support by
phone for a total of up to 30 minutes connect time or one month, whichever
occurs first; technical support by mail for a period of six months from the
date of registration; notification of future upgrades to the software;
discounts on registration of our other software products. Payments must be
in US dollars, drawn on and payable through a US bank; or may be made by
credit card through the Public (Software) Library: PO Box 35705, Houston TX
77235; 800-242-4775, 713-524- 6394; Fax, 713-524-6398; CompuServe
71355,470.

"RECAP", CONSISTING OF ALL RELATED SOFTWARE, INSTRUCTION MANUAL, DATA
FILES, AND REFERENCE MATERIALS, IS PROVIDED "AS IS", WITHOUT WARRANTY AS TO
ITS PERFORMANCE, MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE. THE
ENTIRE RISK AS TO THE RESULTS AND PERFORMANCE OF THESE PRODUCTS IS ASSUMED
BY THE USER. IN NO EVENT WILL THE AUTHOR BE LIABLE FOR ANY DAMAGES,
INCLUDING LOST PROFITS, LOST SAVINGS, OR OTHER INCIDENTAL OR CONSEQUENTIAL
DAMAGES ARISING OUT OF THE USE OF OR INABILITY TO USE THIS PROGRAM, OR FOR
ANY CLAIM BY ANY PARTY, REGARDLESS OF CIRCUMSTANCES.