[Gambas-user] SQLite - in memory DB

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