Doh. Been a bit since I did it. Its-- ATTACH DATABASE pathtodb.db as dbname
On Mon, Jul 30, 2018 at 8:55 AM Mike Bonner <[email protected]> wrote: > Sorry.. To elaborate, yes you can attach a disk based db to a memory db. > Then you use dot notation to specify which database you're working on. > > So it would be a regular attach-- attach pathtodatabase.db as dbname > Then any place you would specify a table name it would be dbname.tablename > > > > On Mon, Jul 30, 2018 at 8:51 AM Mike Bonner <[email protected]> wrote: > >> Yes >> <Wait, you can attach a disk based database to a memory database?? >> >> On Mon, Jul 30, 2018 at 8:45 AM Bob Sneidar via use-livecode < >> [email protected]> wrote: >> >>> Wait, you can attach a disk based database to a memory database?? >>> >>> Bob S >>> >>> >>> > On Jul 27, 2018, at 15:19 , Mike Bonner via use-livecode < >>> [email protected]> wrote: >>> > >>> > On the subject of sqLite/memory databases and preferences/data >>> persistence, >>> > rather than using an array, and doing the encode/decode stuff, would it >>> > make sense to do the following.. >>> > 1. open an empty in memory database >>> > 2. attach a disk based database >>> > 3. copy the required table(s) from disk base to memory base >>> >>> >>> _______________________________________________ >>> use-livecode mailing list >>> [email protected] >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >>> >> _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
