We are using UpdateBatch to update changes made to a disconnected recordset.
The problem is that it appears ADO(2.1) is performing Updates in the
recordset before doing Inserts. I would expect UpdateBatch would perform in
the following order:
It appears that Updates are happening before Inserts. We are getting a
'Foreign Key' violation because of this. If I do an insert, then save, and
then do a change(Update), and save again, everything works fine, but if I do
the insert and then the change(Update) and THEN save, it fails because of
the Foreign Key violation.
We are using the Microsoft OLE DB Provider for SQL Server, going against SQL
Server 7.0 SP1. I can't find anything which talks about the order in which
the items are processed. It almost looks like it might being looping
through the recordset, in Bookmark order, and performing the tasks in
Any suggestions, or pointers to where I might look for more information,
would be greatly appreciated.
Mark A. Essex