General information
Category:
The Mere Mortals .NET Framework
Title:
ExecNonQuerySQL Participation in Transaction
I have a parent business object with several child objects to handle the data changes when creating statements for customers. I tried to use GetDataBySQLQuery() on one of the business objects, but I get an error that a referenced key (created within the transaction) does not exist. It works fine if I use the same business object, fill the business object and make the same change.
Does the ExecNonQuerySQL() participate in the transaction of the business object? If not, how can I structure the activity so it is included. This action may change 1,000's of records and I'd rather do it with a database hit for speed purposes.
Thanks,
Jeff
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