Naomi,
My CursorAdapter classes have served me well on this (transactions). I use the DE subclass send SPT "Begin, Commit, Rollback" commands before calling each CA object's TABLEUPDATE(). In case ALL return ok, then fire off a commit. Otherwise, rollback. =)
Dennis
>>Hi,
>>
>>Is this the right approach to use BEGIN/END TRANSACTION when updating more that one cursor adapter cursors? And if the cursor adapters use SQL Server tables, will the ROLLBACK undo the changes to the SQL Server table(s)?
>>
>>TIA.
>
>IMHO, the best way will be to use a Stored procedure, where you can implement transactions.
>
>I don't think VFP transactions will be of much help here - you can search older messages (about 5 years back), I believe Dorin V was having a similar problem and had discussions with Aleksey T.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only