For our Cycle (DB table) values within Quality Center we have one field setup to 'allow multiple selections'. Since we added this field I can no longer do simple updates on the CYCLE table via the backend.
Everytime I try to do an update I get an error stating: "Invalid Object: CYCLE_MULTIVALUE". I can however update the multivalue table which I thought was odd.
I have tried everyting I could think of and have had no luck thus far. I have found that I can completly delete the whole record then reinsert it with the modified value but this sounds like more of a hack than a solution ... is anyone familiar with an SQL update syntax that will assist with this situation?