On Tuesday 13 October 2009 20:56:26 Alexsander Rosa wrote: > This transaction locks the changes in the database structure so you can't, > for example, create a new table with a foreign key. A mere CREATE TABLE > with a FOREIGN KEY referring to an existing table would take forever > waiting for that lock to be released.
It will not help you with FCL sqldb, anyway, this is how it works in MSEgui: tmsesqltransaction.options has tao_fake flag, there will be no transaction commands sent to the server if activated. tmsesqlquery.controller.options has flag dso_offline, the DB connection can be closed after fetching the data if set. It is possible to reconnect and write the changes to the DB later. Martin -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
