[Lazarus] SQLDB - Can't attach second SQLite database because transaction
mse00000 at gmail.com
Fri Jan 11 07:12:48 CET 2013
On Friday 11 January 2013 06:52:20 stdreamer wrote:
> 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.
MSEgui transaction component has an option "tao_fake" which can be used in
situations where statements should run in an implicit transaction.
More information about the Lazarus