Adrian,
the simpliest solution is to limit the result of the query you are fetching.
If your query is a "select * from table" and you jump to the last
record, than all records are transferred from the server to your client.
If you are only interested in the last record modify the query to
something like
select last(1) * from table;
or maybe adopt a default filter to keep the query result small. Like a
default date filter showing only the medical records from today back to
the last 10 days.

BTW: The message "Fetching Query Results. Row #nnn" is not an error
message, but a status screen informing you, that the fetching operation
is still running. I believe the default timeout is 5 seconds. All
fetching operations running longer than that are displaying this status
screen.

Regards, Gunther.

Am 03.05.2010 12:41, schrieb Adrian Wreyford:

> Hi, I know a lot has been said, but some pointers will be appreciated:
>
> I use a Firebird 2.1.2.18118 server in my bussiness.
> We have 12000 client records. These records contain the usual postal data, but also medical records, billing records, currently no images.
>
> I access the data using clients over a network.
> I developed frontend With D2010, and use IB_Queries to display the data and a navbar and update bar for browsing and editing the records.
>
> When the apllication is opened all is fine. Going to the last record, the Query posts a message that it is busy "Fetching Query Results : Row #NNNN",
> and all the Client records are iterated over the network, or at least it appears so, and eventually the last record displays.
>
> Can I somehow force this to happen on the server, and then for the server to only supply the record we are interested over the network
>
> The Client Query:
> RequestLive := True;
> AutoFetchAll := False;
> AutoFetchFirst:=True;
> RefreshAction:= raKeepRowNum
>
> When I edit this last record, then Post the changes I get the same message: Fetching Query Results : Row #NNNN and the NNNN increments until the current record.
> This takes quite a while over the network.
>
> I'ts not entirely so simple as there are many nested queries, to supply linked data.
> Perhaps I'm missing out on basics here!
>
> Thanks
>
> Adrian
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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 ! Yahoo! Groups Links
>
>
>
>
>