<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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 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>
<pre class="moz-quote-pre" wrap="">valid::lookup yar = PDM k=fb i=E -nx:
yarloop:not yar:goto counted:
:yar(437) ne fa:goto counted:
:yar(431) ne fb:getnext yar;goto yarloop:</pre>
<br>
valid::lookup yar = PDM k=fb i=E -nx:<br>
yarloop:not yar:goto counted:<font color="#ff0000"><br>
:yar(431) ne fb:goto counted:</font><font color="#ff0000"><br>
:yar(437) ne fa:getnext yar;goto yarloop:</font>
<br>
<br>
Richard D. Williams<br>
<br>
<div class="moz-cite-prefix">On 2/27/2019 1:35 PM, scooter6--- via
Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CADpQzqPxU+RM=Ub=EcLg2jpvgypnhL2LF7caOWq22o2Wid36Sg@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">Doh - true story
After fixing that - it does still do the first record correctly, then it
shows error on that same first record 'Number Already Assigned'
So that tells me it's not getting to the next record even after the
'validation' part....
Hmm.....
On Wed, Feb 27, 2019 at 2:09 PM Bill Randall <a class="moz-txt-link-rfc2396E" href="mailto:breadran01@gmail.com"><breadran01@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">I am not sure but I do notice one thing.
Your message box statements are showing you the incorrect data.
:yar(438) ne "":msgbox "Problem with"<14<15<"Number Already Assigned";exit:
I believe, based on your code, that you really want 14<15 to really be
yar(14)<yar(15)
Just that alone may shed some light on your data.
Bill
On 2/27/2019 1:59 PM, scooter6--- via Filepro-list wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">I am trying to make a processing table that takes two pieces of
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">information
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">from the end user - then counts and validates those records before
proceeding
For some reason that I can't find it goes 'backwards' (in my mind
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">anyways -
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">I'm sure whoever may look at this and say it's not backwards it's your
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">code
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">- I get it haha)
After it selects the first valid record, it does what it's supposed to do
but on the 2nd record it catches one of the 'validation' issues that I'm
filtering through first...if that makes sense
First record, it grabs data from client file if it passes and does
everything right, but the 2nd record it says a field is not empty (but it
is)
Here is my code:
:fa="":input fa(5,0RJ,g) "Enter Client Number ":
:fb="":input fb(8,mdy/,g) "Enter Placement Date ":
:fa="" or fb="":exit:
::goto valid:
::end:
valid::lookup yar = PDM k=fb i=E -nx:
yarloop:not yar:goto counted:
:yar(437) ne fa:goto counted:
:yar(431) ne fb:getnext yar;goto yarloop:
:yar(438) ne "":msgbox "Problem with"<14<15<"Number Already Assigned";exi
t:* SECOND RECORD FOUND ERRORS HERE*
:yar(432)="":msgbox "Problem with"<14<15<"No DOO";exit:
:yar(435)="" or yar(435)=".00":msgbox "Problem with"<14<15<"No Balance or
Zero B
alance";exit:
:yar(14)="":msgbox "Problem with"<14<15<"No First Name";exit:
:yar(15)="":msgbox "Problem with"<14<15<"No Last Name";exit:
:yar(23)="":msgbox "Problem with"<14<15<"No Address";exit:
:yar(24)="":msgbox "Problem with"<14<15<"No City";exit:
:yar(25)="":msgbox "Problem with"<14<15<"No State";exit:
:yar(26)="":msgbox "Problem with"<14<15<"No Zip";exit:
:yar(439) ne "01" and yar(439) ne "66":msgbox "Problem
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">with"<14<15<"Status
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">is"<y
ar(439);exit:
:yar(437)=fa and yar(431)=fb:x(10,.0,g)=x+"1":
::getnext yar;goto yarloop:
::end:
counted:x="0":msgbox "No Records Selected";exit:
:fc="":input popup fc(1,yesno,g)"I found"<x<"Accounts - Is this correct?
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">":
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">:fc ne "Y":exit:
::goto client:
::end:
client::lookup cli = client k=437 i=A -nx:
:not cli:msgbox "Client"<437<"Not Found!";exit:
:cli(72)="90":msgbox "Client"<437<"is Inactive!";exit:
:cli and cli(72) ne
"90":438=cli(17);430=430{cli(17);cli(17)=cli(17)+"1";write:
::end:
::goto selectm:
selectm:437=fa and 431=fb and 438 ne "":select;end:
So everything works fine- it correctly finds 3 records that meet my
criteria
The first record it finds, it adds data from 'client' lookup, increments
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">it
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">by 1 and does what it's supposed to - 2nd record (that has already passed
validation in my eyes) then says 'Problem with Mary Smith Number Already
assigned'
But after the error, if I go look at the record, that field is empty...?
Does anyone see an issue with what I'm doing in this processing table?
I'm running this as rreport filename -f CoverSheet -u -a -v select
(the above code is in my select processing table - then it's supposed to
pass those records to CoverSheet)
Thanks
Scott
PDM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap=""><a class="moz-txt-link-freetext" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/82205474/attachment.html">http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/82205474/attachment.html</a>
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
---
This email has been checked for viruses by Avast antivirus software.
<a class="moz-txt-link-freetext" href="https://www.avast.com/antivirus">https://www.avast.com/antivirus</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/bd52e8dc/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/bd52e8dc/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br />
<table style="border-top: 1px solid #D3D4DE;">
<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 src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;" /></a></td>
<td style="width: 470px; padding-top: 12px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">Virus-free. <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: #4453ea;">www.avg.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body>
</html>