Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Atlanta, 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, OBIEE. Contact: qaiuminfo@gmail.com
Search This Blog
Wednesday, January 24, 2018
Tabular Form Serial Number Auto Generation Oracle Apex
1. Copy and Pest the javaScript at HTMLHader in the page.
<script>
function setNextSortOrder() {
var highest=0;
$(".sortorder").each(function(){
if (this.value != "") {
highest=Math.max(highest,parseFloat(this.value));
}
});
$(".sortorder").last().val(highest+1);
}
</script>
2. Create a item and use default sql and select max value.
and copy the item at "tabular form attributes" as PL/SQL Expression or Function Default ....
3.Copy and Pest sortorder at tabuler form item.
Element CSS Classes : sortorder
4. Finally copye pest the code on "Add Row" button -> URL Target
javascript:{apex.widget.tabular.addRow();setNextSortOrder();}
Subscribe to:
Post Comments (Atom)
Check Difference Between Two Database Objects
Step-1. Create Two DBLINK to connect with Two Database then Step-2. define logindb= DBLINKONE define remotedb= DBLINKTWO define schema_name=...
-
Search by keyword from Oracle Database Objects. select owner, type, name, line, text from dba_source where 1 = 1 and text like '%TEXT Y...
-
We Can Export Application Components individually from Oracle Apex. Application > Shared Components > Export Application Compo...
Hi,
ReplyDeleteI have tried this but sequence number not incrementing for new row.can you please help.