New Data Maintenance Wizard

Name

Yes

Specify the name to be assigned to the new form and IDO.

Form names must be unique within an application.

IDO Project

Yes

Specify from the drop-down list which IDO project the new form is to be part of

Form Type

Yes

Specify from the drop-down list which type of form is to be created. Options include:

• Multiview (default)
• Grid-only
• Detail-only

Device Type

No

Specify from the drop-down list which device type is to be the default device type for this form.

Based on Database Table

No

When selected, this option indicates that the new database table and IDO are to be based on an existing database table. Specify which table with the drop-down list to the right of this check box.

After you specify the table, use the Get Schema button to retrieve the scheme of the specified table and display it in the Table Schema grid.

Create Form

No

When selected, this option indicates that the wizard is to create the form.

When cleared, this option creates the SQL table and IDO, but not the form itself. In this case, you can create the form later, using the New Form Wizard.

Create Scripts

No

When selected, this option causes the wizard to generate SQL scripts based on any User-Defined (Data) Types (UDTs) and the table being created.

After they are generated, the scripts display in the next page of the wizard.

Get Schema

No

Use this button to retrieve and display the schema of the database table specified in the Based on Database Table options.

When you click this button, the wizard displays the entire table schema in the Table Schema grid.

Save Template

No

Use this button to save the current wizard settings as a job template to an XML file.

This allows you to reload the template later, should you need to, and can be a valuable aid to form development, in case you need to recreate a form.

Open Template

No

Use this button to open a previously saved wizard job template (XML file) and load its values into the wizard.

Table Schema grid

Yes

For information about how to use this grid, see Table Schema /Column Properties Grid, below.

Add Row

No

Use this button to add a row to the Table Schema grid.

This creates a new table column and all of its property attributes.

Delete Row

No

Use this button to delete the selected row (property column) from the Table Schema grid.

Delete All Rows

No

Use this button to dlete all rows from the Table Schema grid at once.

Name

Yes

Specifies the internal name to be assigned to the column.

Data Type

Yes

Specifies the Mongoose system data type to be used for the property.  

If you specify this setting first, Mongoose automatically selects an appropriate data type for the SQL Data Type setting, which you can then override if you want.

If you are not particularly concerned with Mongoose system data types, you can leave this field blank and instead select the desired SQL Data Type.

SQL Data Type

Yes

Specifies the data type as used by SQL.

You can use either an existing SQL base type here, or a User-defined Data Type (UDT). If you specify the name of a UDT (that is, a non-SQL base type), the wizard prompts you to create the UDT, if it does not already exist. You can then use the wizard to generate the scripts for SQL to use.

Property Length

No

Specifies the maximum length that the value for this property value can have.  

For string types, this specifies the maximum number of characters allowed. For numeric types, this specifies the maximum total number of digits the field can display.

NOTE: Not all data types recognize this attribute.

Required

No

Indicates whether the property value is required or not.

Label String ID

No

Specifies the string that is to be used for the form component caption.  

If you specify a string that does not already exist, the wizard prompts you to either create it as a translatable string or use it as a literal value.

Primary Key

No

Indicates whether the property is to be a primary key.  

Property Class

No

Specifies the name of a property class to be used in defining the property attributes.  

Decimal Precision

No

Specifies how many digits are to display to the right of the decimal point.  

NOTE: This attribute is recognized only by numeric types that display decimal values.

Default Value

No

Specifies a default IDO property value to be used when creating or copying records.  

For more information, see Default Values for Components.