Commiting Records

Hallo

I am using Adodc in my app. On my save function, I use datPrimaryRS.Recordset.UpdateBatch adAffectAll. The problem I am experiencing is that the data is only committed when the window is closed! Is there some way to force the ado to commit right after the adUpdateBatch code is executed?

Thanx

Hi hermanvd
Did you try using datPrimaryRS.refresh ??????

Hallo

That only refresh the recordset and not the entries in the database. Thanx but as I understand Resync is suppose to do this.

Thank you