Column

Topic updated 15-5-2007

In the Column Designer you can edit your datastore column properties.

The columns normally map one to one to your database columns, however the name can vary for different reasons. For instance in some databases the name of the table can be the same as the name of the column. In GenWise due to the mapping to classes this can not be the case.  In GenWise the Name is used as an identifying property of the column.

 

ColumnUI

 

General Settings

Name
The name of the Table column. This name has to be a valid .Net type name, since it gets mapped to a class property. This name will be used as the property name in the corresponding object. For instance PhoneNumber property in the customers object.

Dbname
The name of the database column. This column name will be mapped in the NHibernate template to the corresponding class property. The Dbname can be different from the GenWise column name.

Initial Value
The initial value will be set during insert in the Business object layer.

Control Settings group
These setting are used by the Webform Designer. For instance the grid header text is used by the browse template. This sets the default grid header when a browse template is dropped on the Webform designer canvas.

Exclude from generation / Excluded from insert / Excluded from update
These settings are described in the Exclude Options topic.

Description (lookup)
Check this option to explicitly set this column as the one that provides descriptions. The values from this column will then be used in dropdown lists when a user interface is generated with GenWise. Using the right description property is important in lookup scenarios, where records from a related entity are picked from a list that displays descriptions.

Control Settings

The Pick button opens the Format Helper, where you can pick a Format String to format the column's values in the user interface.

 

Validations tab

This is described in the Column Validation Rules topic.