What is the best way to create a table that say consists of 3 columns:
Name char, Price real, Qty real
I don't see where this could be done using wxSqlite3 unless I'm missing something.
(I probably am, )
I just want to create a table that I can use but doesn't actually get saved. Is there a better way than virtual tables?
wxSqlite3 and Creating Virtual tables...
Re: wxSqlite3 and Creating Virtual tables...
sqlite supports ":memory:" as a special filename, this will create an in-memory database. I suppose it also works with wxSQlite3.
Use the source, Luke!
Re: wxSqlite3 and Creating Virtual tables...
If you are actually referring to SQLite's virtual tables based on the virtual table mechanism, then you haven't missed anything, since wxSQLite3 has no special support for implementing such virtual tables. This would be way beyond the scope of wxSQLite3.ouch67 wrote:What is the best way to create a table that say consists of 3 columns:
Name char, Price real, Qty real
I don't see where this could be done using wxSqlite3 unless I'm missing something.
(I probably am, )
However, from your below comment I get the impression that ...
... what you really want to have, are temporary tables which can be created using the SQL command CREATE TEMPORARY TABLE.ouch67 wrote: I just want to create a table that I can use but doesn't actually get saved. Is there a better way than virtual tables?
Temporary tables are only visible to the database connection in which they were created, and temporary tables are always automatically deleted when the database connection is closed.
Regards,
Ulrich
Re: wxSqlite3 and Creating Virtual tables...
Ah, I see. Thanks to you both.