Hi,
How could I implement the feature of Fetch As Needed for remotr view but not available for local view for my application?
I have a member table that contain 5,000 records at this moment. It is just the beginning. The member could be calssified into many classification. Each classification allow 10,000 number of members.
I would like ot display them in grid and let user to seach it using incremental search. So that, I only display the members records for one classification at the same time. However, since the number of members for each class could up to 10,000 records. How could I fetch them as needed. E.g. 500 per time, and append next 500 if required and etc.
I SELECT the records into a temporary cursor recently instead of bind the native table into rowsource.
My question: How to append records into cursor using fecth as needed methodoloy? USING APPEND FROM ?

Thank you