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

Luca Olivetti luca at wetron.es
Thu Oct 15 17:45:21 CEST 2009


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




More information about the Lazarus mailing list