<div dir="ltr"><div>I actually thought I've done this before in -v table - but makes sense what you're saying about the index used</div><div>In this instance however, I wasn't changing field values for the index I was using but it was still going back to the first record I selected after I executed the 'select' command....so I must have something else wrong in that code when I was trying it</div><div><br></div></div><br><div class="gmail_quote"><div class="gmail_attr" dir="ltr">On Thu, Feb 28, 2019 at 2:52 PM Bill Randall <<a href="mailto:breadran01@gmail.com">breadran01@gmail.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">Not true, Richard<br>
<br>
We use -v processing to change record values all the time.<br>
The important thing is what you pointed out. Don't change the value of <br>
a field that is used as the index you are using.<br>
<br>
This saves filePro from having to process a record more than once.<br>
The records that pass -v processing are never selected. Only updated <br>
and the -v ends without selecting.<br>
<br>
Bill<br>
<br>
On 2/28/2019 12:29 PM, Richard D. Williams via Filepro-list wrote:<br>
> Yes, that is the point.<br>
><br>
> There are two places one should never change values is a real field on <br>
> a record, automatic processing and any -V processing.<br>
><br>
> Richard<br>
><br>
> On 2/28/2019 8:43 AM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
>> Yes that's correct - and I actually thought about that but when I <br>
>> initially wrote this it 'seemed' to work as I wanted except at the <br>
>> 'end' of the processing it loops back into what I'm looking for as <br>
>> far as valid records<br>
>> my command is<br>
>> rreport filename -f CoverSheet -u -a -v select<br>
>><br>
>> I will try to move the 'validation' part to CoverSheet and not in the <br>
>> 'select' processing table - I'll assume that's what you're referring to<br>
>><br>
>><br>
>> On Thu, Feb 28, 2019 at 9:21 AM Richard D. Williams <br>
>> <<a href="mailto:richard@appgrp.net" target="_blank">richard@appgrp.net</a> <mailto:<a href="mailto:richard@appgrp.net" target="_blank">richard@appgrp.net</a>>> wrote:<br>
>><br>
>> 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>
>> "90":438=cli(17);430=430{cli(17);cli(17)=cli(17)+"1";write:<br>
>><br>
>> This is probably changing the index you loaded on your menu line<br>
>> 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<br>
>> real field values on any record.<br>
>> The associated output processing table would be the place for<br>
>> 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<br>
>> 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>
>><br>
>> On 2/28/2019 7:18 AM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a><br>
>> <mailto:<a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>> wrote:<br>
>>> Duly noted - I fixed that part as well<br>
>>><br>
>>> But still getting same issue - runs through the records that are<br>
>>> 'validated' but then starts over and it says Number Already<br>
>>> Assigned on the first record it assigned the number to during the<br>
>>> process itself?<br>
>>><br>
>>> Index being used is just a normal index<br>
>>><br>
>>> On Wed, Feb 27, 2019 at 10:54 PM Richard D. Williams via<br>
>>> Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a><br>
>>> <mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>>> wrote:<br>
>>><br>
>>> 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<br>
>>> 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<br>
>>> correctly, then it<br>
>>> > shows error on that same first record 'Number Already <br>
>>> Assigned'<br>
>>> > So that tells me it's not getting to the next record even<br>
>>> after the<br>
>>> > 'validation' part....<br>
>>> > Hmm.....<br>
>>> ><br>
>>> > On Wed, Feb 27, 2019 at 2:09 PM Bill Randall<br>
>>> <<a href="mailto:breadran01@gmail.com" target="_blank">breadran01@gmail.com</a> <mailto:<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<br>
>>> data.<br>
>>> >><br>
>>> >> :yar(438) ne "":msgbox "Problem with"<14<15<"Number<br>
>>> Already Assigned";exit:<br>
>>> >><br>
>>> >> I believe, based on your code, that you really want 14<15<br>
>>> 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<br>
>>> pieces of<br>
>>> >> information<br>
>>> >>> from the end user - then counts and validates those<br>
>>> records before<br>
>>> >>> proceeding<br>
>>> >>> For some reason that I can't find it goes 'backwards' (in<br>
>>> my mind<br>
>>> >> anyways -<br>
>>> >>> I'm sure whoever may look at this and say it's not<br>
>>> backwards it's your<br>
>>> >> code<br>
>>> >>> - I get it haha)<br>
>>> >>> After it selects the first valid record, it does what<br>
>>> it's supposed to do<br>
>>> >>> but on the 2nd record it catches one of the 'validation'<br>
>>> issues that I'm<br>
>>> >>> filtering through first...if that makes sense<br>
>>> >>> First record, it grabs data from client file if it passes<br>
>>> and does<br>
>>> >>> everything right, but the 2nd record it says a field is<br>
>>> 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<br>
>>> 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<br>
>>> with"<14<15<"No Balance or<br>
>>> >>> Zero B<br>
>>> >>> alance";exit:<br>
>>> >>> :yar(14)="":msgbox "Problem with"<14<15<"No First <br>
>>> Name";exit:<br>
>>> >>> :yar(15)="":msgbox "Problem with"<14<15<"No Last <br>
>>> 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 -<br>
>>> 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<br>
>>> that meet my<br>
>>> >>> criteria<br>
>>> >>> The first record it finds, it adds data from 'client'<br>
>>> lookup, increments<br>
>>> >> it<br>
>>> >>> by 1 and does what it's supposed to - 2nd record (that<br>
>>> has already passed<br>
>>> >>> validation in my eyes) then says 'Problem with Mary Smith<br>
>>> Number Already<br>
>>> >>> assigned'<br>
>>> >>> But after the error, if I go look at the record, that<br>
>>> field is empty...?<br>
>>> >>><br>
>>> >>> Does anyone see an issue with what I'm doing in this<br>
>>> processing table?<br>
>>> >>><br>
>>> >>> I'm running this as rreport filename -f CoverSheet -u<br>
>>> -a -v select<br>
>>> >>> (the above code is in my select processing table - then<br>
>>> 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>
>>> >><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>
>>> <mailto:<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<br>
>>> 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:<br>
>>> <<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>
>>> <mailto:<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:<br>
>>> <<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>
>>> <mailto:<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>
>> <<a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" rel="noreferrer">http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient</a>><br>
>> Virus-free. <a href="http://www.avg.com" target="_blank" rel="noreferrer">www.avg.com</a><br>
>> <<a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" rel="noreferrer">http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient</a>><br>
>><br>
>><br>
>> <#m_-5512988116758715792_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2><br>
>><br>
><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <br>
> <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190228/9e0eb91f/attachment.html" target="_blank" rel="noreferrer">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190228/9e0eb91f/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>
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>
</blockquote></div>