issues with called table causing lookup behaviour change...need help
Fairlight
fairlite at fairlite.com
Fri Aug 9 10:22:08 PDT 2013
On Fri, Aug 09, 2013 at 10:17:43AM -0400, Kenneth Brody thus spoke:
> 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?
The called table does -two- lookups to the same file. Both are closed.
But they're not the same lookup alias as the one in the parent (calling)
table.
Is this still a problem? If so, I could use a fix.
mark->
--
Audio panton, cogito singularis.
More information about the Filepro-list
mailing list