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: > > > >> Public conH As New Connection > >> conH.Type

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 conH.Open() >> If Error

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

2016-06-19 Thread zainudin ahmad
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 conH.Open() >If Error Then > Print "Unable to open database \n Error :"; Erro

[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