Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeffrey.m.bryant
Starting Member
5 Posts |
 Posted - 2011-12-20 : 13:31:11
|
| Hi... I think I screwed up major. I have removed the Primary key from my InfoPath 2007 Main datasource and now I cannot update any of the forms. I receive this error on submit. "The value of an ID key or timestamp has been changed. ID keys and timestamp columns are automatically generated by the data source and cannot be changed."Can anyone advise me on how to allow updates or bind a new PK. I have over 1000 rows and I feel like I might be in big trouble. I really appreciate your time and direction.Respectfully, Jeff |
|
|
jeffrey.m.bryant
Starting Member
5 Posts |
Posted - 2011-12-21 : 17:15:50
|
| Well, I unbound all my controls and I could submit again. Then I added a few new columns and modified the form some and I again receive the error.I am using SQL 2008 and neither of my PKs have timestamps involved (NAME char 30 and COUNTER seed 0 increment 1).Could anyone direct me to how to allow update for all rows except the Primary keys? Is that even the problem? I do appreciate your time. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
How can I update all columns except PKs