Hello, I'm looking for some advice on implementing 'On Demand Loading' in my program. Some GUI controls such as a Listview have a 'virtual mode' where the control only needs to be loaded with the items currently shown. The Listview will call a callback function where it indicates which items need to be loaded. BTW I'm using wxWidgets for my GUI library.
My question centers on how to implement this using SQLite as I'm not really sure how to retrieve 'record numbers 445 to 456' using SQL statements efficiently. Any thoughts on this? Kind regards, Olaf
