CLdot version 1.0
CLdot is an interactive dot prompt mode for Dbase and Clipper
databases. At this time CLdot v1.0 is being offered as "Freeware"
which means that you do not have to pay for it. You are both
allowed and encouraged to copy and distribute this program to
friends, co-workers and bulletin boards as long as there is no
charge involved and all accompanying documentation is intact.
If after using CLdot you find it useful, you may wish to become a
registered user of CLdot. Registration assures the author that
people find his program useful and wish to compensate him for the
long hours spent developing it. It also assures the user that the
author will maintain and enhance his product. A registration fee
of $30 is suggested, but any amount will be appreciated. All
registered users will receive notification of enhancements and
upgrades, along with free product support for one year.
Additional support may be purchased later at the rate of $10 per
year. To register, send your Name, address, company, city , state
and zip code along with your donation to :
Randolph P. Schmidt
1001 Mayflower #50
South Bend, IN 46619
I have been using and modifying CLdot for about 6 months now and
have found it to be pretty well bug free. The few bugs that I am
aware of tend to be mostly with memo fields and should be
corrected in my next release. Because it is not 100% error free,
I will try to correct any bugs brought to my attention by anyone,
registered or not. I will not, however, be held responsible for any
damages that may occur from the use of CLdot.
** Note - Although Both Dbase and Clipper databases are
supported, only the Clipper NTX index files may be used.
Dbase is a trademark of Ashton-Tate, Inc.
Clipper is a trademark of Nantucket Corp.
..... = .....
The equal sign allows you to set up variables. For example
to set up a variable named X and give it a value of 5, type
X = 5.
Displays ..... on the screen.
@ x,y GET .....
Get allows you to interactively change a database field. x
and y are screen coordinates. To change a field called name
on line 6 starting in row 10 type: @ 6,10 GET Name.
@ x,y SAY .....
Same as @ Get except that fields are display only and cannot
Adds a blank record to the end of the current database.
APPEND FROM .....
Appends records to the current data base from ..... The SDF
option is used if the ..... file is a text file.
Browse lets you look at all of the current databases records
in table format. Browse supports field lengths over 80
characters along with memo fields.
DOS change directory command to view which directory you are
currently in type CD. To change directories type CD\.....
Clears the Screen.
Closes all databases and indexes and clears all memory
Clears all memory variables.
Closes all open databases.
Closes all open index files.
Clears the screen.
Go to the next record that meets the criteria of the
previously entered LOCATE command.
COPY TO .....
With the SDF option the current database is copied to .....
in text file format.
With the STRUCTURE EXTENDED option a new database is created
with the field names of the current database becoming
records in the new database.
Allows you to define your own database structure.
CREATE ..... FROM .....
Creates a database ..... from the STRUCTURE EXTENDED
Marks the current record for deletion. The record can be
permanently removed with a PACK command or brought back with
the RECALL command.
Displays the structure of the current database on the
DTDIR lets you display a directory of only files that fall
between two dates. For example typing DTDIR *.exe will prompt
you for a beginning and ending date. All .exe files created
between those two dates will be displayed.
** NOTE: DTDIR.CLD must be in the current subdirectory for
DTDIR to work.
Edit allows you to view and change one record at a time.
Field lengths over 80 are supported along with memo fields.
Moves paper in printer to top of form.
Issues a file lock command.
Repositions the record pointer to the specified record.
INDEX ON ..... TO .....
Builds a Clipper compatible index file.
Lists the specified field on the screen for all records.
LIST STRU TO PRINT
List the structure of the current database to the printer.
LOCATE FOR .....
Finds the first record that meets the specified criteria.
Lets you add, delete, or change fields in the current
Permanently removes records marked for deletion.
Closes all open files and returns to DOS.
Brings back records that were marked for deletion.
Rebuilds the current index file.
REPLACE ..... WITH .....
Replaces ..... with ..... for the current record. If the
ALL option is used the replace affects all records.
Issues a record lock.
Allows execution of DOS commands.
Goes to the first record that meets the entered criteria.
** NOTE: The database must be indexed for a SEEK.
CLdot allows up to five databases to be opened at the same
SET DEFAULT TO .....
Sets the default drive.
Set deleted tells whether to recognize records marked for
deletion. ON - deleted records will not be recognized.
OFF - deleted records will be recognized.
Set exclusive tells whether you have exclusive or shared use
of all your databases. ON - exclusive use.
OFF - shared use.
SET INDEX TO .....
Allows the use of the specified index file with the current
SET PATH TO .....
Sets the search path.
Moves the record pointer to the next record.
Unlocks any record or file locks currently in use in the
Unlocks all record or file locks currently in use.
Sets the ..... database to be current. If the index option
is used the specified index is also set current. If the
EXCLUSIVE option is used, the database will be used
Erases all records from the currently active database.
Along with these commands your last 10 dot prompt commands are
available through the use of the PgUp and PgDn keys.
If you find any problems or have any suggestions, please let me