Inventory Control (was Re: "No name" S-100 computer)

From: Doug Yowza <yowza_at_yowza.com>
Date: Sat Jun 27 01:38:33 1998

On 26 Jun 1998, Frank McConnell wrote:

> Doug, you live in a part of California that has a dry climate. How do
> you propose to affix barcodes to boxes? Are they sticky labels? Have
> you noticed that the sticky stuff turns brittle after a while (like,
> say, three years or so), and the labels become susceptible to falling
> off?

Well, the DMV seems to have solved this problem -- I can never get my
license plate stickers off, even after 10+ years :-) And there's always
good card stock tags and steel wire. For the most part, I'm getting by
now with cardboard boxes and magic markers, but that renders my barcode
scanners useless, and it means that I usually stop short of writing the
entire contents on the box (due to laziness).

If I could print box contents directly from database info (in both human
readable and barcode form), I could find a way to tag stuff.

> OK, that said, the schema of my database looks something like this
[...]

Looks good. I'll probably steal this, if you don't mind.

> I say the schema is "something like this" because it is changing,
> again. I'm fooling around with New Software, actually several New
> Softwares that are all several-years-old dBase-alikes that run on my
> HP200LX palmtop.

I'm a portable, wireless, and web zealot. I'll probably run the database
on one of my home Linuxboxen, which I can talk to via various
wireless-networked portables. (I have to admit that most of the wireless
portables are non-classic, but one of them is an early NEC CP/M portable
with a late 80's AirShare device.) This would free you from the memory
constraints of your HP200LX. (Did I mention that I have some PCMCIA
wireless LAN cards available for sale or trade?)

-- Doug
Received on Sat Jun 27 1998 - 01:38:33 BST