| |
Abbreviation | ..Abbreviation is used to find out 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 | ..Access is used to manage the type of access for a connection (HFSQL Client/Server, OLE DB, etc.). |
ActiveDirectory | ..ActiveDirectory is used to manage a connection with authentication to a HFSQL server via Active Directory. |
Binary | ..Binary is used to find out whether an item is a binary item or not. |
BrowsedFile | ..BrowsedFile is used to find out and modify the data source used to display records in controls based on a data file. |
CacheSize | ..CacheSize is used 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.
|
CalculatedDefaultItem | ..CalculatedDefaultItem is used to:- Find out the SQL expression defining the default value of an item. This item was defined in the data model editor or by programming.
- Define the SQL expression returning the default value of a item (when the item is described by programming).
|
CalculatedItemExpression | ..CalculatedItemExpression is used 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 | ..CompositeKey is used to find out whether an item is a composite key. |
Compression | ..Compression is used to manage the compression of data during a connection (HFSQL Client/Server, etc.). |
Connection | ..Connection is used to find out and modify the connection currently associated with a data file. |
CryptMethod | ..CryptMethod is used to manage the type of encryption for the communication established between the client computers and the HFSQL server. |
CtAccess | ..CtAccess is used to manage the type of access to the data file during the OLE DB connection 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 | ..CtDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table. |
CtDescribedAccess | ..CtDescribedAccess is used to manage the type of access to the data file during the OLE DB connection 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 is used to define the password that will be used to open the file during an OLE DB connection (file defined by programming only). |
CtDescribedUserName | ..CtDescribedUserName is used to configure the name of the user that will be used during the OLE DB connection to a specific table. |
CtExtendedInfo | ..CtExtendedInfo is used to find out the additional information inserted into the connection string to the database. |
CtInitialCatalog | ..CtInitialCatalog is used to identify 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 | ..CtUserName is used to configure the user name that will be used during the OLE DB connection 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 | ..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 | ..DefaultValue is used 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 | ..DescribedDirectory is used 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 | ..Directory is used 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 | ..Filter is used to find out and modify the filter used to display records in: - browsing Table controls,
- browsing TreeView Table controls,
- browsing List Box controls,
- browsing Combo Box controls,
- browsing Looper controls.
|
FilterCondition | ..FilterCondition is used to find out the selection condition implemented by HFilter on a data file, a HFSQL view or a query. |
FilteredItem | ..FilteredItem is used to find out the item on which a filter was implemented by HFilter. |
FilterWithBounds | ..FilterWithBounds is used to find out whether bounds have been specified for the filter implemented byHFilter on a HFSQL data file, view or query. |
Format | ..Format is used to configure the format of data in a data file. |
GenerationNumber | ..GenerationNumber is used to find out the generation number of the physical file associated with the specified logical file. |
GUIDAnalysis | ..GUIDAnalysis returns the GUID of the analysis that was used to create 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. |
InfoThumbnailGeneration | ..InfoThumbnailGeneration is used to find out whether the thumbnails of an item have been successfully generated. |
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 | ..KeyExpression is used to configure the different components of a composite key. |
KeySize | ..KeySize is used to configure the characteristics of a Text Memo key item. |
KeyType | ..KeyType is used to configure 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 | ..LogBackupDirectory is used to manage the backup directory of the log files. |
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 or not. |
LogMethod | ..LogMethod is used 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 | ..MaxLinkedCardinality is used to find out and modify the maximum cardinality of the linked item in the link. |
MaxSourceCardinality | ..MaxSourceCardinality is used to find out and modify the maximum cardinality of the source item in the link. |
MaxThumbnailHeight | ..MaxThumbnailHeight is used to find out and modify the maximum height of an item thumbnail. |
MaxThumbnailWidth | ..MaxThumbnailWidth is used to find out and modify the maximum width of an item thumbnail. |
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 | ..MinAutoID is used to find out the minimum automatic identifier on a replicated file. |
MinimumLength | ..MinimumLength is used to configure the minimum length of the words to index. |
MinLinkedCardinality | ..MinLinkedCardinality is used to find out and modify the minimum cardinality of the linked item in the link. |
MinSourceCardinality | ..MinSourceCardinality is used to find out and modify the minimum cardinality of the source item 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 | ..MmoCryptMethod is used to configure the encryption mode of memo file (.MMO extension) associated with the data file. |
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 | ..ModificationRule is used to configure the modification rule of the records (integrity management) that will be applied to the data file 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 | ..NbKeyItem returns the total number of key items (including composite keys) found in a record of:- a file described in the data model editor,
- a file described by programming,
- an HFSQL view,
- a query.
|
NbMemoItem | ..NbMemoItem returns the total number of memo items found in a 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 | ..NdxCryptMethod is used to configure the encryption mode of index file (.NDX extension) associated with the data file. |
NewRecord | ..NewRecord is used to find out whether the record is a new record or whether it comes from 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 | ..NullSupported is used to manage the NULL value in HFSQL data files. |
Numerical | ..Numerical is used to find out whether an item is a numeric item. |
OperationLogDirectory | ..OperationLogDirectory is used to manage the directory of the log operations file associated with a log data file. |
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 | ..PhysicalName is used 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 | ..RecordSize is used to find out and modify the size (in bytes) of a record found in:- a file described in the data model editor,
- a file described by programming,
- an HFSQL view,
- a query.
|
RepeatableReadSupported | ..RepeatableReadSupported is used 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 | ..Replication is used 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 | ..ReplicationDirectory is used to manage the directory of replica (".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 | ..Secure is used to configure the security level for file encryption. |
Server | ..Server is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...). |
Versions 11 and laterSize New in version 11Size Size | ..Size is used to find out and modify the size of an element. |
SortType | ..SortType is used 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, ..Source is used to find out the source of series: Table column, list of values, ...
- a connection: in this case, ..Source is used to find out and define the source of a connection (HFSQL Client/Server, OLE DB, etc.).
|
SourceFile | ..SourceFile is used to configure the characteristics of a link. |
SourceKey | ..SourceKey is used to configure the characteristics of a link. |
SQLCode | ..SQLCode is used to find out the SQL code of a query created with the query editor (".WDR" file). |
Stemming | ..Stemming is used to enable the stemming and to define the language used to perform a stemming in a full-text index defined by programming. |
StopWord | ..StopWord is used to define the stop words in a full-text index defined by programming. |
Subscript | ..Subscript is used to find out the physical subscript (physical order) of the item in the record. |
Synonym | ..Synonym is used to define the synonym in the 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 | ..TextItemCompleted is used to configure the management of text items in a HFSQL file. |
Thumbnail | ..Thumbnail is used 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 | ..TimestampType is used to:- 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 | ..TransactionFile is used to find out whether a data file is a transaction file 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 | ..Unalterable is used to configure the unalterability of a data file: the data file cannot be modified; only the additions will be possible. |
Versions 10 and laterUser New in version 10User User | ..User is used to manage the user of a 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 | ..Year is used to: |