Member Avatar for Shailesh25
Shailesh25 0 Newbie Poster 
con.BeginTrans
	con.Execute	"insert into A3 values(1,'B')",cnt1	
	con.Execute	"insert into A3 (id3) values(1)",cnt2
con.CommitTrans

if second statement fails to execute then it should rollback the transcaction.

Here, I want to check whether any transaction is still in process and error has come.
If this is the case then will rollback transaction.

Can any body suggest for this..

  • 1 Contributor
  • 0 Replies
  • 58 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.