Solved

Add data to custom logical unit on transfer

  • 29 March 2021
  • 2 replies
  • 203 views

Userlevel 6
Badge +14

Hi all,

I have an RMB that navigate to a custom page:

 

The problem is that the custom page does not jet have any rows to navigate to.

Is it possible to fetch the parameter values and add a row to the custom page?  

icon

Best answer by dhlelk 29 March 2021, 12:11

View original

This topic has been closed for comments

2 replies

Userlevel 6
Badge +15

Hi @Hans Andersen,

 

Unfortunately, this is not possible.
However, you could have 2 custom menus as a workaround.
1. To execute a PL/SQL block with the logic to create the record if it does not exists.
2. To navigate to the custom page with a data transfer.

 

Second workaround is to have a custom event on the LU connected to frmEstimateOperation and write a PL/SQL event action to create a record on your custom LU for every new record entered on the LU connected to frmEstimateOperation.

 

Cheers !
Dhananjaya.

Userlevel 6
Badge +14

Second workaround is to have a custom event on the LU connected to frmEstimateOperation and write a PL/SQL event action to create a record on your custom LU for every new record entered on the LU connected to frmEstimateOperation.

 

That is the solution I am trying to avoid. An unpleasant amount of events creating data where 90% will not be used.

I do not like the first workaround either. 

I guess it going to be events and some data cleaning on a background job.

Thanks.