OraFAQ Forum: Forms » unable to insert or update the formula field

Home » Developer & Programmer » Forms » unable to insert or update the formula field

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

unable to insert or update the formula field [message #182756]

Tue, 18 July 2006 01:29

aditya_gangadharam
Messages: 43
Registered: February 2005
Location: Hyderabad

Member

hi all,

I have three columns in my table as quant,rate_qty,amnt
where amnt = rate_qty*quant;

i am using the datablocks in forms 6.

when i give the formula to the amnt this is not getting inserted but the quant and rate_qty are inserted even if I update the quant and rate_qty they are updating but amnt is not updating.

thanks in regards,

aditya..

Report message to a moderator

Re: unable to insert or update the formula field [message #182842 is a reply to message #182756]

Tue, 18 July 2006 06:43

rana.irfan@arzootex.com
Messages: 15
Registered: June 2006
Location: Faisalabad.

Junior Member

Dear,
through Formula in Forms you can't do this.

just write this in Post-change in Block level.
:Amnt:=Nvl(:Rate_Qty,0)* NVl(:Quant,0);

Regards,

Rana Irfan

Report message to a moderator

Previous Topic:	Microsoft Tree Control
Next Topic:	calling a webservice from another webservice in Oracle forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:52:12 CDT 2024