[Lazarus] sqlite3 app on linux

[Andrea Mauri]

Il 14/10/2010 16:55, Michael Van Canneyt ha scritto:
>
>
> On Thu, 14 Oct 2010, Andrea Mauri wrote:
>
>> Il 14/10/2010 15:51, Michael Van Canneyt ha scritto:
>>>
>>> Yes. Put the following in the startup code of your app:
>>>
>>> uses sqlite3dyn;
>>>
>>> begin
>>> InitializeSqlite('libsqlite3.so.0');
>>> end;
>>>
>> I tried but now I get the following error when I create at runtime the
>> sqlite db and related tables:
>>
>> sqlite interface already initialized from library libsqlite3.so.0
>
> Hm. This is a bug. Or rather, a shortcoming. The connection should detect
> whether the library is already loaded, and if so, re-use that name.
> (The sqliteLibrary variable can be used for that). Better yet, the library
> name should be configurable in the connection instance.
>
> Can you please enter a bugreport for this ?
>

ok, bug id 0017633 in [FPC] Database Components


>>> More sophisticated would be to detect which file actually exists, and
>>> use
>>> the correct filename.
>>
>> How can I do that? Suggestions?
>
> The above bug prevents you from doing this.
>
> What you can try to do is create the symbolic link yourself, in the
> installation procedure - I assume it will be executed as root.
>

ok. I prepared a deb package so I will try to prepare a postinst script 
in order to create the symbolic link (if it does not exist yet).

thanks,
andrea