OraFAQ Forum: Forms » Calculated items are not Getting Saved.

Home » Developer & Programmer » Forms » Calculated items are not Getting Saved.

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

Calculated items are not Getting Saved. [message #243628]

Fri, 08 June 2007 02:10

sreepathi.das
Messages: 12
Registered: May 2007
Location: Cochin,Kerala

Junior Member

Hi friends.

I am facing a problem in both 6i and 9i.

I have some fileds which are calculated items.
I have written some formula in its fomula property and its calculation type is Formula.This field is a database item.

Now the problem is that when i have data in all these fields and i am saving it,These calculated fields are not saved.
I am having null values in the table for this field.

I solved it by placing a non database item in the form and calculating to it and then asiigning this non database item to my actual database item in PRE-INSERT and PRE-UPDATE triggers.
It is working.

Is there any other simple way to solve this problem?
Why it is not saving this item?

Thnks in Advance.

Report message to a moderator

Re: Calculated items are not Getting Saved. [message #243821 is a reply to message #243628]

Sat, 09 June 2007 06:17

mustaf_82
Messages: 20
Registered: May 2007
Location: UAE

Junior Member

Check in the button property Database Column=Yes and enter the column Name which is present in the table.

Report message to a moderator

Re: Calculated items are not Getting Saved. [message #243834 is a reply to message #243628]

Sat, 09 June 2007 13:33

hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE

Senior Member

oops..

you cannot tag a calculated field as a database field.
It is always non db.

even if you set it to database proeprty yes and give the name of the table-column in the source.

Report message to a moderator

Re: Calculated items are not Getting Saved. [message #243858 is a reply to message #243834]

Sun, 10 June 2007 01:43

sreepathi.das
Messages: 12
Registered: May 2007
Location: Cochin,Kerala

Junior Member

Oh,
Then thats the problem...
it cannot be taged a calculated field as a database field.
Ok.
Thank you very much hemavb

--
Regards
Sree

Report message to a moderator

Previous Topic:	how to invoke a LOV with a push button
Next Topic:	Setting up Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 09:31:06 CDT 2025