<div dir="ltr"><div dir="ltr"><div>Yes that's correct - and I actually thought about that but when I initially wrote this it 'seemed' to work as I wanted except at the 'end' of the processing it loops back into what I'm looking for as far as valid records</div><div>my command is  </div><div><span style="text-align:left;color:rgb(34,34,34);text-transform:none;text-indent:0px;letter-spacing:normal;font-family:Arial,Helvetica,sans-serif;font-size:13.33px;font-style:normal;font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inline;white-space:normal;float:none;background-color:rgb(255,255,255)">rreport filename -f CoverSheet -u -a -v select</span></div><div><span style="text-align:left;color:rgb(34,34,34);text-transform:none;text-indent:0px;letter-spacing:normal;font-family:Arial,Helvetica,sans-serif;font-size:13.33px;font-style:normal;font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inline;white-space:normal;float:none;background-color:rgb(255,255,255)"><br></span></div><div><span style="text-align:left;color:rgb(34,34,34);text-transform:none;text-indent:0px;letter-spacing:normal;font-family:Arial,Helvetica,sans-serif;font-size:13.33px;font-style:normal;font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inline;white-space:normal;float:none;background-color:rgb(255,255,255)">I will try to move the 'validation' part to CoverSheet and not in the 'select' processing table - I'll assume that's what you're referring to</span></div><div><span style="text-align:left;color:rgb(34,34,34);text-transform:none;text-indent:0px;letter-spacing:normal;font-family:Arial,Helvetica,sans-serif;font-size:13.33px;font-style:normal;font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inline;white-space:normal;float:none;background-color:rgb(255,255,255)"><br></span></div></div></div><br><div class="gmail_quote"><div class="gmail_attr" dir="ltr">On Thu, Feb 28, 2019 at 9:21 AM Richard D. Williams <<a href="mailto:richard@appgrp.net">richard@appgrp.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
  
    
  
  <div bgcolor="#FFFFFF">
    I suggest you use a msgbox yar(@RN) right after your "not yar" line.<br>
    <br>
    Oops, I think I found it. This seems like a -V table, correct?<br>
    In your code you are changing the value of the record you are on;<br>
    <font color="#ff0000">"90":438=cli(17);430=430{cli(17);cli(17)=cli(17)+"1";write:<br>
      <br>
      <font color="#000000">This is probably changing the index you
        loaded on your menu line and therefore moving you to a different
        location on the index.<br>
        The next record would be one that would not be valid.<br>
        <br>
        -V code is meant to be used to select/sort only, not to change
        real field values on any record. <br>
        The associated output processing table would be the place for
        these value changes.<br>
        <br>
        Please send me the full menu command you are using.<br>
        You have a basic design issue here that can be resolved quickly
        once the full purpose is known.<br>
        <br>
        Happy to help. You can call me directly at (713) 931-9938.<br>
        <br>
        Richard D. Williams<br>
        <br>
        <br>
      </font></font><br>
    <div class="gmail-m_-5512988116758715792moz-cite-prefix">On 2/28/2019 7:18 AM,
      <a class="gmail-m_-5512988116758715792moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
    </div>
    <blockquote type="cite">
      
      <div dir="ltr">
        <div>Duly noted - I fixed that part as well</div>
        <div><br>
        </div>
        <div>But still getting same issue - runs through the records
          that are 'validated' but then starts over and it says Number
          Already Assigned on the first record it assigned the number to
          during the process itself? </div>
        <div><br>
        </div>
        <div>Index being used is just a normal index </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div class="gmail_attr" dir="ltr">On Wed, Feb 27, 2019 at 10:54
          PM Richard D. Williams via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>>
          wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">It
          also loks to me that youo have another error in your logic.<br>
          <br>
          Here you do a lookup using key  fb with exact match. I assume
          you only <br>
          want to evaluate records where fb eq yar(431).<br>
          Is index E build on 431?<br>
          If yes than see the adjusted code below.<br>
          <br>
          valid::lookup yar = PDM  k=fb   i=E -nx:<br>
          yarloop:not yar:goto counted:<br>
          :yar(437) ne fa:goto counted:<br>
          :yar(431) ne fb:getnext yar;goto yarloop:<br>
          <br>
          <br>
          valid::lookup yar = PDM k=fb i=E -nx:<br>
          yarloop:not yar:goto counted:<br>
          :yar(431) ne fb:goto counted:<br>
          :yar(437) ne fa:getnext yar;goto yarloop:<br>
          <br>
          Richard D. Williams<br>
          <br>
          On 2/27/2019 1:35 PM, scooter6--- via Filepro-list wrote:<br>
          > Doh - true story<br>
          > After fixing that - it does still do the first record
          correctly, then it<br>
          > shows error on that same first record 'Number Already
          Assigned'<br>
          > So that tells me it's not getting to the next record even
          after the<br>
          > 'validation' part....<br>
          > Hmm.....<br>
          ><br>
          > On Wed, Feb 27, 2019 at 2:09 PM Bill Randall <<a href="mailto:breadran01@gmail.com" target="_blank">breadran01@gmail.com</a>> wrote:<br>
          ><br>
          >> I am not sure but I do notice one thing.<br>
          >><br>
          >> Your message box statements are showing you the
          incorrect data.<br>
          >><br>
          >> :yar(438) ne "":msgbox "Problem
          with"<14<15<"Number Already Assigned";exit:<br>
          >><br>
          >> I believe, based on your code, that you really want
          14<15 to really be<br>
          >> yar(14)<yar(15)<br>
          >><br>
          >> Just that alone may shed some light on your data.<br>
          >><br>
          >> Bill<br>
          >><br>
          >><br>
          >> On 2/27/2019 1:59 PM, scooter6--- via Filepro-list
          wrote:<br>
          >>> I am trying to make a processing table that takes
          two pieces of<br>
          >> information<br>
          >>> from the end user - then counts and validates
          those records before<br>
          >>> proceeding<br>
          >>> For some reason that I can't find it goes
          'backwards' (in my mind<br>
          >> anyways -<br>
          >>> I'm sure whoever may look at this and say it's
          not backwards it's your<br>
          >> code<br>
          >>> - I get it haha)<br>
          >>> After it selects the first valid record, it does
          what it's supposed to do<br>
          >>> but on the 2nd record it catches one of the
          'validation' issues that I'm<br>
          >>> filtering through first...if that makes sense<br>
          >>> First record, it grabs data from client file if
          it passes and does<br>
          >>> everything right, but the 2nd record it says a
          field is not empty (but it<br>
          >>> is)<br>
          >>> Here is my code:<br>
          >>><br>
          >>> :fa="":input fa(5,0RJ,g) "Enter Client Number ":<br>
          >>> :fb="":input fb(8,mdy/,g) "Enter Placement Date
          ":<br>
          >>> :fa="" or fb="":exit:<br>
          >>> ::goto valid:<br>
          >>> ::end:<br>
          >>> valid::lookup yar = PDM  k=fb   i=E -nx:<br>
          >>> yarloop:not yar:goto counted:<br>
          >>> :yar(437) ne fa:goto counted:<br>
          >>> :yar(431) ne fb:getnext yar;goto yarloop:<br>
          >>> :yar(438) ne "":msgbox "Problem
          with"<14<15<"Number Already Assigned";exi<br>
          >>> t:*    SECOND RECORD FOUND ERRORS HERE*<br>
          >>> :yar(432)="":msgbox "Problem
          with"<14<15<"No DOO";exit:<br>
          >>> :yar(435)="" or yar(435)=".00":msgbox "Problem
          with"<14<15<"No Balance or<br>
          >>> Zero B<br>
          >>> alance";exit:<br>
          >>> :yar(14)="":msgbox "Problem
          with"<14<15<"No First Name";exit:<br>
          >>> :yar(15)="":msgbox "Problem
          with"<14<15<"No Last Name";exit:<br>
          >>> :yar(23)="":msgbox "Problem
          with"<14<15<"No Address";exit:<br>
          >>> :yar(24)="":msgbox "Problem
          with"<14<15<"No City";exit:<br>
          >>> :yar(25)="":msgbox "Problem
          with"<14<15<"No State";exit:<br>
          >>> :yar(26)="":msgbox "Problem
          with"<14<15<"No Zip";exit:<br>
          >>> :yar(439) ne "01" and yar(439) ne "66":msgbox
          "Problem<br>
          >> with"<14<15<"Status<br>
          >>> is"<y<br>
          >>> ar(439);exit:<br>
          >>> :yar(437)=fa and yar(431)=fb:x(10,.0,g)=x+"1":<br>
          >>> ::getnext yar;goto yarloop:<br>
          >>> ::end:<br>
          >>> counted:x="0":msgbox "No Records Selected";exit:<br>
          >>> :fc="":input popup fc(1,yesno,g)"I
          found"<x<"Accounts - Is this correct?<br>
          >> ":<br>
          >>> :fc ne "Y":exit:<br>
          >>> ::goto client:<br>
          >>> ::end:<br>
          >>> client::lookup cli = client  k=437  i=A -nx:<br>
          >>> :not cli:msgbox "Client"<437<"Not
          Found!";exit:<br>
          >>> :cli(72)="90":msgbox "Client"<437<"is
          Inactive!";exit:<br>
          >>> :cli and cli(72) ne<br>
          >>>
          "90":438=cli(17);430=430{cli(17);cli(17)=cli(17)+"1";write:<br>
          >>> ::end:<br>
          >>> ::goto selectm:<br>
          >>> selectm:437=fa and 431=fb and 438 ne
          "":select;end:<br>
          >>><br>
          >>> So everything works fine- it correctly finds 3
          records that meet my<br>
          >>> criteria<br>
          >>> The first record it finds, it adds data from
          'client' lookup, increments<br>
          >> it<br>
          >>> by 1 and does what it's supposed to - 2nd record
          (that has already passed<br>
          >>> validation in my eyes) then says 'Problem with
          Mary Smith Number Already<br>
          >>> assigned'<br>
          >>> But after the error, if I go look at the record,
          that field is empty...?<br>
          >>><br>
          >>> Does anyone see an issue with what I'm doing in
          this processing table?<br>
          >>><br>
          >>> I'm running this as     rreport filename -f
          CoverSheet -u -a -v select<br>
          >>> (the above code is in my select processing table
          - then it's supposed to<br>
          >>> pass those records to CoverSheet)<br>
          >>><br>
          >>> Thanks<br>
          >>><br>
          >>> Scott<br>
          >>> PDM<br>
          >>> -------------- next part --------------<br>
          >>> An HTML attachment was scrubbed...<br>
          >>> URL: <<br>
          >> <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/82205474/attachment.html" target="_blank" rel="noreferrer">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/82205474/attachment.html</a><br>
          >>> _______________________________________________<br>
          >>> Filepro-list mailing list<br>
          >>> <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
          >>> Subscribe/Unsubscribe/Subscription Changes<br>
          >>> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank" rel="noreferrer">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
          >><br>
          >> ---<br>
          >> This email has been checked for viruses by Avast
          antivirus software.<br>
          >> <a href="https://www.avast.com/antivirus" target="_blank" rel="noreferrer">https://www.avast.com/antivirus</a><br>
          >><br>
          >><br>
          > -------------- next part --------------<br>
          > An HTML attachment was scrubbed...<br>
          > URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/bd52e8dc/attachment.html" target="_blank" rel="noreferrer">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/bd52e8dc/attachment.html</a>><br>
          > _______________________________________________<br>
          > Filepro-list mailing list<br>
          > <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
          > Subscribe/Unsubscribe/Subscription Changes<br>
          > <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank" rel="noreferrer">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
          ><br>
          <br>
          <br>
          <br>
          ---<br>
          This email has been checked for viruses by AVG.<br>
          <a href="https://www.avg.com" target="_blank" rel="noreferrer">https://www.avg.com</a><br>
          -------------- next part --------------<br>
          An HTML attachment was scrubbed...<br>
          URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/a44f222a/attachment.html" target="_blank" rel="noreferrer">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/a44f222a/attachment.html</a>><br>
          _______________________________________________<br>
          Filepro-list mailing list<br>
          <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
          Subscribe/Unsubscribe/Subscription Changes<br>
          <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank" rel="noreferrer">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
        </blockquote>
      </div>
    </blockquote>
    <br>
  <div id="gmail-m_-5512988116758715792DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top-color:rgb(211,212,222);border-top-width:1px;border-top-style:solid">
        <tbody><tr>
        <td style="width:55px;padding-top:13px"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img width="46" height="29" style="width: 46px; height: 29px;" alt="" src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png"></a></td>
                <td style="width:470px;color:rgb(65,66,78);line-height:18px;padding-top:12px;font-family:Arial,Helvetica,sans-serif;font-size:13px">Virus-free. <a style="color:rgb(68,83,234)" href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank">www.avg.com</a>
                </td>
        </tr>
</tbody></table><a href="#m_-5512988116758715792_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" height="1" width="1"> </a></div></div>

</blockquote></div>