Since this weekend's update, I've been sporadically getting a the following error when updating a service log I created. The screen worked great for a few weeks prior to the this weekend's push. I made some minor changes but they shouldn't have caused this error and when tested...they worked fine. I also tried a couple of different screen versions but I still get the error. It is also sporadic and hard to reliably duplicate. I don't want to undo hours of work only to determine that it might be something related to the weekends update. The error is:
"Viloation of UNIQUE KEY constraint 'PoolServiceLog_ActivityNoRef_unique'. Cannot insert duplicate key in object 'dbo.PoolServiceLog'. The statement has been terminated.
Additional Information
Action Sequence Order:53"
I'm currently using the screen FieldService_AddEditWorkOrder_Live_Backup062609_live and getting the error. I also get the error with the older versions. I assume that the error is telling me that I can't create a new record because it thinks one already exists; however, in reality...it doesn't exist.
Background: I added a section on this screen that takes user input and creates a Pool Service Log entry (when one doesn't exists) or updates the log entry (if one does exists).
Any guidance would be greatly appreciated.
James Stapleton
Update: I will be adding this entry into the QXpress Online forum.