[Lazarus] Is there a way to NOT use a transaction in sqldb ?

Alexsander Rosa alexsander.rosa at gmail.com
Fri Oct 16 13:46:18 CEST 2009


So your suggestion is to ditch sqldb and switch to zeosdbo instead of try to
fix sqldb?**

2009/10/15 Luca Olivetti <luca at wetron.es>

> En/na Zaher Dirkey ha escrit:
>
>> Just open the connection, get your query results then close the
>> connection, every time you query, do not keep the connection to
>> database opened while you application run.
>>
>
> Data aware components need an open connection to show data.
> Incidentally, I had problems regarding transactions trying to use sqldb
> with sqlite (a similar problem than the one Alexsander reported, i.e. it
> constantly maintained an open transaction precluding other connections from
> updating the db).
> I hadn't much time to analyze the issue then and I just switched to
> zeosdbo.
>
> Bye
> --
> Luca Olivetti
> Wetron Automatización S.A. http://www.wetron.es/
> Tel. +34 93 5883004 (Ext.133)  Fax +34 93 5883007
>
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>



-- 
Atenciosamente,
Alexsander da Rosa
Linux User #113925

"Extremismo na defesa da liberdade não é defeito.
Moderação na busca por justiça não é virtude."
-- Barry Goldwater
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20091016/358c625f/attachment-0004.html>


More information about the Lazarus mailing list