Re: [Gambas-user] SQLite - in memory DB

2016-07-26 Thread Vinode Singh Ujlain
I am able to attach a file based SQLite database to in-memory DB and copy entire database (all tables sequentially using create table + select * from..) into in-memory DB.How do I do the reverse ? i.e dump in-memory DB onto a file based sqlite DB by attaching the memory based DB to file based DB ?

Re: [Gambas-user] SQLite - in memory DB

2016-06-20 Thread Benoît Minisini
Le 20/06/2016 04:07, adamn...@gmail.com a écrit : > > hmm, that contradicts with > http://gambaswiki.org/wiki/comp/gb.db/connection/name > > Huh, this is a bug in the documentation. :-/ I fix that... -- Benoît Minisini

Re: [Gambas-user] SQLite - in memory DB

2016-06-19 Thread adamn...@gmail.com
On Mon, 20 Jun 2016 02:25:18 +0200 Benoît Minisini wrote: > Le 20/06/2016 01:17, zainudin ahmad a écrit : > > I can't use it too (attach pic), it's bug ? (attach project) > > > > On Sun, Jun 19, 2016 at 5:57 PM, Vinode Singh Ujlain > > wrote: > >

Re: [Gambas-user] SQLite - in memory DB

2016-06-19 Thread Benoît Minisini
Le 20/06/2016 01:17, zainudin ahmad a écrit : > I can't use it too (attach pic), it's bug ? (attach project) > > On Sun, Jun 19, 2016 at 5:57 PM, Vinode Singh Ujlain > wrote: > >> Public conH As New Connection >> conH.Type = "sqlite3" >> conH.name = ":memory:" >>Try

Re: [Gambas-user] SQLite - in memory DB

2016-06-19 Thread zainudin ahmad
users, apps, and protocols > are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning > reports. http://sdm.link/zohomanageengine > ________________

[Gambas-user] SQLite - in memory DB

2016-06-19 Thread Vinode Singh Ujlain
Public conH As New Connection conH.Type = "sqlite3" conH.name = ":memory:" Try conH.Open() If Error Then Print "Unable to open database \n Error :"; Error.Text Error I am getting is :- /Unable to open database // //Error : Unable to locate database `:memory:` in ``/ conH.name