ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / Various properties
  • Defining the items programmatically
  • Filling mode
  • Type of a Table control cell
  • Limit
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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.
WEBDEV - Browser code 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.
MonVariant is Variant = "5"
Info(MonVariant..Type) // Renvoie 19
// 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
WEBDEV - Server codePHPAjax
// 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:
wlBoolean1Boolean
wlCharacter81Character
wlString
  • 16 in an ANSI configuration
  • 19 in a Unicode configuration.
Character string
wlCombination136Combination
wlDate24Date
wlDateTime26DateTime
wlDuration27Duration
wlInt8Signed 4-byte integer
wlEnumeration135Enumeration
wlTime25Time
wlCurrency10Currency
wlSecurePassword160Secure password
wlNumeric13Numeric
wlPoint150Point
wlProcedure61Procedure
wlRectangle151Rectangle
wlReal128-byte real
wlSQLQuery152SQL query
wlAdvancedType111Advanced variable type
wlUUID154UUID
wlUUID_128154UUID
wlUUID_256155UUID
wlVariantObject143The Variant contains named subelements.
wlVariantArray142The Variant contains indexed subelements.
wlEmpty0The 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:
    hFileAS40054AS400 file
    hFileOther58Other type of file
    hFileClientServer79HFSQL Client/Server file
    hFileHF556Hyper File 5 file
    hFileMySQL72MySQL file
    hFileNormal51Standard file (HFSQL Classic)
    hFileOLEDB60OLE DB file
    hFileOracle61Oracle file
    hFileOracleLite83Oracle Lite file
    hFilePostgreSQL88PostgreSQL file
    hFileProgress77Progress file
    hFileQuery57Request
    hFileQueryAS40067Query on an AS/400 database
    hFileQueryClientServer80Query on an HFSQL Client/Server database
    hFileQueryMySQL69Query on a MySQL database
    hFileQueryOLEDB64Query on a database accessed via an OLE DB provider
    hFileQueryOracle65Query on an Oracle database
    hFileQueryOracleLite85Query on an Oracle Lite database
    hFileQueryPostgreSQL87Query on a PostgreSQL database
    hFileQueryProgress78Query on a Progress database
    hFileQuerySQLAzure66Query on an SQL Azure database
    hFileQuerySQLServer66Query on an SQL Server database
    hFileQuerySybase76Query on a Sybase database
    hFileQueryXML82Query on an XML database
    hFileSQL50SQL file
    hFileSQLAzure91SQL Azure file
    hFileSQLite89SQLite file
    hFileSQLServer62SQL Server file
    hFileSybase75Sybase file
    hFileTemporary52Temporary file
    hFileView55View
    hFileXBase53xBase file
    hFileXML81XML file
  • If the name of an item is specified:
    Type of the specified item:
    hItemBinary23Binary
    hItemBoolean27Boolean
    hItemCharacter26Character
    hItemCombination33Combination
    hItemDate610Date in YYMMDD format
    hItemDate814Date in YYYYMMDD format
    hItemDateTime24Date/Time
    hItemTimeLength25Duration
    hItemInteger141-byte integer
    hItemInteger232-byte integer
    hItemInteger454-byte integer
    hItemInteger8198-byte integer
    hItemUnsignedInteger112Unsigned 1-byte integer
    hItemUnsignedInteger29Unsigned 2-byte integer
    hItemUnsignedInteger422Unsigned 4-byte integer
    hItemUnsignedInteger820Unsigned 8-byte integer
    hItemEnumeration32Enumeration
    New in version 2024
    hItemShape
    52Any geometric or geographical shape.
    hItemHour11Time of day
    hItemIDAuto1Automatic identifier (8 bytes)
    hItemIDAuto428Automatic identifier (4 bytes)
    hItemPicture21Image
    hItemInvalid0Invalid
    hItemJSON38JSON
    hItemBinaryMemo18Binary memo
    hItemBinaryMemo416Binary memo (4 bytes)
    hItemTextMemo15Text memo
    hItemUnicodeMemo30Unicode text memo
    hItemCurrency17Currency
    hItemSecurePassword39Password
    New in version 2024
    hItemMultiPoint2D
    46Geometric multipoint in 2 dimensions
    New in version 2024
    hItemMultiPointGeo
    47Geographic multipoint
    New in version 2024
    hItemMultiPolygon2D
    50Geometric multipolygon in 2 dimensions
    New in version 2024
    hItemMultiPolygonGeo
    51Geographic multipolygon
    New in version 2024
    hItemMultiLinestring2D
    48Geometric multipolyline in 2 dimensions
    New in version 2024
    hItemMultiLinestringGeo
    49Geographic multilinestring
    hItemNumRec8Record number
    hItemNumeric31Digital
    New in version 2024
    hItemPoint2D
    402-dimensional geometric point
    New in version 2024
    hItemPointGeo
    41Geographic point
    New in version 2024
    hItemPolygon2D
    44Geometric Polygon in 2 dimensions
    New in version 2024
    hItemPolygonGeo
    45Polygon geographical
    New in version 2024
    hItemLinestring2D
    422-dimensional geometric polyline
    New in version 2024
    hItemLinestringGeo
    43Geographical polyline
    hItemReal464-byte real
    hItemReal878-byte real
    hItemRealTurbo13Turbo real
    hItemText2Text
    hItemUnicodeText29Unicode text
    hItemUUID12834UUID 128
    hItemUUID128Auto35UUID 128 automatic identifier
    hItemUUID25636UUID 256
    hItemUUID256Auto37UUID 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.
