I think it's a bug, but someone knows the opposite (I hope).
I have a form where I can create a batch (of payments of the month). When a new batchnumber is created, a query is called to collect records. A button creates a XML file. During this procedure, a batchdate will be increased in periodes in giving order. All SELECT and INSERT queries are working on a separate SQLTransaction.
All those things are working.
When I use commitretaining and open a contactform, I can't see the batchdate is changed. When I close my application reopend it, the batchdate is changed visually.
But when create a new batch again, use commit and open a contactform, I can see the changed batchdate.
So Why is commitreaining not refressing my data correctly?