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
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which 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 mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
