browse lookup phenomenon - SOLVED!!!!!
Jean-Pierre A. Radley
appl at jpr.com
Fri Mar 24 11:13:14 PST 2006
Dennis Malen propounded (on Fri, Mar 24, 2006 at 01:26:37PM -0500):
|
| I use "rn" in all my processing for a record number lookup. I identify it
| as rn=@rn.
|
| I was always under the misguided impression that if you have a dummy field
| that was already defined that the dummy field would take on that
| characteristic. I not only use that concept for "rn" but for other dummy
| fields. I thought it always worked.
|
| It was only recently that my staff brought to my attention that a number of
| browse lookups had never worked properly for years. After an investigation
| of which ones were not working properly we found that in every instance the
| browse lookup was executed from a "chained" processing table. It worked in
| "input" but not in "chain".
|
| Why? The answer to my particular problem was that the lookup file for
| record number had an edit of (6,.0). In every case, whether the browse
| lookup resides in "input" or a "chain" process, it appears the proper
| approach is to always edit rn as rn(6,.0) to mirror the corresponding
| field. In my case it must contain the exact edit. Even if I edited it as
| rn(7,.0) it will not work. It must be exactly what the lookup file
| possesses.
Since the very first days of filePro, the system field @RN (the current
record number) has been an integer field with length 8 ; why do you keep
trying to utilize it as if it were (6,.0) ??
--
JP
==> http://www.frappr.com/cusm <==
More information about the Filepro-list
mailing list