Good morning to all,
i have two question:
1. I need help with my application. I have a static form in apex 5.0 with several textbox and one checkbox. I need to insert into db, the values checked into checbox, this value will be stored into the same table. To understand better what i need, i will explain my db configuration:
i have a db with 7 tables. One of this is called "Procedures". Now on APEX, i have some textfield (that will be stored into Procedures table) and a checkbox with a value that change in relation of the textfield.
Now i need a similar INSERT ALL, to insert all checked values into Procedures Table.
How i can do that?
2. I need to build a trigger and i need you to do this. In the same table called Procedures, i have a column named Status. This value, from APEX, initially is setted to 1 by default when insert new record into Procedures table.
Now when i have to update this record, throught APEX interface, i need a trigger that insert a new row into same table with Version changed to 2 (with autoincrement is the best way i think). I see on internet that this BEFORE or AFTER UPDATE trigger, cannot be implemented into the same table, if i have to insert new record, before update the same record, into another table, no problem, but if this action will be made into the same table, that will be a problem.
Thanks in advance.
Vincenzo