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

[Reinier Olislagers]

On 8-1-2013 13:14, Reinier Olislagers wrote:
> On Monday, January 7, 2013, Michael Van Canneyt wrote:
>     On Mon, 7 Jan 2013, Ludo Brands wrote:
>         On 07/01/2013 16:01, Michael Van Canneyt wrote:
>             On Mon, 7 Jan 2013, Krzysztof wrote:
>                 2013/1/7 Michael Van Canneyt <michael at freepascal.org>
> 
>                 Maybe we should make a method for this in
>                 TSQLite3Connection ?
> 
> 
>                 It would be great. Because without this we can't use all
>                 opportunities of SQLite, like attaching databases or
>                 also VACUUM (trim and pack database)
> 
> 
>             I meant a method Procedure AttachDatabase(Const AFileName,
>             AnAlias : String);
>             ?
> 
>             Other methods can also be added, of course.
> 
>         A method to execute a statement outside a transaction would also
>         be useful for the following reasons:
> 
> 
>     That will have to be database-specific.
> 
>     For example Firebird does not allow you to execute statements
>     "outside a transaction".
> 
> Yes it does, using execute immediate or execute block or
> something, iirc. Though yes, the execute block does need to run in some
> sort of transaction, but the action inside the block is committed
> regardless of any transaction rollbacks.
> Useful for logging...
Memory was not completely correct again: the term is autonomous
transactions:
http://www.firebirdsql.org/refdocs/langrefupd25-psql-autonomous-trans.html

Reinier