I’m updating the Part table through a UBAQ, i have the correct BO selected (Part, UpdateExt), but when i try to update a row, i get the following
“Column ‘Company, QueryID, ControlID’ is constrained to be unique”
Any ideas?
Hi Martin,
I have an updatable query for Part and Part Rev that is working on UpdateExt too. Make sure you include Company in your display fields data, even if you don’t need to use it. Generally, I think if you want to update a table via a UBAQ you need to include key fields. Could this be your problem?
Nancy
Usually there would be a different error that would pop up if key fields were missing, however I don’t get that specific error.