Attributes Types Overview

SIS Desktop 9.1 attribute data types are:

Properties can also contain arrays of the above list (including the Version 6 compatible types). Properties with these types have the suffix character '@' e.g. "MyDate@". The GetProperty, SetProperty, Evaluate and SetListProperty methods support the new property types, using COM "variants" as parameters.

At the moment, only cursor-based datasets take advantage of these new types

When setting an item’s property to null using the SetProperty method, remember these points:

  • For non-cursor datasets, i.e. BDS, where the attribute is not type'@' the attribute is removed from the item.
  • For non-cursor datasets where the attribute has type'@' the attribute is not removed but is given the value of a null variant.
  • For cursor datasets NULL is set in the database (in cursor datasets a NULL attribute is equivalent to an absent attribute).

Attributes

Attributes are displayed in the hierarchical form of "Parent::Child::Grandchild$".

Attributes are entered in the New Attribute form, one level at a time, with each hierarchical level separated by double colons (::)

The Properties Control Bar will display the attribute hierarchy.

Schema in the Maps Control Bar displays the attribute full name with a "/" separator in place of the double colons.

The Table Window will be displayed as follows: