ExternalColumn Members

These members are controls the properties of a column (field) of an external profile.

Functions

Name Description
ChangeDBOriginalData Change the original database data (meta data) of this column.

Properties

Name Description
AssociatedCharacteristic Returns/sets the name of the Characteristic associated with this column. Return/assignment value: String.
AssociatedCharacteristics Returns/sets the group of Characteristics associated with this column. Return/assignment value: Variant.
AutoUpdate Returns/sets the auto-update column type for this column. Return/assignment value: AutoUpdateColumn. (NOT YET LINKED)
CAValueList Returns the Cause/Action value list associated with this column. Return value: Variant. This property is read only.
CAValueListLabel Returns/sets the Label ID associated with this Cause/Action value list. Return/assignment value: Integer.
CAValueListSQL Returns/sets the SQL statement for retrieving the Cause/Action value list associated with this column. Return/assignment value: String.
CAValueListType Returns/sets the type of the Cause/Action value list associated with this column. Return/assignment value: ExternalColumnCAValueListType. (NOT YET LINKED)
CAWriteBackSQL Returns/sets the SQL for writing back Cause/Action values to the external database. Return/assignment value: String.
CharID Returns the Characteristic ID that can be associated with the column. Return value: Integer. This property is read only.
ChartType Returns/sets the type of Quality Control chart produced by this variable. Return/assignment value: ChartType.
ColumnSize Return value: Integer. This property is read only.
Crosstab Returns/sets the crosstab type for this column. Return/assignment value: CrosstabColumn. (NOT YET LINKED)
DBInfoCatalog Returns/sets the database catalog name this column is qualified by. Return/assignment value: String.
DBInfoSchema Returns/sets the database schema name this column is qualified by. Return/assignment value: String.
DBInfoTable Returns/sets the database table this column is qualified by. Return/assignment value: String.
DBOriginalCatalogName Returns the database catalog column name. Return value: String. This property is read only.
DBOriginalColumnName Returns the database original column name. Return value: String. This property is read only.
DBOriginalSchemaName Returns the database schema column name. Return value: String. This property is read only.
DBOriginalTableName Returns the database original table name. Return value: String. This property is read only.
DefectSQL Returns/sets the SQL associated with the defects. Return/assignment value: String.
DisplayInSQLCriteria Return/assignment value: Boolean.
DynamicSpec Returns an ExternalColumnDynamicSpec which describes the dynamic specification for this column. Return value: ExternalColumnDynamicSpec. This property is read only.
FilterForAllQuery Returns/sets if the filtering value for this column will apply to all queries in the Profile. Return/assignment value: Boolean.
FilterRequired Returns/sets if this column must be filtered; that is, the user must supply a filtering value for it when the Monitor is run. Return/assignment value: Boolean.
FilterSequence Returns/sets the sequence number of this column when it is displayed during dynamic filtering; lower sequence numbers will be requested before higher sequence numbers. Return/assignment value: Integer.
FilterValueListSQL Returns/sets the SQL statement used to retrieve the filtering values for this column. Return/assignment value: String.
FilterValueListSuppressed Returns/sets if the list of filtering values for this column is suppressed; useful when the column contains many unique values. Return/assignment value: Boolean.
Filterable Returns/sets if this column is filterable; that is, can participate in dynamic filtering when the Monitor is run. Return/assignment value: Boolean.
FullyQualifiedColumnName Return/assignment value: Boolean.
FullyQualifiedTableName Return/assignment value: Boolean.
HasColumnMetaData Returns if there is column meta data. Return value: Boolean. This property is read only.
IncludeSpecInDataFile Returns/sets if this specification associated with this column should be included in the Spreadsheet. Return/assignment value: Boolean.
IsDateTime Returns if the data type of this column is date/time. Return value: Boolean. This property is read only.
ListOfValue Return value: ListOfValue. This property is read only.
Name Returns the database name of this column (field). Return value: String. This property is read only.
Parent Returns the parent query. Return value: ExternalQuery. This property is read only.
ProductTraceabilityAggregationType Return/assignment value: ProductTraceabilityAggregationType.
ProductTraceabilityRole Return/assignment value: ProductTraceabilityRole.
QuoteOption Return/assignment value: ExternalColumnQuoteOption. (NOT YET LINKED)
SQLOperatorList Returns/sets the SQL operator list. Return/assignment value: SQLOperator.
SQLOperatorList2 Returns/sets the SQL operator list. Return/assignment value: Variant.
SingleCriterionOnly Return/assignment value: Boolean.
SpecificationType Returns/sets the Quality Control specification type for this column. Return/assignment value: String.
StaticSpec Returns a Properties collection which describes the static specifications for this column. Return value: Properties. This property is read only.
TargetName Returns/sets the target (display) name for this column. Return/assignment value: String.
TargetType Returns/sets the target (displayed) data type for this column. Return/assignment value: ExternalColumnTargetType.
Type Returns the database data type for this column. Return value: Integer. This property is read only.
TypeAsString Returns the database data type for this column. Return value: String. This property is read only.
UpdateMetaDataWhenSQLChanged Return/assignment value: Boolean.