|
|
|
Re: Property Palette > Calculation Mode > Formula [message #660606 is a reply to message #660602] |
Wed, 22 February 2017 03:17 |
cookiemonster
Messages: 13920 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Can users insert records in the middle or only at the end?
Can users update either debit or credit?
If they can't update those columns and can only insert at the end then it's not particularly difficult, if they can it's going to be very awkward to implement.
|
|
|
Re: Property Palette > Calculation Mode > Formula [message #660615 is a reply to message #660606] |
Wed, 22 February 2017 12:04 |
|
sr8464
Messages: 82 Registered: February 2017 Location: India
|
Member |
|
|
Test Case
CREATE TABLE ITEMTRAN_BODY
(
VRNO VARCHAR(11) NOT NULL,
CODE NUMBER(11) NOT NULL,
QTYRECD NUMBER(12,3) DEFAULT 0.000,
QTYISSUED NUMBER(12,3) DEFAULT 0.000,
CONSTRAINT PK_ITEMTRAN_BODY PRIMARY KEY (VRNO)
);
INSERT INTO ITEMTRAN_BODY (VRNO, CODE, QTYRECD, QTYISSUED ) VALUES ('CC','2','0','2');
INSERT INTO ITEMTRAN_BODY (VRNO, CODE, QTYRECD, QTYISSUED ) VALUES ('DD','3','1','0');
INSERT INTO ITEMTRAN_BODY (VRNO, CODE, QTYRECD, QTYISSUED ) VALUES ('AA','1','1','0');
INSERT INTO ITEMTRAN_BODY (VRNO, CODE, QTYRECD, QTYISSUED ) VALUES ('BB','2','2','0');
INSERT INTO ITEMTRAN_BODY (VRNO, CODE, QTYRECD, QTYISSUED ) VALUES ('EE','3','0','2');
COMMIT;
In PlSql My Query & its result...
SELECT VRNO, CODE, QTYRECD, QTYISSUED, SUM (QTYRECD-QTYISSUED) OVER (ORDER BY VRNO,CODE) CLOSING FROM ITEMTRAN_BODY;
1 AA 1 1.000 0.000 1
2 BB 2 2.000 0.000 3
3 CC 2 0.000 2.000 1
4 DD 3 1.000 0.000 2
5 EE 3 0.000 2.000 0
In Oracle Form Builder
I have 2 Block ITEM_MAIN_BLOCK and ITEM_QUERY_BLOCK
1 Text Item in ITEM_MAIN_BLOCK name... CODE_LOV Where List of value defined for CODE1 when i press F9 Showing LOV, Suppose i selected 2
A Trigeer is defined under CODE_LOV
KEY-NEXT-ITEM
DECLARE
CURSOR C_CODE IS
SELECT VRNO, CODE, QTYRECD, QTYISSUED FROM ITEMTRAN_BODY
WHERE CODE = :CODE_LOV;
BEGIN
GO_BLOCK ('ITEM_QUERY_BLOCK');
CLEAR_BLOCK(NO_VALIDATE);
FIRST_RECORD;
FOR CUR IN C_CODE LOOP
:VRNO1 := CUR.VRNO;
:CODE1 := CUR.CODE;
:QTYRECD1 := CUR.QTYRECD;
:QTYISSUED1 := CUR.QTYISSUED;
NEXT_RECORD;
END LOOP;
FIRST_RECORD;
GO_ITEM ('CODE_LOV');
END;
2nd ITEM_QUERY_BLOCK, in Property Palette No of Item Displayed '10' and Insert Allowed 'No'
5 Text Items name... VRNO1 CODE1 QTYRECD1 QTYISSUED1 CLOSING1
Then Result... In form
SELECT VRNO, CODE, QTYRECD, QTYISSUED, SUM (QTYRECD-QTYISSUED) OVER (ORDER BY VRNO,CODE) CLOSING FROM ITEMTRAN_BODY WHERE CODE='2';
1 BB 2 2.000 0.000 2
2 CC 2 0.000 2.000 0
Which Trigger i define to get Running Total in Oracle Form
Can any one post me the FMB or Solution for this...
-
Attachment: TEST.fmb
(Size: 52.00KB, Downloaded 188 times)
[Updated on: Wed, 22 February 2017 14:20] Report message to a moderator
|
|
|
|
|
|
|
|
|
|