OraFAQ Forum: Forms » check box selection in data base block

Home » Developer & Programmer » Forms » check box selection in data base block

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

check box selection in data base block [message #82891]

Tue, 15 July 2003 03:05

Victoria
Messages: 152
Registered: July 2002

Senior Member

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!!!

Thanks
~V~

Report message to a moderator

Previous Topic:	Run Time error
Next Topic:	add lexical and Bind variable to RUN_PRODUCT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 17:12:24 CDT 2024