What I do is load all (or blocks) of the data all at once, put it into a data grid, then navigate through the records in the data grid. I trap selectionChanged in the datagrid to populate the detail fields on the form. I have an edit bar for creating new, editing existing and deleting existing records. I also have a search object for finding records in a table and displaying them in a datagrid. By setting some constants in the search object's input field it can be used with any table and data grid. Navigation is now accomplished by the user simply arrowing down or up in the data grid, or scrolling down, sorting columns etc., or usign the search bar.
Trouble is, I develop almost exclusively for sqlYoga but it would not be difficult to refactor it for use with any database. Bob S > On Oct 11, 2015, at 20:42 , Peter W A Wood <peterwaw...@gmail.com> wrote: > > I decided to convert a small card-based database stack to a “proper” database > using SQLite. I immediately missed the next/previous card navigation features > which were ideal for browsing the small database. > > LiveCode chunking is great for handling lists but, as far as I can tell, is > missing forward and backward navigation through lists. I decided to write a > few simple functions to come up with such a mechanism. > > I suspect that there may be an existing way to navigate forwards and > backwards through a list but I just can’t find it. I’ve put together a very > simple, completely unoptimised start of a LiveCode list processing library. > It contains only a handful of functions. You can find it at > https://github.com/PeterWAWood/LiveCode-ListProcessor > <https://github.com/PeterWAWood/LiveCode-ListProcessor>. > > Perhaps you would be kind enough to let me know of existing ways to achieve > what this small library does before I spent more time developing it? > > Regards > > Peter > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
