Home » Developer & Programmer » Forms » its urgent
its urgent [message #194071] Wed, 20 September 2006 13:03 Go to next message
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
Re: its urgent [message #194148 is a reply to message #194071] Thu, 21 September 2006 00:22 Go to previous messageGo to next message
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
Re: its urgent [message #194198 is a reply to message #194071] Thu, 21 September 2006 02:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: its urgent [message #194379 is a reply to message #194071] Thu, 21 September 2006 16:08 Go to previous message
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
Previous Topic: how to make odbc connection & external data source (merged)
Next Topic: Forms10g Logon screen intresting question
Goto Forum:
  


Current Time: Tue Dec 06 13:56:16 CST 2016

Total time taken to generate the page: 0.10960 seconds