checking status of COMMIT

[siraj777]

Working on PowerBuilder 8 with Oracle 9

dw_1.DeleteRow(li_row); // Deleting row

If dw_1.Update() = 1 Then // Updating the table
COMMIT USING SQLCA; // Commit
End If

// DO I need to write the below line of code
If SQLCA.SQLCODE = -1 Then
ROLLBACK USING SQLCA;
END IF

 

[mbalent]

It is always good practice to check the SQL return codes.