Interface functionality: accessing the database setup
Contents
To access the database setup for your Collections application in Axiell Designer, you have to open the Application browser. With the Application browser you can scroll through your application similar to scrolling through folders and files on your computer with Windows Explorer. But in the application/object browser you'll only see folders and application objects, like screens and application definitions and database definitions. From here, you can add new application objects too, to the folders or lists of your choice. And if possible, you'll find the properties of a selected object in the right pane of the Application browser, where you may edit them.
Follow these steps:
| 1. | In the main Axiell Designer window that opens when you start Designer, start the Application browser by choosing View > Application browser or clicking the button for this tool: |
| 2. | Select your working folder in the Application browser window, by clicking the Open folder button: Preferably, choose your main (copy of an) Axiell folder, not one of the subfolders in it. This allows you to browse all your application objects quickly. |
| 3. | In the left window pane of the Application browser, click the + in front of each folder or object to expand the tree structure and display all objects or folders underneath the current item. Click the - in front of each folder or object to fold it in. Since all database management takes place on objects in your \data subfolder, open just the data node. Click any of the objects underneath the data node to display its properties in the window pane on the right; some nodes are just list headers and no objects, like Fields (#), Indexes (#), or Data sets (#) and therefore have no properties. These three nodes do display a different list of their objects in the right window pane. These lists offer more information than the Explorer-type lists on the left. Also you can easily sort the list on the right on any of the displayed columns by clicking the column header on which you want to sort, once or twice (for sorting ascending or descending). For example, sort the datasets list on the Upper limit column, and you can easily check if there are no overlapping record number ranges between datasets. You can double-click any field, index or dataset in the list on the right, to open its properties. Note that underneath the data node in the tree view you can see Windows folder names as well as Collections application object descriptions, namely:  - folders - database definitions - dataset definitions - index definitions - field list header - fields (blue field names denote linked fields) - fields for which access rights have been set up - internal links - feedback database definitions |
See also
Managing databases and datasets