En/na Joost van der Sluis ha escrit:
This can be done perfectly with sqldb. But which are the cases which are difficult?
When you have a visual database component (e.g. a dbgrid) that needs the connection opened all the time (otherwise it wouldn't show any data) and locks the database for other uses. Mind me, it happens also with zeos when you select a TransactIsolationLevel different than tiNone, but there you have the option. An use case I have (but it's not the only one) is a dbgrid opened on a read only query (i.e. just to show data), while all data modification is done with a different connection (that signals a refresh to the display one when data is changed). I also don't understand the transaction model of zeos, so even if I'm using it, when I need transactions I issue them explicitly (DbConnection.ExecuteDirect('BEGIN')...DbConnection.ExecuteDirect('COMMIT')).
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 [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
