[Lazarus] Support for SQLite virtual table?

[Ludo Brands]

>     > You mean a temporary table ?
>     >
>     > I'm not an expert, but this is IMHO a completely different concept.
>
>
> Oh, now I see that SQLite has TEMP table too. I thought that 
> PostgreSQL TEMP table is called VIRTUAL table in SQLite. After quick 
> testing it's working fine without any dll API calls unlike VIRTUAL 
> table. What I read that VIRTUAL table is created in memory and TEMP 
> table is written to temp database. Both are destroyed after 
> disconnect. But can't find where this file is created or maybe temp 
> database mean that it is created in memory also? Anyway, TEMP table is 
> solution for me until issue with VIRTUAL table will be solved
>
If you want a pure memory table in sqlite3, give it the special filename 
':memory:'. No special support is required the user code. If you use 
TSQLite3Connection you can also use the TSQLite3Backup to easily copy 
the memory database from/to a disk database, if needed.

Ludo