[sqlite] Resetting virtual table
Hi, As I see sqlite can accept the schema of a virtual table (Sqlite3_declare_vtab) only in the context of xCreate or xConnect. But if I want to refresh not only data, but schema also, is it possible? For example, I already did a query for my virtual table based on clipboard contents, the clipboard has changed and I want the new select to contain not only new rows, but also new columns (if this new contents is different to the previous one). Thanks, Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Resetting virtual table
On 01/13/2012 03:31 PM, Max Vlasov wrote: Hi, As I see sqlite can accept the schema of a virtual table (Sqlite3_declare_vtab) only in the context of xCreate or xConnect. But if I want to refresh not only data, but schema also, is it possible? For example, I already did a query for my virtual table based on clipboard contents, the clipboard has changed and I want the new select to contain not only new rows, but also new columns (if this new contents is different to the previous one). No way to do that. Can you Drop and then recreate the table? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Resetting virtual table
On Fri, Jan 13, 2012 at 3:02 PM, Dan Kennedy wrote: > On 01/13/2012 03:31 PM, Max Vlasov wrote: > >> As I see sqlite can accept the schema of a virtual table >> (Sqlite3_declare_vtab) only in the context of xCreate or xConnect. But if >> I >> want to refresh not only data, but schema also, is it possible? >> > > No way to do that. Can you Drop and then recreate the table? > Probably this way and reopening the db are the only options in this case. Thanks, Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users