User Guide

398
Tables Tab
! To display a table’s contents, click its name in the left pane. The table’s contents
appear in the upper right pane, arranged in columns by field. The column width and
sort order are retained when you leave the Tables tab.
The top heading row of the table displays field names. Key fields are indicated by a
key symbol. By convention, database columns that are external keys take the name
of the primary key column with an added underscore character. Example: An
external key to the File column of the File table is always named File_.
! An optional, second heading row shows the field’s data type, string length if
applicable, and whether the field can be null. To display or hide the second heading
row, right-click the table and select Column Info.
! Initially, tables are not sorted. To sort a table, click the heading for the column to
sort.
! You can select rows in tables, then copy and paste them into any program that
supports SYLK format, such as Excel. You also can paste the rows into a text editor,
where they appear as comma-delimited text.
Creating a New Table
Caution
Deleting, adding, or editing table data directly is not recommended unless you are an
experienced Windows Installer developer with a clear understanding of Windows Installer
database technology. Editing table data might result in unexpected, undesirable results,
including damage to the installation. Wise Solutions cannot provide technical support for
problems arising from table editing.
1. In Setup Editor > Tables tab, right-click and select Create Table.
The Create Table dialog appears.
2. In Table Name, enter the name of the new table.
3. Click Add to add a field.
The Field Definition dialog appears.
4. Complete the dialog:
• Field Name
Enter the name of the field.
•Data Type
Specify whether this field is a long integer, short integer, or string.
• String Length
If this field is a string, enter the length of the string in this field. The default is
255 characters; a length of 0 indicates no length limit.
•Nullable
Mark this to indicate that this field can be null.
• Primary Key
Mark this to indicate that this field is a primary key in this table. A table can have
more than one primary field.
• Localizable
Mark this to indicate that this field should be translatable. If you distribute this
installation in another language, the data in this field will be translated.