Generating the Database

Top  Previous  Next

WHAT HAPPENS

A data storage database to hold all the workflow information is created the first time the designer clicks the Make Tables option from the popup menu
The data storage name must unique and cannot be repeated
Caution:  'Make Tables' on a Workflow will destroy the tables and data

Definition OF 'System Tables'

When creating the data storage database there are also system tables that are created to hold information about completed Forms, what user/users have tasks available in their task lists etc...
End users and Designers do not have access to these tables

How to 'Make Tables'

Making Tables creates or drops and re-creates the tables that contain all the data collected from the web forms in the workflows
'Make Tables' must be performed at least once for a workflow to become active
To Make Tables navigate to the Workflow you wish to generate the database for 
Click once on Workflow Name
From the pop up menu click on Make Tables
You will be asked to confirm you are sure as 'Make Tables' destroys all data in all tables
Click OK to proceed
Error messages will be displayed if there were inconsistencies that are caused by improper Form creation or improper workflow creation
The first time you 'Make Tables' it will also generate the storage database you specified in the Workflow properties window
If there are already tables in the database then Kontinuum will first drop all the tables before creating new ones (it is highly recommended that each workflow has its own database)


<%www.webandflo.com%>