Unable to update/add to table

[cooh23]

Hi All,

I recently upgraded to a SQL server backend. After the upgrade, i was able to add/update a particular table but now i can't seem to do anything. This is only happening for 1 table.
However, I am able to add/update from the tables in SQL server directly.

what could possibly be the issue here?

Thank you,

 

[cooh23]

Hi All,

I recently upgraded to a SQL server backend. After the upgrade, i was able to add/update a particular table but now i can't seem to do anything. This is only happening for 1 table.
However, I am able to add/update from the tables in SQL server directly.

what could possibly be the issue here?

Thank you,

Nevermind, upon further investigation, i remembered that i had rebuilt the indexes of my table and because of that my Unique ID changed to non-unique.

Thank you,