.CW10 COMM.CM i se o dBaseII(tm comman file designe t wor i conjunctio wit Do Morrison' FAMILY.LBR FAMILY.LB i writte t kee trac o member o Churc congregation an sor th variou mailing t differen group withi th Churc body COMM.CM i designe t maintai trac o membes o th Church' donatio an communio records Th system a i i package here i writte t ru unde m versio o dBaseI (3.9B) I ca b upgrade t mor advance versio wit littl work however hav no bee inspired becaus CP/ an ge alon quit fine probabl wil remai i thi world becaus hav tw system tha ar doin jus fin fo me Wh need 640 o memor d fin wit 64K. hav t admit borrowe th mai men tha thi progra use fro Do Morrison A result hav lef hi signatur o th menu becaus fee i i hi righ t b advertised H originall create th menu an borrowe i t kee th system a loo-alikes fee tha th tw dBas librarie wil b use together an loo-alik menu mak on fee a home. Th res o th cod i m ow creation I i mad u o th followin databases an thei structure follow: STRUCTURE FOR FILE: IDDATA.DBF NUMBER OF RECORDS: 00001 DATE OF LAST UPDATE: 02/20/90 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 IN:NUMBER N 005 ** TOTAL ** 00006 STRUCTURE FOR FILE: COMMUNE.DBF NUMBER OF RECORDS: 00026 DATE OF LAST UPDATE: 02/20/90 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 NAME C 022 002 DATE C 008 003 MEMID N 004 ** TOTAL ** 00035 STRUCTURE FOR FILE: CONGRE.DBF NUMBER OF RECORDS: 00005 DATE OF LAST UPDATE: 02/20/90 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 LAST:NAME C 020 002 FIRST:NAME C 020 003 ADDRESS C 025 004 CITY C 020 005 STATE C 002 006 ZIP C 005 007 ENV:NO N 003 008 DONATIONS N 008 002 009 COMMUNE N 004 010 MEMID N 004 011 LAST:ATTEN N 006 ** TOTAL ** 00118 STRUCTURE FOR FILE: DONATE.DBF NUMBER OF RECORDS: 00017 DATE OF LAST UPDATE: 02/20/90 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 ENV:NO N 004 002 DONATION C 015 003 AMOUNT N 007 002 004 DATE C 008 ** TOTAL ** 00035 Databas IDDAT i recor keepin on spo databas tha maintain th curren identificatio numbe fo assignin t th nex membe wh wil joi th congregation I i accesse onl whe ne membe i adde t th rolls an assign him/he a identificatio number Thi i don t preven th duplicatio o membe identificatio whe searchin fo specifi person communio records Databas CONGR i th mai informatio databas upo whic al informatio revolves Thi databas contain th firs an las name address envelop number an record o th tota amoun donate t th church th tota numbe o communion a wel a th las tim th perso commune b date Thi informatio i automaticall poste t th databas recor a additiona informatio i adde t th donat an communio databases Ther i metho t b abl t recal thi informatio an displa i a i i needed Th informatio i presente o th scree b th routin COMM-4.CMD Thi routin coul easil b protecte b puttin passwor int i i to man peopl hav acces t th computer hav no ha th requiremen t d thi becaus th syste ha onl bee runnin o m persona micros bu i a offic atmosphere ca se problems Additiona routine the coul b create i thi informatio i no t b see b mor tha th Pastor On routin coul giv th basi informatio (suc a name address etc whil th othe coul b earmarke fo specifi individual i th Churc organizatio wit th prope nee t know. COMMUNE.DB store th name dat o communion an th membe identificatio number Th membe identificatio numbe i th onl wa t verif tha member o famil wh hav th sam firs initia ar actuall presen i th database Th fiel NAM consist o th firs initia an las nam o th membe o th congregatio wh ha take communion Thi lef drawbac o actuall bein abl t sor th multipl A.Jone wher coul b And i on cas an Arlen i anothe case adde th membe I t ge awa fro thi problem lef th nam becaus ther coul b tim wher yo neede t se ho man record on perso ha (i.e th numbe o time commune i certai yea o month fo som repor o othe tha i require b th overseein Churc body DONATE.DB i recor o al contribution o an member o th congregation I i earmarke o th standar metho o trackin fo man Churches tha i b envelop numbers Th envelop numbe i poste t th CONGR database whic i thenindexe b thes numbers an tha index i tur give th trackin o th tota tha i poste t th mai record Th recor i DONATE.DB give a amount reaso fo th donatio (i.e 'envelope i automaticall entere wit blan fiel o specia causes ca b entered.) an th dat o th donation. Thi progra work ver effectivel wit ou Churc Congregation grou o 45 communican members I take som tim t originall se u th database an fil i wit data bu th spee t postin dat i marke improvemen ove th manua postin t cards no hav th proble o persuadin th Churc t obtai a ol CP/ compute system or eve a IB compatabl runnin dBaseII o dBaseIV I the woul bu on o them woul b translatin th softwar fo them. Preparation t us Comm.cmd Befor settin u record fo you congregation us th .db file hav create here an pla aroun wit th comman files I wil giv yo fee fo th operation o th databas system Whe yo ar comfortable creat ne dis fo th .db file an th .nd files The shoul b locate i driv B o you syste a th cod i now Al th comman file shoul b include o you dBas disk whic shoul b i driv A: I yo ar usin har dis system yo wil hav t mak mino modification t m code (Al databas an inde file ar name 'b:filename' Thi wil hav t b change t eithe jus 'filename o us th prope driv identifie 'xx:filename wher x i you driv identifier. Us dBas t delet al record fro th abov liste databas file EXCEP IDDATA.DBF Pac th databases an don' forge t r-inde th empt database t reinitializ th indexes Th indexe ar a follow wit th databas involved: Congre.db Inde o last:nam t name Inde o env:n t cenv Donate.db Inde o env:n t denv Edi recor 000 o databas IDDATA an rese th numbe i fiel in:numbe t b "1 (o whateve you congregatio consider t b th firs membe number Fro here yo ar read t begi fillin i th database an pu the t use. Enjo th softwar tha hav forwarde t th Publi Domain I wil d wha hav writte about bu wil no produc an reports canno writ report fo other withou knowin wha the need s decide t leav th repor writin t th users a sendin th cod t d th countin an posting an leav yo t you defense fo repor writing. I yo hav an question o problems ca b reache a th followin addres o th Arm Militar Network: pvpullen@crdec2.apgea.army.mil M landlin i (301 67-251 (work o (301 86-293 a hom (5:00p t 8:00p Easter time) M hom addres is: 810 Sagramor Road Baltimore M 21237