Randy Graham wrote:
I'd thought of this, but wanted to avoid having to iterate through all the rows and having explicit insert statements for each table, which would require knowledge of the schema for each table
Not really. With a judicial application of sqlite3_column_count and sqlite3_column_type, I believe a generic CopyTable function can be written.
It sure would be nice to be able to attach one mem db to another.
Yes, something like sqlite3_attachdb API taking a pair of db handles would be helpful.
Igor Tandetnik
