|
|
|
|
|
|
|
|
|
|
- Defining the items programmatically
- Limitation
Type (Property) In french: Type
The Type property is used to get: - the type of an element described programmatically (field or data file description) or not (data file or field defined in the data model editor, view or query).
- the type of object.
- the type of data held in a Variant.
Note To change the type of value stored in a variant, use function VariantConvert.
The Type property defines the type of a dynamic object. MonVariant is Variant = "5"
Info(MonVariant..Type)
ResType = Client.Contact.Type
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 | 4-byte signed 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 the 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 a data file, view or query name is specified Type of data file specified:
| | | | hFileAS400 | 54 | AS400 file | | hFileOther | 58 | Other type of file | | hFileClientServer | 79 | HFSQL Client/Server data file | | hFileHF5 | 56 | Hyper File 5 data file | | hFileMySQL | 72 | MySQL file | | hFileNormal | 51 | HFSQL Classic data file | | 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 | 1-byte unsigned integer | | hItemUnsignedInteger2 | 9 | 2-byte unsigned integer | | hItemUnsignedInteger4 | 22 | 4-byte unsigned integer | | hItemUnsignedInteger8 | 20 | 8-byte unsigned integer | | hItemEnumeration | 32 | Enumeration | | hItemGeometry | 52 | Geometry in 2D or geographic coordinates | | 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 | | hItemMultiPoint2D | 46 | Multipoint in 2D coordinates | | hItemMultiPointGeo | 47 | Multipoint in geographic coordinates | | hItemMultiPolygon2D | 50 | Multipolygon in 2D coordinates | | hItemMultiPolygonGeo | 51 | Multipolygon in geographic coordinates | | hItemMultiLinestring2D | 48 | Multilinestring in 2D coordinates | | hItemMultiLinestringGeo | 49 | Multilinestring in geographic coordinates | | hItemNumRec | 8 | Record number | | hItemNumeric | 31 | Numeric | | hItemPoint2D | 40 | Point in 2D coordinates | | hItemPointGeo | 41 | Point in geographic coordinates | | hItemPolygon2D | 44 | Polygon in 2D coordinates | | hItemPolygonGeo | 45 | Polygon in geographic coordinates | | hItemLinestring2D | 42 | Linestring in 2D coordinates | | hItemLinestringGeo | 43 | Linestring in geographic coordinates | | 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>: Object type 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.
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
| | typOrganizer | 76 | Organizer control
| | typScrollbar | 18 | Scrollbar control
| | typAttribute | 41 | Attribute of a Looper control
| | typSlidingBanner | 122 | Sliding Banner control
| | typNavigationBar | 117 | Navigation Bar control
| | typToolbar | 22 | Toolbar control
| | typToolbox | 29 | Sidebar control
| | typButton | 4 | Button control | New in version 2025typSegmentedButton | 148 | Segmented Button control
| | typCalendar | 47 | Calendar control
| | typCaptcha | 82 | Captcha control
| | typMap | 92 | Map control
| | typCarousel | 37 | Carousel control
| | typStatusBarBox | 40002 | Cells of a status bar
| | typCell | 50014 | Cell control
| | typCellCSSGrid | 147 | Cell control in a CSS Grid control. | | typNavigationBarCell | 115 | Cell control in a Navigation Bar control.
| | typCellLayout | 127 | Cell in a Layout control | | typCellFlexBox | 139 | Cell of a FlexBox control. | | typCellPageLayout | 84 | Cell control used for the Zoning layout.
| | typFormattedControl | 50001 | Formatted display control
| | typHTMLControl | 50002 | HTML control
| | typMenuControl | 50007 | Menu of a WEBDEV page
| | typContextMenuControl | 141 | Context menu in a WEBDEV page
| | typBreadcrumb | 50011 | Breadcrumb control
| | typClick | 30001 | Clickable Image control (Image control with the "This image is a clickable area" option).
| | typBarCode | 26 | Bar Code control
| | typColumn | 56 | Table column
| | typComboWE | 10001 | Editable Combo Box control
| | typComboNE | 10002 | Non-editable Combo Box control
| | typWebComponent | 121 | Web Component control | | typConference | 25 | Conference control
| | typNativeContainer | 125 | Native Container control
| | typCube | 38 | Cube control
| | typDate | 20002 | Date Edit control
| | typLayout | 126 | Layout control
| | typDuration | 20006 | Duration Edit control
| | typDiagramEditor | 130 | Diagram Editor control
| | typCodeEditor | 146 | Code Editor control
| | typHtmlEditor | 134 | HTML Editor control
| | typImageEditor | 124 | Image Editor control
| | typMobileImageEditor | 138 | Mobile Image Editor control
| | typWin | 1 | Window
| | typInternalWindow | 31 | Internal Window
| | typWire | 118 | Wire control
| | typFlash | 50008 | Flash control
| | typFlex | 48 | Flex control
| | typFlexbox | 139 | Flexbox control
| | typShape | 20 | Shape/Drawing control
| | typGantt | 110 | Gantt Chart column (Table or TreeView Table control).
| | typChart | 33 | Chart control in a window or page
| | typGrp | 58 | Group of controls
| | typTime | 20003 | Time Edit control
| | typHTML | 23 | HTML static
| | typIFrame | 50013 | IFrame control
| | typImage | 8 | Image control | | typCheckBox | 5 | Check Box control
| | typSwitch | 132 | Switch control
| | typProgressBar | 10 | Progress Bar control
| | typInfiniteProgressBar | 113 | Infinite Progress Bar control
| | typJava | 50004 | Java control
| | typKanban | 140 | Kanban control
| | typPDFReader | | PDF Reader control
| | typStatic | 3 | Static Text control | | typHTMLStatic | 50006 | HTML Static control
| | typLink | 50005 | Link control
| | typSocialLink | 103 | Social Network control
| | typHorizontalRule | 50003 | Line control
| | typList | 7 | List Box control
| | typListView | 27 | ListView control
| | typKanbanList | 142 | Kanban List control
| | typMapArea | 50010 | Clickable Image control
| | typControlTemplate | 43 | Control Template control. | | typCurrency | 20005 | Currency Edit control
| | typMultimedia | 39 | Multimedia control
| | typRating | 85 | Rating control
| | typRepositionableNote | 119 | Repositionable Note control
| | typNum | 20004 | Numeric Edit control
| | typOle | 15 | OLE control
| | typTab | 16 | Tab control
| | typSwitchOption | 133 | Option of a Switch control
| | typMenuOption | 40001 | Menu option
| | typOrganizationChart | 86 | Organization Chart control
| | typPage | 1 | Page
| | typPeelingCorner | 79 | Peeling Corner control
| | typInternalPage | 31 | Internal page
| | typPanel | 131 | Dockable Panel control
| | typSlidingBannerPlane | 123 | Plane associated with a Sliding Banner control
| | typSiteMap | 45 | Site Map control
| | typScheduler | 80 | Scheduler
| | typPopup | 90 | Popup page
| | typSlider | 12 | Slider control
| | typRangeSlider | 72 | Range Slider
| | typRotativeSlider | 13 | Round Slider
| | typRangeSlider | 72 | Range Slider control
| | typPager | 50009 | Pager control
| | typRibbonGroup | | Ribbon group
| | typRibbon | 87 | Ribbon control
| | typBreak | | Break in a Looper control
| | typRadioButton | 6 | Radio Button control | | typSplitter | 28 | Splitter control
| | typSilverlight | 46 | SilverLight control
| | typSpin | 11 | Spin control
| | typSuperControl | 40 | Supercontrol | | typTable | 9 | Table control
| | typPivotTable | 102 | Pivot Table control. | | typDashboard | 111 | Dashboard control
| | typTreeviewTable | 35 | TreeView Table control
| | typSpreadsheet | 114 | Spreadsheet control
| | typText | 20001 | Text Edit control
| | typDrawer | 34 | Drawer control
| | typWordProcessing | 120 | Word Processing control
| | typTreeMap | 74 | TreeMap control
| | typTreeView | 19 | TreeView control
| | typUpload | 73 | Upload control
| | typVideo | 78 | Video control
| | typThumbnail | 50012 | Thumbnail control
| | typWebCam | 24 | Web Camera control
| | typXaml | 36 | Xaml control
| | typMultilineZone | 97 | Multiline Zone control
| | typLooper | 30 | Looper control
| | typLinearLooper | 77 | Linear Looper control
| | typRichTextArea | 109 | Text 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 Limitation 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,
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|