HomePowerBuilderAppeon Documentation Center

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.

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 PowerBuilder to get a result set description before retrieving data and adjust the bind information if necessary.

For more information, see the section called “StaticBind” in Connection Reference.

Examples

string ls_coltype
ls_coltype = dw1.Object.emp_id.ColType
ls_coltype = dw1.Describe("emp_id.ColType")
Prev  Up  Next
Color  Home  Column.Count