Sorry, they do not have the same definition. They are different definitions. I just want to view the data in a view such that all rows from all tables can be seen sorted by time.
Obviously SQLite cannot do this since the table definitions are different, and I'd have to write some application code. I'm trying to understand what's the best way to use SQLite for this purpose. It's almost as if I need a table that has "pointers" to rows of other tables. I'm quite astonished by the flexibility of SQLite, so maybe it is possible to shoe-horn such a feature? On Fri, Jul 17, 2015 at 3:48 AM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 17 Jul 2015, at 3:22am, Hayden Livingston <halivingston at gmail.com> > wrote: > >> So, In my application code I'm going to through loop through all the >> tables. The table count is usually high hundreds (~600-800) > > Why do you have so many tables which, if I understand your post right, have > the same column definitions ? You can't have thought up 800 different table > definitions for one program. Why isn't all your data in one big table using > an extra column to indicate its category ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
