General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Hey Neighbor:
I wrapped it in a transaction and set the isolation level to serialized.
However, one thing still confuses me. Using SQL Passthrough, every transactable command (update, delete, insert) is automatically wrapped in a transaction. If you choose automatic, VFP does it for you and if you use manual, you select when to commit transaction. If VFP is already putting it in a transaction, how does that effect SQL Server transactions? Do they become nested?
Charlie
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