| |
| Abbreviation | The Property Abbreviation gives the abbreviation of the data file. This abbreviation was defined in the data model editor when describing the data file. This property is read-only. |
| AccentuationSensitive | ..AccentuationSensitive is used to configure the management mode of accented characters in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example). |
| Access | The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.). |
| ActiveDirectory | The ActiveDirectory property allows to manage an Connection with authentication to an HFSQL server by Active Directory. |
| Binary | The Property Binary makes it possible to know if an Item is of binary type or not. |
| BrowsedFile | The Property BrowseFile allows you to know and modify the HEX@ of data used to display records in a data file based fields. |
| CacheSize | The Property SizeCache makes it possible to:- Find out the maximum number of records that can be stored in the cache of Native MySQL Access.
- Modify the maximum number of records that can be stored in the cache of Native MySQL Access.
|
| CalculatedDefaultValue | The CalculatedDefaultValue property is used to:- Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or by programming.
- Define the SQL expression that returns the default value of an item (item described by programming only).
|
| CalculatedItemExpression | The Property CalculatedRubricFormula allows to:- Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or by programming.
- Define the SQL expression returning the value of a calculated item (when describing the item by programming).
|
| Caption | In a database, ..Caption is used to:- Find out the caption associated with a file item.
- Find out the caption associated with a data file.
- Find out and modify the connection caption.
In a report, ..Caption is used to: - Find out the text displayed in a Static or Link control.
- Modify the text displayed in a Static or Link control.
In a window or in a page, ..Caption is used to: - Find out and modify the caption of a control in a window or in a page.
- Find out and modify the caption of a menu option.
- Find out and modify the title of a window or page.
- Find out the content of a site map path.
|
| CaseSensitive | ..CaseSensitive is used to configure the management mode of case (uppercase/lowercase characters) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example). |
| Charset | Charset is used to: - Find out the character set used by a Font variable.
- Modify the character set used by a Font variable.
- Find out the character set used by an HFSQL data file.
|
| Component | ..Component is used to configure the different components of a composite key. |
| CompositeKey | The Property CompoundKey allows to know if an Item is a compound key. |
| Compression | The Compression property is used to manage data compression during an Connection (HFSQL Client/Server, ...). |
| Connection | Connection is used to find out and modify the connection currently associated with a data file. |
| CryptMethod | The Property Encryption allows to manage the type of encryption of the communication between the Client workstations and the HFSQL Server workstation. |
| CtAccess | The CxAccess property is used to manage the type of access to the data file when Connection OLE DB to a specific table. |
| CtCacheSize | ..CtCacheSize is used to find out and modify the maximum number of records that can be stored in the cache of the Native MySQL Access. |
| CtCursorOptions | ..CtCursorOptions is used identify the type of cursor that will be used during a connection to an external database. |
| CtDatabase | The CxBaseData property allows you to manage the OLE DB data source when Connection OLE DB to a specific table. |
| CtDescribedAccess | The CxAccessDécrit property is used to manage the type of access to the data file during Connection OLE DB to a specific table. |
| CtDescribedCaption | CtDescribedCaption is used to manage the caption of the connection to the OLE DB data source. |
| CtDescribedDatabase | CtDescribedDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table. |
| CtDescribedOLEDBProvider | CtDescribedOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server). |
| CtDescribedPassword | CtDescribedPassword enables you to define the password used to open the file during an OLE DB connection (file defined by programming only). |
| CtDescribedUserName | The CxUserDescript property is used to set the user name used in the Connection OLE DB to a specific table. |
| CtExtendedInfo | The CxInfosExtended property allows to know the additional information inserted in the string from Connection to the database. |
| CtInitialCatalog | CtInitialCatalog is used to find out the default database defined for the access. |
| CtOLEDBProvider | CtOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server). |
| CtUserName | The CxUser property is used to set the user name used in the Connection OLE DB to a specific table. |
| CursorOptions | ..CursorOptions is used to manage the type of cursor used during a connection (Native Accesses, OLE DB, etc.). |
| Database | ..Database is used to manage the database associated with a connection (HFSQL Client/Server, OLE DB, etc.). |
 Versions 09 and laterDate New in version 09Date | ..Date is used to:- Retrieve the date from a DateTime variable.
