Subject | Re: [IBO] How to avoid lookup table from fetching all records ? |
---|---|
Author | Harald Klomann |
Post date | 2001-04-10T10:47:53Z |
> They are false already. If I set KeySeeking to False It doesn't fetch theGeraldo,
> records, and the lookup doesn't work too...
>
> Thanks in advance
are you shure, that all records of the lookup dataset are fetched ?
Normally, by opening the main dataset, a bunch of records are fetched
from the server, depending on your settings. For each of this records,
there will be a fetch to the lookup table - but only, if the record
to be fetched doesn´t exist in the buffer. So please check, how many
records exist in your lookup table and how many of the are fetched
after opening the main dataset.
Harald