Problem Description: I need to update the F03B11 in the P03B102. I am updating the file in the OK "Post Button Pressed" button Pressed after the F03B11 has been updated in the table. The problem is that the Table I/O update is not being processed and is locked on the UPDATE statement.
The Update is after the file has been updated and the Cache is destroyed.
"Call the B03B0158 function to destroy the entry cache.
///
Receipts Entry Destroy Cache"
In the debug log the program stops on the TABLE UPDATE that I put in and does not move to the next statement no matter how long I wait.
If I kill the program after 1/2 plus hour the program back outs out all the previous table entries including the F03B11 and F03B14 records.
=======================================================================
FORM: Receipt Entry [HEADER DETAIL] (W03B102E)
=======================================================================
CONTROL: HYPITEM &OK
EVENT: Post Button Clicked
-----------------------------------------------------------------------
>>>>>> SKIPPED CODE >>>>>>>>>>
If VA frm_TypeTransaction is not equal to <Blank>
And VA frm_TypeTransaction is not equal to <Null>
F03B13Z2 Process Receipt Header Outbound Transaction
End If
End If
End If
If SL CountryCode is not equal to <Blank>
And SL CountryCode is not equal to <Null>
Plug & Play - P03B103 Country Server Exits
End If
//
B03B0069 function to maintain unapplied cash.
//
F03B14 Maintain Unapplied Cash
//
// ... Call the B03B0158 function to destroy the entry cache.
//
Receipts Entry Destroy Cache
//
// Update the RU document type using the Balance Sheet Business Unit for the
// company on the receipt. Both the F03B11 and the F03B14 tables.
//
F03B11.Select
F03B11.Select
F03B11.Fetch Next
F03B11.Update
The Update is after the file has been updated and the Cache is destroyed.
"Call the B03B0158 function to destroy the entry cache.
///
Receipts Entry Destroy Cache"
In the debug log the program stops on the TABLE UPDATE that I put in and does not move to the next statement no matter how long I wait.
If I kill the program after 1/2 plus hour the program back outs out all the previous table entries including the F03B11 and F03B14 records.
=======================================================================
FORM: Receipt Entry [HEADER DETAIL] (W03B102E)
=======================================================================
CONTROL: HYPITEM &OK
EVENT: Post Button Clicked
-----------------------------------------------------------------------
>>>>>> SKIPPED CODE >>>>>>>>>>
If VA frm_TypeTransaction is not equal to <Blank>
And VA frm_TypeTransaction is not equal to <Null>
F03B13Z2 Process Receipt Header Outbound Transaction
End If
End If
End If
If SL CountryCode is not equal to <Blank>
And SL CountryCode is not equal to <Null>
Plug & Play - P03B103 Country Server Exits
End If
//
B03B0069 function to maintain unapplied cash.
//
F03B14 Maintain Unapplied Cash
//
// ... Call the B03B0158 function to destroy the entry cache.
//
Receipts Entry Destroy Cache
//
// Update the RU document type using the Balance Sheet Business Unit for the
// company on the receipt. Both the F03B11 and the F03B14 tables.
//
F03B11.Select
F03B11.Select
F03B11.Fetch Next
F03B11.Update