- Modify the date in a DateTime variable.
- Retrieve the date from a Date item (in "Date and Time" format) .
- Modify the date in a Date item (in "Date and Time" format)
|
Versions 09 and laterDay New in version 09Day Day | ..Day is used to:- Retrieve the day from a Date, DateTime variable or retrieve the number of days from a Duration variable.
- Modify the day in a Date, DateTime variable or modify the number of days in a Duration variable.
- Retrieve the day or the number of days from a Date item (in "Date", "Date and Time" or "Duration" format)
- Modify the day or the number of days in a Date item (in "Date", "Date and Time" or "Duration" format)
|
| DecimalPart | DecimalPart is used to configure the Numeric items. |
| DefaultValue | The Property Default Value allows you to:- Find out the default value of an item. This item was defined in the data model editor or by programming.
- Define the default value of an item (when describing the item by programming).
|
| DeletionRule | ..DeletionRule is used to configure the deletion rule (integrity management) that will be applied to the data file described by programming. |
| DescribedDirectory | The Property WrittenDirectory allows you to manage the physical directory of HFSQL files. |
| DescribedName | ..DescribedName is used to manage the logical name of HFSQL files. |
| DescribedPhysicalName | ..DescribedPhysicalName is used to manage the physical name of HFSQL files. |
| Directory | The Property Directory allows you to manage the physical directory of HFSQL files. |
| ExecutionCompleted | ..ExecutionCompleted is used to find out whether the execution of a query or view (in HFSQL Classic or Client/Server format) is completed. |
| ExtendedInfo | ExtendedInfo is used to get additional information:- about a data file accessed by a Native Connector or HFSQL Client/Server.
- about an item accessed by a Native Connector or HFSQL Client/Server.
- about a connection. In this case, this property is equivalent to ..CtExtendedInfo.
|
| Extension | Extension is used to:- find out the extension of a file defined in the data model editor or by programming.
- define the extension of a file (when the file is described by programming only).
|
| FicCryptMethod | FicCryptMethod is used to configure the encryption mode of the data file. |
| Filter | The Property Filter makes it possible to know and modify the filter used for the display of records in: - browsing Table controls,
- browsing TreeView Table controls,
- browsing List Box controls,
- browsing Combo Box controls,
- browsing Looper controls.
|
| FilterCondition | The Property ConditionFiltre allows you to know the selection condition set up by the HFilter function on a data file, a HFSQL view or a query.. |
| FilteredItem | The Property Item Filtered makes it possible to know the Item on which a filter has been set by the HFilter function.. |
| FilterWithBounds | The Property FilterWithTerminals allows to know if terminals have been specified on the filter set up by the HFilter function on a data file, a HFSQL view or a query. |
| Format | Format is used to configure the format of the data in the data file. |
Versions 26 and laterGDPR New in version 26GDPR GDPR | The GDPR property is used to: - find out if the GDPR applies to an item from a data file.
- define whether the GDPR should apply to an item (in the item description in the code only).
|
| GenerationNumber | The Property GenerationNumber allows to know the generation number of the physical HEX@ associated to the specified logical HEX@. |
| GUIDAnalysis | The Property GUIDAnalyse returns the GUID of the analysis that created the data file. |
| GUIDFile | ..GUIDFile is used to find out the GUID of the file defined in the analysis that was used to create the data file. |
Versions 09 and laterHour New in version 09Hour Hour | ..Hour is used to:- Retrieve the time from a Time, DateTime variable or retrieve the number of hours from a Duration variable.
- Modify the time in a Time, DateTime variable or modify the number of hours in a Duration variable.
- Retrieve the time or the number of hours from a Date item (in "Date and time" or "Duration" format) or from a Time item.
- Modify the time or the number of hours in a Date item (in "Date and time" or "Duration" format) or in a Time item.
|
| HugeFile | HugeFile is used to configure the maximum size of a data file. |
Versions 09 and laterIndex Index | The Index indicates the physical index (physical order) of an item in a record. |
| InfoThumbnailGeneration | InfoThumbnailGeneration is used to find out whether the thumbnails of an item were generated properly. |
| InitialFile | ..InitialFile is used to find out the initial name of the data file associated with an item found in a query. |
| InitialItem | InitialItem is used to find out the initial name of an item found in a query. This name is known from the alias of this item. |
| IntegerPart | ..IntegerPart is used to configure the Numeric items. |
Versions 14 and laterItems Items | Items is used to configure the different items included in a full-text index. |
| KeyExpression | The Property FormulaKey allows you to set the different components of a compound key. |
| KeySize | The Property KeySize allows you to set the characteristics of an Item key of the text memo type. |
| KeyType | The Property TypeKey allows to set the characteristics of a key Item. |
| Language | ..Language is used to manage the language used to perform the comparisons and the sort for the Unicode items (Unicode Text item or Unicode Text Memo item). |
| LanguageDescribed | ..LanguageDescribed allows you to manage the language used to perform the comparisons and the sort for the Unicode items (Unicode Text item or Unicode Text Memo item). |
| LinkedFile | LinkedFile is used to configure the characteristics of a link. |
| LinkedKey | ..LinkedKey is used to configure the characteristics of a link. |
| LogBackupDirectory | The Property LogBackupDirectory allows to manage the log files backup directory. |
| LogDirectory | ..LogDirectory is used to manage the directory of the log file described in the analysis. |
| LogFile | LogFile is used to find out whether a data file is a log file. |
| LogMethod | The Property Logging allows you to:- find out the log mode used for a data file (file defined in the data model editor or by programming).
- define the log mode used for a data file (when the file is described by programming).
|
| ManageHTML | ..ManageHTML is used to configure the HTML management mode in a full-text index. |
| ManageRTF | ..ManageRTF is used to configure the management mode of RTF in a full-text index. |
| MaxAutoID | MaxAutoID is used to find out the maximum automatic identifier on a replicated file. |
| MaxLinkedCardinality | The Property Linked CardinalityMax allows to know and modify the maximum cardinality of the Item linked in the Link. |
| MaxSourceCardinality | The Property CardinalitySourceMax makes it possible to know and modify the maximum cardinality of the Item source in the Link. |
| MaxThumbnailHeight | ..MaxThumbnailHeight is used to find out and modify the maximum height of an item thumbnail. |
| MaxThumbnailWidth | The Property WidthMaxVignette makes it possible to know or modify the maximum width of a vignette of an Item. |
| MaxValue | MaxValue is used to:- find out and modify the upper bound of a report based on a data file.
- find out the upper bound defined for the current filter.
- find out the maximum value of a chart series.
- find out and modify the maximum value for some types of controls.
|
Versions 09 and laterMemo New in version 09Memo Memo | ..Memo is used to find out whether an item is a memo item. |
| Millisecond | ..Millisecond is used to:- Retrieve the number of milliseconds from a Time, DateTime or Duration variable.
- Modify the number of milliseconds in a Time, DateTime or Duration variable.
- Retrieve the milliseconds or the number of milliseconds from a Date item (in "Date and Time" or "Duration" format)
- Modify the milliseconds or number of milliseconds in a Date item ("Date and Time" or "Duration" format)
|
| MinAutoID | The IdAutoMin property allows to know the minimum automatic identifier on a replicated HEX@. |
| MinimumLength | ..MinimumLength is used to configure the minimum length of the words to index. |
| MinLinkedCardinality | The Property Linked CardinalityMin allows to know and modify the minimum cardinality of the Item linked in the Link. |
| MinSourceCardinality | The Property CardinalitySourceMin makes it possible to know and modify the minimum cardinality of the Item source in the Link. |
| Minute | ..Minute is used to:- Retrieve the minutes from a Time or DateTime variable or the number of minutes from a Duration.
- Modify the minutes in a Time or DateTime variable or the number of minutes in a Duration.
- Retrieve the minutes or the number of minutes from a Date item (in "Date and Time" or "Duration" format) or from a Time item
- Modify the minutes or the number of minutes in a Date item (in "Date and Time" or "Duration" format) or in a Time item
|
| MinValue | MinValue is used to:- find out and modify the lower bound of a report based on a data file.
- find out the lower bound defined for the current filter.
- find out the minimum value of a chart series.
- find out and modify the minimum value for some types of controls.
|
| MmoCryptMethod | 0 |
| MmoPackMethod | ..MmoPackMethod is used to configure the compression mode of the MMO file (containing the binary and text memos) associated with a data file. |
| ModificationRule | The Property RuleModification is used to set up the rule of modification (integrity management) of the records to be applied to the HEX@ of data described by programming. |
Versions 09 and laterMonth Month | ..Month is used to:- Retrieve the month from a Date or DateTime variable.
- Modify the month in a Date or DateTime variable.
- Retrieve the month from a Date item (in "Simple date" or "Date and Time" format)
- Modify the month in a Date item (in "Simple Date" or "Date and Time" format)
|
Versions 09 and laterName New in version 09Name Name | Name is used to find out- the name of the font associated with a Font variable.
- the name of a control, report or report block.
- the name of a control, group of controls or window.
- the name of a control, group of controls or page.
|
| Name55 | ..Name55 is used to manage the logical name of a data file in Hyper File 5.5 format not migrated and found in an analysis in WINDEV 19. format. |
| NbArrayElement | NbArrayElement is used to configure the number of elements in an array item. |
| NbComponent | ..NbComponent is used to find out the number of elements found in a composite key. |
| NbDescribedThumbnail | NbDescribedThumbnail is used to find out the number of thumbnails described for an item. |
| NbItem | ..NbItem is used to find out the total number of items (including composite keys) in a record found in:- a file described in the data model editor,
- a file described by programming,
- an HFSQL view,
- a query.
|
| NbKeyItem | The KeyNumber property gives the total number of key fields (including compound keys) present in an Record of:- a file described in the data model editor,
- a file described by programming,
- an HFSQL view,
- a query.
|
| NbMemoItem | The NbRubriqueMémo property gives the total number of memo headings present in an Record of:- a file described in the data model editor,
- a file described by programming,
- an HFSQL view,
- a query.
|
| NbThumbnail | NbThumbnail is used to find out the number of thumbnails generated for an item. |
| NdxCryptMethod | The Property EncryptionNdx allows you to set the encryption mode of the index HEX@ (extension .NDX) associated with the data HEX@. |
| NewRecord | The NewRecord property allows to know if the Record is a new Record or comes from of the data file. |
Versions 09 and laterNull New in version 09Null Null | ..Null is used to:- Assign NULL to the item for the current record.
- Find out whether the item is associated with the NULL value for the current record.
- Define the default value of an item when the item is described by programming.
|
| NullSupported | The Property NullSupported allows to manage the NULL value in HFSQL data files. |
| Numerical | ..Numerical is used to find out whether an item is a numeric item. |
| OperationLogDirectory | The Property LogOperationDirectory is used to maintain the directory of the log operation file associated to a data file logged. |
| Password | Password can be used: - on the edit controls (or on the text table columns) to find out whether the control is a "Password" control or to modify the "Password" type of the control.
- on the connections (HFSQL Client/Server, OLE DB, etc.) to define the password of the user who is using the connection.
|
| PasswordProtected | ..PasswordProtected is used to find out whether a data file is password protected. |
| PersistedCalculatedItem | ..PersistedCalculatedItem is used to:- Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or by programming.
- Define whether the value of a calculated item is stored in the data file (when describing the item by programming).
|
| PhysicalName | The Property PhysicalName allows to manage the physical name of HFSQL files. |
| Provider | ..Provider is used to manage the type of connection (HFSQL Client/Server, OLE DB, etc.). |
| PunctuationSensitive | ..PunctuationSensitive is used to configure the management mode of punctuation (comma, dot, etc.) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example). |
| RecordSize | The RecordSize property allows to obtain the Length( in bytes) of an Record of:- a file described in the data model editor,
- a file described by programming,
- an HFSQL view,
- a query.
|
| RepeatableReadSupported | The Property RepeatableRead Supported allows to: - Find out whether the data file (file defined in the data model editor or by programming) can be used in HFSQL Client/Server in a transaction that includes a "Repeatable Read" isolation mode.
- Allow the use of a transaction that includes a "Repeatable Read" isolation mode for a data file (when the file is described by programming only).
|
| Replication | The Property Replication allows to:- find out the replication mode used for a data file (file defined in the data model editor or by programming).
- specify the replication mode used for a data file (when the file is described by programming).
|
| ReplicationDirectory | The Property ReplicationDirectory is used to manage the replication directory (HEX@ ".RPL" or ".RPM"). |
| Second | ..Second is used to:- Retrieve the number of seconds from a Time, DateTime or Duration variable.
- Modify the number of seconds in a Time, DateTime or Duration variable.
- Retrieve the seconds or the number of seconds from a Date item (in "Date and Time" or "Duration" format)
- Modify the seconds or the number of seconds in a Date item (in "Date and Time" or "Duration" format)
|
| Secure | The Property Secured allows you to set the security level of file encryption. |
| Server | The Server property is used to manage the data source of an Connection (HFSQL Client/Server, OLE DB, ...). |
Versions 11 and laterSize New in version 11Size Size | The Property Size allows to know and modify the size of an element. |
| SortType | The Property TypeTri allows to:- Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or by programming.
- Define the sort direction for an item or for a component of a composite key (when describing the item by programming).
|
| Source | Source can be used on:- a Chart control: in this case, the Property HEX@ allows to know the HEX@ of the series: Table column, list of values, ...
- a connection: in this case, the Source property allows to know or define the source of an Connection (HFSQL Client/Server, OLE DB, ...).
|
| SourceFile | SourceFile is used to configure the characteristics of a link. |
| SourceKey | SourceKey is used to configure the characteristics of a link. |
| SQLCode | The Property CodeSQL allows to know the SQL code of a query created with the query editor (HEX@ with ".WDR" extension). |
| Stemming | The Property Racinization allows to activate the rootization and to define the language used to perform a rootization in a programming defined full-text index. |
| StopWord | The Property MotVide allows to define hollow words in a full-text index defined by programming. |
| Synonym | The Property Synonym allows to define synonyms in a full-text index defined by programming. |
Versions 09 and laterText New in version 09Text Text | Text is used to find out whether an item is a text item. |
| TextItemCompleted | The Property CompleteTextTopic allows you to configure the management of text fields in an HEX@ HFSQL. |
| Thumbnail | The Property Vignette allows you to: - find out the value of an item thumbnail. This item was defined in the data model editor or by programming.
- find out and modify the image associated with a Thumbnail control.
|
Versions 09 and laterTime New in version 09Time Time | ..Time is used to:- Retrieve the time from a DateTime variable.
- Modify the time in a DateTime variable.
- Retrieve the time from in a Date item (in "Date and Time" format)
- Modify the time in a Date item ("Date and Time" format).
|
| TimestampType | The Property TimestampType allows:- Find out the type of timestamp for an item. This item was defined in the data model editor or by programming.
- Define the type of timestamp for a Date, Time or DateTime item (when describing the item by programming).
|
| TimestampUTC | ....TimestampUTC is used to:- Find out whether a timestamp item will use a UTC time or a local time. This item was defined in the data model editor or by programming.
- Define whether a timestamp item will use a UTC time or a local time (when describing the item by programming).
|
| TransactionFile | The Property HEX@ Transaction makes it possible to know if a data file is a transaction HEX@ or not.. |
Versions 09 and laterType New in version 09Type Type | Type is used to find out:- the type of element described by programming (file or item description) or not (file or item defined in the data model editor, view or query).
- the type of object.
- the type of value stored in a variant.
|
| TypeDescription | ..TypeDescription is used to: - Find out the type used by an Enumeration or Combination item. This item was defined in the data model editor or by programming.
- Define the type used by an Enumeration or Combination item (when describing the item by programming).
|
| Unalterable | The Property Unalterable allows to set the inalterability of a data file: the data file cannot be modified; only additions will be possible.. |
Versions 10 and laterUser New in version 10User User | The User property allows to manage the user of an Connection (HFSQL Client/Server, OLE DB, ...). |
| VisibleEndUser | VisibleEndUser is used to:- Find out whether an item is visible or not to the end users. This item was defined in the data model editor or by programming.
- Define whether an item must be visible or not to the end users (when describing the item by programming).
|
Versions 09 and laterWDD55 WDD55 | WDD55 is used to:- Find out the name and full path of the WDD file in Hyper File 5.5 format.
- Define the name and full path of the WDD file in Hyper File 5.5 format.
|
| WDD55Password | WDD55Password is used to specify the password of the analysis in 5.5 format during the description by programming of a file in Hyper File 5.5 format in an analysis in Hyper File Classic format. |
Versions 09 and laterYear New in version 09Year Year | The Property Year makes it possible to: |