GreatManuals.com
Huge Collections of Software Manuals and Knowledgebase

ASP XMLMaker

Note: For simplicity, we use "table" through this help file to refer to any of database object in the project. A database object can be either a table, a view or a custom view.

After loading the database, the tables and views will be shown in the database pane on the left pane (database pane). Click on the [Tables] or [Views] or [Custom Views]node to go to the Table Setup page at any time.

You can also change the display order of the menu item by drag-and-drop. Select a table by clicking the first column - [Table/View Name] column, then drag and drop to where you want. Note that a table cannot be moved out of its parent node.

Note: For all checkbox columns, if you want to apply the setting to ALL tables or views, you can choose your setting at the [Tables] or [Views] or [Custom Views] row.

The available table level settings are as follows:

Generate
Select/unselect a particular table for generation

Caption
To change the caption of a table, click on [Caption] box to make the necessary change.

Filter (WHERE Clause)
Specify a filter (WHERE clause) for the table. Click the [...] button in [Filter] column, the Filter Editor will popup. Enter your filter, you can drag the field names from the left pane to the editor, the SQL identifier quote characters will also be added for you automatically.

Note: The filter must be a valid VBScript string as the WHERE clause will be concatenated to the SQL string. For example, "State = 'CA'".

Sort (ORDER BY clause)
Specify the sort fields (ORDER BY clause) for the table. Click the [...] button in [Sort] column, the following dialog box will popup. You can choose up to 6 fields, in either ascending or descending order.

»