Subject RE: [IBO] Screen Refresh after changing SQLWhere clause to slow
Author Alan McDonald
> I use a TIB_Query to access a table where I store two kind of
> informations - normal products and spareparts data.
> in my application I use a TpageControl to display them
> separated but on a single form anyway.
> Switching the Tabs between Spareparts and Products I have to
> change the SQLWhere clause like
> iqProducts.SQLWhere.Text := 'WHERE PRODUCTS.PRODUCT_TYP=''SPT''';
> To immediately refresh the screen and show the new data I have to
> iqProducts.Prepare;
> iqProducts.FetchAll;
> iqProducts.Next;
> The problem is that this way is quit slow -
> but without the FetchAll my screen will not be updated !
> How can I refresh the screen data more faster after
> changing the SQLWhere clause ?

is there a reason why you don't just have to components - one for spares and
one for normal products?