Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update conflict error using local view
- Thread starter phita
- Start date
Hi Phita,
In your vies creation, you have used the UPDATE crieteria based on some fields uniquness value. If that is not unique and you have multiple records with the same key value, the UPDATE gets confused. Example..
The view updates based on field1 value. If this field1 value is not a unique field, probably you are editing one records with field1 value="1001" and there are more than one record having the identical value. So the view gets confused as to which record need to be changed. SO you get this error intermittantly when there are more records with similar values. You have to look into the view construction.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
In your vies creation, you have used the UPDATE crieteria based on some fields uniquness value. If that is not unique and you have multiple records with the same key value, the UPDATE gets confused. Example..
The view updates based on field1 value. If this field1 value is not a unique field, probably you are editing one records with field1 value="1001" and there are more than one record having the identical value. So the view gets confused as to which record need to be changed. SO you get this error intermittantly when there are more records with similar values. You have to look into the view construction.
ramani (Subramanian.G),FoxAcc, ramani_g@yahoo.com
- Thread starter
- #3
- Status
