ColType

Description

The datatype of the column or computed field.

Applies to

Column and Computed Field controls

Syntax

Describe argument:

"controlname.ColType"

Parameter	Description
controlname	The column for which you want the datatype. Possible datatypes are: Char (n) – n is the number of characters Date DateTime Decimal (n) – n is the number of decimal places Int Long Number Real Time Timestamp ULong

Parameter

Description

controlname

The column for which you want the datatype. Possible datatypes are:

Char (n) – n is the number of characters
Date
DateTime
Decimal (n) – n is the number of decimal places
Int
Long
Number
Real
Time
Timestamp
ULong

Usage

In the painter

The value of ColType is derived from the data or expression you specify for the control. The value is displayed in the Column Specifications view.

Date column types If you define a DataWindow with a column of type Date and deploy it with a DBMS that uses the DateTime datatype, set the StaticBind database parameter to 0 or No. This forces the DataWindow server to get a result set description before retrieving data and adjust the bind information if necessary.

For more information, see the StaticBind DBParm parameter in the online Help.

Examples

Example 1

[Visual Basic]
ls_coltype = dw1.Describe("emp_id.ColType")