B4J Tutorial Access DB (mdb) BeginTransaction and AddNonQueryToBatch

I spent quite a bit of time tracking down an error that... wasn't in my project. To prevent you from doing it too...

I had to insert many records into an Access table.

I used a transaction (BeginTransaction).
The project produced no errors, but the table was empty.

I also tried AddNonQueryToBatch; even with this no errors but also no data in the table.

Apparently these two types of operations do not work with ucanaccess and mdb files.

Running the insert queries in a "normal" manner, everything worked.

 

[OliverA]

It just requires an additional call at the right place:

sql.ExecNonQuery("COMMIT;")

See:
(Thanks to @jmon https://www.b4x.com/android/forum/threads/jsql-and-ucanaccess.62909/post-477390

Jrdc with ucanaccess not committing inserts (Solved)

I have Jrdc connecting with ms access ( would prefer not to use access but stuck with it for now). Its working fine for select queries but having trouble with inserts. I am testing on a simple table with an auto 'id' column and 'UserName' text column with unique constraint. I have the config...

www.b4x.com