Error with Insert and Update Stored Procs adnd TimeStamp Columns


Author
Message
choyt
choyt
StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)StrataFrame Novice (92 reputation)
Group: Forum Members
Posts: 78, Visits: 246
Hi Folks

I am using the DDT to create my DML sprocs.

All of my tables have an integer identity field as the PK and a TimeStamp column named RowVersion for use with concurrency.  When I generate the sprocs using the DDT, I get this error on all of the Update and Insert statements (the deletes work fine)

Cannot insert an explicit value into a timestamp column. use INSERT with a column list to exclude the timestampe column, or insert a DEFAULT.

I tried setting the default to 0 in the DDT table structure interface but get a broken rule.

I understand why I'm getting this error but not sure what to do about it. When using  TimeStamps, do I need to do this piece manually?

Thanks!

Clay

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search