Yes, it turned out that achieving the goal with C code is much simpler than using SQL statements (I also take my limited sql knowledge into account)
Now, I'll have two sqlite3_exec() calls, one of which is invoked by first call's callback function. This led having some natsy C structs around to pass parameters to sqlite3_exec() calls, but I could not find any other approach. On 29/07/2013, at 7:48 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 29 Jul 2013, at 4:03am, Fehmi Noyan ISI <fnoyan...@yahoo.com> wrote: > >> One point I forgot to mention; the number of columns is unknown. > > There is no way in SQL to say "Give me the contents of all the columns of a > row of table in an unambiguous format.". > > It would be possible to write the code you want in SQLite, by using various > PRAGMAs to inspect the table format, but this would lead to complicated code > which was highly tuned to how SQLite works. > > I suspect you'd be better off writing C code which inspects whatever "SELECT > *' returns. > > Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users