WEBDEV - Server codePHPAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBODBCNative Connectors (Native Accesses)

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

<Object used>.Type = <New type>
<Object used>: Object type
Name of the dynamic object used:
<New type>: Constant
  • If the name of a file is specified: New type of the specified file:
    hFileAS40054AS400 file
    hFileOther58Other type of file
    hFileClientServer79HFSQL Client/Server file
    hFileHF556Hyper File 5 file
    hFileMySQL72MySQL file
    hFileNormal51Standard file (HFSQL Classic)
    hFileOLEDB60OLE DB file
    hFileOracle61Oracle file
    hFileOracleLite83Oracle Lite file
    hFilePostgreSQL88PostgreSQL file
    hFileProgress77Progress file
    hFileQuery57Request
    hFileQueryAS40067Query on an AS/400 database
    hFileQueryClientServer80Query on an HFSQL Client/Server database
    hFileQueryMySQL69Query on a MySQL database
    hFileQueryOLEDB64Query on a database accessed via an OLE DB provider
    hFileQueryOracle65Query on an Oracle database
    hFileQueryOracleLite85Query on an Oracle Lite database
    hFileQueryPostgreSQL87Query on a PostgreSQL database
    hFileQueryProgress78Query on a Progress database
    hFileQuerySQLAzure66Query on an SQL Azure database
    hFileQuerySQLServer66Query on an SQL Server database
    hFileQuerySybase76Query on a Sybase database
    hFileQueryXML82Query on an XML database
    hFileSQL50SQL file
    hFileSQLAzure91SQL Azure file
    hFileSQLite89SQLite file
    hFileSQLServer62SQL Server file
    hFileSybase75Sybase file
    hFileTemporary52Temporary file
    hFileView55View
    hFileXBase53xBase file
    hFileXML81XML file
  • If the name of an item is specified: New type of the specified item:
    Type of the specified item:
    hItemBinary23Binary
    hItemBoolean27Boolean
    hItemCharacter26Character
    hItemCombination33Combination
    hItemDate610Date in YYMMDD format
    hItemDate814Date in YYYYMMDD format
    hItemDateTime24Date/Time
    hItemTimeLength25Duration
    hItemInteger141-byte integer
    hItemInteger232-byte integer
    hItemInteger454-byte integer
    hItemInteger8198-byte integer
    hItemUnsignedInteger112Unsigned 1-byte integer
    hItemUnsignedInteger29Unsigned 2-byte integer
    hItemUnsignedInteger422Unsigned 4-byte integer
    hItemUnsignedInteger820Unsigned 8-byte integer
    hItemEnumeration32Enumeration
    New in version 2024
    hItemShape
    52Any geometric or geographical shape.
    hItemHour11Time of day
    hItemIDAuto1Automatic identifier (8 bytes)
    hItemIDAuto428Automatic identifier (4 bytes)
    hItemPicture21Image
    hItemInvalid0Invalid
    hItemJSON38JSON
    hItemBinaryMemo18Binary memo
    hItemBinaryMemo416Binary memo (4 bytes)
    hItemTextMemo15Text memo
    hItemUnicodeMemo30Unicode text memo
    hItemCurrency17Currency
    hItemSecurePassword39Password
    New in version 2024
    hItemMultiPoint2D
    46Geometric multipoint in 2 dimensions
    New in version 2024
    hItemMultiPointGeo
    47Geographic multipoint
    New in version 2024
    hItemMultiPolygon2D
    50Geometric multipolygon in 2 dimensions
    New in version 2024
    hItemMultiPolygonGeo
    51Geographic multipolygon
    New in version 2024
    hItemMultiLinestring2D
    48Geometric multipolyline in 2 dimensions
    New in version 2024
    hItemMultiLinestringGeo
    49Geographic multilinestring
    hItemNumRec8Record number
    hItemNumeric31Digital
    New in version 2024
    hItemPoint2D
    402-dimensional geometric point
    New in version 2024
    hItemPointGeo
    41Geographic point
    New in version 2024
    hItemPolygon2D
    44Geometric Polygon in 2 dimensions
    New in version 2024
    hItemPolygonGeo
    45Polygon geographical
    New in version 2024
    hItemLinestring2D
    422-dimensional geometric polyline
    New in version 2024
    hItemLinestringGeo
    43Geographical polyline
    hItemReal464-byte real
    hItemReal878-byte real
    hItemRealTurbo13Turbo real
    hItemText2Text
    hItemUnicodeText29Unicode text
    hItemUUID12834UUID 128
    hItemUUID128Auto35UUID 128 automatic identifier
    hItemUUID25636UUID 256
    hItemUUID256Auto37UUID 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.
