I have a database with two tables: one with 91 column names and the other with 54. Both have several records. I would like to have a menu or list option to select either table to display its data in a grid like spreadsheet format. Most of the examples I have seen in the forum treat a database with only one table. Klaus’s SQLite Viewer sample allows you to select a table of your choice but, you cannot filter, or sort. The header (column names) scrolls off the screen when you are scrolling vertically. Therefore, you cannot tell what data belong to what column name. SQLExample sample does almost what I want, but its database has only one table. I can write two separate projects with two separate icons, each displaying one table, but that is not efficient. I would like to be able to display the data of either table from the same application. Does any database guru have any idea on how to achieve my goal.
Thank you in advance for your assistance.
Thank you in advance for your assistance.