how do i use a form 6i calculated field

[bookouri]

The documentation seems really straight forward on this but it doesnt work for me. I have a simple form with one datablock. I put some fields on a form and one of them is a total_field. I make that total_field a calculated - formula and put in :datablock.field_one + :datablock.field_two + :datablock.field_three etc. When I run the form the total_field will correctly calculate the numbers put in field1 field2 field3 etc. However when I save the form the form does NOT save the total_field. When I select the records from the table the field1 field2 field 3 amounts are there but total_field is null. The documentation seems to say that the contents of the total_field will be saved since that total_field is a datablock item.

what am i doing wrong...

 

[sem]

How may it be saved?! There's no place in Oracle database to save totals, unless you created it. Regards, Dima

 

[bookouri]

I had a totals column in the database. What I found is that using the calculated options and putting in a formula would display the total on screen but would not save it to the underlying column..apparently a "feature" I ended up putting a trigger on each of the fields that are being entered for totalling and just making the column item := to the field1 + field2..etc.... and having it recalculate every time a number is changed....

 

[prosuc]

Oracle don't save the values obtained from a formula. Your alternative solution is right.