CheckBox component

Hi Lezgin,

As i understand you have a grid based on a view. Inside the grid is a checkbox. If you check the checkbox the row must be deleted, and if you uncheck, the row must be saved.

I would do the following: Create the view including the checkbox column (wich would be null for all rows) Define the datasource on the view, and specify the primary key, so you can check insert, update and/or delete. Create the grid with the checkbox and define the checkbox values like:

<checkBox name="your_checkbox_name" column="name_of_view_column" checkedValue="Y" uncheckedValue="N"/>

Create an instead of trigger on the view. In this instead of trigger, catch the condition of the checkbox and save, or remove according to the checkbox value set. Something like this:

create or replace trigger your_trigger_name
   instead of update or delete or insert on your_view_name
begin
   if updating
   then
      if :new.checkbox_value = 'Y'
      then
         update your_table
         set    id          = :new.id
               ,column_name = :new.column_name
         where  id = :old.id;
      else
         delete from your_table
         where  id = :old.id;
      end if;
   elsif deleting
   then
      delete from your_table
      where  id = :old.id;
   else
      /* inserting */
      -- depends on your use case if you can insert a new row
      -- might have to chack for the checkbox value as well..   
      if :new.checkbox_value = 'Y'
      then
         insert into your_table
            (id
            ,column_name)
         values
            (:new.id
            ,:new.column_name);
      end if;
   end if;
end;

After saving the grid with api_datsource.docommit ('your_datasource') requery the grid with api_datasource.executeQuery('your_datasource')

Should work i think..

Best , Michiel A