Long tabular form checkboxes not working right. [message #539905] |
Thu, 19 January 2012 04:44 |
|
balckbandit5
Messages: 104 Registered: December 2011
|
Senior Member |
|
|
Hi,
I'm having a problem with a long tabular form with checkboxes. Its basically just a list and you select the things that are relevant to you using the checkboxes then a PL/SQL process updates the database accordingly:
Delete from LEGAL_PERSON_SPOKEN_LANGUAGE
where MUID = :P19_MUIDD;
FOR i in 1..APEX_APPLICATION.G_F09.count
LOOP
if APEX_APPLICATION.G_F09(i) is not null then
insert into legal_person_spoken_language(MUID, language_code)
values(:P19_MUIDD, APEX_APPLICATION.G_F09(i));
end if;
END LOOP;
as I say, its a long list. So its on more than 1 page (I mean you have to click 'next' at the bottom to see everything) and this is what seems to be the problem.
Lets say there are 10 rows and it displays 5 at a time.
Values: 1, 2, 3, 4, 5, 6, 7, 8, 9, 0.
I want to select 1, 3, and 9 so I select 1 and 3 on the first page then click 'next' and select 9 on the second.
If I then submit when I'm on the second page, only the 9 gets enterred into the database. If I submit when I'm on the first page only the 1 and 3 get submitted...so it only submits the ones you've selected on the current page...
I'm really sure why it should do that...surely once the checkboxes are selected, thats that?
I don't know if this is something other people have encountered...I couldn't find anything helpfull online so...yeh
thanks
source for the tabular form:
select
ea.language_code,
ea.language_name name,
APEX_ITEM.CHECKBOX(9,ea.language_code,DECODE(lpea.language_code,null,'','CHECKED') ) sel
from LEGAL_PERSON_spoken_language lpea, spoken_language ea
where MUID (+)= :P19_MUID
and lpea.language_code (+)= ea.language_code
order by muid, language_name
EDIT: oh I'll just add that I have checked going back to a page where I've selected something and the checkbox is no longer checked...
[Updated on: Thu, 19 January 2012 04:47] Report message to a moderator
|
|
|
|
|