| |
| 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 | The Property SensitiveAccentuation allows you to set the accentuation to be taken into account in the various searches carried out on the heading or on the full-text index (with the HLitSearch, HLitSearchFirst and HLitSearchLast functions 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 allows you to know if a field is of binary type or not. |
| BrowsedFile | The Property FilePath allows you to know and modify the data source used to display records in fields based on a data file. |
| 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, the Caption property 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, the Caption property 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 page, the Caption property is also 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 Breadcrumb control.
|
| CaseSensitive | The Property Case Sensitive allows you to set the case sensitivity (upper/lower case) of the different searches performed on the topic or on the full-text index (with the functions HLitSearch, HLitSearchFirst and HLitSearchLast, for example). |
| Charset | The Charset property 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 Property CxAccess allows you to manage the type of data file access when connecting 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 to find out the type of cursor used during a connection to an external database. |
| CtDatabase | The Property CxDatabase is used to manage the OLE DB data source when connecting OLE DB to a specific table. |
| CtDescribedAccess | The Property CxAccèsDécrit is used to manage the type of access to the data file when connecting 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 | The Property CursorOptions allows to manage the type of cursor used during a connection (Native Access, OLE DB, ...). |
| Database | The Property Database allows to manage the database associated with a connection (HFSQL Client/Server, OLE DB, ...). |
 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 | The DecimalPart property is used to configure 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 | The Property DeletionRule is used to set the record deletion rule (integrity management) to be applied to the data file described by programming. |
| DescribedDirectory | The Property WrittenDirectory allows you to manage the physical directory of HFSQL files. |
| DescribedName | The Property DescribedName is used to manage the logical name of HFSQL files. |
| DescribedPhysicalName | The Property PhysicalName 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 | The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) 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 Filter property is used to identify and change the filter applied to 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 FilteredTopic is used to find out the topic on which a filter has been set up 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 file associated to the specified logical file. |
| GUIDAnalysis | The Property GUIDAnalyse returns the GUID of the analysis that created the data file. |
| GUIDFile | The Property GUIDFile returns the GUID of the file defined in the analysis that created 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 property 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 | The Property LinkKey is used to set the characteristics of a link. |
| LogBackupDirectory | The Property LogBackupDirectory allows to manage the log files backup directory. |
| LogDirectory | The Property DirectoryJournal 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 | The IdAutoMax property allows to know 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 file. |
| 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 | The Property EncryptionMmo allows you to set the encryption mode of the memo file (.MMO extension) associated to the data file. |
| MmoPackMethod | The Property CompressionMmo is used to set the compression mode of the MMO file (containing binary and text memos) associated to the data file. |
| ModificationRule | The ModificationRule property is used to configure the modification rule (integrity management) to be applied to the data file described in the code. |
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 | The Property Name allows you to know:- 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 | The Property Nom55 allows to manage the logical name of a data file in Hyper File 5.5 format not migrated and present 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 | The NbRubric property gives the total number of headings (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.
|
| 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 NdxCryptMethod property is used to configure the encryption method for the index (.NDX) file associated with the data file. |
| 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 | The PasswordProtected property is used to determine if a datafile 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 | The Property Provider allows to manage the type of a connection (HFSQL Client/Server, OLE DB, ...). |
| PunctuationSensitive | The Property SensitivePunctuation allows you to set the parameters for taking punctuation (comma, full stop, etc.) into account in the various searches performed on the topic (with the HLitSearch, HLitSearchFirst and HLitSearchLast functions 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 ReplicaDirectory is used to manage the replica directory (".RPL" or ".RPM" file). |
| 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 Property Server allows to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...). |
Versions 11 and laterSize New in version 11Size Size | The Size property is used to determine and change 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 applies to:- a Chart control: in this case, the Property Source allows to know the source of the series: Table column, list of values, ...
- a connection: in this case, the Property Source allows to know or define the source of a 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 you to know the SQL code of a query created with the query editor (file extension ".WDR"). |
| 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 CompleteTextField allows you to set up the management of text fields in an HFSQL file. |
| 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 TransactionFile allows to know if a data file is a transaction file or not. |
Versions 09 and laterType New in version 09Type Type | The Property Type allows to know:- 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 | The Property VisibleUserFinal allows you 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: |