Apex button to insert new rows
Martin Rodriguez
I'm using Application Express to build a page with a form that shows all the rows in Table A. Table A has to contain all the values from Table B that have a specific "Status".
I'm looking for a way to update Table A so that new rows with the correct status from Table B are added to Table A.
Is there a way to add a button to the page that inserts into Table A those rows? I have no problems with coding the query itself, but on Apex' Page Designer, when I add a button (which I called Refresh) to the page, I can't find a place to add the Insert Query.
Any tips?
Typo
there are several ways to do what you need, the simplest one would be to bind a dynamic action to the click event on the button.
On the button definition go to "Action when button clicked" region and on the action field select "Defined by dynamic action"
On execute validations choose "No"
Then, back on the page definition, create a dynamic action, on Event choose "Click", on Selection type choose "Button" this will make a field named button appear whit a list of the available buttons to choose. In condition you can define a true/false evaluation. if so then you would be able to define actions to execute in both cases, if you leave it empty ("No condition") then all the actions defined will be executed.
Once defined click next and here you decide the action type, the one you need is "Execute PL/SQL Code", which will show a text field on which you can paste your code, and the parameters needed from the page.
finally you can specify if the action will have a repercussion on any kind of visual component on the page, this is for efficiency, but is not necessary.
That would be all, once created, when you click the button the code will be executed on the server.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Python: MemoryError vs OverflowError vs instant-system-freeze
- Next: First and second time appearing row id in PostgreSQL
Related
Related Related
- 1
Apex button to insert new rows
- 2
Insert new rows in pandas dataframe
- 3
Insert array as new rows in postgresql without a loop
- 4
JQuery clear HTML table and insert new rows
- 5
mysql : How to update or insert new rows DAILY?
- 6
MySQL insert trigger only for new rows
- 7
How to check if new rows is insert in specific table
- 8
SSIS 2012 - Insert new rows, ignore existing rows
- 9
Adding new rows to table on clicking button in JQuery
- 10
How to add edit button to only some rows meeting specific condition in oracle apex report
- 11
Insert new rows into table that's connected to another table on Database
- 12
ExtJS interval timer get data and insert new rows in grid
- 13
INSERT dynamic set of rows into table after generating new primary key
- 14
Update and insert new value for existing value of multiple rows
- 15
Insert Rows Into Same Table and Store Old/New Identity Column
- 16
PHP MySQL Insert new rows from previous result
- 17
Insert (multiple) new rows into a table from another table using a subquery?
- 18
Limit row a table in SQL and Insert new rows on Top
- 19
Insert new rows into table that's connected to another table on Database
- 20
insert new rows to the time series data, with date added automatically
- 21
Insert rows after every new reference shows up in a column
- 22
Insert new rows into table but copy data from another row in the table
- 23
Truncate rows and insert new ones without introducing a service break?
- 24
SQL Insert new columns in table B from rows of table A
- 25
Unable to insert new row to UITableView with dynamic number of Sections And Rows
- 26
Insert new field for upload when click in a button .net mvc
- 27
I want to insert multiple data into multiple rows when a submit button is clicked in codeigniter
- 28
Insert values from a ListManager Oracle Apex
- 29
Does INSERT OVERWRITE create new empty partition if SELECT returns 0 rows
Comments