On Mon, 20 Jun 2016 02:25:18 +0200 Benoît Minisini <gam...@users.sourceforge.net> 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 <ujl...@gmail.com> > > 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 <adamn...@gnail.com (sort of)> ------------------------------------------------------------------------------ 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