StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Delete stored procedure/Optimistic Timestamp issue

Delete stored procedure/Optimistic Timestamp issue

Gary Wynne — Fri, 01 Sep 2006 03:13:48 GMT

SF doesn’t appear to be passing the TimeStamp value on a Delete by stored procedure when using Optimistic Timestamp. Even thought the properties are set correctly, in the SQL profiler you can clearly see that only the PK is being passed and not the TimeStamp column value.

When doing an Update, the TimeStamp value is being passed. Ideas?

RE: Delete stored procedure/Optimistic Timestamp issue

Gary Wynne — Fri, 01 Sep 2006 03:13:48 GMT

Yes, they are both set.

RE: Delete stored procedure/Optimistic Timestamp issue

StrataFrame Team — Thu, 31 Aug 2006 10:38:17 GMT

There are separate UpdateConcurrencyType and DeleteConcurrencyType properties that control UPDATEs and DELETEs respectively... are they both set to OptimisticTimestamp? (by default, DeleteConcurrencyType is set to Off)