[Lazarus] SQLDB - Can't attach second SQLite database because transaction

stdreamer stdreamer at freemail.gr
Fri Jan 11 06:52:20 CET 2013

On 7/1/2013 11:59 μμ, Michael Van Canneyt wrote:
> Ah yes.
> Good point, had not though of that. Well, let's add the bypass then.
> Just need to figure out what to do with Firebird, since it needs
> transactions.
> Probably temporarily creating one and committing it at the end will do.
> Michael.

Personally I disagree, that behavior is exactly the opposite of what the 
method name imply and I would simply raise an exception instead with a 
message of : firebird does not support out of transaction commands, or 
something along those lines also I would like to propose an other 
alternative, Instead of adding one more method I would extend the 
existing one with an extra parameter Transaction:TSQLTransaction if the 
parameter is nil then it will run outside of a transaction if supported 
by the database or raise an exception.

That's my 2 cents.


More information about the Lazarus mailing list