1. Create 3 button named Insert , Update, Delete
and Enable Edit
2. Create a process On Submit-After Computation and validation.
Copy and Pest the code as PL/SQL
begin
case :APEX$ROW_STATUS
when 'C' then
insert into PRODUCT_STORE ( SERIAL, PRODUCT_SERIAL, PRODUCT_CODE )
values ( :SERIAL, :PRODUCT_SERIAL, :PRODUCT_CODE )
returning rowid into :ROWID;
when 'U' then
update PRODUCT_STORE
set PRODUCT_SERIAL = :PRODUCT_SERIAL
where rowid = :ROWID;
when 'D' then
delete PRODUCT_STORE
where rowid = :ROWID;
end case;
end;
This process is written respecting a table and form item. But you should wright it respecting your table and form item.
No comments:
Post a Comment