Subject RE: [IBO] TDBlookupCombos
Author Jason Wharton
How large is the dataset being selected from and what kind of network
connection do you have to the server?

You could try using TIBOTable and setup indexes to be ascending and
descending and get a virtualized dataset that interacts with the server and
only fetches records it needs, however it will always be fetching records
from the server rather than scanning records in memory.

Jason Wharton

> -----Original Message-----
> From: []On
> Behalf Of Robert martin
> Sent: Thursday, July 07, 2005 9:08 PM
> To:
> Subject: [IBO] TDBlookupCombos
> Hi all
> This might be a really stupid question but....
> We have come from a BDE / Dbase background and have used
> DBLookupCombos
> (in particular our customized descendant) to allow selection / Entry.
> We have a DbLookupCombo that lists product name and writes
> its PK into
> another table. I have set it to read from a TIBOQuery components and
> all is well apart from when I try to locate a product beginning with
> 'Y'. It is not found. If I scroll to the bottom of the list it is
> displayed and will then be found. I am assuming the
> component is only
> searching the data that has been buffered on the client side
> and that by
> moving to the end I force the component to 'pull' all the
> data down from
> the server. Indeed if I set 'AutoFetchAll' to true the
> component works
> fine. My assumption is that in the BDE version the component
> searched
> the buffer and if it failed, forced another block of data to be
> downloaded until it found the record of ran out of data.
> Questions
> Do I have to set 'AutoFetchAll' or is there a better way of
> doing it (I
> don't want to pull the records unless I need to)?
> Is there a better way of doing this? (we need to remain TDataset
> compatible).
> TIA :)
> --
> Rob Martin
> Software Engineer
> phone +64 03 377 0495
> fax +64 03 377 0496
> web
> Wild Software Ltd