[Lazarus] SQLDB issues.

Martin Schreiber fpmse at bluewin.ch
Fri Jan 8 10:28:25 CET 2010

On Friday 08 January 2010 10:06:44 Luca Olivetti wrote:
> >
> > It is a limitation of sqlite.
> Then why zeosdbo has no such issue?
Sqlite3 uses filelocks for transactions and ZEOS works without transactions by 
default AFAIK.
MSEgui tsqlite3connection has the options property members slo_transactions 
and slo_designtransactions which are false by default. So normally there will 
be no transaction opened at design time.
Another problem with Sqlite3 is that a not finished fetch operation holds an 
implicit lock so reading recorddata in chunks by TSQLQuery.PacketRecords 
<> -1 can be problematic.


More information about the Lazarus mailing list