Check box in Interactive Reports

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Check box in Interactive Reports

Post by admin »

-- A column to be added as below, so the user will check the lines and then in the process loop will insert values in a table.

select
ID,
apex_item.checkbox2(1,PROFILE_ID) as "Select",
name
from js_users

-- Process

begin

for i in 1..apex_application.g_f1.count
loop
apex_debug_message.log_message('Sikandar Hayat: ' || apex_application.g_f10(i));
insert into js_candidates (PROFILE_ID, comments)
values( apex_application.g_f1(i), :P24_COMMENTS);
end loop;
end;
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: Google Adsense [Bot] and 4 guests