On 6/17/2017 8:17 AM, Robert M. Münch wrote:
On 17 Jun 2017, at 14:10, Igor Tandetnik wrote:
I don't think so. The number and names of columns in the view are determined at
the time CREATE VIEW statement is executed.
That won't be a problem as we can update the VIEWs. The question is, how does a
query look like that transposes the data from a flat to column structure?
By the same token, I don't believe such a query exists. The schema of the
resultset can be derived entirely from the syntax of the SELECT statement,
without consulting underlying data. So you could call, say,
sqlite3_column_count() right after preparing the statement, before it has a
chance to look at the actual contents of the table.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
