sql.BeginTransaction
sql.ExecNonQuery("update timu set zd=true where xh ='" & xh & "'")
sql.TransactionSuccessful
When I close the software,and open the mdb with Access 2010,I find the data doesn't change.
I know in VB6,you must use sql.update to make the data real change.How can I do with B4J?
After I insert data,I can read it with sql.ExecQuery,but when I close my software,and open the mdb with Access2010,I can't find the new data.
I close the SQL object when closing the software.
B4X:
Sub MainForm_CloseRequest (EventData As Event)
sql.Close
End Sub