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

[Reinier Olislagers]

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...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20130108/d2796cfc/attachment-0003.html>