Activity for RapidASDev for Oracle
-
Anonymous posted a comment on discussion Hints and Tips using RASD
For better understanding I would add a comment if (cMF()== false) { alert(''Field label is mandatory!"); }
-
Domen Dolar modified a wiki page
Welcome
-
Welcome
-
Welcome
-
Welcome
-
Welcome
-
If you would like to add confirm question on buttons you have to: 1.Create Link (Links - LOV program). In JAVASCRIPT option you shoul put this code: if ( confirm("Do you want to submit!") ) { #GC# } else { _rasd_SpinnerOff=true; } 2.Add new link to the button where you want a confirm. You can do the same procedure for buttons, submit buttons, links, ....
-
If you would like to add confirm question on buttons you have to: 1.Create Link (Links - LOV program). In JAVASCRIPT option you shoul put this code: if ( confirm("Do you want to submit!") ) { #GC# } else { _rasd_SpinnerOff=true; } 2.Add new link to the button where you want a confirm.
-
If you would like to add confirm question on buttons you have to: 1.Create Link (Links - LOV program). In JAVASCRIPT option you shoul put this code: if ( confirm("Do you want to submit!") ) { #GC# } else { _rasd_SpinnerOff=true; } 2.Add new link to the button where you want a confirm.
-
In some cases we use build in actions and we would like to skip saving data based on some rules. We can solve this issue in trigger PRE_COMMIT with calling return; Sample: Trigger: PRE_COMMIT Like: if MYDATA = null then ERROR := 'The data MYDATA is missing. The data is not saved!'; // This return is importnat because this statement stops execution in pcommit procedure. return; end if; With this code all commit settings and all commit triggers (PRE_UPDATE, ON_UPDATE, POST_UPDATE, PRE_INSERT, ....)...
-
In some cases we use build in actions and we would like to skip saving data based on some rules. We can solve this issue in trigger PRE_COMMIT with calling return; Sample: Trigger: PRE_COMMIT Like: if MYDATA = null then ERROR := 'The data MYDATA is missing. The data is not saved!'; ** return;** end if; With this code all commit settings and all commit triggers (PRE_UPDATE, ON_UPDATE, POST_UPDATE, PRE_INSERT, ....) in all blocks are skiped. Also preigger POST_COMMIT is skiped.
-
You can add new ACTION (event) to your form on many ways, but here is the best scenario how to do that. 1.Create your new button to trigger new event - ACTION on your form. You can create button in form fields or your own block fields. Importantat is that the button is "Button submit". The name of button is not important. Important is the value of button. This will be stored in ACTION when the event will be triggered. In our case button name is MYNEWACTION and default value is 'New action'. When...
-
Stanislav Šlivić posted a comment on discussion Hints and Tips using RASD
in last code where is target :9 change abaut where is place in the your table. If place in the table 5 you enter it in code 4, if place 7 enter 6 , ecc..
-
Anonymous posted a comment on discussion Hints and Tips using RASD
If you encounter a problem with this example, turn your attention to the last part, where you specify the place in the table. Since it is +1, the place of -1 must be considered. (target:9) So if the date is in the 4th place in the table, enter it in code 3. And rename the block as it is called in your program.
-
Welcome
-
RapidASDev for Oracle released /Code is moved - read file.txt
-
To activate READONLY attribute to DATE field you have to do two thinks. In DATETIME picker global settings (rasd_datepicker.html) add beforeShow code. This setting will imapact to all your forms. Added code: beforeShow: function(i) { if ($(i).attr('readonly')) { return false; } }, Like in rasd_datepicker.html <script> $(function() { $("#:NAME" ).datetimepicker({ beforeShow: function(i) { if ($(i).attr('readonly')) { return false; } }, dateFormat: ':DFORMAT', timeFormat: ':TFORMAT' :PROPERTIES ,showOn:...
-
You can add new ACTION (event) to your form on many ways, but here is the best scenario how to do that. 1.Create your new button to trigger new event - ACTION on your form. You can create button in form fields or your own block fields. Importantat is that the button is "Button submit". The name of button is not important. Important is the value of button. This will be stored in ACTION when the event will be triggered. In our case button name is MYNEWACTION and default value is 'New action'. When...
-
You can add new ACTION (event) to your form on many ways, but here is the best scenario how to do that. 1.Create your new button to trigger new event - ACTION on your form. You can create button in form fields or your own block fields. Importantat is that the button is "Button submit". The name of button is not important. Important is the value of button. This will be stored in ACTION when the event will be triggered. In our case button name is MYNEWACTION and default value is 'New action'. When...
-
You can add new ACTION (event) to your form on many ways, but here is the best scenario how to do that. Create your new button to trigger new event - ACTION on your form. You can create button in form fields or your own block fields. Importantat is that the button is "Button submit". The name of button is not important. Important is the value of button. This will be stored in ACTION when the event will be triggered. In our case button name is MYNEWACTION and default value is 'New action'. When you...
-
You can add new ACTION (event) to your form on many ways but here is the best scenario how to do that. Create your new button to trigger new event - ACTION on your form. You can create button in form fields or your own block fields. Importantat is that the button is ggg
-
RASD_EXECUTE
-
More details in How genereted programs execute code Video: Executing code in RASD
-
More details:
-
If you woud like to use result of LOV's in your code and you do not like to double SQL statements you can kreate call like this: begin B10SF_PREKINITEV := openlov( 'lov$storitev' , --name of the list of values B10SF_PREKINITEV -- value to search lov )(1).label; -- 1 means first row in lov's results exception when others then null; end; LOV's in RASD are in type: TYPE LOVrec__ IS RECORD (label varchar2(4000),id varchar2(4000) ); TYPE LOVtab__ IS TABLE OF LOVrec__ INDEX BY BINARY_INTEGER; TIP: String...
-
Sometimes you would like to order date values by date not by string in table. Below is what you have to do. Yo also can see that in demo sample DEMO_FIELDS. Add link to script in Form CSS/JS -> FORM_UIHEAD <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.2/moment.min.js"></script> In Form CSS/JS change datatable properties of your table and add code Added code: $.fn.dataTable.render.moment = function ( from, to, locale ) { // Argument shifting if ( arguments.length...
-
To set table responsive you will use some javascript. We will preprate block B10 responsive. In RASD for presenting tables is used DataTable library. So on this way you can customize all your tables. Now the program looks like this. 1.Javascript we write in program "CSS, JS source" select tab "Form CSS, JS" and from dropdown select "FORM_JS" Now we will add some code. This code replaces behavior of default DataTable on block B10. $(document).ready(function() { var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties));...
-
For adding export into DataTable you can use DataTable setting. In RASD all default DataTable properties are stored in global variable _rasd_dataTableProperties. With sample below you can overwrite default settings or add new ones. Default settings you can see in General CSS/JS - rasd/ rasd_datatable.html file. This code you should save in FORM_JS part on CSS, JS source. ... var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); //properties for buttons newDT1.dom = 'Bfrtip'; newDT1.buttons...
-
To change default DataTable settings you can create your owv DataTable object. You have block named B10 In "FORM_JS" you can put your own code: --Create new DataTable with custom properties! var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); --Your custom preferences. If no chanege tehn don't add any. newDT1.bPaginate = true; newDT1.bPageLength = 8; -- newDT1.destroy = true; $("#B10_TABLE").removeClass( "rasdTableN" ); var xTable1 = $("#B10_TABLE").DataTable(newDT1);
-
Demo shown how to export datatable rows into format CSV, Excel, PDF. You have block with name B10 with rows more then 1 Write yur own "FORM_JS" code --Create new DataTable with custom properties! var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); --Your custom preferences. If no chanege tehn don't add any. newDT1.dom='Bfrtip'; newDT1.buttons=[ 'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5' ]; -- newDT1.destroy = true; $("#B10_TABLE").removeClass( "rasdTableN" ); var xTable1 =...
-
At inicialisation of DataTable be sure that name is DataTable and not dataTable dataTable - you will get old object of datatable DataTable - you will get new version https://stackoverflow.com/questions/24325786/table-columns-is-not-a-function-in-datatable-js
-
You have two steps to activate show/hide columns in RASD tables (using DataTables). 1.Put somewhere into HTML part (label ob block, ON_UI field, ...). On click on this item the column will show or hide. <a class="toggle-vis" data-column="0">Col1</a> <a class="toggle-vis" data-column="2">Col3</a> 2.Add conntent into FORM_JS part: $(document).ready(function () { --Create new DataTable with custom properties! var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); --Your custom preferences....
-
You have two steps to activate show/hide columns in RASD tables (using DataTables). Put somewhere into HTML part (label ob block, ON_UI field, ...): <a class="toggle-vis" data-column="0">Col1</a> <a class="toggle-vis" data-column="2">Col3</a> Add conntent into FORM_JS part: $(document).ready(function () { --Create new DataTable with custom properties! var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); --Your custom preferences. If no chanege tehn don't add any. newDT1.bFilter=false;...
-
You have two steps to activate show/hide columns in RASD tables (using DataTables). Put somewhere into HTML part (label ob block, ON_UI field, ...): <a class="toggle-vis" data-column="0">Col1</a> <a class="toggle-vis" data-column="2">Col3</a> Add conntent into FORM_JS part: $(document).ready(function () { --Create new DataTable with custom properties! var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); --Your custom preferences. If no chanege tehn don't add any. newDT1.bFilter=false;...
-
You can use program "SQL Client" to create model. Just copy CREATE TABLE statements and submit. The table will be created and you will see it on the left side on program.
-
When you set number of rows (Rows) in RASD then you will see in last page with documents empty lines. The number of empty lines depends how many rows should be added to prepare table in setted value. Like: You can disable this with setting negative number of "Rows" into "Empty rows". Like: An the result is:
-
When you set number of rows (Rows) in RASD then you will see in last page with documents empty lines. The number of empty lines depends how many rows should be added to prepare table in setted value. Like: You can disable this with setting negative number of "Rows" into "Empty rows". Like: An the result is:
-
When you set number of rows (Rows) in RASD then you will see in last page with documents empty lines. The number of empty lines depends how many rows should be added to prepare table in setted value. Like: slika 1 You can disable this with setting negative number of "Rows" into "Empty rows". Like: slika2 An the result is: Slika 3
-
You have two solutions to create tabs in RASD. Both have some pros and cons. Each PAGE is one tab. Each tab can be represented by many blocks. Solution 1: In one page you prepare all tabs. And when they are prepared chosen one is visible others are hidden. Pros: - Actions on changing tabs on browser is faster. You have no interaction with server (only ajax calls). Cons: - Slower loading of the page, because all tabs should be filed with data. - When changing data on hidden tabs can happen that the...
-
You have two solutions to create tabs in RASD. Both have some pros and cons. Each PAGE is one tab. Each tab can be represented by many blocks. Solution 1: In one page you prepare all tabs. And when they are prepared chosen one is visible others are hidden. Pros: - Actions on changing tabs on browser is faster. You have no interaction with server (only ajax calls). Cons: - Slower loading of the page, because all tabs should be filed with data. - When changing data on hidden tabs can happen that the...
-
You have two solutions to create tabs in RASD. Both have some pros and cons. Each PAGE is one tab. Each tab can be represented by many blocks. Solution 1: In one page you prepare all tabs. And when they are prepared chosen one is visible others are hidden. Pros: - Actions on changing tabs on browser is faster. You have no interaction with server (only ajax calls). Cons: - Slower loading of the page, because all tabs should be filed with data. - When changing data on hidden tabs can happen that the...
-
You have two solutions to create tabs in RASD. Both have some pros and cons. Each PAGE is one tab. Each tab can be represented by many blocks. Solution 1: In one page you prepare all tabs. And when they are prepared chosen one is visible others are hidden. Pros: - Actions on changing tabs on browser is faster. You have no interaction with server (only ajax calls). Cons: - Slower loading of the page, because all tabs should be filed with data. - When changing data on hidden tabs can happen that the...
-
You have two solutions to create tabs in RASD. Both have some pros and cons. Each PAGE is one tab. Each tab can be represented by many blocks. Solution 1: In one page you prepare all tabs. And when they are prepared chosen one is visible others are hidden. Pros: - Actions on changing tabs on browser is faster. You have no interaction with server (only ajax calls). Cons: - Slower loading of the page, because all tabs should be filed with data. - When changing data on hidden tabs can happen that the...
-
You have two solutions to create tabs in RASD. Both have some pros and cons. Each PAGE is one tab. Each tab can be represented by many blocks. Solution 1: In one page you prepare all tabs. And when they are prepared chosen one is visible others are hidden. Pros: - Actions on changing tabs on browser is faster. You have no interaction with server (only ajax calls). Cons: - Slower loading of the page, because all tabs should be filed with data. - When changing data on hidden tabs can happen that the...
-
We will use class name for highlight custom line. First ve have to set your new class name to the row you would like to highlight. One of the options is to do that POST_SELECT trigger on block. Field where you would like to do that must be checked for Visual Settings (VS is true). Simple code POST_SELECT trigger where you will set your new class. if B10CODE = 999 then B10CODE#SET.custom := 'class="MySpecialClass"'; end if; Then you should put some Javascript in FORM_JS part. ... HighLightRow('MySpecialClass',...
-
We will use class name for highlight custom line. First ve have to set your new class name to the row you would like to highlight. One of the options is to do that ON_SELECT trigger on block. Field where you would like to do that must be checked for Visual Settings (VS is true). Simple code ON_SELECT trigger where you will set your new class. if B10CODE = 999 then B10CODE#SET.custom := 'class="MySpecialClass"'; end if; Then you should put some Javascript in FORM_JS part. ... HighLightRow('MySpecialClass',...
-
We will use class name for highlight custom line. First ve have to set your new class name to the row you would like to highlight. One of the options is to do that ON_SELECT trigger on block. Field where you would like to do that must be checked for Visual Settings (VS is true). Simple code ON_SELECT trigger where you will set your new class. if B10CODE = 999 then B10CODE#SET.custom := 'class="MySpecialClass"'; end if; Then you should put some Javascript in FORM_JS part. HighLightRow('MySpecialClass',...
-
We will use class name for highlight custom line. First ve have to set your new class name to the row you would like to highlight. One of the options is to do that ON_SELECT trigger on block. Field where you would like to do that must be checked for Visual Settings (VS is true). Simple code ON_SELECT trigger where you will set your new class. if B10CODE = 999 then B10CODE#SET.custom := 'class="MySpecialClass"'; end if; Then you should put some Javascript in FORM_JS part. HighLightRow('MySpecialClass',...
-
We will use class name for highlight custom line. First ve have to set your new class name to the row you would like to highlight. One of the options is to do that ON_SELECT trigger on block. Field where you would like to do that must be checked for Visual Settings (VS is true). Simple code ON_SELECT trigger where you will set your new class. if B10CODE = 999 then B10CODE#SET.custom := 'class="MySpecialClass"'; end if; Then you should put some Javascript in FORM_JS part. for (i = 0 ; i < document.getElementsByClassName("MySpecialClass").length;...
-
For adding export into DataTable you can use DataTable setting. In RASD all default DataTable properties are stored in global variable _rasd_dataTableProperties. With sample below you can overwrite default settings or add new ones. Default settings you can see in General CSS/JS - rasd/ rasd_datatable.html file. This code you should save in FORM_JS part on CSS, JS source. ... var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); //properties for buttons newDT1.dom = 'Bfrtip'; newDT1.buttons...
-
GC: Using visited tag on generated links
-
By default all POP-UPs in RASD are opened in new window with function: ListOfValues javascript: var link=window.open(encodeURI(lov url),'openLOV','resizable,scrollbars,width=680,height=550'); LINK javascript: var link=window.open(encodeURI(link url),'x1', 'resizable,scrollbars,width=680,height=550'); so, the variable link is defined and name of window is x1 or openLOV. To override properties of width, height, ... you can put code below to your program into FORM_JS part. You have to change name NAMEOFFIELD...
-
In background DataTables librarys are used. To create table responsive you have to change default DataTable with responsive parameters: 1: Add code in -> "CSS, JS source" -> tab "Form CSS, JS" -> select "FORM_JS" and add code 2: Sample where table on block B10 is changed: dataTableProperties are strored in JavaScript object _rasd_dataTableProperties var newDT1 = JSON.parse(JSON.stringify(_rasd_dataTableProperties)); newDT1.responsive = true; newDT1.destroy = true; $("#B10_TABLE").removeClass( "rasdTableN"...
-
Welcome
-
By default all POP-UPs in RASD are opened in new window with function: ListOfValues javascript: var link=window.open(encodeURI(lov url),'openLOV','resizable,scrollbars,width=680,height=550'); LINK javascript: var link=window.open(encodeURI(link url),'x1', 'resizable,scrollbars,width=680,height=550'); so, the variable link is defined and name of window is x1 or openLOV. To override properties of width, height, ... you can put code below to your program into FORM_JS part. You have to change name NAMEOFFIELD...
-
You have many options to do that. The most common are described below. 1. With CSS in FORM_CSS (tab CSS,JS source -> Form CSS,JS chose FORM_CSS) set code like: .rasdTxBXXMYFIELD.rasdTxTypeN { text-align: right; } Where BXXMYFIELD is name (UI Field name) of field in table (block). Normally field must be number type. 2. With PL/SQL Field must be number type and visual settings should be turned on (VS is checked). Then you put next code into one of the triggers on block (most common POST_SELECT trigger)....
-
You have many options to do that. The most common are described below. 1. With CSS in FORM_CSS (tab CSS,JS source -> Form CSS,JS chose FORM_CSS) set code like: .rasdTxBXXMYFIELD.rasdTxTypeN { text-align: right; } Where BXXMYFIELD is name (UI Field name) of field in table (block). Normally field must be number type. 2. With PL/SQL Field must be number type and visual settings should be turned on (VS is checked). Then you put next code into one of the triggers on block (most common POST_SELECT trigger)....
-
You have many options to do that. The most common are described below. 1. With CSS in FORM_CSS (tab CSS,JS source -> Form CSS,JS chose FORM_CSS) set code like: .rasdTxBXXMYFIELD.rasdTxTypeN { text-align: right; } Where BXXMYFIELD is name (UI Field name) of field in table (block). Normally field must be number type. 2. With PL/SQL Field must be number type and visual settings should be turned on (VS is checked). Then you put next code into one of the triggers on block (most common POST_SELECT trigger)....
-
The erron on STANDALONE ORDS is: JETTY ERROR: Feb 15, 2021 10:00:16 AM SEVERE: org.eclipse.jetty.io.EofException: Early EOF org.eclipse.jetty.io.RuntimeIOException: org.eclipse.jetty.io.EofException: Early EOF at org.eclipse.jetty.server.Request.extractFormParameters(Request.java:560) at org.eclipse.jetty.server.Request.extractContentParameters(Request.java:478) at org.eclipse.jetty.server.Request.getParameters(Request.java:387) at org.eclipse.jetty.server.Request.getParameterMap(Request.java:1046)...
-
Another string causing a problem "(SELECT DISTINCT". Add space after (
-
RASDC_CSSJS
-
RASDC_CSSJS
-
When createing block where you would like to show data from database you should check this block as "DB Block". You have many options how to create a query from the database 1.Just select table, view from the "Table, View, Synonym". Like EMP. If you woluld like to set order by you can put statement into SQL field like "order by ENAME" SQL statement is created from inserted fields on block where "S" is checked and selected object in "Table, View, Synonym" and SQL field. Like: select ENAME, JOB, MGR,...
-
When createing block where you would like to show data from database you should check this block as "DB Block". You have many options how to create a query from the database 1.Just select table, view from the "Table, View, Synonym". Like EMP. If you woluld like to set order by you can put statement into SQL field like "order by ENAME" SQL statement is created from inserted fields on block where "S" is checked and selected object in "Table, View, Synonym" and SQL field. Like: select ENAME, JOB, MGR,...
-
When createing block where you would like to show data from database you should check this bloc as "DB Block". You have many options how to create a querry from the database 1.Just select table, view from the "Table, View, Synonym". Like EMP. If yu woluld like to set order by you can put statement into SQL field like "order by ENAME" SQL statement is created from inserted fields on block where "S" is checked and selected object in "Table, View, Synonym" and SQL field. Like: select ENAME, JOB, MGR,...
-
To enable this function you must manualy change EXECUTESQL package (you add AUTHID CURRENT_USER): From create or replace package EXECUTESQL is To create or replace package EXECUTESQL AUTHID CURRENT_USER is After that developers can create data models through RASD environment.
-
You can see how to use RASD REST on sample on https://bit.ly/RasdNo1 -> Click "Get started" (black button) -> select program DEMO_RASD_REST
-
Another string that can cause a problem "where exists (select 1 from".
-
This is fully operational link to RASD running in Oracle Cloud Instance http://bit.ly/RasdNo1
-
ORDS: Using string "(case when" on post error 500
-
33 ORDS: Using string "(case when" on post error 500
-
-
If you would like to integrate keyboard shortcuts into your RASD application you can use code below. Copy it into form - "CSS, JS source" - "FORM_JS". document.onkeyup = function(e) { if (e.ctrlKey && e.altKey && e.shiftKey && e.code == 'KeyV') { //CTRL + ALT + SHIFT + V pressed // go to the beggining of the form window.location='#PAGE_RASD'; elem = document.getElementById('PAGE_RASD'); elem.focus(); } else if (e.ctrlKey && e.altKey && e.shiftKey && e.code == 'KeyB') { //CTRL + ALT + SHIFT + B pressed...
-
If you would like to integrate keyboard shortcuts into your RASD application you can use code below. Copy it into form - "CSS, JS source" - "FORM_JS". document.onkeyup = function(e) { if (e.ctrlKey && e.altKey && e.shiftKey && e.code == 'KeyV') { //CTRL + ALT + SHIFT + V pressed // go to the beggining of the form window.location='#PAGE_RASD'; elem = document.getElementById('PAGE_RASD'); elem.focus(); } else if (e.ctrlKey && e.altKey && e.shiftKey && e.code == 'KeyB') { //CTRL + ALT + SHIFT + B pressed...
-
GC: Setting custom attribute to TD (TX_) element on HTML source
-
RASD: Using initRowStatus in dataTable responsive=true - onChange event problem
-
We will have one SELECT element. When element value is changed there will be ajax call. We will cal RASD REST service and set the response contenet to empty block. 1: We have to create custom RASD REST service. We can also use all created LOV services you have prepared. Look at Testing tab. We created block A99 with SQL for Empoloyees data. The filter variable is named FEMPNO. The Block A99 is set to PAGE=19. We can test service and result is: Call:/!DEMO_AJAX_JSON_BLOCK.rest?restrestype=JSON&FEMPNO=7521&PAGE=19...
-
We will have one SELECT element. When element value is changed there will be ajax call. We will cal RASD REST service and set the response contenet to empty block. 1: We have to create custom RASD REST service. We can also use all created LOV services you have prepared. Look at Testing tab. We created block A99 with SQL for Empoloyees data. The filter variable is named FEMPNO. The Block A99 is set to PAGE=19. 1 2 3 We can test service and result is: Call:/!DEMO_AJAX_JSON_BLOCK.rest?restrestype=JSON&FEMPNO=7521&PAGE=19...
-
There are 4 steps how to create custom button: 1: Create element on the block or form with type button 2: Create Link with the code that button will trigger when it is pressed In this part link can open new form, trigger your custom javscript code, ... In our example will trigger code to go on previous page (history.go(-1)). We will also disable spinner. Spinner is set to all buttons by default in RASD. On JAVACSRIPT element you can use #GC# kode to input generated code by RASD into ypur link. 3:...
-
There are 4 steps how to create custom button: 1: Create element on the block or form with type button 2: Create Link with the code that button will trigger when it is pressed In this part link can open new form, trigger your custom javscript code, ... In our example will trigger code to go on previous page (history.go(-1)). We will also disable spinner. Spinner is set to all buttons by default. On JAVACSRIPT element you can use #GC# kode to input generated code by RASD into ypur link. 3: Connect...
-
There are 4 steps how to create custom button: 1: Create element on the block or form with type button 2: Create Link with the code that button will trigger when it is pressed In this part link can open new form, trigger your custom javscript code, ... In our example will trigger code to go on previous page (history.go(-1)) 3: Connect link to new created button 4: Set value to be visible in the name of the button and the result is....
-
There are 4 steps how to create custom button: 1: Create element on the block or form with type button 2: Create Link with the code that button will trigger when it is pressed In this part link can open new form, trigger your custom javscript code, ... In our example will trigger code to go on previous page (history.go(-1)) 3: Connect link to new created button 4: Set value to be visible in the name of the button
-
There are 4 steps how to create custom button: 1: Create element on the block or form with type button 2: Create Link with the code that button will trigger when it is pressed In this part link can open new form, trigger your custom javscript code, ... In our example will trigger code to go on previous page (history.go(-1)) 3: Connect link to new created button 4: Set value to be visible in the name of the button
-
There are 4 steps how to create custom button: 1: Create element on the block or form with type button 2: Create Link with the code that button will trigger when it is pressed 3: Connect link to new created button 4: Set value to be visible in the name of the button
-
Try it here: http://130.61.248.196:8080/ords/your_app_schema/!IMP_DEMO_HOW_SUBMIT_WORKS.webclient
-
-
ddddfcccc
-
If you woul'd like to add your own functions or procedures you can do that on page "Trrigers" Click green + and then choose "PL/SQL procedure". If you choose public you can also put declarations of your procedures and functions (also types) and this will be visible ato other PL/SQL programs... Change "FuncProcBlockName" to your logical name taht something mean to you. In one of this triggers you can have more than one procedure, function, type, ... Important!!! If you have more of this procedure...
-
If you woul'd like to add your own functions or procedures you can do that on page "Trrigers" Click green + and then choose "PL/SQL procedure". If you choose public you can also put declarations of your procedures and functions (also types) and this will be visible ato other PL/SQL programs... Change "FuncProcBlockName" to your logical name taht something mean to you. In one of this triggers you can have more than one procedure, function, type, ... Important!!! If you have more of this procedure...
-
If you woul'd like to add your own functions or procedures you can do that on page "Trrigers" Click green + and then choose "PL/SQL procedure". If you choose public you can also put declarations of your procedures and functions (also types) and this will be visible ato other PL/SQL programs...
-
If you woul'd like to add your own functions or procedures you can do that on page "Trrigers" Click green + and then choose "PL/SQL procedure". If you choose public you can also put declarations of your procedures and functions (also types) and this will be visible ato other PL/SQL programs...
-
You can get this error in next situations: Program you are createing has errors. It is not compiled in database. Link to the program is not set OK. Link is set in ORDS. In this case all aplications throught this link should have problems. The inicializaction variables in the package are not set OK. Like in the package body you have: my_package_variable varchar2(5) := 'My package variable'; you can see that length of the string is longer that varchar2 size. In the inicializatin part this will cause...
-
Using initRowStatus in when locking values
-
Using initRowStatus in dataTable responsive=true
-
Using initRowStatus in when locking values
-
Using initRowStatus in when locking values
-
When you create list of values with large lists it is recomended to use LOV on input field not to use dropdown list's or checkbox list's. In our program we will add description of code to field JOB on block B10. The list of values is already created and it is put to Input field. To open it you can doubleclick on field. 1.We have to create new field in block B10. In this field we will show description of JOB code. We can name it whatever we want but if we name it like FIELD_NAME+'LABEL' then the description...
1 >
