| XArrayDB Reference > XArrayDB Object Properties > DefaultColumnType Property (XArrayDB) |
DefaultColumnType Property (XArrayDB)
This property sets or returns the default data type of a column in an XArrayDB object.
XArrayDB.DefaultColumnType (column)
Arguments
column is a long integer specifying the index of the column whose default data type is being set or returned.
Values
Run Time
|
0 - Default |
XTYPE_DEFAULT |
|
1 - Boolean |
XTYPE_BOOLEAN |
|
2 - Byte |
XTYPE_BYTE |
|
3 - Currency |
XTYPE_CURRENCY |
|
4 - Date |
XTYPE_DATE |
|
5 - Double |
XTYPE_DOUBLE |
|
6 - Integer |
XTYPE_INTEGER |
|
7 - Long |
XTYPE_LONG |
|
8 - Single |
XTYPE_SINGLE |
|
9 - String |
XTYPE_STRING |
Read-only at run time. Not available at design time.
Property applies to XArrayDB object.
By default, this property returns 0, which means that the column's data values are not automatically translated to a specific data type.
When using XArrayDB as an OLEDBSimpleProvider data source, you can set the DefaultColumnType property so that bound controls can determine the data type of individual columns.
You can also use this property to specify the default data type for a column when using the Find and QuickSort methods.
See Also