OraFAQ Forum: Forms » Updating value

Home » Developer & Programmer » Forms » Updating value

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

Updating value [message #171051]

Mon, 08 May 2006 02:08

seemafarheen
Messages: 8
Registered: January 2006

Junior Member

I want to increment a value in control block , ie initial value I am taking from database . For doing this I have used WHEN_NEW_BLOCK_INSTANCE trigger . But this trigger executes only once and gives the initial value . Now to increment that in control block

Report message to a moderator

Re: Updating value [message #171069 is a reply to message #171051]

Mon, 08 May 2006 04:17

hidayatk
Messages: 25
Registered: November 2005

Junior Member

to incremet use 'select colum+increment_value into item from table'..but..
if block is multi-record, then use pre-text_item/when_new_item_instance on the item and if u want fresh value from database, then before select, a commit_form is advised.

Report message to a moderator

Re: Updating value [message #171170 is a reply to message #171069]

Mon, 08 May 2006 18:25

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

Senior Member
Account Moderator

If you only want it to happen ONCE, then use the When-Create-Record trigger at the block level.

David

Report message to a moderator

Previous Topic:	Query Problem
Next Topic:	Running Sum in Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:54:08 CDT 2024