I.T. Discussion Community!
-Collapse +Expand
Delphi
Search Delphi Group:

Advanced
-Collapse +Expand Delphi To/From
To/FromCODEGuides
-Collapse +Expand Delphi Store
PRESTWOODSTORE

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyPascal and Delphi Coding BoardDelphi Distributed Apps Topic   Print This     

Executing Stored Procedures in a Transaction

Executing Stored Procedures in a Transaction in Delphi Distributed Apps topic (part of our Pascal and Delphi Coding group).

Quick Search: Executing   Procedures   Transaction   Executing Stored   Executing Stored Procedures  
Most Recent Post
andyhud
 (Inactive)
Fleet, Surrey, England
Does anyone know why calling ExecProc
for 3 or more stored procedures that each do a simple insert rec into different tables on a SQL Server Database in a transaction and then rolling back the transaction causes the last record to still be inserted?????

I cannot always use Open to run the stored proc (although this resolves the problem) as I an insert does not return a record set.

Help MUCH appreciated!
 Posted 18 years ago (Thread Starter)
Comment Quote
About andyhud -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2805, No Replies Be the first!
Thread Started 7/2/2001 2:19:00 AM
View Counter=1494
Location=Fleet, Surrey, England  
Joined=18 years ago   MB Posts=14  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1233A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #2805 Counter
1494
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech