home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload / ShartewareOverload.cdr / database / workdb.zip / DATABASE.DOC < prev    next >
Text File  |  1983-01-04  |  9KB  |  181 lines
  1.             THE AMATEUR COMPUTER GROUP OF NEW JERSEY
  2.  
  3.                               SIG/M
  4.  
  5.                 LIBRARY OF PUBLIC DOMAIN SOFTWARE
  6.  
  7.         A dBASEII Program by Steve Leon for ............
  8.  
  9.             DISK INVENTORY            ORDER PROCESSING
  10.               SHIPPING                   DISK LABELS
  11.  
  12.  
  13.  
  14.  
  15.  
  16.  
  17.  
  18.                           DOCUMENTATION
  19.  
  20.  
  21.  
  22.  
  23.                           INTRODUCTION
  24.  
  25.  
  26.      Iεá SIG/═ Volumσ 11░ wσ issueΣ thσ ACGN╩ datß basσ a≤ botΦ ß 
  27. workinτá datßá basσ anΣ ß tutoria∞ iεá dBASEII«á Tha⌠á serie≤á oµ 
  28. modules¼á patterneΣá afte≥ Adaφ Green'≤ dBASEI╔ USER'╙ GUIDE¼á i≤ 
  29. actuall∙ ß modificatioε oµ ß serie≤ oµ workinτ datß base≤ wσá ruε 
  30. oεá IB═á Displaywriters«á  Thσ ACGN╩ datß basσá work≤á well¼á bu⌠ 
  31. becausσá i⌠á wa≤ intendeΣ t∩ bσ ß tutoria∞ i⌠ lack≤ somσá oµá thσ 
  32. "tricks" use to speed up dBASE application programs.
  33.  
  34.      Oεá thσ ACGN╩ datß basσ wσ als∩ useΣ separatσ screeεá files« ì
  35. Thσá reasoεá fo≥ thi≤ wa≤ t∩ allo≈ yo⌡ t∩ adap⌠ i⌠ fo≥á you≥á owε ì
  36. need≤ witΦ ease«á However¼ fo≥ maximuφ speeΣ disδ call≤ shoulΣ bσ ì
  37. a⌠ ß minimuφ anΣ screen≤ shoulΣ thereforσ bσ iε thσ commanΣ file.
  38.  
  39.  
  40.                        THIS NEW DATA BASE
  41.  
  42.      SIG/═ haΣ somσ problem≤ witΦ shippinτ anΣ inventor∙á manageì
  43. ment¼á al∞ oµ whicΦ werσ solveΣ wheε Gleε DuscΦ tooδ ove≥ contro∞ ì
  44. oµá tha⌠á operation«á Gleεá pu⌠á thσ record≤á int∩á dBAS┼á a≤á aε ì
  45. interactivσá datßá base«á Havinτ jus⌠ purchaseΣ thσá firs⌠á dBAS┼ ì
  46. prograφ generato≥ tha⌠ ╔ wa≤ satisfieΣ with¼á FASTBASE¼ ╔ createΣ ì
  47. aεáá inventor∙á managemen⌠á prograφá fo≥á Gleεá arounΣá thσá datß ì
  48. structurσ hσ haΣ created«á However¼ onσ thinτ FASTBAS┼ diΣ no⌠ d∩ ì
  49. wa≤ allo≈ multiplσ additioε oµ record≤ withou⌠ puttinτ eacΦ addeΣ ì
  50. recorΣá int∩ thσ index«á Stevσ Takifµ oµ Fourcolo≥ Datßá Systems¼ ì
  51. thσá autho≥á oµá FASTBASE¼á indicateΣá tha⌠á mos⌠á peoplσá prefe≥ ì
  52. indexinτá witΦ eacΦ record¼á bu⌠ witΦ thσ SIG/═ orde≥á volumσá wσ ì
  53. though⌠ i⌠ advisablσ t∩ modif∙ thσ program.Wha⌠ starteΣ ou⌠ a≤ ß ì
  54. simplσá modificatioε becamσ ß rewritσ oµ thσ datß basσ incorporaì
  55. tinτ thσ feature≤  oµ FASTBASE«                             è                     HOW TO USE THE PROGRAM
  56.  
  57.      Extrac⌠á al∞ oµ thσ file≤ froφ thσ .LB╥ filσ ont∩ you≥ dBAS┼ ì
  58. disk« Thσ inde° filσ anΣ tw∩ datß file≤ (.ND╪ anΣ .DBF⌐ caε bσ oε ì
  59. anothe≥á disk«á (Yo⌡ caε put you≥ prograφ file≤ oε an∙ disδá jus⌠ ì
  60. s∩ lonτ a≤ yo⌡ se⌠ you≥ defaul⌠ t∩ tha⌠ drive......Don'⌠ laugΦ a⌠ ì
  61. mσá fo≥á makinτá sucΦ aε obviou≤ statement¼á bu⌠á ╔á spokσá t∩á ß ì
  62. gentlemeεá livinτá '50░ mile≤ nortΦ oµ Torontoº wh∩ calleΣá afte≥ ì
  63. spendinτá halµ ß nigh⌠ gettinτ thσ messagσ tha⌠ thσ commanΣá filσ ì
  64. coulΣ no⌠ bσ found«áì
  65.  
  66.      Thσ prograφ i≤ selµ explanatory«á Fo≥ spacσ reason≤ wσá havσ ì
  67. includeΣá onl∙á ßá fe≈ made-u≡ orde≥ files«á Thσá ful∞á list≤á oµ ì
  68. volume≤á witΦ somσ made-u≡ datß i≤ includeΣ iε STOCK.DBF¼á in case      ì
  69. yo⌡á wan⌠ t∩ labe∞ you≥ SIG/═ volumes«á  Oncσ yo⌡ havσ i⌠ u≡á anΣ ì
  70. runninτ looδ a⌠ thσ codσ anΣ theε begiε thσ joΓ oµ adaptinτ i⌠ t∩ 
  71. you≥ owε requirement≤ (o≥ takσ advantagσ oµ thσ routine≤ anΣ reaΣ 
  72. theφá int∩ you≥ programs)«á Wheε ╔ writσ ß ne≈ applicatioεá usinτ 
  73. thi≤á serie≤á oµ prograφ module≤ ╔ usuall∙ firs⌠ definσ thσá datß 
  74. basσ field≤ anΣ theε usσ FASTBAS┼ o≥ ZI╨ t∩ creatσ ß screeε file« 
  75. WitΦ ß printou⌠ oµ thσ mode¼á lines¼á anΣ promp⌠ requirement≤á iε 
  76. hanΣá i⌠ i≤ ß relativel∙ simplσ tasδ t∩ creatσ ß screeε file«á T∩ 
  77. makσá i⌠ looδ professional¼á tr∙ t∩ linσ u≡ thσ datß a≤á mucΦá a≤ 
  78. possible« 
  79.  
  80.      EacΦá oµá thσá module≤  i≤ selµ explanator∙ anΣá jus⌠á abou⌠ ì
  81. ever∙á linσ iε theφ i≤ therσ fo≥ somσ reasoε (eveε iµ tha⌠ reasoε ì
  82. bσá ou≥ ignorance«á Therefore¼á wσ strongl∙ sugges⌠ yo⌡ reaΣá thσ ì
  83. code«á I⌠á i≤á relativel∙ eas∙ codσ t∩ reaΣ - havinτ beeεá prett∙ ì
  84. printeΣáá witΦá FASTBASE«áá (Thi≤á documentatioεá sounΣá likσáá ß ì
  85. commercia∞á anΣá i⌠á i≤á not«á Thσ fac⌠á i≤á tha⌠á dBASEI╔á i≤á ß ì
  86. magnificen⌠á prograφá anΣá FASTBAS┼ make≤ lifσ witΦ dBAS┼á ßá lo⌠ ì
  87. simpler.⌐á Oε ou≥ actua∞ operationa∞ prograφ wσ useΣ FASTBAS┼á t∩ ì
  88. "squishó al∞ line≤ oµ codσ flusΦ lef⌠ anΣ deleteΣ al∞ comment≤ t∩ ì
  89. increasσ runninτ speed.
  90.  
  91.      Thi≤ prograφ use≤ tw∩ searcΦ methods« Onσ searche≤ thσ inde° ì
  92. filσá fo≥ an∙ lastnamσ o≥ fractioε thereof«á Thσ othe≥ find≤á AN┘ ì
  93. strinτá iε AN┘ field«á Again¼á ╔ didn'⌠ writσ thσ latte≥ program¼ ì
  94. FASTBAS┼ diΣ - anΣ i⌠ i≤ great«á Tha⌠ program¼á SEARCH1.SI╟á als∩ ì
  95. include≤á aεá inde°á searcΦá witΦ ß teεá linσá fas⌠á search«á
  96.  
  97.      Yo⌡ wil∞ finΣ iε thσ prograφ usefu∞ bit≤ oµ information« Thσ ì
  98. ADD.SI╟ prograφ wherσ wσ reaΣ thσ order≤ int∩ thσ othe≥ datß basσ ì
  99. t∩ determinσ iµ the∙ arσ iε inventor∙ o≥ mus⌠ bσ bacδ ordereΣ anΣ ì
  100. theεá changσá thσá inventor∙ i≤ oµá use«á Thσá datσá verificatioε ì
  101. routinσ anΣ thσ drivσ selectioε routinσ arσ therσ fo≥ yo⌡ t∩ use¼ ì
  102. etc¼ etc¼ etc.
  103.  
  104.      Wσá decideΣá t∩á releasσ thi≤ t∩ thσ librar∙ anΣ t∩á thσá P├ ì
  105. librar∙ withou⌠ thσ opportunit∙ t∩ debuτ ove≥ aε extendeΣá perioΣ ì
  106. oµ time«á Wσ thinδ wσ havσ al∞ thσ majo≥ bug≤ (some¼á sucΦ a≤ ou≥ ì
  107. selectioεá oµá thσá updatσá datσá iε report≤á arσá no⌠á bug≤á bu⌠ ì
  108. intentional)« Wσ havσ noticeΣ goinτ iε anΣ ou⌠ oµ thσ .LB╥ forma⌠ ì
  109. tha⌠ fo≥ somσ reasoε wσ migh⌠ losσ ß letter«á Fo≥ thi≤ reason¼ wσ ìèuseΣ colon≤ t∩ makσ lonτ line≤ iε thσ repor⌠ file≤ int∩á multiplσ ì
  110. linσ anΣ tooδ ou⌠ thσ prett∙ prin⌠ oµ thosσ files«á N∩ prograφ a≤ ì
  111. comprehensivσá a≤ thi≤ onσ i≤ eve≥ stay≤ thσ samσ froφ da∙ t∩ da∙ ì
  112. - s∩á iµá yo⌡ comσ u≡ witΦ somσ gooΣ addition≤á - pleasσá le⌠á u≤ ì
  113. know.
  114.  
  115.                     CHANGES AND MODIFICATIONS
  116.  
  117.      Printe≥á code≤á arσ founΣ iε al∞ program≤ tha⌠ outpu⌠á t∩á ß ì
  118. printer«á Theyá arσá no≈ se⌠ u≡ fo≥ aε OKIDAT┴ 92¼á s∩ makσá you≥ ì
  119. change≤ accordingly«á Thσ prograφ SIG/M.CM─ allow≤ yo⌡ t∩á modif∙ ì
  120. thσá intensit∙á commanΣá - anΣ als∩ eacΦ oµ thσ screeεá filσá "I╞ ì
  121. FIRSTó contain≤ aε intensit∙ call« A⌠ al∞ oµ thσ point≤ wherσ yo⌡ ì
  122. havσ ß drivσ option¼ wσ allo≈ drive≤ A,B,C,─ anΣ M« ╔ sugges⌠ yo⌡ ì
  123. deletσá thσá drive≤á yo⌡á d∩ no⌠ havσá t∩á preven⌠á aεá erroneou≤ ì
  124. selection« (Wσ d∩ no⌠ allo≈ ß backu≡ t∩ ═ drive¼ however.⌐ 
  125.  
  126.                        THE DUAL DATA BASE
  127.  
  128.      Wσá havσ haΣ limiteΣ succes≤ witΦ usσ oµ dua∞ datß bases«á ╔ ì
  129. finΣá tha⌠ SELEC╘ PRIMAR┘ anΣ SELEC╘ SECONDAR┘ causσ morσátroublσ 
  130. thaεá the∙ arσ wortΦ anΣ thereforσ prefe≥ t∩ namσ thσá datßá basσ ì
  131. thσá switcΦá i≤ beinτ madσ to«á Whilσ thi≤ prograφ use≤ tw∩á datß ì
  132. base≤ - i⌠ i≤ no⌠ reall∙ ß dua∞ datß basσ sincσ thσ men⌡á prograφ ì
  133. merel∙á control≤ whicΦ onσ yo⌡ use«á ╔ d∩ usσ dBAS┼ program≤ tha⌠ ì
  134. transfe≥á betweeεá datßá base≤ froφ thσ maiε men⌡á anΣá froφá thσ ì
  135. searcΦá menu«á  Ever∙á s∩ often¼á inspitσ oµ al∞ oµá ou≥á CLEARs¼ ì
  136. RELEASEs¼ SE╘ INDE╪ TOs¼ anΣ USEs¼ ╔ stil∞ ge⌠ ß "TO╧ MAN┘ FILESó ì
  137. erro≥á messagσá anΣá ß do⌠ prompt«á Thi≤ probleφ exist≤á iεá thi≤ ì
  138. program« Iµ yo⌡ g∩ bacδ anΣ fortΦ betweeε thσ datß base≤ froφ thσ ì
  139. startinτ men⌡ - afte≥ abou⌠ ┤ change≤ yo⌡ wil∞ ge⌠ thσ "TO╧á MAN┘ ì
  140. FILESóá erro≥á message«á Therσá probabl∙ i≤ ßá simplσá answe≥á t∩ ì
  141. preven⌠á i⌠á (sor⌠ oµ likσ "CLEA╥ GETSó afte≥ al∞ read≤) - bu⌠á ╔ ì
  142. havσ no⌠ beeε ablσ t∩ solvσ it«á Iµ yo⌡ kno≈ how¼á pleasσ advise« ì
  143. Thσá savinτ facto≥ i≤ tha⌠ iε norma∞ usσ i⌠ jus⌠ no⌠ logica∞á fo≥ ì
  144. yo⌡á t∩á jum≡ bacδ anΣ fortΦ ┤ time≤ betweeε datß base≤ iεá rapiΣ ì
  145. order«á Iµá you≥ applicatioε doe≤ requirσ transfe≥á betweeεá datß ì
  146. bases¼ anΣ yo⌡ arσ carefu∞ t∩ closσ anΣ eliminatσ al∞ indexe≤ anΣ ì
  147. datß files¼ thσ followinτ codσ work≤ wel∞ oε thσ transfe≥ betweeε ì
  148. thσ two:
  149.  
  150.                 CASE COMMAND = 'T'
  151.                 * transfer to individual data base 
  152.                 RELEASE ALL
  153.                 USE
  154.                 STORE t TO first
  155.                 DO search.ind
  156.  
  157.  
  158.                             THE DATE
  159.  
  160.      Thσá datσá verificatioε camσ froφ aε issuσ oµ dNEWS«á I⌠á i≤ ì
  161. certainl∙á wortΦá using«áá Harr∙á Vaεá Tassel∞á wrotσá thσá drivσ ì
  162. selectioε codσ whicΦ include≤ aε interestinτ routinσ t∩ determinσ ì
  163. iµá thσ prograφ i≤ runninτ unde≥ CP/═ 8░ o≥ 86«á Hσ als∩ founΣá ß ìè"hidinτ placeó t∩ drivσ lette≥ storagσ anΣ contributeΣ man∙ othe≥ ì
  164. gooΣ idea≤ t∩ thσ programs.
  165.  
  166.  
  167.                            CONCLUSION
  168.  
  169.  
  170.      An∙ thoughts¼á comment≤ o≥ suggestion≤ woulΣ bσ appreciated« ì
  171. SIG/═á woulΣá als∩á appreciatσ donatioε oµ you≥á datßá base≤á fo≥ ì
  172. releasσá iεá thσ library«á Ou≥ order≤ reflec⌠ the∙á arσá mos⌠á iε ì
  173. demand behind ZCPR and the modem programs.
  174.  
  175.  
  176.                                        Steve Leon
  177.                                        200 Winston Drive
  178.                                        Cliffside Park, NJ 07010
  179.                                        (201) 886-1658
  180. August 26, 1983
  181.