typActiveX17ActiveX control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typOrganizer76Organizer control
typScrollbar18Scrollbar control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typAttribute41Attribute of a Looper control
typSlidingBanner122 Sliding Banner control
typNavigationBar117Navigation Bar control
typToolbar22Toolbar control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typToolbox29Sidebar control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typButton4Button control
typCalendar47Calendar control
typCaptcha82Captcha control
typMap92Map control
typCarousel37Carousel control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typStatusBarBox40002Cells of a status bar
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typCell50014Cell control
typNavigationBarCell115Cell control in a Navigation Bar control.
typCellLayout127Cell in a Layout control
Linux Not available.
typCellFlexBox139Cell of a FlexBox control.
typCellPageLayout84Cell control used for the Zoning layout.
typFormattedControl50001Formatted display control
typHTMLControl50002HTML control
typMenuControl50007Menu of a WEBDEV page
typContextMenuControl141Context menu in a WEBDEV page
typBreadcrumb50011Breadcrumb control
typClick30001Clickable Image control (Image control with the "This image is a clickable area" option).
WEBDEV - Server codeWEBDEV - Browser codePHP
Not available.
typBarCode26Bar Code control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typColumn56Table column
typComboWE10001Editable Combo Box control
typComboNE10002Non-editable Combo Box control
typWebComponent121Web Component control
typConference25Conference control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typNativeContainer125Native Container control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typCube38Cube control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typDate20002Date Edit control
typLayout126Layout control
Linux Not available.
typDuration20006Duration Edit control
typDiagramEditor130Diagram Editor control
LinuxPHP
Not available.
New in version 2024
typCodeEditor
146Code Editor control
WEBDEV - Server codeWEBDEV - Browser codeLinuxPHP
Not available.
typHtmlEditor134HTML Editor control
WEBDEV - Server codeWEBDEV - Browser codeLinuxPHP
Not available.
typImageEditor124Image Editor control
WEBDEV - Server codeWEBDEV - Browser codeLinuxPHP
Not available.
typMobileImageEditor138Mobile Image Editor control
WEBDEV - Server codeWEBDEV - Browser codeWindowsLinuxPHP
Not available.
typWin1Window
WEBDEV - Server codeWEBDEV - Browser codePHP Not available.
typInternalWindow31Internal Window
WEBDEV - Server codeWEBDEV - Browser code Not available.
typWire118Wire control
WEBDEV - Server codeWEBDEV - Browser codeLinuxPHP
Not available.
typFlash50008Flash control
typFlex48Flex control
typShape20Shape/Drawing control
typGantt110Gantt Chart column (Table or TreeView Table control).
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typChart33Chart control in a window or page
typGrp58Group of controls
typTime20003Time Edit control
typHTML23HTML static
typIFrame50013IFrame control
typImage8Image control
typCheckBox5Check Box control
typSwitch132Switch control
typProgressBar10Progress Bar control
typInfiniteProgressBar113Infinite Progress Bar control
WEBDEV - Server codeWEBDEV - Browser codePHP Not available.
typJava50004Java control
typKanban140Kanban control
PHP
Not available.
typPDFReaderPDF Reader control
WEBDEV - Server codeWEBDEV - Browser codeLinuxPHP
Not available.
typStatic3Static control
typHTMLStatic50006HTML Static control
typLink50005Link control
typSocialLink103Social Network control
typHorizontalRule50003Line control
typList7List Box control
typListView27ListView control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typKanbanList142Kanban List control
PHP
Not available.
typMapArea50010Clickable Image control
typControlTemplate43Control Template control.
typCurrency20005Currency Edit control
typMultimedia39Multimedia control
WEBDEV - Server codeWEBDEV - Browser code Not available.
typRating85Rating control
Linux
Not available.
typRepositionableNote119Repositionable Note control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typNum20004Numeric Edit control
typOle15OLE control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typTab16Tab control
typSwitchOption133Option of a Switch control
typMenuOption40001Menu option
typOrganizationChart86Organization Chart control
WEBDEV - Server codeWEBDEV - Browser codePHP
Not available.
typPage1Page
typPeelingCorner79Peeling Corner control
typInternalPage31Internal page
typPanel131Dockable Panel control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typSlidingBannerPlane123Plane associated with a Sliding Banner control
typSiteMap45Site Map control
typScheduler80Planning
typPopup90Popup page
typSlider12Slider control
typRangeSlider72Range Slider
typRotativeSlider13Round Slider
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typRangeSlider72Range Slider control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typPager50009Pager control
typRibbonGroupRibbon group
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typRibbon87Ribbon control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typBreakBreak in a Looper control
typSelect6Radio Button control
typSplitter28Splitter control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typSilverlight46SilverLight control
typSpin11Spin control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typSuperControl40Supercontrol
typTable9Table control
typPivotTable102Pivot Table control
WEBDEV - Server codeWEBDEV - Browser codePHP
Not available.
typDashboard111Dashboard control
typTreeviewTable35TreeView Table control
typSpreadsheet114Spreadsheet control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typText20001Text Edit control
typDrawer34Drawer control
typWordProcessing120Word Processing control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typTreeMap74TreeMap control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typTreeView19TreeView control
typUpload73Upload control
PHP
Not available.
typVideo78Video control
PHP
Not available.
typThumbnail50012Thumbnail control
typWebCam24Web Camera control
typXaml36Xaml control
WEBDEV - Server codeWEBDEV - Browser code
Not available.
typMultilineZone97Multiline Zone control
WEBDEV - Server codeWEBDEV - Browser codeWindowsLinux
Not available.
typLooper30Looper control
typLinearLooper77Linear Looper control
typRichTextArea109Text Area control
<Object used>: Object type
Name of the object (window control, page control, table cell, group of controls, page or window) to be used.
Remarks
WEBDEV - Server codeAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBODBCNative Connectors (Native Accesses)

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:
hFileAS400AS400 file
hFileNormalStandard file
hFileOLEDBOLE DB file
hFileOracleOracle file
hFileSQLServerSQL Server file
hFileSybaseSybase file
hFileXBasexBase file
hFileXMLXML file


Caution: For WINDEV Mobile, only the following types are available:
hFileNormalStandard file
hFileOracleOracle file
hFileSQLServerMobileSQL Server Mobile file
WEBDEV - Server codePHPAjax

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.
WEBDEV - Server codePHPAjax

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,
Minimum version required
  • Version 9
This page is also available for…
Comments
Controltype
56 is Looper attributes AND Table column ?
TOR-BJARNE HENRIKSE
09 May 2017

Last update: 02/29/2024

Send a report | Local help