[Gambas-user] SQLite - in memory DB

[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 = 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