Re: selecting check box inside database block

Manikandan wrote:

> declare
> lvar_lableId varchar2(20);
> lnum_recCount number;
> begin
> select count(*) into lnum_recCount from file_name;
> select decode(:chk_all,1,'Clear All','Select All') into lvar_lableId
> from dual;
> set_item_property('chk_all',PROMPT_TEXT ,lvar_lableId);
> first_record;
> :file_name.chk_selectfile := :chk_all;
> for i in 1..lnum_recCount loop
> next_record;
> :file_name.chk_selectfile := :chk_all;
> end loop;
> end;
>
> The above code is used to select all the check boxii in the database
> block by selecting 1 'Select All' check box.
> But it is not checked/unchecked correctly.
>
> Where am i wrong?
> Please guide me!!!
>
> --
> Posted via http://dbforums.com

Maybe I'm missing something but I don't see any relationship between the code and what you are trying to do.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
[Quoted] damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)