OraFAQ Forum: Forms » unable to Save Value of Formula or summary

Home » Developer & Programmer » Forms » unable to Save Value of Formula or summary (winXp Oralce 9i forms6i)

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

unable to Save Value of Formula or summary [message #397545]

Sun, 12 April 2009 02:24

sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana

Junior Member

Hello all,

I hv net-amt fileld which i put a furmula Grossamt+Discountamt it's show on the filed but its not save in my table.

help me

Report message to a moderator

Re: unable to Save Value of Formula or summary [message #397549 is a reply to message #397545]

Sun, 12 April 2009 03:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you correctly set its properties? (I'm thinking of "Database Item" set to "Yes")

Report message to a moderator

Re: unable to Save Value of Formula or summary [message #397553 is a reply to message #397549]

Sun, 12 April 2009 07:54

sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana

Junior Member

yes my dear i i already set field to database=Y

Report message to a moderator

Re: unable to Save Value of Formula or summary [message #397567 is a reply to message #397553]

Sun, 12 April 2009 13:28

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you COMMIT changes you've made?

Report message to a moderator

Re: unable to Save Value of Formula or summary [message #397587 is a reply to message #397567]

Sun, 12 April 2009 22:58

sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana

Junior Member

yes my dear i commit but it's not save in database

Report message to a moderator

Re: unable to Save Value of Formula or summary [message #397643 is a reply to message #397587]

Mon, 13 April 2009 02:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How exactly did you test whether this value was saved or not? Did you connect to the same schema as you did during your Forms session?

Report message to a moderator

Re: unable to Save Value of Formula or summary [message #398364 is a reply to message #397643]

Thu, 16 April 2009 02:03

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

Senior Member
Account Moderator

Did you do a commit, a forms_commit, or a standard.commit?

And where did you do it? Please post your code (IN CODE TAGS!).

David

Report message to a moderator

Previous Topic:	use jre 1.4.2.09 with forms10g
Next Topic:	how to avoid mutating table error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 11:19:28 CST 2025