Home » Developer & Programmer » Forms » How to Use CheckBox Is Checked All In Block by button (XP SP3, Oracle Form 6i)
icon2.gif  How to Use CheckBox Is Checked All In Block by button [message #442174] Fri, 05 February 2010 02:35 Go to next message
lok1830
Messages: 7
Registered: February 2010
Location: THAILAND
Junior Member
Hi All Friend.

I query data to block customer is show 10 rows and have scrollbar.
I have problem about CheckBox, I want it checked all row in block by button.


Thk for read, please help me.
Re: How to Use CheckBox Is Checked All In Block by button [message #442175 is a reply to message #442174] Fri, 05 February 2010 02:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One by one, in a loop.
Re: How to Use CheckBox Is Checked All In Block by button [message #442177 is a reply to message #442174] Fri, 05 February 2010 03:02 Go to previous messageGo to next message
lok1830
Messages: 7
Registered: February 2010
Location: THAILAND
Junior Member
Thk for "One by one, in a loop."

I think may be method or function or property which better it way.

Re: How to Use CheckBox Is Checked All In Block by button [message #442180 is a reply to message #442174] Fri, 05 February 2010 03:28 Go to previous messageGo to next message
lok1830
Messages: 7
Registered: February 2010
Location: THAILAND
Junior Member
Okey I find the way

I use trigger in button
My code

IF :GLOBAL.SELE_MODE = 'ALL' THEN
:GLOBAL.SELE_MODE := 'NONE';
ELSE
:GLOBAL.SELE_MODE := 'ALL';
END IF;
GO_BLOCK('OUTLET_INF');
EXECUTE_QUERY;


And trigger post-query In Block OUTLET_INF

IF :GLOBAL.SELE_MODE = 'ALL' THEN
:OUTLET_INF.PRN_SEL := 'Y';
:GLOBAL.CDOC_LST := :GLOBAL.CDOC_LST + 1;
ELSE
:OUTLET_INF.PRN_SEL := 'N';
:GLOBAL.CDOC_LST := :GLOBAL.CDOC_LST + 1;
END IF;


Thk for read topic and try to help me
Re: How to Use CheckBox Is Checked All In Block by button [message #442243 is a reply to message #442180] Fri, 05 February 2010 21:56 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
Is your ChekcBox & query data block in Same Block?
Re: How to Use CheckBox Is Checked All In Block by button [message #442244 is a reply to message #442243] Fri, 05 February 2010 22:08 Go to previous message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
Find the following attachment.
connect scott user & run the fmb.


Regards,
Tamzidul Amin.
  • Attachment: CHECKBOX.fmb
    (Size: 44.00KB, Downloaded 187 times)
Previous Topic: priviliges assign
Next Topic: Attaching file in UTL_MAIL.send_attach_varchar2
Goto Forum:
  


Current Time: Fri Dec 09 06:14:30 CST 2016

Total time taken to generate the page: 0.10284 seconds