-
Cesar Lirato
- PowerBuilder
- Wednesday, 9 March 2022 04:08 PM UTC
Hey Guys.
I try to insert a record in my table, have a simple program.
I describe the step by step
1.-The user completes the form(Datawindow freeform)
2.-I run update() for the first time
the program runs and fails, I call rollback in the program.
3.-The user makes the corrections
4.I run update() a second time
the program runs and after the dw.update() method, it fails and shows "Row Changed between retrieve and update"
The table has no records, the test is performed by only one user in the system.
WHERE clause for update/delete: key Columns
/*********
user event of window ue_save()
IF dw_mant.accepttext( ) <> 1 THEN RETURN
IF dw_mant.event ue_valida() = -1 THEN RETURN
IF dw_mant.Update() = -1 THEN
ROLLBACK using sqlca;
RETURN
END IF
INSERT STATUS (ID, STATE) VALUES (:al_id, :as_state);
IF SQLCA.SQLCODE<>0 THEN
ROLLBACK using sqlca;
MESSAGEBOX("","ERROR" + STRING(sqlca.SQLDBCode)+' ' + sqlca.SQLErrText)
RETURN
END IF
COMMIT;
/**********
Please help me.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.