I have a situation where the order records are written (shown via audit
triggers) is a bit odd.
Basically I have code which updates 3 files via separate cursoradapters
(buffermodeoverride=5) in one transaction. The cursoradapters can be Native
or SQL Server.
Cursoradapter 1 is scanned and updated 1 record at a time using
tableupdate(.F.,.F.).
Cursoradapter 2 is scanned and updated 1 record at a time using
tableupdate(.F.,.F.).
Cursoradapter 3 has a single record updated using tableupdate(.F.,.F.)
Transaction ends
The order the records are committed is as follows:
All Cursoradapter 1 records except the last one updated.
All Cursoradapter 2 records except the last one updated.
Cursoradapter 3 record.
Last Cursoradapter 1 record.
Last Cursoradapter 2 record.
Is there any way of getting the last 2 record updates committed before the
Cursoradapter 3 record as it looks really odd in our audit and is bound to
raise questions later?
Thanks for any help.
Bernie