Page History

...

Fill in the events with following SQL rules

Event

Rule

Before create environment

Code Block

language	sql
collapse	true

CREATE TABLE LOG
  ( 
     Id NUMBER,
     time_of_creation timestamp,
     event varchar2(255)
  );

After create environment

Code Block

language	sql
collapse	true

INSERT INTO log (id, time_of_creation, event) VALUES (1, sysdate, 'After Create Environment');

Before deployment

Code Block

language	sql
collapse	true

INSERT INTO log (id, time_of_creation, event) VALUES (3, sysdate, 'Before Deployment');

After deployment

Code Block

language	sql
collapse	true

INSERT INTO log (id, time_of_creation, event) VALUES (3, sysdate, 'After Deployment');

Before delete environment

Code Block

language	sql
collapse	true

INSERT INTO log (id, time_of_creation, event) VALUES (4, sysdate, 'Before Deleting');

When saving the solution (or the environment), AppBase creates the table Log and then inserts data into it.
When building the Solution, after pressing Execute SQL, AppBase executes the next two events (Before Deployment,then After Deployment)
Similarly for the other events

Versions Compared