Using the edit box with a button to bring up a lookup form is an excellent
approach for client/server environment.

Well done!

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Marc Leclerc" <mlpgr@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, April 10, 2001 6:07 AM
Subject: Re: [IBO] How to avoid lookup table from fetching all records ?


> Hi,
>
> I have a few clue that support this problem. The app I am working on uses
a
> fairly large dataset as lookup ( a company list ) and the edit form that
> used the lookup was taking several seconds (oven a 56K modem) to load
> displaying a "Fetching Query Result" message. Every properties mentionned
> here were all set properly. I have since changed the input (TIB_Lookup...)
> to an edit field + button that brings a search form and have cut down 20
> seconds. Of course I could't see all that on my systeme here as the server
> sits on the same computer so speed isn't an issue and as far as wondering
if
> the CB was filled, well unless the 56K modem can throw all fields to fill
> the box in the time required to drag a scroll bar...
>
> HTH
>