[Gambas-user] SQLite - in memory DB

adamnt42 at ...626... adamnt42 at ...626...
Mon Jun 20 04:07:50 CEST 2016


On Mon, 20 Jun 2016 02:25:18 +0200
Benoît Minisini <gambas at ...1...> 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 <ujlain at ...626...>
> > 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 :"; Error.Text
> >> ....
> >> ....
> >>
> >> Error I am getting is :-
> >> /Unable to open database //
> >> //Error : Unable to locate database `:memory:` in ``/
> >>
> >> conH.name = Null /'does work but that is creating a temp database in
> >> /tmp folder and marginally slower/
> >>
> >> I request opinion on following :-
> >> (a) How to create "in memory" Sqlite DB so that the operations can be
> >> done expeditiously.
> >> (b) Further how to attach using GAMBAS an existing file based Sqlite and
> >> how to shift one table from this to in-memory DB ?
> >>
> >> regards
> >> Vinode Singh
> >>
> 
> To use a database memory, you have to use a null name.
> 
> http://gambaswiki.org/wiki/comp/gb.db/connection
> 
> Regards,
> 
> -- 
> Benoît Minisini
> 

hmm, that contradicts with http://gambaswiki.org/wiki/comp/gb.db/connection/name


-- 
B Bruen <adamnt42 at ...3379... (sort of)>




More information about the User mailing list