Hi Dennis

you could use CURSORSETPROP properties like

FetchAsNeeded
or
FetchSize

If you are working with CA then there are equivalent properties available.



>Hi Experts,
>
>I have a data entry form class that has a pageframe control with two pages, one showing a grid, the other showing current record contents of the "active record".
>
>This is just fine if I use DBFs as backend data, since it is mere file sharing. This does not augur well though if the same data entry form class is used since ALL rows from a MySQL server database will be fetched (which may run into 100s of thousands)
>
>My question is - what is the best practice for a Client-server data entry form:
>1. Get first X number of rows?
>2. Show no data at first then have a "new function" to view (in addtion to Edit, New, Delete) with certain filter conditions?
>3. I am leaning towards how Yahoo Mail UI does it - but how would you implement the "coordination" of fetching the right number of rows
> when user resizes the message header pane?
>
>Thanks In Advance
>Dennis