home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.whtech.com
/
ftp.whtech.com.tar
/
ftp.whtech.com
/
articles
/
Sughrue
/
tibase2.txt
< prev
next >
Wrap
Text File
|
2006-10-19
|
13KB
|
391 lines
.IF DSK1.C3
.CE 2
*IMPACT/99*
by Jack Sughrue
TI-BASE
PART TWO
.IF DSK1.C2
Last time in IMPACT I waxed
enthusiastic over Dennis Faherty's
TI-BASE. In the few days since I
wrote Part I of this review I have
grown even more fond of this
fantastic database.
You can throw out all your
others, just as you did your old TI
WRITER cartridge after FUNNELWEB came
out.
TI-BASE is perfect for business,
school, home, and playtime. This can
handle anything you want a database
for and lots of things you didn't
know you wanted one for before seeing
the creative possibilities built in.
But before I list a pile of its
operational properties, it might be
better to start (as I had to) with
the simple things. Last month I said
I wanted to create a personal library
catalog of works by comedy author
P.G.^Wodehouse. It could just as
easily be a video library or recipes
or a checkbook or mailing addresses
or whatever. It does all these
simple tasks more easily than any
other database I have used for the
TI. Its input has no restrictions,
nor does its output, as you will
see.
The Wodehouse collection I have
includes paperback books, hardbounds,
multi-book anthologies, short
stories, tapes, videos. I have a
numerically assigned bibliography. I
also have sheets of paper with the
various titles under which the same
books were printed. And I have a lot
of various pieces of information
about many of the printed materials
from different sources, including
some library research. And, of
course, I have many of the books.
So I first had to decide how I
wanted this information collected and
how I wanted it to appear in final
screen display and hard copy forms.
I have over 200 separate items,
but for our purposes I'll use the
first few. All books.
At first glance I realized that
the pre-computer layout is similar to
many databases. I have to designate
a field (title, original publication
date, assigned number for
cross-referencing [like K235 for
Mozart's works] and so on).
I'm allowed 17 different fields
on each record page. More than I'll
ever use. I'm allowed up to 255
characters for each field. Again,
more than I'll use. And I'm allowed
over 8,000 records per database.
Definitely more than I'll ever use.
And I can create an infinite number
of bases.
So, I put my TI-BASE in Drive 1
(though I can assign it to any drive
or RAM) and my initialized blank disk
for creation of the database in Drive
2 (though I could initialize it from
inside the program itself while I'm
using it). I load it automatically
by choosing Extended BASIC.
It takes about 97 seconds to
fully load. Then you are asked for
the date in this form: 09/18/88. This
info goes onto your disk and
database, so be sure the
write-protect tabs are not on either
disk. And be sure you made backups
(as recommended by Faherty) and keep
your originals safe.
Next you'll be presented with a
STATUS report with these defaults:
^^DATDISK=DSK2.
^^PRGDISK=DSK1.
^^PRINTER=PIO.
^^LINE=80
^^PAGE=56
^^HEADING=ON
^^TALK=ON
^^SPACES=1
^^RECNUM=ON
^^LSPACE=256
^^DATE=09/08/88
I stuck with the Data and Program
drives and with the Printer. I
changed Line to 134 because I wanted
a condensed printout. I kept the
Page length of 56 lines. I shut OFF
the Heading because I planned to
print out lots of different
hardcopies and didn't need the
heading. I retained TALK which
displays the commands as they are
being executed. And the Spaces
between columns at 1 and the 256
character Lspace for the variables I
was about to create. I shut OFF the
Record Numbers because my assigned
numbers (which start at 1 instead of
0) would give me a cleaner, more
relevant printout, as well as screen
display. There is no cursor here.
Just a dot in the lower left corner.
That means TI-BASE is ready for your
command. I had to make those changes
above, so I just typed SET LINE=134
(ENTER) and SET HEADING=OFF (ENTER)
and SET RECNUM=OFF (ENTER). I then
typed at the dot DISPLAY STATUS just
to see that everything got in okay.
It did.
Now I typed CLEAR to clear the
screen (and ENTER, of course, after
each command).
But I don't like the screen
colors of white on dark-blue. So at
the dot I type COLOR BLACK
DARK-YELLOW. Voila! A nice crisp
black-on-yellow screen, though I
could have chosen any combination I
wanted.
Have you noticed that at the
Command Dot I simply type in a word
or two that DIRECTLY and INSTANTLY
performs the operation? At last, I
am ready to create a structure for my
P.G.^Wodehouse database.
At the dot I type CREATE
DSK2.WODEHOUS (8-Letter DB title).
This sets up the base automatically
for my personalized structure.
Up on the screen comes a 1
followed by a long slash and a couple
short ones. I type NUMBER in the long
slash and ENTER. The cursor jumps to
the first short dash. I type N over
the default C because this is to be a
number instead of character. When I
get to the next small dash I type 3
because my numeration will never
reach into the thousands, so a
three-place digit is sufficient for
my needs. An extra box appears.
This is for decimals. I type 0
because I'm only going to deal with
whole numbers. (When I eventually do
my CHECKBOOK database someday, I will
use this.) When I press ENTER here,
the cursor jumps down one line and a
2 and similar slashes appear.
The top line now reads like this:
1 NUMBER (This is the field for the
biographically assigned
numbers)^^N^^3^^0. The next line
will be typed in as this: 2
ORIG_DATE^^N^^4^^0^^for the original
publication date and a number which
will take up four spaces.
The next six fields (all
characters) are done as follows:
^^3 TITLE^^C^^26
^^4 H_P_T_S_O^^C^^1
^^5 JV_BL_OTHR^^C^^2
^^6 FIRST?YNM^^C^^1
^^7 OWN?YN^^C^^1
^^8 COMMENTS^^C^^255
I assigned Title 26 characters
because that is the most characters
any novel or play title has; #4
merely tells me in one character if
the material is Hardbound, Paperback,
Tape, Story, or Other; #5 lets me
know in two characters if the item is
about JeeVes, BLandings, or OTher; #6
asks if this is a first edition. The
M is for Maybe (to check later). #7
wants to know if I own it; and #8
lets me input comments up to 255
characters long. That way I can list
alternate titles, descriptions,
characters, plot, whatever.
So my very personal 8-field
record structure is finished in about
a minute. Before we leave this,
though, I check it out. The cursor
can be run all over the screen for
any changes easily. Now I Execute
(Fctn/8) to continue the process of
creating my database. At this point
I was asked if I wanted to input
data. I did, so I pressed Y. (At
this point I could have created
another structure or a few more.
TI-BASE handles 5 databases
simultaneously by providing slots for
each base.)
My next step (as record #1
appears on the screen) is to simply
fill in the blanks I created. Here
is what I type for the first record:
^^1 001 (for bib #)
^^2 1902 (orig pub date)
^^3 POTHUNTERS, THE (title)
^^4 P (paperback)
^^5 OT (other than Jeeve or Bland)
^^6 N (not first edition)
^^7 Y (I own this book)
^^8 First book of PGW. " Turn of
the century" English public school
tales. Mostly boxing. St.^Austin's
boarding house. In single-book
collection with A PREFECT'S UNCLE &&
TALES OF ST.^AUSTIN'S (#2 && 3).
I check it out, make any changes,
and press ENTER. It automatically
records on DSK2, my "WODEHOUS" data
disk.
This TI-BASE is fast, simple, and
direct. My second record template is
waiting for me to just fill in the
blanks. I continue on and on until
about two dozen records are
established. Then I quit for dinner
by typing CLOSE ALL. The program
takes care of all my database
records. Then I type QUIT.
Stuffed with roast turkey, I
return to my TI, load up TI-BASE and
type again the date.
Once the command dot appears I
type USE DSK2.WODEHOUS. Bang! It's
ready for me. I type DISPLAY
STRUCTURE just to see my template.
Still there. Perfect. I type EDIT 5
just to see if it'll pull up my fifth
record page. It does. Instantly. I
run my cursor around just playing
with the editing functions. The
program comes with a key strip and
most functions (such as INSERT
[FCTN/2]) just toggles on and off.
In the EDIT mode I page FORWARD and
BACK with the 5 && 6 keys. Neat and
easy. And instantaneous.
But I'm ready to add more. I
just type APPEND and the next blank
record comes up. I just go on
filling up record after record as
effortlessly as buttering hot corn
muffins. This is fun.
All the time I'm doing this stuff
I keep thinking of more and more uses
for TI-BASE.
After a while I stop (after 83
records) to try out some other
features.
First, I want to get some screen
displays.
I type SORT ON TITLE. Zip!!! My
83 records are now sorted
alphabetically by title. To prove it
I next type DISPLAY ALL TITLE NUMBER.
You guessed it. This gives me two
columns: the titles alphabetically
with its biblio number in a neat
column just to the right in the 27th
screen column. So I type DISPLAY 10
and get the first 10 records
displayed alphabetically with all 8
fields. Then I type SORT ON NUMBER.
Zip!!!
I type DISPLAY ALL TITLE NUMBER
ORIG_DATE OWN?YN [I must type my
original template names.] Now I get
four nice columns all in numerical
order.
I play, thus, for about a half
hour trying all kinds of
configurations.
How do you suppose one goes about
getting a hardcopy? Right! I type
PRINT with all the same combos as
DISPLAY. With the identical results
on paper. The printer is on and
starts right up printing exactly what
I asked for in numeric order: PRINT
ALL NUMBER TITLE ORIG_DATE OWN?YN. I
had already set my NX-1000 for
condensed. A beautiful four-column
readout is in my hand. I type SORT
ON TITLE; then PRINT ALL TITLE
COMMENTS and get a quick,
alphabetical column of titles
followed by my complete comments.
I guess I don't have to go on
with this, but if I want to delete I
type DELETE (and what I want deleted)
and later I can recall it (by typing
RECALL and the item).
I cannot imagine what could be
easier. This is wonderful! And I
haven't even tried the Tutorial Disk
yet, nor have I even begun to explore
even a small part of what this
database does. This is going to take
me months. I don't care. I can use
it instantly for 99% of all my
database needs without even looking
at the manual any more. It's that
easy. But I still want to discover
the secrets of TI-BASE still hidden
from me.
However, most TI users (if you're
like me), will need just the stuff I
dealt with during these first four
hours with this new software. For
those people who need a professional
database of the highest order, they
are in luck. It's here, also.
I've never unconditionally
recommended any commercial software
in the 7 years I've been reviewing
stuff for the TI. But I do with
TI-BASE. The price of $24.95 is
ridiculously low for such software
and is offered even lower to user
groups ordering in any size bulk. It
comes with two disks, a 40-page
manual (which I wish were bigger, in
black and white instead of blue, and
had some step-by-step tutorial type
instructions), and a function key
strip. Send your order (with $1.50
S&&H) to Texaments, 53 Center Street,
Patchogue, NY 11772 or credit charge
at 516-475-3480.
I think we're going to be seeing
lots of companion disks, templates,
and textware for TI-BASE from users
world-wide.
Excuse me. I think I'll get
started on a few more templates.
~~~~~~~~~~~~~~~~~~~~~~~~~
[Jack Sughrue, Box 459,
E.Douglas, MA 01516]
If any newsletter editor prints
these articles, please put me on
your mailing list. Thanks - JS
ÇçǼçïÉòƒ⌐╒╒╒╒╒╒╒╒╒╒Çï