Examples—Commit Statement
Commit a database statement:
insert into employees(salary, age)
values(:salfield, :agefield);
commit work;
The following event block gives the user a choice to commit or roll back changes before the frame closes:
on terminate =
begin
if CurFrame.ConfirmPopup(messagetext =
'Commit database changes?') = PU_OK then
commit work;
else
rollback work;
endif;
end