WinStudio

Adding a User-Defined Data Type

NOTE: The Add User-Defined Type dialog box is available only from the New Data Maintenance Wizard.

To add a user-defined data type (UDT):

  1. In the New Data Maintenance Wizard, specify the name for your UDT in the SQL Data Type field for a property attribute.
  2. When WinStudio prompts you to create the UDT, respond Yes.
  3. WinStudio opens the Add User-Defined Type dialog box with the Name field already filled in.
  4. In the Add User-Defined Type dialog box, specify:
    Field Description/Comments

    Schema

    Currently, only dbo is supported.

    System Data Type

    Use the drop-down list to specify what data type the new UDT is to be.

    Length

    Optional. On data types that require or permit a length specification, specify the length.

    Decimal Precision

    Optional. Some data types allow you to specify how many decimal places should be displayed. Specify that precision level here.

    Scale

    Optional. Some data types allow you to specify the maximum total number of digits the property value can have. Specify that number here.

  5. Click OK.

Related Topics

Creating a Form with the New Data Maintenance Wizard

New Data Maintenance Wizard