Set the select statement ("SQL" property = "select * from table1"), the insert, delete and update statements are built automatically. Then use tmsesqlquery.edit(), insert(), delete() and post() or cancel() and access the fields. In order to write the data to the server call tmsesqlquery.applyupdates(). In order to commit call tmsesqltransaction.
(
Read more... )