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 <bonnm...@gmail.com> 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 <bonnm...@gmail.com> 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 < >> use-livecode@lists.runrev.com> 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 < >>> use-livecode@lists.runrev.com> 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 >>> use-livecode@lists.runrev.com >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >>> >> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
