RE: Dirty Read

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter Huang (v-phuang_at_online.microsoft.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 08:00:59 GMT

Hi Boaz,

First of all, I would like to confirm my understanding of your issue.
>From your description, I understand that you wants to retrieve data from
database to a disconnected recordset and someone modified the data in the
database, also you will do some change to the disconnected recordset and
then update the recordset back to the database.
Have I fully understood you? If there is anything I misunderstood, please
feel free to let me know.

I think there is a few thing needs to pay attention to.
1. We can not delete the records in the database which will be updated back
to the database.
e.g. we retrieve the a record from database into recordset (CustomerID = 5,
and etc). and someone delete the record with CustomerID = 5, then when
update back into the database there will be an error occur.

2. If we insert a record into the disconnected recordset whose
CustomerID(primary key) is 10, but someone insert a record into the
database whose CustomerID is 10 too, and this will also have an error occur.

Please apply my suggestion above and let me know if it helps resolve your
problem.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages