ColType

Description

The datatype of the column or computed field.

Applies to

Column and Computed Field controls

Syntax

PowerBuilder dot notation:

dw_control.Object.controlname.ColType

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

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.

NoteDate 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 PowerBuilder 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

string ls_coltype

ls_coltype = dw1.Object.emp_id.ColType

Example 2

ls_coltype = dw1.Describe("emp_id.ColType")