Delete stored procedure/Optimistic Timestamp issue


Author
Message
Gary Wynne
Gary Wynne
StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)
Group: Forum Members
Posts: 10, Visits: 40
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?

StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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)
Gary Wynne
Gary Wynne
StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)StrataFrame Beginner (16 reputation)
Group: Forum Members
Posts: 10, Visits: 40
Yes, they are both set.
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