StrataFrame Forum

Delete stored procedure/Optimistic Timestamp issue

http://forum.strataframe.net/Topic2580.aspx

By Gary Wynne - 8/31/2006

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?

By StrataFrame Team - 8/31/2006

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)
By Gary Wynne - 8/31/2006

Yes, they are both set.