This discussion is archived
3 Replies Latest reply: Apr 17, 2013 2:06 AM by Alan Lawlor RSS

Sum of updateable column on tabular form adds default value

Alan Lawlor Explorer
Currently Being Moderated
Hi folks

Apex 4.2.1, Oracle 11gr2

I have a weird one for you - I have an master/detail form and the detail region is an updateable tabular sql query.

I have a quantity column which is updateable, and I want to show the total. On the report attributes/ column attributes, I have checked the "sum" checkbox. This successfully shows the sum total of my quantity column.

However, if I specify a default value for the column, it ADDs this default value to the sum total.

Sounds very much like a bug to me, but I am interested in others who have encountered this and whether there is a SIMPLE way around this. I do want to avoid adding lots of Javascript/Jquery as suggested in other threads to maintain running totals dynamically.

I have modified the sample DB application to show total quantity on the Order detail and it demonstrates this "feature" : http://apex.oracle.com/pls/apex/f?p=19287:4 - log in as demo/demo and edit order 0010 to see that it adds 1 to the total quantity (which is the default value for quantity).

I had encountered this also in Apex 4.1.1

Looking forward to your feedback !

Alan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points