On Fri, Jul 29, 2011 at 1:42 PM, Ludo Brands wrote:
> I traced through TSqlQuery.Close and there isn't happening a lot, except for
> cleaning up prepared statements and cursors. And that is where your direct
> BEGIN/COMMIT could very well confuse sqlite.
> sqlite3_finalize(fstatement) is used to u
> Thank you for your reply. I found it very interesting. I
> switched the code that I posted to the following (I
> refactored this so that I could call from several different
> places, for inserts, updates, and
> deletes):
>
> procedure TfrmMain.ExecSQL(sql:string);
> begin
> FormDatabase.