Home » Developer & Programmer » Forms » Master Detail database block populating (Oracle forms 11g)
icon5.gif  Master Detail database block populating [message #678216] Mon, 18 November 2019 06:02 Go to previous message
ANASKABIR
Messages: 15
Registered: November 2019
Junior Member
I have created Three level master detail database block and their replica Three level master detail database block. I want to populate data to replica database block from original database block.

In the Button I tried This .. But did not work for all master detail data ..

BEGIN
GO_BLOCK ('DIVISION_R');
:DIVISION_R.DIVISION_NAME := :DIVISION.DIVISION_NAME;

GO_BLOCK ('DISTRICT_R');

LOOP
SELECT DISTRICT_NAME
INTO :DISTRICT_R.DISTRICT_NAME
FROM DISTRICT;
NEXT_RECORD;
STANDARD.COMMIT;
EXIT WHEN :SYSTEM.LAST_RECORD = 'TRUE';
END LOOP;


GO_BLOCK ('UPAZILA_R');

LOOP

SELECT UPAZILA_NAME
INTO :UPAZILA_R.UPAZILA_NAME
FROM UPAZILA;

NEXT_RECORD;
STANDARD.COMMIT;
EXIT WHEN :SYSTEM.LAST_RECORD = 'TRUE';
END LOOP;

END;





Example Picture: in the attachment
  • Attachment: Form.JPG
    (Size: 38.29KB, Downloaded 1586 times)

Report message to a moderator

[Message index]
 
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: install forms 6i and developper 2000 under windows 10 64 bits
Next Topic: Move Item on a Canvas
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 03:37:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.