Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
Monday, July 2, 2018
Auto New Row Generation In Interactive Grid Using Bar-code Reader or Manual Input
1. Create a page and a region type Interactive Grid form from a table.
(using where 1=2 for showing empty grid).
2. Now create a Dynamic action with Change Event and Execute javaScript Action
on column, from where new row will create.
3. Then goto Region Properties Advanced>> Static ID >> type a id like: REG_ID
4.Use below JavaScript for create new from Upper side new row.
apex.region("REG_ID").widget().interactiveGrid("getActions").invoke("row-add-row")
OR
apex.region("REG_ID").widget().interactiveGrid("getActions").invoke("insert-record")
(for down side new row)
(After making interactive grid if there any primary key problem then go to a primary key column>>
Sours>>Primary Key>>Yes)
No comments:
Post a Comment