home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
testpgm.zip
/
READ.ME
< prev
next >
Wrap
Text File
|
1988-06-18
|
2KB
|
30 lines
06/18/1988
Marvin Spears,
I put a suggestion as to how to handle your unique custnum and
invoice num on Nick's board, but mistakenly erased it. Instead of
rewriting the msg, I decided a few quick files would probably be
more helpful to you.
This is no programming gem, but may help you with your immediate
problem and show you one method of handling this type of problem.
As you can see, the two numbers in question end up in char form within
the transaction file (testbiz.dbf). The advantage of strings is that
you can incorporate other information into them. For example the
Invoice number here contains the date (in a format that is easy to view
for aging, or filing), in addition to a unique, sequential invoice number.
Similarly, the CustCode includes a ZipCode, the year the customer started
doing business with your firm, and a unique sequential customer code.
I tried to show you the concept, not necessarily my suggestion for info
to be stored in these strings. Expand or contract these strings to your
heart's content. My suggestion is to consider what type of reports you may
want to generate from these files, or what info you want from just a quick
glance at the piece of paper they're printed on when deciding what info to
put in these strings. The possibilities are limitless - the principal is
the same.
To run this sample program, just type 'do biz' at the dBaseIII+ dot prompt.
Good Luck,
John Wood