Re: JB 3.10 ON WINDOWS 7

[Charlie Noah]

Hi Dave, I have some ideas and some utilities I'll email you tomorrow. I have some problems with my online store I'll need to deal with first, though. Charlie On 12-29-2014 8:57 PM, David Grenfell wrote: Well , I’m stumped and probably need your help on this one.   I have actually done a DELETE-INDEX and a CREATE-INDEX .  My create is really simple..    CREATE-INDEX MEMBERS ENV BY 15 .  Att 15 holds my envelope number.   If I add a dummy member to my MEMBERS FILE, with an envelope number 99 , it shows up in my “on file” list. If I add another dummy member with another number, it shows up also.   If I delete the second record again, the envelope shows up on my “envelopes available” list as it should If I delete the record with envelope #99, it does not show up on my “available list”   I have researched my files and have deleted a couple of records that I thought might be corrupted, but no cigar.     Dave.   From: David Grenfell Sent: Sunday, December 28, 2014 3:04 PM To: jbase@googlegroups.com Subject: JB 3.10 ON WINDOWS 7   Gentlemen:   I have a quandary:   Following is some code I am using in a small program to develop a final result of displaying/printing a list of Unused membership numbers for a church.   I have an index built so that I can select members either by envelope number as well as by ID   I have initialized EQUATE ENV.NO TO MEMBERS.REC(15)   113 FOR ENVELOPE.NO = BEG.ENV TO END.ENV  (set as 1 to 300) 114    SELECT ENV.INDEX ATKEY ENVELOPE.NO 115    READNEXT KEY index.key,MEMBER THEN 116       MATREAD MEMBERS.REC FROM MEMBERS.FILE, MEMBER ELSE MAT MEMBERS.REC = 117         ** ENV.NO IS MEMBERS.REC(15) 118       CRT "ENV.NO = " : ENV.NO :" index.key = " : index.key : "  ENVELOPE.N”  (this just debugging stuff) 119       IF ENV.NO = ENVELOPE.NO THEN 120 *its on file so skip* 121          NULL 122       END ELSE 123 * its not on file so add it to the list 124          ENV.LIST = ENV.LIST : ENVELOPE.NO : VM 125       END 126    END 127 NEXT ENVELOPE.NO   So, the loop should pull every number from 1 to 300 and look it up in the index and if it cannot match the number with the the members record, then assume it is not there.  It seems to work except 99 is missing in my loop .   Here is a segment of the sample data coming off the above code   ENV.NO = 96 index.key = 96  ENVELOPE.NO = 96  MEMBER ISSCHAEF RIC ENV.NO = 97 index.key = 97  ENVELOPE.NO = 97  MEMBER ISFROOK HAR ENV.NO = 98 index.key = 98  ENVELOPE.NO = 98  MEMBER ISGATEMA IRE ENV.NO = 100 index.key = 100  ENVELOPE.NO = 100  MEMBER ISGEBHAR ELA ENV.NO = 101 index.key = 101  ENVELOPE.NO = 101  MEMBER ISMOYER KRI ENV.NO = 102 index.key = 102  ENVELOPE.NO = 102  MEMBER ISSCHUKN MAU   My question is, why is my envelope.no 99 missing from the loop.  I am teary eyed looking for this.   Dave Grenfell             -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum.   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum.   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum.   To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.