Could you not combine the data on the app side? On Sat, 17 Jun 2017, 9:15 AM J Decker, <d3c...@gmail.com> wrote:
> Probably need to use some CTE expressions to tackle that. > > https://sqlite.org/lang_with.html > > On Fri, Jun 16, 2017 at 10:59 PM, Robert M. Münch < > robert.mue...@saphirion.com> wrote: > > > Hi, suppose I store my data like this: > > > > Table A: table, column, data > > > > Now I want to create a VIEW named A.table, with columns A.column and rows > > A.data > > > > Is that possible? > > > > Background: We have one table where columns can be added/removed. We want > > to use the session extension to keep track of changes to our database. > But > > the session extension can't handle schema changes. > > > > Thanks a lot. > > > > -- > > > > Robert M. Münch, CEO > > M: +41 79 65 11 49 6 > > > > Saphirion AG > > smarter | better | faster > > > > http://www.saphirion.com > > http://www.nlpp.ch > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users