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
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011