Hi,
I want attach second databse to sqlite connection by command:
DBConnection.ExecuteDirect('attach database
'+QuotedStr(GetConfigDir+'second.db')+' as mydb2');
But I get error that cannot attach database when on transaction. Even If I
commit transaction first, then ExecuteDirect start new one. How to get
around this?
BTW: Why SQLDB has logic "always in transaction"? Is it really perform in
large and complex ERP systems? What I was always taught that the
transaction should be used only in specific situtations (importing,
converting documents, FIFO, stock status etc) but whole time? Is not
dangerous? One programmer's mistake (e.g forget commit somewhere, or
transaction conflict etc.) and client can loose bunch of data.
Regards
--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
