Lookup "gotcha"

Kenneth Brody kenbrody at spamcop.net
Mon Oct 26 06:20:48 PDT 2009


Richard Kreiss wrote:
[...]
> The problem is when looping through the file, with the key being
> street&address, her records are at the end of the file.  The program loaded
> the array but when it hit the NOT CLIST, the routing ended without
> displaying the array.
[...]

I'm not sure I see any "lookup gotcha" here.  It sounds like your code just 
didn't handle the possibility of "not clist" being hit before running out or 
matches.

Don't assume that "I hit EOF" means "I found no records".  When the loop 
terminates because of _either_ a mismatch or "not clist", then display the 
listbox if the count was not zero.

-- 
Kenneth Brody


More information about the Filepro-list mailing list