Information générale
Titre:
Error 1585 with Key & Timestamp
Versions des environnements
Network:
Windows 2000 Server
Hello everyone,
I am having an issue with the above. I have a view that includes a timestamp column. I have the WHERE clause set to Key & Timestamp. The timestamp column is part of the SELECT field list. The timestamp column is however marked as non-updateable.
The problem is as follows. If I make a change to the view and save the changes, all is well and the update succeeds. If I then make another change to the view and attempt to save it, I get the above error message. The error recommends to revert the table or update with "Force" mode. If I revert the table and try to re-save it, I still get the above error message.
I have not tried to update the table with "Force" mode because there have been no changes made by any one else and besides, I obviously need to detect real update conflicts :)
Whilst it may appear that another user might have made changes, this is most definately not the case as I have only just developed the table on SQL server, it is on a development server only and there is only me working on the table.
If I change the SQL WHERE clause in the view to Key & Modified fields, everything works as expected?
Any insight to this would be great!
Regards,
Angie.
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