Hi!

I know that the client side will retrieve from server only those visible
records in the dbgrid, but...
Will it retrieve all the Fields, or only those that are visible?

I have a dbgrid with a few fields and one TPageControl with some Sheets.
On each sheet I have some DBEdits with more fields.

I have been thinking of disabling the pagecontrol, so the client will only
retrieve the dbgrid necessary data, and retrieve the other fields when
entering on each tabsheet. Will it work as I expect, or all the fields are
retrieved at a time?

(I'm using DBISAM 4.25, C/S mode)

Thanks!

Luis,

<< I know that the client side will retrieve from server only those visible
records in the dbgrid, but...Will it retrieve all the Fields, or only those
that are visible? >>

All of the fields.

--
Tim Young
Elevate Software
www.elevatesoft.com

<< I know that the client side will retrieve from server only those visible
> records in the dbgrid, but...Will it retrieve all the Fields, or only
> those that are visible? >>
>
> All of the fields.

However, a query will only retrieve the selected fields if you want to limit
the amount of data coming back.

Bill

Bill,

<< However, a query will only retrieve the selected fields if you want to
limit the amount of data coming back. >>

Just a reminder - only if the query result set is canned, otherwise all
fields will be returned if the query result set is live.

--
Tim Young
Elevate Software
www.elevatesoft.com

> Just a reminder - only if the query result set is canned, otherwise all
> fields will be returned if the query result set is live.

Thanks for the clarification.
Bill