CP/M/CPM_CDROM.iso/lambda/soundpot/f/kp-db19.lbr/DB19.DZC/DB19.DOC

Text File | 1993-10-26 | 5.1 KB | 132 lines

                            D B  v1.9

              A Name/Address/Phone/Mailing Database

                               by
                        Steven L. Sanders

                All rights reserved (c) 21-Jan-85

=================================================================
Thi≤á softwarσ i≤ hereb∙ placeΣ int∩ thσ publiπ b∙ thσ autho≥ fo≥ ì
al∞á t∩ FREEL┘ use¼á copy¼á o≥ exchange«á  Thσ autho≥ assume≤á n∩ ì
liabilitie≤á fo≥ an∙ damage≤ causeΣ b∙ thσ usσ o≥ misusσ oµá thi≤ ì
program«á  Portion≤ oµ thσ objec⌠ codσ arσ (c⌐ 1982¼ 198│ Digita∞ ì
Research¼á thσá sourcσá codσ iε Cbasiπ compile≥ i≤á (c⌐á 198╡á b∙ ì
Steven L. Sanders.
=================================================================

                        "What's a DB ??"

     ╔á wa≤á ß happ∙ Kaypr∩ owne≥ bu⌠ wa≤á constantl∙á frustrateΣ ì
witΦá m∙á attempt≤á t∩á creatσ ß 'decentºá databasσá forma⌠á witΦ ì
PERFEC╘ FILE╥ - so¼á ╔ madσ DB«á  D┬ doe≤ no⌠ requirσ ß multitudσ ì
oµ .OV╥ o≥ .OV╠ file≤ t∩ operate¼ jus⌠ thσ DBxx.CO═ anΣ ß startu≡ ì
file called STARTUP.DB, and your database file.

DB19.CO═á i≤á KAYPRO-ORIENTED¼á fo≥ eithe≥á thσá earl∙á non-vide∩ ì
capablσá model≤á likσá thσ KPI╔ anΣ KP┤ (prσ '84⌐á o≥á an∙á mode∞ ì
Kaypr∩á 1░á o≥ newe≥ '8┤ models«á  Fo≥ eithe≥ KP1░ o≥á newe≥á '8┤ ì
mode∞á owners¼á D┬á ha≤ aε excellen⌠ vide∩ screen«á  Iµá yo⌡á arσ ì
tryinτá t∩ ruε thi≤ prograφ oε ß non-Kaypr∩ machine¼á gooΣá luckí  ì
Unles≤á i⌠á caε imitatσ aε ADM-3┴ termina∞ thσ screeεá call≤á arσ ì
useless for you.

DB1╣áá i≤á ßá littlσá morσá BUSINESSá ORIENTEDá no≈áá theεáá it'≤ ì
predecessor≤á likσ DB18¼á 17¼á etc..«á  D┬ no≈ ha≤ ß COMPAN┘ NAM┼ ì
fielΣá anΣ n∩ longe≥ ha≤ ß Homσ phonσ field«á  Yo⌡ caεá als∩á no≈ ì
prin⌠á singlσá label≤á witΦá thσ SCA╬ optioε o≥á label≤á fo≥á al∞ ì
members with the standard 'M'ail option.

Oncσá yo⌡ havσ initiall∙ installeΣ DB.CO═ i⌠ wil∞ 'knowºá ho≈á t∩ ì
comσá u≡ al∞ b∙ itselµ thσ nex⌠ time«á  I⌠ create≤ ß filσá calleΣ ì
STARTUP.D┬áá whicΦá hold≤á al∞á thσá value≤á fo≥á video/no-video¼ ì
clock/no-clock¼ anΣ thσ namσ oµ thσ defaul⌠ databasσ filσ anΣ thσ ì
drive where it is located.

Thσá objec⌠ codσ i≤ generateΣ froφ Digita∞á Research'≤á CB80/LK8░ ì
compiler/linke≥ fo≥ Cbasic«  I⌠ i≤ fas⌠ anΣ ver∙ clean¼ jus⌠ takσ ì
ß looδ a⌠ you≥ database.da⌠ filσ anΣ yo⌡ wil∞ seσ thσ neat¼ easy-ì
to-understanΣá structurσá i⌠ uses«á  Al∞ field≤ arσ seperateΣá b∙ ì
quotatioεá mark≤ anΣ comma≤ anΣ al∞ alphß character≤á arσá alway≤ ì
converted to UPPER CASE automatically.

è{ Labels, Labels, Labels }

T∩á usσá an∙ oµ DB'≤ label-generatinτ option≤ yo⌡ neeΣ t∩ havσá ß ì
stocδ oµ standarΣ 1-u≡ label≤ ¿ 3-1/2ó ° 15/16ó continuou≤ )«

           D┬ does not support any other label sizes!

The mailing labels are generated to look like so:

                  _______________________________
                  |                             |
                  |  Company name               |
                  |  First name, last name      |
                  |  Street Address             |
                  |  City, State, Zip           |
                  |                             |
                  -------------------------------


{ Data Record Format }

The format of the data record is:

"FIRM","FIRST","LAST","ADDRESS","CITY","STATE","ZIP","PHONE",\
"DATE ENTERED"

Thi≤á i≤ ß fixeΣ recorΣ witΦ ß lengtΦ oµ 128«á  Iµ usinτ Wordsta≥ ì
iεá non-documen⌠ modσ yo⌡ wil∞ finΣ thσ linσ goe≤ ou⌠á t∩á columε ì
12╖á anΣá theε drop≤ t∩ thσ nex⌠ line«á  Thσ CR/L╞ pai≥á actuall∙ ì
count≤ a≤ 12╕ bu⌠ i≤ invisiblσ bu⌠ ABSOLUTEL┘ NECESSARY«á  Iµ yo⌡ ì
d∩á alte≥ yo⌡ database.da⌠ filσ - B┼ CAREFUL¼á yo⌡ mus⌠á maintaiε ì
thσ lengtΦ oµ 12╕ oε eacΦ anΣ ever∙ line«  Bes⌠ t∩ jus⌠ usσ D┬ t∩ ì
ente≥á anΣ deletσ membe≥ records«á  Iµ yo⌡ havσ deleteΣá ßá largσ ì
numbe≥á oµ member≤ theε usσ Wordstar'≤ CTRL-┘ t∩ deletσ thσ wholσ ì
line of the file containing the nulls.

      Example:  This is what a deleted entry looks like

"","","","","","","","",""

Al∞á thσá field≤ havσ beeε replaceΣ witΦ nul∞ (""⌐á strinτá chrs«  ì
Afte≥ runninτ SORT¼á al∞ oµ thesσ entrie≤ wil∞ bσ brough⌠ t∩á thσ ì
very top of the file for easy removal.

{ Phone ROLADEX }

Thσá ROLADE╪á optioεá stil∞ key≤ iε oε thσ firs⌠á lette≥á oµá thσ ì
lastnamσá entry«á  I⌠ wil∞ sho≈ thσ followinτ fo≥á eacΦá matchinτ ì
entry:

LASTNAME, FIRSTNAME   FIRMNAME   PHONE NUMBER



Therσ i≤ n∩ rea∞ neeΣ fo≥ an∙ furthe≥ documentatioε a≤ D┬ i≤ ver∙ ìèsimplσá t∩á operatσ anΣ i≤ completel∙á menu-driven«á  Jus⌠á thinδ ì
beforσáá pressinτá aεá optioεá ke∙á a≤á al∞á one-ke∙á input≤á arσ ì
automatically acted upon very quickly!


{ Problems, bugs, complaints??? }

╔ don'⌠ wan⌠ t∩ hea≥ abou⌠ themí

Onl∙ kidding¼ addres≤ you≥ mai∞ to:

                        STEVEN L. SANDERS
                 % Tampa Bay Kaypro User's Group
                        14 Cypress Drive
                      Palm Harbor, FL 33563

           [phone] voice (9a-5p Eastern ONLY!)

           Modem'ers can leave E-MAIL on any of these

                [phone]  300/1200  24 hrs
                [phone]  300/1200  24 hrs
                [phone]  300/1200  24 hrs