odd lookup problem
Jeff Harrison
jeffaharrison at yahoo.com
Wed Nov 10 09:56:51 PST 2010
----- Original Message ----
> From: Richard Kreiss <rkreiss at gccconsulting.net>
> To: Kenneth Brody <kenbrody at spamcop.net>; rkreiss at gccconsulting.net
> Cc: Filepro-list at lists.celestial.com
> Sent: Wed, November 10, 2010 11:36:19 AM
> Subject: RE: odd lookup problem
>
> New problem:
>
> Doing a lookup in the auto processing table using lv=master_code&"99" to
> display information from the sales journal in the current file. The NOT
> sales line shows false when a record is present in the sales journal.
>
> When @keyW is pressed and this lookup is done from input processing, the NOT
> sales is true.
>
> I removed the casting lv from the input process as a test but NOT sales
> still showed as true in input processing.
>
> My question is, why would the lookup return the correct value in auto
> processing but not in input processing.
>
> Richard
>
Richard, it is difficult to say exactly without seeing ALL of the code that is
being executed here, but keep in mind that when you press "W" for your @key
processing, that causes automatic processing to run first. Auto processing is
likely doing something to mess you up.
Try this as a test: Go into your looked up record without any processing (
dclerk filename -s0 -y none -z none) and verify that the data is as you expect.
Then test your code in input processing without any automatic processing. I
suspect that it will work fine. You are probably changing the data in auto
processing.
Good Luck.
Jeff Harrison
jeffaharrison at yahoo.com
Author of JHExport and JHImport
More information about the Filepro-list
mailing list