I have 2 Recordsets on 2 different applications communicating with the same
-=The first Recordset is opened with=-
m_pGlobal_RS->Open(adCmd, m_pConnection.GetInterfacePtr(), adOpenKeyset,
-=The second Recordset is opened with=-
local_RS->Open(adCmd, m_pConnection.GetInterfacePtr(), adOpenKeyset,
* adCmd is a simple SELECT statement that is the SAME for both recordsets.
The code order is roughly this
Change fields on m_pGlobal_RS
MoveNext on all rows of m_pGlobal_RS until EOF then MoveFirst // since
pessimistic every row op sends update
I then fire an event to another application which opens local_RS.
It is random whether the data opened by the second RS is the pre-update data
or the post-update data. How can this be? I opened the connection
with the default synchronous option, isn't this asynchronous behavior?
Thanks for the help,