Attributes for Derived properties

In the IDO Property Wizard, after you select the Derived option and then click Next, provide values for these attributes:

General attributes

Property Name
(Required) Provide the name to be used for the new property.
Property Class
Optionally, select a property class to be used for the new property.

Data Type attributes

Inherit from Property Class
This check box is selected if the property is associated with a property class. When the check box is selected, specifications for Data Type, Length, and Decimal are inherited from the property class. In this case, they are read-only.

To specify other values (and not inherit from the property class), clear this check box.

[Selection list:]
Select the data type to assign to the IDO property. If the property has a data type assigned already, this field displays the data type.

For more information about data types, see Data Type.

Length
Specify the maximum number of characters that the property can include. This attribute applies to properties with a Data Type of String.

If the property has a length attribute assigned already, this field displays the assigned value.

Decimal
Specify the number of decimal places to display to the right of the decimal point. This attribute applies only to properties with a Data Type of Decimal.

If the property has a decimal value assigned already, this field displays the assigned value.

Column Data Type attributes

Inherit from Property Class
This check box is selected if the property is associated with a property class. When the check box is selected, the specification for Column Data Type is inherited from the property class. In this case, it is read-only.

To specify another value (and not inherit from the property class), clear this check box.

[Selection list]
Select the "column data type" to be associated with the property. If the property has a column data type assigned already, this field displays the name of that column data type.

With bound properties, the system defaults this attribute to the SQL Server user-defined data type associated with the column the property is bound to.

For more information about column data types, see Column Data Type.

Expression attributes

Inherit from Property Class
This check box is selected if the property is associated with a property class. When the check box is selected, the specification for the Expression is inherited from the property class. In this case, it is read-only.

To specify another value (and not inherit from the property class), clear this check box.

[Expression list]
Use this field to create or edit an expression that is used to provide the value of the property. If the property has an expression assigned already, this field displays the expression.

For more information about expressions used in derived properties, see About expressions in derived or unbound properties.

Note: The expression can include "parameterized" values for which actual values are substituted at runtime. These parameterized values must be formatted as a zero-based index of consecutive integers in curly braces ({0}, {1}, and so on). Actual values are then passed in as a comma-delimited list. For more information and examples, see SUBSTITUTE, an event action function in the Application Event System that uses similar logic.