Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is ROLLBACK automatic?

Status
Not open for further replies.
siraj777

siraj777

Programmer
Aug 22, 2002
27
IN
Using PowerBuilder 8 with Oracle 9.

dw_1.DeleteRow(li_row)
dw_1.Update()
COMMIT;

Is the ROLLBACK automatic when COMMIT FAILS? or do we need the following statement?

If sqlca.sqlcode = -1 Then ROLLBACK
 
Sort by date Sort by votes
it is set at transaction object level
Ex: SQLCA.AutoCommit = True
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spnatal
  • Locked
  • Question
Spin Editmask Issue
Replies
0
Views
107
spnatal
spnatal
law1233
  • Locked
  • Question
Power Builder based application opening issue
Replies
1
Views
140
FabrizioV
FabrizioV
RubensLott
  • Locked
  • Question
HOW TO CHECK IF A FILE EXISTS AND IS ALREADY FINISHED
Replies
2
Views
175
RubensLott
RubensLott
bansshilpi
  • Locked
  • Question
Retaining DisplayCoulm value of dddw which is multiply used in a single datawindow
Replies
4
Views
157
PowerObject
PowerObject
suryak
  • Locked
  • Question
Printer Automatically Stopped Working at Last Row
Replies
0
Views
71
suryak
suryak

Part and Inventory Search

Sponsor

Back
Top