home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
HomeWare 14
/
HOMEWARE14.bin
/
database
/
ddf606a.arj
/
HELPDOC.EXE
/
MISCUTIL.HLP
< prev
next >
Wrap
Text File
|
1994-03-05
|
5KB
|
95 lines
╒═══════════════════════════════════════════════════════════════════╕
│ Miscellaneous Utilities │
╘═══════════════════════════════════════════════════════════════════╛
There are currently four utilities available under "Miscellaneous
Utilities" in the main menu. More will be added as needed. They will
allow you to: a) search and replace data in your fields, b) convert
data in fields to all upper or upper/lower case, c) modify the field
order of a database, and d) query the zippy database which requires
the optional Zippy database.
A) Search and Replace
B) Convert UPPER/lower Case
C) Modify Field Order
D) Search Zippy Database
A) Search and Replace
─────────────────────────────────────────────────────────────────────
This selection will search for specific data in a field and then
replace it with the new data that you specify.
This will work on all the records in the database file. Simply select
the field you want to search for data in. Then, enter the field
content you want DDFile to look for and replace. Then, enter the new
data to replace the old.
If a character or memo field is selected and old data is specified,
you will be asked if you want to search within the field and replace
only the data specified.
When finished, the total number of records with the new field content
is displayed.
B) Convert UPPER/lower Case
─────────────────────────────────────────────────────────────────────
This selection will convert data in a field to all upper case or
upper/lower (upper case first character of each word and lower case
the rest). This will work on all the records in the database file.
Select the field you want to convert data in and select either
"UPPER/lower" or "All UPPER" from the sub-menu.
C) Modify Field Order
─────────────────────────────────────────────────────────────────────
This selection will allow you modify the field arrangement of the
currently selected database. The changes will not take place in the
current file. It is only used as a model to create a new file with
the new field order.
The records in the currently selected database can be put into the
new database field order using the following 2-step process:
1) When finished with this procedure, select the newly created
database with the new field order.
2) Import the records from the prior database into the new
database using "Import/Export dB3/ASCII Files" in the main
menu. Import in dBASE III format. See "Importing & Exporting"
in the on-line documentation.
This will also create a database definition file for the new field
order, eliminating the need to place the fields on the screen after
modifying the field order.
All fields must be selected. After a field is selected, the order
number of that field is placed to the right of it. The fields may be
selected in any order you wish. When all fields have been selected, a
new empty database will be created with the new order.
If you do not want to include some of the fields in the new database,
select them for now but before importing the old records into it,
modify it with "Modify an Existing Database" and delete the unwanted
fields. See "Creating/Modifying a Database" in the on-line
documentation.
D) Search Zippy Database
─────────────────────────────────────────────────────────────────────
Zippy is an optional database of all the cities, states, area codes
and zip codes in the United States. Zippy is available for an
additional cost. You will need a hard drive with at least 2.5 MB of
free disk space.
Once you have zippy installed you will be able to make this
selection. A sub-menu will open allowing you to search for a City,
State, Zip Code, or Area Code. To look up a zip code for a particular
city, for example, select City and then enter the city name. Next,
all the cities in the United States by that name will appear in a
scrollable window with their corresponding state, area code, and zip
code. This database can be cross-referenced to look up any data on
any of the four selections.