For a non-base table field u have to add it to the table row each time. i,e if u have 20 rows in the table with(quantity ,price fields ) then u have to add 20 non-base table fields.
is that the way u r doing....
Are you sure ? That doesnt make sense to me
The number of rows will change over time so I wont know whether to create 20 or 500 or 10000 calculated fields
If I have 10000 rows, it is not feasible for me to manually define 10000 calculated fields in ApEx, one at a time.
Thanks, but its not the solution that I am after
I am looking for a solution that will ...
1) not require the calculated value TOTAL to be stored in the table
and 2) re-calculate the TOTAL when I modify the dependent values (QTY and PRICE) before I save the changes to the database
I am still looking for a solution if anyone can help
just go to Edit Region of a Tabluar form and then in Region Source change/add as
"PRICE",(quantity*price) as sum_total
Thanks. My calculated value is now retrieved by the query
However, the TOTAL calculated value only recalculates when I press the SAVE button
I need it to also recalculate immediately when I change the value of PRICE or QTY, without requiring me to save the changes.
I Think its not possible to recalculate immediately when u change the PRICE or QTY without any action (i,e click Save button or any thing)....Total is a virtual column ..