-xpl
Richard Kreiss
rkreiss at gccconsulting.net
Wed Dec 12 13:41:30 PST 2007
Came across an interesting anomaly when doing the following lookup to the next lowest.
File with index f build on master_code(10,nnn) and renewal(2,.0)
When I set lv=master_code&"99" (1234-1234599)
44 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: lookup sales = sales_journal k=lv i=C -npl
45 ------- - - - - - - - - - - - - - - - -
◄ If: NOT sales
Then: GOTO post_tr
If there are 2 records using the master_code, one has renewal blank and the other has a value of 1.
I would expect that my lookup value would fail and get 1234-12345 1. It actually gets 1234-12345 with renewal blank( not what I expected).
Tested lv=master_code&"9" (1234-123459)
This worked as expected.
Can anyone explain why the first lookup fails to properly find 1234-123451, when 1 is clearly less then 99.
Richard Kreiss
GCC Consulting
More information about the Filepro-list
mailing list