processing issue

Wed Feb 27 19:53:54 PST 2019

It also loks to me that youo have another error in your logic.

Here you do a lookup using key  fb with exact match. I assume you only 
want to evaluate records where fb eq yar(431).
Is index E build on 431?
If yes than see the adjusted code below.

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:

valid::lookup yar = PDM k=fb i=E -nx:
yarloop:not yar:goto counted:
:yar(431) ne fb:goto counted:
:yar(437) ne fa:getnext yar;goto yarloop:

Richard D. Williams

On 2/27/2019 1:35 PM, scooter6--- via Filepro-list wrote:
> 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 <breadran01 at gmail.com> wrote:
>
>> 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:
>>> I am trying to make a processing table that takes two pieces of
>> information
>>> 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
>> anyways -
>>> I'm sure whoever may look at this and say it's not backwards it's your
>> code
>>> - 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
>> with"<14<15<"Status
>>> 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?
>> ":
>>> :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
>> it
>>> 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: <
>> http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/82205474/attachment.html
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>
>>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/bd52e8dc/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

---
This email has been checked for viruses by AVG.
https://www.avg.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20190227/a44f222a/attachment.html>