mercredi 11 mars 2020

insert row into database when checking corresponding checkbox to that row in apex oracle report

I have apex oracle table report with checkbox column, i want the row corresponding to checkbox to be inserted immediately when the user checks the checkbox without using submit button, just when the user checks the checkbox the row be inserted immediately to the database, any row checked to be inserted immediately in database, how can i do this , please advise me with examples i have no idea how to do this. i did it with submit button but that's not what i need. i used this code but it updates and uses submit button.

declare nvalue number;

begin

if apex_application.g_f01.count <> 0 then

for i in 1..apex_application.g_f01.count loop
    nvalue := to_number(nvl(apex_application.g_f01(i),0)); --value1
    update OPERATION_LOG set POL_HOLDER = to_char(SER_NO)||' - '|| to_char(nvalue) where SER_NO= nvalue;

end loop;
apex_application.g_print_success_message := 'Success' ;

end if;

end;




Aucun commentaire:

Enregistrer un commentaire