In the ‘Manage Templates’ form, select ‘New’ from the ‘Action’ list of values.
Enter a unique Template Name and click ‘Ok’.
Select a Mode associated with the Template and click ‘Ok’.
Search and select the Table name for the Insert or Delete modes.
To watch a video on a basic Insert configuration, clickhere.
Select a Package/Procedure name for 'Procedure' mode.
Tip: Use '%' wildcard characters to assist with your search.
In the above example, once the package has been found, select the 'Procedure' from the list of values.
Click ‘Ok’ to retrieve details of the selected table or procedure from the database into the Wizard template sheet.
Note -Depending on size and complexity this may take a few moments.
The form above will be displayed showing information extracted from the database which can now be used to create a user-friendly template loader.
To save the template to the database now, without changing the definition from the defaults click 'Save to Repository'.
Note -Application Interface Wizard will also automatically add its own status and messages columns to the template definition for each section it locates. These do not have 'Return' values or 'Data Types' as they are not parameters or database columns.
For example, if a section 'PROCESS_JOB' has been returned the Wizard will create the following additional mandatory columns it will then use to report statuses and messages:
