Subject Re: [IBO] WhereSQL
Author Svein Erling Tysvær

>I may be wrong but I know that
>at using Filter the table brings all data and then selects it.
>I thougt that if use where clouse I can prevent getting un used data from

>if I'm wrong please notify me...

you're wrong. IBO is made so that all filter processing is done on the
server (according to my help file, the only exception is what is done in
the OnFilterRecord event, but I'm on an old version). However, it is a good
idea to limit the number of records brought to the client, but to take the
full advantage of this change to some other component than TIBOTable (I
recommend TIB_Query or TIB_Cursor, but you can use TIBOQuery if you like).