The tables configuration is a bit more complicated than the rest. Please read this guide carefully.
How to add a table
If you have selected a connection and a table set. you can simply click on the search button next to the Table Name field. A list of all available tables and views will appear. Click on a table or view name to select it.
- Table Name: The name of the table in the database. Use the button to list all tables found and select one of them.
- Table Alias: The name of the table that will appear in searches and reports. This name can be freely chosen, but should be unique across your configuration.
- Table Visible: The table will be visible and selectable on the main screen. You can deselect this option to hide the tabel in Sequenchel without removing it.
- Table Search: The table will be searchable in the main screen. If this option is deselected, the table may be visible but you cannot perform any action on it.
- Table Update: It will be possible to update records in the table. If selected, this setting can be overruled on a field level.
- Table Insert: If selected, new items can be inserted into the table. If not selected, the “New Item” button on the main screen will be disabled.
- Table Delete: If selected, records can be deleted from the table. You can delete 1 record at the time by selecting in in the main screen and next click on Delete.
- All Tables: Select this option to import all tables from the database at once. If the database has many tables this might take a very long time. All tables and fields will have the same settings as selected on the screen.
- Import Columns: Pressing this button will autodetect all columns in the selected table(s) and add them to the list with the default(selected) options. You can alter these options per field after this import.
Click on a Field in the “Selected Table” area to select it. The properties will appear on the right next to the “Selected Table” area.
- Field Name: The actual name of the field / column in the table definition.
- Field Alias: The friendly name you wish to be displayed on the main screen and in reports in stead of the actual name.
- Data type: Sequenchel needs to know how to handle each field. There are only 4 possibilities in Sequenchel:
- CHAR: Every datatype that is treated by SQL Server as character data, including datetime fields.
- INTEGER: Every datatype in SQL Server that is treated like numeric data.
- BIT: Boolean values. Fields that only contain YES/NO or ON/OFF.
- BINARY: binary data types need to be converted to String or CHAR types before they can be displayed properly.
- Field Width: The width of the field in the right side of the main screen.
- Relations: Relations have the form of [SchemaName.]TableName.FieldName and connect your field as a many-to-one relation to the object (table/column) you supply here.
- Related Field: Is a field in a different table that provides usefull information about a relation. If you have a relation with the client table field ID, you could enter ClientName here to have that field displayed next to the (meaningless) ID.
- Default Button: When selected will display a button next to the field on the main screen. When pressed the default value entered here will be entered in the corresponding field on the main screen. You can use variables in this field but not functions.
- Control Field: The other field in the same table that controls whether this field is updatable.
- Control Value: The value in the control field to match
- Control Update: If selected, if the Control Value matches the value in the Control Field, the field is updatable. If unselected, the field is readonly. For detailed explanation, see further on this page.
- Control Mode: The field will be updatable is Sequenchel is started in Control Mode. This can be achieved by starting Sequenchel.exe /control.
- Field List: The field will be included in the list on the left side of the main screen.
- Field List Width: The width of the column for this field on the left side of the main screen.
- Field List Order: The position of the column for this field on the left side of the main screen. If you enter a higher value that the number of rows, an error will occur. more than 1 column can have the same number.
- Identity: This field is an identity field and it’s value can be used to search for the correct row in the table.
- Primary Key: This field is an Primary Key field and it’s value can be used to search for the correct row in the table. Composite primary keys are supported.
- Field Visible: The field will be visible on the right side of the main screen.
- Field Search: The field will be searchable if the table is searchable as well.
- Field Search List: In stead of a textfield, there will be a dropdown list with all possible values for this field on the right side of the main screen. every dropdown list requires a query to the database. Use this only for tables with a limited number of different values.
- Field Update: this field will be updatable if the Table Update is selected and the Control Field setting does not disable it.
Relations
You only have to provide relation information on the Foreign key side of the relation, not on the Primary Key side. The Primary key side is the side where every value only exists once.
You can add more than one relation to every field, although the chance that a field has 2 different sources is very remote. Sequenchel uses this to create a relation to the LinkedServer in the tbl_Servers and additional in vw_Servers. This way you can choose from which table you wish to report.
If you want to add a (new) relation to an existing field, enter the name of the target in the Relations textbox and click on the “V” button to confirm.
To delete a relation from your field, select the relation and click on the X next to the dropdownlist. To save the results click on “Update”. If you click on the button “Delete Field” the entire field will be deleted, including all configured relations.
Control Field options
The Control Field is an advanced setting. This setting, together with Control Value and Control Update, can overrule the update setting on a field. An example:
In the table Servers, there is a field MonitorServer. If this field is selected the server will be monitored by Sequenchel and many properties will be updated automatically. If you have servers that you want to list in this table, but do not want to monitor you deselect this option. The server will not be monitored and the fields will not be updated automatically.
If there is a change in any field that is not updated automatically, you need to be able to do this manually. To be able to update the value for ServicePack manually, you add to the field ServicePack the following options:
- Control Field: MonitorServer
- Control Value: False (in text)
- Control Update: True (selected)
The result is, that if the field MonitorServer has the value False, the field ServicePack will be updatable. If the field MonitorServer has the value True the field ServicePack will not be updatable.
Another example:
- Control Field: Domain
- Control Value: MyDomain (in text)
- Control Update: False (selected)
If the field Domain has the value “MyDomain”, your field will not be updatable, in any other case it will be.