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
