wxSqlite3 and Creating Virtual tables...

[ouch67]

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?

[doublemax]

sqlite supports ":memory:" as a special filename, this will create an in-memory database. I suppose it also works with wxSQlite3.

[utelle]

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, )

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.

However, from your below comment I get the impression that ...

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?

... what you really want to have, are temporary tables which can be created using the SQL command CREATE TEMPORARY TABLE.

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

[ouch67]

Ah, I see. Thanks to you both.