OraFAQ Forum: Forms » its urgent

Home » Developer & Programmer » Forms » its urgent

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

its urgent [message #194071]

Wed, 20 September 2006 13:03

gutta_rajen@yahoo.com
Messages: 16
Registered: September 2006

Junior Member

Hi
i got struck with a problem in oracle forms.Inthe block order_details product_number,quantity and amount,total amount are the item..
when the user select the quantity field the amount field and total amount fields should get populated..
when the user deletes the record the amount field as well as total amount fiels should also delete..
can any one help me insorting this problem which trigger i have to use ..

thanks in advance

regard's
Rajendra

Report message to a moderator

Re: its urgent [message #194148 is a reply to message #194071]

Thu, 21 September 2006 00:22

sandeepk7
Messages: 137
Registered: September 2006

Senior Member

Either you should use Post-Text-Item or When-Validate_item to populate values for other items.

E.g.
if :order_details.quantity is not null then
:order_details.amount:=value_to_be_populated;
:order_details.total_amount:=:order_details.amount*:order_details.quantity;

might it will work for u....

Sandy

Report message to a moderator

Re: its urgent [message #194198 is a reply to message #194071]

Thu, 21 September 2006 02:53

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

Senior Member
Account Moderator

On retrieval you should use the Post-Query trigger to populate these fields. Only use the WVI trigger to populate them when the values have been changed. Don't use the Post-Text-Item as it will fire EVERY time you traverse the record. It is a waste of resources.

David

Report message to a moderator

Re: its urgent [message #194379 is a reply to message #194071]

Thu, 21 September 2006 16:08

gutta_rajen@yahoo.com
Messages: 16
Registered: September 2006

Junior Member

Hi sandy
thanks it is working....

thanks a lot for u r help

Regard's
Rajendra

Report message to a moderator

Previous Topic:	how to make odbc connection & external data source (merged)
Next Topic:	Forms10g Logon screen intresting question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:26:22 CDT 2024