Download User`s Column, January 1982, BYTE Magazine

Transcript
User's Column ______________________________
Second, the bugs have been fixed. Not that there ever
were many; VULCAN was always excellent, even if in­
furiating.
And finally, the program remains very powerful .
dBASE II isn't just a means of storing and retrieving data.
It contains what amounts to a whole data-handling lan­
guage with the ability to do sorts and restructures, to
copy data from one place to another, and to do condi­
tional arithmetic. For example,
REPLACE ALL FOR (BILL:DATE <
COST WITH COST * 1 . 1
=
VULCAN files and then reshape them into the new
system I've designed. What happens is that dBASE I I
copies the old records into new ones, ignoring any i n the
old database that aren't in the new structure; while if it
finds variables in the new structure that weren't in the old
records, it fills them with blanks, leaving room for you to
enter the data at your leisure.
dBASE II, I'm pleased to say, makes no attempt to pre­
vent you from making backup copies. Far from it: all
through the documentation, you're urged to make a
safety copy of both data and program, just in case. That
advice is worth taking, given the relative costs of data­
entry labor as opposed to floppy disks. I expect people
will try to rip off the dBASE II software, given the price,
but I guarantee they11 get zero use of it without a com­
plete set of documents . . . .
791031)
would b e a command t o search the database t o find
records that had BILL: DATE older than October 31, 1979
and for those records to replace the value of the variable
COST by the current value plus ten percent .
Other forms of magic are possible. You have to study
dBASE II; it can do things you wouldn't think of. But it's
well worth the study. I'm using it to organize my files, by
subject, type, date, date of last access, and drawer
number, and also adding keywords; eventually I1I have
this place organized, and this time for sure. (The last time
I got this ambitious I was using VULCAN, and the
documentation drove me to quit in disgust, but this time
things seem to be going much better . ) And my time
wasn't wasted last year, since dBASE II can read the old
MXB0 - $469
APPLE GRAPHICS PARALLEL INTERFACE
Full Hi Res Graphics for Epson, Okidata, etc.
ADDS
ALTOS
ACS 8000-1 5 - $4750
ANADEX
9500 - $1 225
9501 - $1 225
ATARI
730 - $800
737 - $750
DS180 - $1 269
1 640 - $2575
DISKETTES
Scotch - $2.50
Dysan - $3.50
EPSON
MXSOFT - $599
MX1 00 - $739
HAZELTINE
1 500 - $995
Esprit - $675
DISCOUNT LINE
1 -800-528-8960
156
$89
M83A - $749
TRSBO BIDIRECTIONAL 1/0 PORT
Cascadable with Selectable Addressing
SOROC
INTERFACES
1 20 - $729
CPS-CARD - $1 99
HR64DD - $2875
All Major Brands - $CALL
HR640D - $31 50
TELEVIDEO
LOBO
9 1 2 - $669
Apple Drive/Card - $390/$90
8 1 0 - $1 275
820 - $1 795
OKIDATA
HAYS-MICROMODEM - $285
M80 - $369
Novation-Cat - $1 55
M82A - $489
M83A - $739
Penril - 300/1 200 (21 2A) - $795
SL1 25 - $3150
SL250 - $4200
M84 - $1 099
APPLE XTRAS
MONITORS
Memory-16K 200ns - $1 9.95
SANYO-BW - $159
Sanyc-Green - $249
Color - $425
Game Paddle Extension - $1 4.95
Amdek-Green - $1 59
Color - $350
Protyping P.C. Board - $1 9.95
MPI
SSG - $575
99G - $675
NEC
551 0 - $2540
C lOTH
25CPS-P - $1 379
5520 - $2900
EXPOTEK CORPORATION INTEoRNATION�
2231 -R West Shangri La Road, Phoenix, AZ 85029
january 1982 © BYTE Publications Inc
950 - $930
Tl
MODEMS
APF - $1 25
1 35 - $799
SOFTWARE
NORTHSTAR
Apple DO Drive - $2740
DIABLO
630 - $2095
· . APPLE II
TASSO Drive/lnteriace - $390/$90
DATASOUTH
DS1 20 - $595
Microstat by Ecosoft. I don't care much for the house
name - I'm growing weary of "ecology" names for soft­
ware companies, since they make me think their products
may contain significant portions of natural organic
waste - but I can recommend the program, with warn­
ings.
First warning: you, or someone you work with, better
know quite a lot about statistics. Microstat will do some
very sophisticated statistical analyses, but it will not tell
�
,. �
.. .t; � � ... .. • , A. -I'. .. .... ,... ,..., .!: "'\ , ., ..... .... ..... .7 .... .... _.., .. ..t.;-... •
-.. ... ... . .... .... ...... .. ..:.. .! J. · : -:._-:..:
-:__ .
SSM-AIO - $160
Viewpoint - $559
Statistical Analysis with Microstat
45CPS-P - $1699
ZENITH
Z19 - $775
zag - $2195
ARIZONA 1 -602-246-1 783
EXPORT TWX - 91 0-950- 1 1 94
0
Circle 1 52 on i nquiry card.