Problem Updating information in forms

More
8 years 1 month ago #13482 by JD
I am unable to save information in some Tables/Records. I edit the text/date and then when I hit the green check mark to save or the arrow to save and move to the next record this error comes up.




Any ideas?

5.3.1.13
SQL Server 2014
Attachments:

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #13483 by admin
Have you defined Primary key as described here

www.etl-tools.com/wiki/ate:menu_items

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #13487 by JD
I figured this one out, there was a duplicate in the primary key column.

Thanks

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #13489 by JD
Just kidding, I removed the duplicates and I am still getting the error even with a unique PK

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #13496 by JD
Any ideas here?

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #13497 by admin
Idea is still the same

Have you defined PK?


Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.