Type (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

This content has been translated automatically. Click here to view the French version.

Defining the items programmatically
Filling mode
Type of a Table control cell
Limit

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Type (Property)

In french: Type

The Type property is used to get:

the type of element (data file or item) defined programmatically or in the data model editor, view or query.
the type of object.
the type of data held in a Variant.
Remark: To change the type of data held in a Variant, use VariantConvert.

The Type property defines the type of a dynamic object.

This property can only be used to get the type of a control. This property is available only if the new WLanguage framework is enabled. For more details, see Browser code (WLanguage): Framework 2.

Example

See additional examples

MonVariant is Variant = "5"
Info(MonVariant.Type) // Renvoie 19
MonVariant.Type = 2 // Convertit en entier

// Connaître le type de la rubrique "Contact"
ResType = Client.Contact.Type
// Connaître le type du fichier de données Client
ResType = Client.Type

// Connaître le type de l'objet "Client"
ResType = Client.Type

Syntax

Getting the type of data held in a Variant Hide the details

<Result> = <Variable used>..Type

<Result>: Integer

Type of data held in the Variant variable:
wlBoolean 1 Boolean
wlCharacter 81 Character
wlString
16 in an ANSI configuration
19 in a Unicode configuration.
Character string
wlCombination 136 Combination
wlDate 24 Date
wlDateTime 26 DateTime
wlDuration 27 Duration
wlInt 8 Signed 4-byte integer
wlEnumeration 135 Enumeration
wlTime 25 Time
wlCurrency 10 Currency
wlSecurePassword 160 Secure password
wlNumeric 13 Numeric
wlPoint 150 Point
wlProcedure 61 Procedure
wlRectangle 151 Rectangle
wlReal 12 8-byte real
wlSQLQuery 152 SQL query
wlAdvancedType 111 Advanced variable type
wlUUID 154 UUID
wlUUID_128 154 UUID
wlUUID_256 155 UUID
wlVariantObject 143 The Variant contains named subelements.
wlVariantArray 142 The Variant contains indexed subelements.
wlEmpty 0 The Variant is empty.

<Variable used>: Variable name

Name of the Variant variable to be used.

Getting the type of a data file or item Hide the details

<Result> = <Object used>.Type

<Result>: Integer constant

If the name of a data file, view or query is specified: Type of the specified file:
hFileAS400 54 AS400 file
hFileOther 58 Other type of file
hFileClientServer 79 HFSQL Client/Server file
hFileHF5 56 Hyper File 5 file
hFileMySQL 72 MySQL file
hFileNormal 51 Standard file (HFSQL Classic)
hFileOLEDB 60 OLE DB file
hFileOracle 61 Oracle file
hFileOracleLite 83 Oracle Lite file
hFilePostgreSQL 88 PostgreSQL file
hFileProgress 77 Progress file
hFileQuery 57 Query
hFileQueryAS400 67 Query on an AS/400 database
hFileQueryClientServer 80 Query on an HFSQL Client/Server database
hFileQueryMySQL 69 Query on a MySQL database
hFileQueryOLEDB 64 Query on a database accessed via an OLE DB provider
hFileQueryOracle 65 Query on an Oracle database
hFileQueryOracleLite 85 Query on an Oracle Lite database
hFileQueryPostgreSQL 87 Query on a PostgreSQL database
hFileQueryProgress 78 Query on a Progress database
hFileQuerySQLAzure 66 Query on an SQL Azure database
hFileQuerySQLServer 66 Query on an SQL Server database
hFileQuerySybase 76 Query on a Sybase database
hFileQueryXML 82 Query on an XML database
hFileSQL 50 SQL file
hFileSQLAzure 91 SQL Azure file
hFileSQLite 89 SQLite file
hFileSQLServer 62 SQL Server file
hFileSybase 75 Sybase file
hFileTemporary 52 Temporary file
hFileView 55 View
hFileXBase 53 xBase file
hFileXML 81 XML file
If the name of an item is specified: Type of the specified item:
hItemBinary 23 Binary
hItemBoolean 27 Boolean
hItemCharacter 26 Character
hItemCombination 33 Combination
hItemDate6 10 Date in YYMMDD format
hItemDate8 14 Date in YYYYMMDD format
hItemDateTime 24 Date/Time
hItemTimeLength 25 Duration
hItemInteger1 4 1-byte integer
hItemInteger2 3 2-byte integer
hItemInteger4 5 4-byte integer
hItemInteger8 19 8-byte integer
hItemUnsignedInteger1 12 Unsigned 1-byte integer
hItemUnsignedInteger2 9 Unsigned 2-byte integer
hItemUnsignedInteger4 22 Unsigned 4-byte integer
hItemUnsignedInteger8 20 Unsigned 8-byte integer
hItemEnumeration 32 Enumeration
hItemHour 11 Time
hItemIDAuto 1 Automatic identifier (8 bytes)
hItemIDAuto4 28 Automatic identifier (4 bytes)
hItemPicture 21 Image
hItemInvalid 0 Invalid
hItemJSON 38 JSON
hItemBinaryMemo 18 Binary memo
hItemBinaryMemo4 16 Binary memo (4 bytes)
hItemTextMemo 15 Text memo
hItemUnicodeMemo 30 Unicode text memo
hItemCurrency 17 Currency
hItemSecurePassword 39 Password
hItemNumRec 8 Record number
hItemNumeric 31 Numeric
hItemReal4 6 4-byte real
hItemReal8 7 8-byte real
hItemRealTurbo 13 Turbo real
hItemText 2 Text
hItemUnicodeText 29 Unicode text
hItemUUID128 34 UUID 128
hItemUUID128Auto 35 UUID 128 automatic identifier
hItemUUID256 36 UUID 256
hItemUUID256Auto 37 UUID 256 automatic identifier

<Object used>: Type of object

Name of the object to be used:
data file defined in the data model editor or programmatically,
view,
query,
item defined in the data model editor or programmatically.

Setting the type of a data file or item defined programmatically Hide the details

<Object used>: Type of object

Name of the dynamic object used:
data file defined via the File Description type,
item defined via the Item Description type.

<New type>: Constant

If the name of a file is specified: New type of the specified file:
hFileAS400 54 AS400 file
hFileOther 58 Other type of file
hFileClientServer 79 HFSQL Client/Server file
hFileHF5 56 Hyper File 5 file
hFileMySQL 72 MySQL file
hFileNormal 51 Standard file (HFSQL Classic)
hFileOLEDB 60 OLE DB file
hFileOracle 61 Oracle file
hFileOracleLite 83 Oracle Lite file
hFilePostgreSQL 88 PostgreSQL file
hFileProgress 77 Progress file
hFileQuery 57 Query
hFileQueryAS400 67 Query on an AS/400 database
hFileQueryClientServer 80 Query on an HFSQL Client/Server database
hFileQueryMySQL 69 Query on a MySQL database
hFileQueryOLEDB 64 Query on a database accessed via an OLE DB provider
hFileQueryOracle 65 Query on an Oracle database
hFileQueryOracleLite 85 Query on an Oracle Lite database
hFileQueryPostgreSQL 87 Query on a PostgreSQL database
hFileQueryProgress 78 Query on a Progress database
hFileQuerySQLAzure 66 Query on an SQL Azure database
hFileQuerySQLServer 66 Query on an SQL Server database
hFileQuerySQLServerMobile 86 Query on an SQL Server Mobile database
hFileQuerySybase 76 Query on a Sybase database
hFileQueryXML 82 Query on an XML database
hFileSQL 50 SQL file
hFileSQLAzure 91 SQL Azure file
hFileSQLite 89 SQLite file
hFileSQLServer 62 SQL Server file
hFileSQLServerMobile SQL Server CE file
hFileSybase 75 Sybase file
hFileTemporary 52 Temporary file
hFileView 55 View
hFileXBase 53 xBase file
hFileXML 81 XML file
If the name of an item is specified: New type of the specified item:
hItemBinary 23 Binary
hItemBoolean 27 Boolean
hItemCharacter 26 Character
hItemCombination 33 Combination
Remark: To define a Combination item, the type of combination must be specified via the TypeDescription property.
hItemDate6 10 Date in YYMMDD format
hItemDate8 14 Date in YYYYMMDD format
hItemDateTime 24 Date/Time
hItemTimeLength 25 Duration
hItemInteger1 4 1-byte integer
hItemInteger2 3 2-byte integer
hItemInteger4 5 4-byte integer
hItemInteger8 19 8-byte integer
hItemUnsignedInteger1 12 Unsigned 1-byte integer
hItemUnsignedInteger2 9 Unsigned 2-byte integer
hItemUnsignedInteger4 22 Unsigned 4-byte integer
hItemUnsignedInteger8 20 Unsigned 8-byte integer
hItemEnumeration 32 Enumeration
Remark: To define an Enumeration item, the type of enumeration must be specified via the TypeDescription property.
hItemHour 11 Time
hItemIDAuto 1 Automatic identifier (8 bytes)
hItemIDAuto4 28 Automatic identifier (4 bytes)
hItemPicture 21 Image
hItemInvalid 0 Invalid
hItemBinaryMemo 18 Binary memo
hItemBinaryMemo4 16 Binary memo (4 bytes)
hItemTextMemo 15 Text memo
hItemUnicodeMemo 30 Unicode text memo
hItemCurrency 17 Currency
hItemSecurePassword 39 Password
hItemNumRec 8 Record number
hItemNumeric 31 Numeric
hItemReal4 6 4-byte real
hItemReal8 7 8-byte real
hItemRealTurbo 13 Turbo real
hItemText 2 Text
hItemUnicodeText 29 Unicode text
hItemUUID128 34 UUID 128
hItemUUID128Auto 35 UUID 128 automatic identifier
hItemUUID256 36 UUID 256
hItemUUID256Auto 37 UUID 256 automatic identifier

Getting the type of a control (in a window or page), table cell, group of controls, window or page Hide the details

<Result> = <Object used>.Type

<Result>: Constant

Type of the specified object.
typActiveX 17 ActiveX control

Not available.
typOrganizer 76 Organizer control

Not available.
typScrollbar 18 Scrollbar control

Not available.
typAttribute 41 Attribute of a Looper control

Not available.
typSlidingBanner 122 Sliding Banner control

Not available.
typNavigationBar 117 Navigation Bar control

Not available.
typToolbar 22 Toolbar control

Not available.
typToolbox 29 Sidebar control

Not available.
typButton 4 Button control
typCalendar 47 Calendar control
Not available.
typCaptcha 82 Captcha control

Not available.
typMap 92 Map control

Not available.
typCarousel 37 Carousel control

Not available.
typStatusBarBox 40002 Cell in a status bar

Not available.
typCell 50014 Cell control

Not available.
typNavigationBarCell 115 Cell control in a Navigation Bar control.

Not available.
typCellLayout 127 Cell in a Layout control
Not available.
typCellPageLayout 84 Cell control used for the Zoning layout.

Not available.
typFormattedControl 50001 Formatted display control

Not available.
typHTMLControl 50002 HTML control

Not available.
typMenuControl 50007 Menu of a WEBDEV page

Not available.
typBreadcrumb 50011 Breadcrumb control

Not available.
typClick 30001 Clickable Image control (Image control with the "This image is a clickable area" option).

Not available.
typBarCode 26 Bar Code control

Not available.
typColumn 56 Table column
Not available.
typComboWE 10001 Editable Combo Box control
Not available.
typComboNE 10002 Non-editable Combo Box control
Not available.
typWebComponent 121 Web Component control

Not available.
typConference 25 Conference control

Not available.
typNativeContainer 125 Native Container control

Not available.
typCube 38 Cube control

Not available.
typDate 20002 Date Edit control
Not available.
typLayout 126 Layout control
Not available.
typDuration 20006 Duration Edit control
Not available.
typDiagramEditor 130 Diagram Editor control

Not available.
typHtmlEditor 134 HTML Editor control

Not available.
typImageEditor 124 Image Editor control

Not available.
New in version 28
typMobileImageEditor
138 Image Editor control for mobile devices

Not available.
typWin 1 Window
Not available.
typInternalWindow 31 Internal Window
Not available.
typWire 118 Wire control

Not available.
typFlash 50008 Flash control

Not available.
typFlex 48 Flex control

Not available.
typShape 20 Shape/Drawing control

Not available.
typGantt 110 Gantt Chart column (Table or TreeView Table control).

Not available.
typChart 33 Chart control in a window or page

Not available.
typGrp 58 Group of controls

Not available.
typTime 20003 Time Edit control
Not available.
typHTML 23 HTML static

Not available.
typIFrame 50013 IFrame control

Not available.
typImage 8 Image control
typCheckBox 5 Check Box control
Not available.
typSwitch 132 Switch control
Not available.
typProgressBar 10 Progress Bar control
Not available.
typInfiniteProgressBar 113 Infinite Progress Bar control
Not available.
typJava 50004 Java control

Not available.
New in version 28
typKanban
140 Kanban control

Not available.
typPDFReader PDF Reader control

Not available.
typStatic 3 Static control
typHTMLStatic 50006 HTML Static control

Not available.
typLink 50005 Link control

Not available.
typSocialLink 103 Social Network control

Not available.
typHorizontalRule 50003 Line control

Not available.
typList 7 List Box control
Not available.
typListView 27 ListView control

Not available.
New in version 28
typKanbanList
142 Kanban List control

Not available.
typMapArea 50010 Clickable Image control

Not available.
typControlTemplate 43 Control Template control.
Not available.
typCurrency 20005 Currency edit control
Not available.
typMultimedia 39 Multimedia control
Not available.
typRating 85 Rating control

Not available.
typRepositionableNote 119 Repositionable Note control

Not available.
typNum 20004 Numeric edit control
Not available.
typOle 15 OLE control

Not available.
typTab 16 Tab control
Not available.
typSwitchOption 133 Option of a Switch control
Not available.
typMenuOption 40001 Menu option
Not available.
typOrganizationChart 86 Organization Chart control

Not available.
typPage 1 Page

Not available.
typPeelingCorner 79 Peeling Corner control

Not available.
typInternalPage 31 Internal page

Not available.
typPanel 131 Dockable Panel control

Not available.
typSlidingBannerPlane 123 Plane associated with a Sliding Banner control

Not available.
typSiteMap 45 Site Map control

Not available.
typScheduler 80 Planning

Not available.
typPopup 90 Popup page

Not available.
typSlider 12 Slider control

Not available.
typRangeSlider 72 Range Slider

Not available.
typRotativeSlider 13 Round Slider

Not available.
typRangeSlider 72 Range Slider control

Not available.
typPager 50009 Pager control

Not available.
typRibbonGroup Ribbon group

Not available.
typRibbon 87 Ribbon control

Not available.
typBreak Break in a Looper control

Not available.
typSelect 6 Radio Button control
typSplitter 28 Splitter control

Not available.
typSilverlight 46 SilverLight control

Not available.
typSpin 11 Spin control

Not available.
typSuperControl 40 Supercontrol
Not available.
typTable 9 Table control
Not available.
typPivotTable 102 Pivot Table control

Not available.
typDashboard 111 Dashboard control
Not available.
typTreeviewTable 35 TreeView Table control
Not available.
typSpreadsheet 114 Spreadsheet control

Not available.
typText 20001 Text Edit control
Not available.
typDrawer 34 Drawer control

Not available.
typWordProcessing 120 Word Processing control

Not available.
typTreeMap 74 TreeMap control

Not available.
typTreeView 19 TreeView control
Not available.
typUpload 73 Upload control

Not available.
typVideo 78 Video control

Not available.
typThumbnail 50012 Thumbnail control

Not available.
typWebCam 24 Web Camera control

Not available.
typXaml 36 Xaml control

Not available.
typMultilineZone 97 Multiline Zone control

Not available.
typLooper 30 Looper control
Not available.
typLinearLooper 77 Linear Looper control
Not available.
typRichTextArea 109 Text Area control
Not available.

<Object used>: Type of object

Name of the object (window control, page control, table cell, group of controls, page or window) to be used.

Remarks

Defining the items programmatically

When describing items in the code (Item description type), the Type property must be used for all items, except for "Composite key" items. For this type of items, use the KeyExpression property.

For Time items, the Size property must be used to define the item format (2, 4, 6 or 8-character Time). For Combination or Enumeration items, use the TypeDescription property to define the type used by the item.

The following types can be created programmatically using HDescribeFile:


hFileAS400	AS400 file
hFileNormal	Standard file
hFileOLEDB	OLE DB file
hFileOracle	Oracle file
hFileSQLServer	SQL Server file
hFileSybase	Sybase file
hFileXBase	xBase file
hFileXML	XML file

Caution: For WINDEV Mobile, only the following types are available:


hFileNormal	Standard file
hFileOracle	Oracle file
hFileSQLServerMobile	SQL Server Mobile file

Filling mode

To determine how a Table, List Box or Combo Box control is populated (programmatically, with data from a data file or variable), use the FillType property.

Type of a Table control cell

When used on a Table control cell, the Type property is used to get the type of the column that contains the cell.

Limit

For controls in a window or page, the Type property cannot be used on:

an option in a Check Box or Radio Button control,
a row in a Table or Combo Box control,
a row in a List Box control,
a tab in a Tab or Sidebar control.

In the current version, the Type property applies only to controls in a window.