My problem is the term "virtual" I guess. I think of virtual as in-memory only or something. Once they are created in a SQLite database they seem to be as real as the other tables.
>> I had an API problem, and I now think that the virtual table does not need >> to be created each time. I can't find documentation that covers this. > > I don't think there is documentation which covers this, because it's > how all tables (except temp tables) work. You create them, they're in > the database until you drop them. Virtual tables are slightly > different in that you could attempt to read the database with a sqlite > library which doesn't include the virtual table implementation, which > would naturally fail. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users