Multiple Master record block with details
From: Ngew Seng Heng <shngew_at_ipacs.com>
Date: Thu, 7 Oct 1999 15:47:00 +0800
Message-ID: <7thj8u$59h$1_at_mawar.singnet.com.sg>
I had created the master block (job header) and detail block (job detail), both having a relationship.
I wanted to create the multi-job with job details, it is successfully to create the first and second job with job details (2 or 3 records). But when come to third job after entering the job header information and job details. The system would not fire the pre-insert trigger in job-detail block, so that the job details in 3rd job header are missing. For subsequence record in detail block not able to post into database (even thought the first and second job).
Ngew Received on Thu Oct 07 1999 - 09:47:00 CEST
Date: Thu, 7 Oct 1999 15:47:00 +0800
Message-ID: <7thj8u$59h$1_at_mawar.singnet.com.sg>
I had created the master block (job header) and detail block (job detail), both having a relationship.
I wanted to create the multi-job with job details, it is successfully to create the first and second job with job details (2 or 3 records). But when come to third job after entering the job header information and job details. The system would not fire the pre-insert trigger in job-detail block, so that the job details in 3rd job header are missing. For subsequence record in detail block not able to post into database (even thought the first and second job).
Is it memory problem? or do i need to tune the database for large buffering. (my fmb about 4mb using F45) I will appreciate if someone can help me!!
In the Clear_All_Master_Details trigger :
:System.Message_Level := '10';
POST;
:System.Message_Level := oldmsg;
GO_BLOCK(curblk);
Check_Package_Failure;
Clear_Block(NO_VALIDATE);
-------------------------
Ngew Received on Thu Oct 07 1999 - 09:47:00 CEST