SQLite: how to open existing database in memory

Paul Dupuis paul at researchware.com
Sat Oct 17 12:54:43 EDT 2015

On 10/17/2015 12:25 PM, Peter Haworth wrote:
> Sorry, I should have looked at your syntax more closely.
> You can't open an existing database as an in memory database.  If you want
> to open an in memory database, the revopendatabase syntax is
> revOpenDatabase("sqlite",":memory:") and it will be a brand new, empty
> database with no tables.  The syntax you used would have created a disk
> database file named /Users/Dev/Documents/Ratings.db3:memory: with no tables
> in it, hence the error message you got.
> Hope that explains it better.

Could you create a new, empty, in memory data base and open the disk
based existing database and copy its contents to the new memory
database? Does sqlLite provide any easy command for copying a database
or the contents of a database to another?

More information about the use-livecode mailing list