From SQL Query
1. Create a Record Group(RG)
2. Create RG SQL Query as
Select 1,2,3,4,5 from dual;Make sure you set the datatype accordingly w.r.t your col in the dynamic query to be used in the below package.
Here 1,2,3,4,5 represents the number of columns for your query3. Create an LOV an attach this RG to it
4. Add the below logic to the trigger, Click on the field to which LOV is attached. it will show up.
DECLARE
result Number;
rec_id RecordGroup;
rwcnt NUMBER;
p_lovname VARCHAR2(40);
p_rg_name VARCHAR2(40);
lc_query VARCHAR2(1000);
BEGIN
p_lovname := <LOV_name>
p_rg_name := <RG_Name>
lc_query:= 'SELECT
item_name
,desc ,Attr1
,Attr2
,Attr3
from <Your tab name>;
rec_id := find_Group(p_rg_name );
result := POPULATE_GROUP_WITH_QUERY(rec_id, lc_query);
rwcnt := Get_Group_Row_Count(rec_id);
SET_LOV_PROPERTY(p_lovname, GROUP_NAME, rec_id);
END;
From Existing Record Groups
Take serial number behavior as example,For different Txn Type,Then serial number LOV will dispaly different values,so we need to bind different record groups.
Sample Code like:
File:INVSLENT.pld
PROCEDURE set_rec_group (
... ...
IF (trx_act = 1)
THEN
SET_LOV_PROPERTY (llov_name, group_name, 'inv_serial1');
SET_LOV_PROPERTY (to_serial_lov_name, group_name, 'inv_serial1');
ELSIF (trx_act = 2)
THEN
SET_LOV_PROPERTY (llov_name, group_name, 'inv_serial2');
SET_LOV_PROPERTY (to_serial_lov_name, group_name, 'inv_serial2');
ELSIF (trx_act = 3)
THEN
SET_LOV_PROPERTY (llov_name, group_name, 'inv_serial3');
SET_LOV_PROPERTY (to_serial_lov_name, group_name, 'inv_serial3');
ELSIF (trx_act = 4)
THEN
SET_LOV_PROPERTY (llov_name, group_name, 'inv_serial4');
SET_LOV_PROPERTY (to_serial_lov_name, group_name, 'inv_serial4');
ELSIF (trx_act = 5)
THEN
SET_LOV_PROPERTY (llov_name, group_name, 'inv_serial5');
SET_LOV_PROPERTY (to_serial_lov_name, group_name, 'inv_serial5');
......
分享到:
相关推荐
This paper studies the stabilizability of an n-dimensional quantized feedforward nonlinear system. The state of that system is first quantized into afinite number of bits,and then sent through a...
adaptive mesh refinement fortran\An Efficient Dynamically Adaptive Mesh for potentially singular solutions
How to dynamically create, edit, display UI elements in WebDynpro
DB - Unbounded Pipelining in Dynamically Reconfigurable Paxos Clusters.pdf Consensus is an essential ingredient of a faulttolerant distributed system systems. When equipped with a consensus ...
Pecht, “Deep Residual Networks with Dynamically Weighted Wavelet Coefficients for Fault Diagnosis of Planetary Gearboxes,” IEEE Transactions on Industrial Electronics, vol. 65, no. 5, pp. 4290-4300...
Deprecated This library is deprecated and no further development is taking place. ...You can dynamically change the action with: ```java actionView.setAction(new BackAction(), ActionView.ROTATE_C
26. Why do quants like closed-form solutions? 116 27. What are the forward and backward equations? 119 28. Which numerical method should I use and when? 123 29. What is Monte Carlo Simulation? 132 30....
Since the communication quality will change dynamically with the different environments, an off-line given separation distance may not always assure the effective communication quality. In this paper...
SkinEngine is an VCL library that allows you to dynamically change almost any aspect of the visual appearance your project's forms or controls. SkinEngine provides you with full support for ...
unity 3D云彩资源包3D ... Dynamically change the ambient and sun color of the clouds. Also modify the contrast, density, thickness, and opacity. Easily orient them towards an object or the scene camera.
Abstract—Recent efforts show that neural networks are vulnerable to small but intentional perturbations on input features in visual classification tasks. Due to the additional consideration of ...
Dynamically Programmable DRU for High-Speed Serial I/O
group of stocks, we derive a simple form of ‘‘riding the cycles – waves”. These are the derived features of the underlying stock movement. It provides a learning framework to trade on cycles. ...
network congestion through probabilistic retransmission or by dynamically resizing TCP’s segments in order to avoid incurring timeout penalty. We evaluate the merits of the aforementioned solutions ...
SkinEngine is an VCL library that allows you to dynamically change almost any aspect of the visual appearance your project's forms or controls. SkinEngine provides you with full support for ...
LookupCache: Boolean - Determines whether the values of a lookup field are cached or looked up dynamically every time the current record in the dataset changes. LookupDataSet: TDataSet - Identifies ...
C ++ dynamically assigns values to the form. The code is free and open source download. Enter text in the pop-up dialog box. After clicking the application
Ultrafastand low-power dynamically tunable plasmon induced transparencies in compactaperture-coupled rectangular resonators
前端项目-datatables-colvis,ColVis adds a button to the toolbars around DataTables which gives the end user of the table the ability to dynamically change the visibility of the columns in the table
I presented a sub set of this method in a previous article Exporting a Doc/View from a dynamically loaded DLL. What I wanted to do was provide a streamlined and consistent plug-in architecture to ...