Search This Blog

Saturday, February 24, 2018

Interactive Grid Manual Insert, Update, Delete Button process

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

How to Implement Password Hide/Show in Login Page

Follow these steps to enable users to toggle between hiding and showing their password on the login page. Step 1: Add the Function and Glob...