Click or drag to resize

SQLColumnAttributes Class (Typed)

X#
Describe the attributes of an SQL column.
Inheritance Hierarchy
Object
  DataField
    SQLValue
      SQLColumn
        SQLColumnAttributes

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.19
Syntax
[TypesChangedAttribute]
 CLASS SQLColumnAttributes INHERIT SQLColumn
Request Example View Source

The SQLColumnAttributes type exposes the following members.

Constructors
  NameDescription
Public methodSQLColumnAttributes
Construct an SQLColumnAttributes object.
Top
Properties
  NameDescription
Public propertyAliasName
The alias name of the SQL column.
(Inherited from SQLColumn.)
Public propertyAutoIncrement
A logical value of TRUE if the column is automatically incremented or FALSE if it is either not automatically incremented or non-numeric.
Public propertyCaseSensitive
A logical value of TRUE if collating sequences are case sensitive; otherwise, FALSE.
Public propertyColName
A string representing the SQL column name.
(Inherited from SQLColumn.)
Public propertyDisplaySize (Inherited from SQLColumn.)
Public propertyFieldSpec
The FieldSpec object connected to this field.
(Inherited from DataField.)
Public propertyHyperLabel
The hyperlabel connected to this field.
(Inherited from DataField.)
Public propertyIndex
A numeric value representing the SQL column number.
(Inherited from SQLColumn.)
Public propertyLength (Inherited from SQLColumn.)
Public propertyMoney
A logical value of TRUE if the SQL column is a money data type; otherwise, FALSE.
Public propertyName
A string representing the name of the field.
(Inherited from DataField.)
Public propertyNameSym
A symbol representing the name of the field.
(Inherited from DataField.)
Public propertyNullable
A logical value representing whether the SQL value can be NULL.
(Inherited from SQLValue.)
Public propertyScale
A numeric value representing the number of decimal places in the SQL value.
(Inherited from SQLValue.)
Public propertySearchable
A constant (four standard values) representing how the column can be used in searches:
Public propertyType (Inherited from SQLValue.)
Public propertyUnsigned
A logical value of TRUE if the column is unsigned or non-numeric; otherwise, FALSE.
Public propertyUpdatable
A logical value of TRUE if the column can be updated; otherwise, FALSE.
Public propertyUsualType
A string representing the X# usual type corresponding to the originating ODBC type (for example, SQL_INTEGER returns LONG).
(Inherited from SQLValue.)
Top
Functions
  NameDescription
Public methodAsString
Return the descriptive label defined for this field.
(Inherited from DataField.)
Top
See Also