OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » Total

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

Total [message #165038]

Tue, 28 March 2006 02:22

lailakhalid
Messages: 7
Registered: March 2006
Location: LUTON

Junior Member

I need to create a button to show all "Open" problems on an Incident Table on oracle 9i. What would be the best way to go about this, also a total of all the open calls at the bottom.

Any advice would be appriciated.

Report message to a moderator

Re: Total [message #165207 is a reply to message #165038]

Tue, 28 March 2006 23:16

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In the When-Button-Pressed trigger associated with your 'Open Problems' button use the Set_Block_Property ('blk',default_where) statement to include "status='OPEN'" and an Execute_Query to bring the records back.

You can EITHER use a cursor to do a 'select count(*) into :ctrl.counter' (ctrl.counter is a field that exists on your control block 'ctrl' and which is displayed on your canvas) OR AFTER the Set_Block_Property and BEFORE the Execute_Query perform a Count_Query and store the result into :ctrl.counter.

David

Report message to a moderator

Previous Topic:	MultiBlocks
Next Topic:	Calendar Control

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:35:15 CDT 2024