Creating a Resource Based on a Database Table

To create a resource based on a database table:

1. Display the Database Explorer.
2. Find the table on which you want to base the resource. Select it and draft and drop it in the application.

   The Workbench displays a popup menu with the options Query and Update.

3. Select the type of resource you want to create.

   Percussion adds the resource to the application.

4. To modify the resource, double-click on it. The Workbench opens the resource in a separate tab.

A query resource created from a database table includes:

• a Backend Data Tank containing the table you used to create the resource;
• a Page Data Tank with a default DTD generated from the names of the columns in the table you used to create the resource;
• a mapper with guessed mappings between the database table and the default DTD;
• a selector, with no selection criteria.

You can add tables to the Backend Data Tank, change the default DTD in the Page Data Tank, modify mappings, and add selection criteria. You can also add a Results Pager.

An update resource created from a database table includes:

• a Backend Data Tank containing the table you used to create the resource;
• a Page Data Tank with a default DTD generated from the names of the columns in the table you used to create the resource;
• a mapper with guessed mappings between the database table and the default DTD;
• An updater with only Allow updates checked.

You can add tables to the Backend Data Tank, change the default DTD in the Page Data Tank, modify mappings, and modify update settings. You can also add a Transaction Manager to define transaction behavior.