I set the
IB_Query.AutoFetchAll := true;

so I suppose all records are fetched. The result set has about 500 records,
but the filter is changed pretty often and I would avoid issuing the filter
SQL on the slow line. I would prefer to open the query once and then only
change the filter on the client.

Ales

> -----Original Message-----
> From: Daniel Rail [mailto:daniel@...]
> Sent: Tuesday, February 04, 2003 4:22 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] IB_Query.Filter and Filtered
>
>
> Hi,
>
> > Hi,
> > suppose, there is IB_Query, opened and all records are
> fetched. Now assign
> > the
>
> Are you sure that all the records are fetched. Usually after
> IB_Query.Open, not all records are fetched from the server. The BDE
> fetches all of the records and stores them in its buffer, but not
> IBO(in some cases it might be possible, but I don't know the logic
> behind that code).
>
> Out of curiosity, how long does it take to open your query? And, how
> many records are in the result set?
>
> > IB_Query.Filter := 'some filter';
> > IB_Query.Filtered := true;
>
> > and every time you do this an SQL 'SELECT ....' is issued
> against the
> > database. I supposed that this filtering is done on the client...
>
> This is because it can happen that not all records are in the IBO
> local buffers. So, in order to actually satisfy the filter, another
> SELECT has to be performed with the filter appended to the WHERE
> clause.
>
> > Is there any way to filter records on the client simply and
> quickly? I do
> > not want to issue extra SQL queries on the slow internet line.
>
> Load you data in memory tables in the client application.
>
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.accramed.ca)
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get 128 Bit SSL Encryption!
> http://us.click.yahoo.com/LIgTpC/vN2EAA/xGHJAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/