> So to recap > datasource1.dataset.UpdateRecord; > datasource1.dataset.Post; > datasource1.DataSet.close; > sqlquery1.sql.Clear; > sqlquery1.SQL.Text:='commit'; > sqlquery1.ExecSQL > > sqlquery1.Close; > > does not work. > > BTW have no experience using any recent Delphi. All that I'm learning is > through the school of hard knocks (reading articles from google). But when I > get this working I will post to the wiki.
The transaction is committed by the command transaction.commit For an example, see the fpc-code: fcl/db/sqldb/examples/fedittable.pp -- Met vriendelijke groeten, Joost van der Sluis CNOC Informatiesystemen en Netwerken http://www.cnoc.nl _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
