B4J Question B4J and Database ACCESS save the data(solved)

[bjfhs]

I can read data from Access,but when use update,

     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?

 

[Erel]

Better:

sql.ExecNonQuery("update timu set zd=true where xh = ?", Array(xh))

Are you sure that the criteria is met? What happens if you insert data?

Are you closing the SQL object at some point?

 

[bjfhs]

Better:

sql.ExecNonQuery("update timu set zd=true where xh = ?", Array(xh))

Are you sure that the criteria is met? What happens if you insert data?

Are you closing the SQL object at some point?

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.

   Sub MainForm_CloseRequest (EventData As Event)
       sql.Close
   End Sub

 

[Erel]

See this: https://www.b4x.com/android/forum/threads/jsql-and-ucanaccess.62909/#post-477390

 

[bjfhs]

See this: https://www.b4x.com/android/forum/threads/jsql-and-ucanaccess.62909/#post-477390

You are right,after insert data ,the next code is need,

sql.ExecNonQuery("COMMIT;")

Thank you very much.