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