<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Yes, that is the point.<br>
<br>
There are two places one should never change values is a real field
on a record, automatic processing and any -V processing.<br>
<br>
Richard<br>
<br>
<div class="moz-cite-prefix">On 2/28/2019 8:43 AM,
<a class="moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CADpQzqO5ki5968boh9-8ixEcEwF+zYC9fBeYO9MaG4HP-0MLEg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true">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"
moz-do-not-send="true">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" moz-do-not-send="true"><img
style="width: 46px; height: 29px;" alt=""
src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png"
moz-do-not-send="true" width="46" height="29"></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" moz-do-not-send="true">www.avg.com</a>
</td>
</tr>
</tbody>
</table>
<a
href="#m_-5512988116758715792_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"
height="1" width="1" moz-do-not-send="true"> </a></div>
</div>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>