Issues with running insert using SQLExecDirect

Question

Issues with running insert using SQLExecDirect

gkyechuri

SSC Rookie

Points: 49
More actions
October 16, 2009 at 8:50 am

#98125

I am running an insert statement using sqlexecdirect. The insert will fire couple triggers.
- Does the insert and subsequent triggers will be executed in single transaction ?
It looks like c++ code is getting success before the completion of the triggers!
Has any one noticed this before and Please let me know any suggestions/workarounds.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

I don't know much about C++ or SQLExecDirect, but yes the insert and triggers will fire in a single transaction so either all the actions will complete or fail.

What makes you think you are getting a success message back to your C++ application before the trigger actions have completed?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question