Skip to main content
Solved

Add data to custom logical unit on transfer

  • March 29, 2021
  • 2 replies
  • 245 views

Forum|alt.badge.img+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?  

Best answer by dhlelk

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.

This topic has been closed for replies.

2 replies

dhlelk
Superhero
Forum|alt.badge.img+15
  • Superhero
  • Answer
  • March 29, 2021

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.


Forum|alt.badge.img+14
  • Author
  • Hero (Partner)
  • March 29, 2021

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.