>One of my clients is having an update conflict message when deleting a record. That record is from a view. We do not use a DBC so there is no trigger. The only thing I can see is that there was a duplicate key in the table. However, we checked that and there isn't. We checked that with SET DELETE OFF and no pack was done on the table since its creation. Can someone tell me what else can cause an update conflict at delete time on a view if this is not a duplicate key?
Have you check the Key Update in the view and the Where clause? There is some chances it can be the view the problem, not the table.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement