issues with called table causing lookup behaviour change...need help
Kenneth Brody
kenbrody at spamcop.net
Fri Aug 9 07:17:43 PDT 2013
On 8/8/2013 6:00 PM, Fairlight wrote:
> I have a table sitting (with -sr 1) on a record, doing a lookup to another
> table. I'm looping through all records in that table with a -ng lookup on
> an index.
[...]
> Here's the kicker. During that -db trace, I found that the
> "not lookupname" is evaluating true after that one run past the table in
> question. If I yank the call, it apparently must not be, as I get a second
> msgbox. (There are currently only two records that would trigger the
> call/msgbox combination.)
>
> What about a call would cause the lookup to go screwy? Is it because the
> records I'm looking through are the same table that the called table is
> altering? It's not even altering the field upon which the index for the
> lookup in question is based.
Does the called table do a lookup to that same file, and CLOSE the lookup?
--
Kenneth Brody
More information about the Filepro-list
mailing list