# Update to response 02/10/2022 UTC-05:00 Colombia

I would like to tell you that I fixed the error in time to show the user and the problem was that when I copied the forms to the other page, the interactive grid DML was not taken and I thought that just by activating the CRUD it created the process automatically.

Regards,
Edisson


Hi,

I made an interactive grid with the APEX wizard and well I tried it to find out how the CRUD worked and well I copied it to another page I tried it again and everything was perfect, well I started having problems when adding the following:

1. Interactive Grid -> Region -> Source -> Type(SQL Query)->

select 
    syw_fields.id,
    syw_fields.seq,
    syw_fields.subform,
    syw_fields.name as name,
    syw_fields.label as label,
    syw_fields.value as value,
    syw_fields.type as type,
    syw_fields.select_id,
    syw_fields.validators,
    syw_fields.form_id
 from syw_fields syw_fields
 where syw_fields.form_id = :p4_forms --parameter for filter

2. Columns -> syw_fields.type -> Type(Popup LOV) -> List of Values -> SQL Query ->

select 
 types_html.html_name as html_name 
from types_html types_html

3. Columns -> syw_fields.select_id -> Type(Popup LOV) -> List of Values -> SQL Query ->

select  
 syw_selects.select_name as select_name,  
 syw_selects.select_id as select_id  
from syw_selects syw_selects

4. Columns -> syw_fields.name -> Dynamic Action -> When -> Event (Key press), Selection Type(Column(s)), Column(s)(name) -> True -> Action -> Set Value -> Settings -> Set Type -> SQL Statement ->

select 
 :P4_FORMS 
from dual;

-> Items to Submit -> FORM_ID -> Affected Elements -> Selection Type(Column(s)) -> Column(s)(FORM_ID).


When I press save, the record disappears, and I get a message Changes Save, but I check, and it is not yet in the record.