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 <[email protected]> > > 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 -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
