not foobar lookup problem

Kenneth Brody kenbrody at bestweb.net
Thu Nov 20 08:37:03 PST 2008


Quoting RKreiss1 (Thu, 20 Nov 2008 11:27:32 -0500):

> OK replace foo for sales.  That is the actual alias I used not foo.
>
>
> Ken, are lookup files opened when the input table is loaded even though the
> program line to execute the lookup has not been executed?

No.  The files are opened when the lookup is executed.

> Based on what has happened, it appears to be so.

Why do you say that?

[...]

In any case, there is nothing wrong with having multiple uses of the same
alias.  The last one executed is the one that is used.  Given your original
example:

     Lookup foo=foobar  k=mc   i=c -xn
     Not foo
     END
     More programming

The "not foo" line refers to the lookup on the line immediately preceding
it.  If that lookup succeeds, as you say it does, then "not foo" will be
false, regardless of any other uses of that alias, or lookups to that
same file with different aliases.

Perhaps you should give the actual code which you say is failing, rather
than your pseudo-code example?

-- 
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list