Hello, My current SQLite application is written with Pyxia's IBasic, and by nature of the database, is form based. This works well now I have applied all the speed tweaks I have picked up from this forum
I have added a button to the form to show records in Listview format. This works OK as long as I send a second SELECT to the Listview for it to display the required range of records Of course, I have already sent a SELECT to the main form-based window for it to show my required range of records. How do I send the same SELECT to the listview for it to show the already selected range? I see there is "create view" and it probably appears to be what I want, but I have no idea how to apply it, or make a "pre-packaged" select Any answers or suggestions would be most gratefully welcomed Thanks a lot, Brian Pugh