StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Error with Insert and Update Stored Procs adnd TimeStamp Columns

Error with Insert and Update Stored Procs adnd TimeStamp Columns

choyt — Tue, 24 Jul 2007 11:40:43 GMT

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

RE: Error with Insert and Update Stored Procs adnd TimeStamp Columns

choyt — Tue, 24 Jul 2007 11:40:43 GMT

Thanks Folks

That did the trick. Appreciate the help!

RE: Error with Insert and Update Stored Procs adnd TimeStamp Columns

Trent L. Taylor — Tue, 24 Jul 2007 11:10:25 GMT

Yeah, you have Optimistic Row Version selected. You need to make it Optimistic Time Stamp to produce the stored proc you are needing.

RE: Error with Insert and Update Stored Procs adnd TimeStamp Columns

choyt — Tue, 24 Jul 2007 10:43:39 GMT

Hi Ben

Attached is the table properties I have setup.

RE: Error with Insert and Update Stored Procs adnd TimeStamp Columns

StrataFrame Team — Tue, 24 Jul 2007 10:18:53 GMT

In the table properties, where you check the boxes to generate the stored procedues, did you set the concurrency type on Update (and maybe delete if you want) to Optimistic Timestamp? And you also have to specify the field in the combo box at the bottom to tell what field is the row version column (so that it gets left out off the inserts and updates).

RE: Error with Insert and Update Stored Procs adnd TimeStamp Columns

choyt — Tue, 24 Jul 2007 09:58:29 GMT

Thanks Larry

Unfortunately, the problem is in generating the stored procedures themselves and not in the business objects.

I'm thinking that this is a bug in the stored procedure generator. It sounds to me like the generator is trying to Insert into and Update the TimeStamp column.

Clay

RE: Error with Insert and Update Stored Procs adnd TimeStamp Columns

Larry Caylor — Tue, 24 Jul 2007 09:52:51 GMT

Under the Strataframe CRUD settings for your business object make sure you set the UpdateConcurrencyType property to OptimisticTimestamp and entered the column name that contains the timestamp in the RowVersionOrTimestampColumn.

RE: Error with Insert and Update Stored Procs adnd TimeStamp Columns

choyt — Mon, 23 Jul 2007 15:02:06 GMT

Hi Folks

Here are 2 screencaps of the error.