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

[stdreamer]

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.

Regards
Jo.