Home » Developer & Programmer » Forms » Calculated items are not Getting Saved.
Calculated items are not Getting Saved. [message #243628] Fri, 08 June 2007 02:10 Go to next message
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.

Re: Calculated items are not Getting Saved. [message #243821 is a reply to message #243628] Sat, 09 June 2007 06:17 Go to previous messageGo to next message
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.
Re: Calculated items are not Getting Saved. [message #243834 is a reply to message #243628] Sat, 09 June 2007 13:33 Go to previous messageGo to next message
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.
Re: Calculated items are not Getting Saved. [message #243858 is a reply to message #243834] Sun, 10 June 2007 01:43 Go to previous message
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
Previous Topic: how to invoke a LOV with a push button
Next Topic: Setting up Oracle Forms
Goto Forum:
  


Current Time: Fri Dec 09 23:24:29 CST 2016

Total time taken to generate the page: 0.10774 seconds