Multiple inserts
Hello All,
I am running Forms 10g. Please forgive my lack of knowledge.
As I understand it, the post_query that inserts data into my field Boxes, runs for every line. It also needs one record to process. What I need is it to process with multiple records.
The following code run perfectly if I take out the GROUP BY. It sums all the boxes and sticks in the total for all records. The problem is I want to sum by line_number then by shipment_number and put that number in the corresponding line/shipment number.
for example the last two lines would combine into 1 line with the insert being 8. In total there would be 3 lines inserted 1.1, 2.1 and 2.2 with box totals of 10, 10 and 8 respectively.
I am running Forms 10g. Please forgive my lack of knowledge.
As I understand it, the post_query that inserts data into my field Boxes, runs for every line. It also needs one record to process. What I need is it to process with multiple records.
The following code run perfectly if I take out the GROUP BY. It sums all the boxes and sticks in the total for all records. The problem is I want to sum by line_number then by shipment_number and put that number in the corresponding line/shipment number.
for example the last two lines would combine into 1 line with the insert being 8. In total there would be 3 lines inserted 1.1, 2.1 and 2.2 with box totals of 10, 10 and 8 respectively.
0