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

[Martin Schreiber]

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