OraFAQ Forum: Forms » How to Use CheckBox Is Checked All In Block by button

Home » Developer & Programmer » Forms » How to Use CheckBox Is Checked All In Block by button (XP SP3, Oracle Form 6i)

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

How to Use CheckBox Is Checked All In Block by button [message #442174]

Fri, 05 February 2010 02:35

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One by one, in a loop.

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator