HFSQL properties

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HFSQL properties

Available only with these kinds of connection

These properties can be used on the HFSQL objects described in the data model editor, in the query editor or by programming.


Versions 09 and later Abbreviation New in version 09 Abbreviation 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.
Versions 09 and later AccentuationSensitive New in version 09 AccentuationSensitive 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).
Versions 10 and later Access New in version 10 Access Access	..Access is used to manage the type of access for a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 23 and later ActiveDirectory New in version 23 ActiveDirectory ActiveDirectory	..ActiveDirectory is used to manage a connection with authentication to a HFSQL server via Active Directory.
Versions 09 and later Binary New in version 09 Binary Binary	..Binary is used to find out whether an item is a binary item or not.
Versions 09 and later BrowsedFile New in version 09 BrowsedFile BrowsedFile	..BrowsedFile is used to find out and modify the data source used to display the records in the controls based on a data file.
Versions 10 and later CacheSize New in version 10 CacheSize 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.
Versions 21 and later CalculatedDefaultItem New in version 21 CalculatedDefaultItem 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).
Versions 21 and later CalculatedItemExpression New in version 21 CalculatedItemExpression 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).
Versions 09 and later Caption New in version 09 Caption 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 control or in a link control. Modify the text displayed in a Static control or in a 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.
Versions 09 and later CaseSensitive New in version 09 CaseSensitive 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).
Versions 09 and later Charset New in version 09 Charset 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 a HFSQL file.
Versions 09 and later Component New in version 09 Component Component	..Component is used to configure the different components of a composite key.
Versions 09 and later CompositeKey New in version 09 CompositeKey CompositeKey	..CompositeKey is used to find out whether an item is a composite key.
Versions 14 and later Compression New in version 14 Compression Compression	..Compression is used to manage the compression of data during a connection (HFSQL Client/Server, etc.).
Versions 09 and later Connection New in version 09 Connection Connection	..Connection is used to find out and modify the connection currently associated with a data file.
Versions 10 and later CryptMethod New in version 10 CryptMethod CryptMethod	..CryptMethod is used to manage the type of encryption for the communication established between the client computers and the HFSQL server.
Versions 09 and later CtAccess New in version 09 CtAccess CtAccess	..CtAccess is used to manage the type of access to the data file during the OLE DB connection to a specific table.
Versions 09 and later CtCacheSize New in version 09 CtCacheSize 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.
Versions 09 and later CtCursorOptions New in version 09 CtCursorOptions CtCursorOptions	..CtCursorOptions is used identify the type of cursor that will be used during a connection to an external database.
Versions 09 and later CtDatabase New in version 09 CtDatabase CtDatabase	..CtDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table.
Versions 09 and later CtDescribedAccess New in version 09 CtDescribedAccess CtDescribedAccess	..CtDescribedAccess is used to manage the type of access to the data file during the OLE DB connection to a specific table.
Versions 09 and later CtDescribedCaption New in version 09 CtDescribedCaption CtDescribedCaption	..CtDescribedCaption is used to manage the caption of the connection to the OLE DB data source.
Versions 09 and later CtDescribedDatabase New in version 09 CtDescribedDatabase CtDescribedDatabase	..CtDescribedDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table.
Versions 09 and later CtDescribedOLEDBProvider New in version 09 CtDescribedOLEDBProvider CtDescribedOLEDBProvider	..CtDescribedOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server).
Versions 09 and later CtDescribedPassword New in version 09 CtDescribedPassword 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).
Versions 09 and later CtDescribedUserName New in version 09 CtDescribedUserName CtDescribedUserName	..CtDescribedUserName is used to configure the name of the user that will be used during the OLE DB connection to a specific table.
Versions 09 and later CtExtendedInfo New in version 09 CtExtendedInfo CtExtendedInfo	..CtExtendedInfo is used to find out the additional information inserted into the connection string to the database.
Versions 09 and later CtInitialCatalog New in version 09 CtInitialCatalog CtInitialCatalog	..CtInitialCatalog is used to identify the default database defined for the access.
Versions 09 and later CtOLEDBProvider New in version 09 CtOLEDBProvider CtOLEDBProvider	..CtOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server).
Versions 09 and later CtUserName New in version 09 CtUserName CtUserName	..CtUserName is used to configure the user name that will be used during the OLE DB connection to a specific table.
Versions 10 and later CursorOptions New in version 10 CursorOptions CursorOptions	..CursorOptions is used to manage the type of cursor used during a connection (Native Accesses, OLE DB, ...).
Versions 10 and later Database New in version 10 Database Database	..Database is used to manage the database associated with a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 09 and later Date New in version 09 Date 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 later Day New in version 09 Day 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)
Versions 12 and later DecimalPart New in version 12 DecimalPart DecimalPart	..DecimalPart is used to configure the Numeric items.
Versions 09 and later DefaultValue New in version 09 DefaultValue 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).
Versions 09 and later DeletionRule New in version 09 DeletionRule DeletionRule	..DeletionRule is used to configure the deletion rule (integrity management) of records that will be applied to the file described by programming.
Versions 09 and later DescribedDirectory New in version 09 DescribedDirectory DescribedDirectory	..DescribedDirectory is used to manage the physical directory of HFSQL files.
Versions 09 and later DescribedName New in version 09 DescribedName DescribedName	..DescribedName is used to manage the logical name of HFSQL files.
Versions 09 and later DescribedPhysicalName New in version 09 DescribedPhysicalName DescribedPhysicalName	..DescribedPhysicalName is used to manage the physical name of HFSQL files.
Versions 09 and later Directory New in version 09 Directory Directory	..Directory is used to manage the physical directory of HFSQL files.
Versions 11 and later ExecutionCompleted New in version 11 ExecutionCompleted ExecutionCompleted	..ExecutionCompleted is used to find out whether the execution of a query or view (in HFSQL Classic or Client/Server format) is completed.
Versions 09 and later ExtendedInfo New in version 09 ExtendedInfo 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.
Versions 09 and later Extension New in version 09 Extension 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).
Versions 09 and later FicCryptMethod New in version 09 FicCryptMethod FicCryptMethod	..FicCryptMethod is used to configure the encryption mode of the data file.
Versions 09 and later Filter New in version 09 Filter Filter	..Filter is used to find out and modify the filter used to display records in: the browsing Table controls, the browsing TreeView Table controls, the browsing List Box controls, the browsing Combo Box controls, the browsing Looper controls.
Versions 09 and later FilterCondition New in version 09 FilterCondition FilterCondition	..FilterCondition is used to find out the selection condition implemented by HFilter on a data file, a HFSQL view or a query.
Versions 09 and later FilteredItem New in version 09 FilteredItem FilteredItem	..FilteredItem is used to find out the item on which a filter was implemented by HFilter.
Versions 09 and later FilterWithBounds New in version 09 FilterWithBounds 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.
Versions 09 and later Format New in version 09 Format Format	..Format is used to configure the format of data in a data file.
Versions 09 and later GenerationNumber New in version 09 GenerationNumber GenerationNumber	..GenerationNumber is used to find out the generation number of the physical file associated with the specified logical file.
Versions 09 and later GUIDAnalysis New in version 09 GUIDAnalysis GUIDAnalysis	..GUIDAnalysis returns the GUID of the analysis that was used to create the data file.
Versions 09 and later GUIDFile New in version 09 GUIDFile 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 later Hour New in version 09 Hour 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.
Versions 09 and later HugeFile New in version 09 HugeFile HugeFile	..HugeFile is used to configure the maximum size of a data file.
Versions 10 and later InfoThumbnailGeneration New in version 10 InfoThumbnailGeneration InfoThumbnailGeneration	..InfoThumbnailGeneration is used to find out whether the thumbnails of an item have been successfully generated.
Versions 09 and later InitialFile New in version 09 InitialFile InitialFile	..InitialFile is used to find out the initial name of the data file associated with an item found in a query.
Versions 09 and later InitialItem New in version 09 InitialItem 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.
Versions 12 and later IntegerPart New in version 12 IntegerPart IntegerPart	..IntegerPart is used to configure the Numeric items.
Versions 14 and later Items New in version 14 Items Items	..Items is used to configure the different items included in a full-text index.
Versions 09 and later KeyExpression New in version 09 KeyExpression KeyExpression	..KeyExpression is used to configure the different components of a composite key.
Versions 14 and later KeySize New in version 14 KeySize KeySize	..KeySize is used to configure the characteristics of a Text Memo key item.
Versions 09 and later KeyType New in version 09 KeyType KeyType	..KeyType is used to configure the characteristics of a key item.
Versions 12 and later Language New in version 12 Language 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).
Versions 14 and later LanguageDescribed New in version 14 LanguageDescribed 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).
Versions 09 and later LinkedFile New in version 09 LinkedFile LinkedFile	..LinkedFile is used to configure the characteristics of a link.
Versions 09 and later LinkedKey New in version 09 LinkedKey LinkedKey	..LinkedKey is used to configure the characteristics of a link.
Versions 10 and later LogBackupDirectory New in version 10 LogBackupDirectory LogBackupDirectory	..LogBackupDirectory is used to manage the backup directory of the log files.
Versions 09 and later LogDirectory New in version 09 LogDirectory LogDirectory	..LogDirectory is used to manage the directory of the log file described in the analysis.
Versions 09 and later LogFile New in version 09 LogFile LogFile	..LogFile is used to find out whether a data file is a log file or not.
Versions 09 and later LogMethod New in version 09 LogMethod 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).
Versions 14 and later ManageHTML New in version 14 ManageHTML ManageHTML	..ManageHTML is used to configure the HTML management mode in a full-text index.
Versions 14 and later ManageRTF New in version 14 ManageRTF ManageRTF	..ManageRTF is used to configure the management mode of RTF in a full-text index.
Versions 09 and later MaxAutoID New in version 09 MaxAutoID MaxAutoID	..MaxAutoID is used to find out the maximum automatic identifier on a replicated file.
Versions 09 and later MaxLinkedCardinality New in version 09 MaxLinkedCardinality MaxLinkedCardinality	..MaxLinkedCardinality is used to find out and modify the maximum cardinality of the linked item in the link.
Versions 09 and later MaxSourceCardinality New in version 09 MaxSourceCardinality MaxSourceCardinality	..MaxSourceCardinality is used to find out and modify the maximum cardinality of the source item in the link.
Versions 10 and later MaxThumbnailHeight New in version 10 MaxThumbnailHeight MaxThumbnailHeight	..MaxThumbnailHeight is used to find out and modify the maximum height of an item thumbnail.
Versions 10 and later MaxThumbnailWidth New in version 10 MaxThumbnailWidth MaxThumbnailWidth	..MaxThumbnailWidth is used to find out and modify the maximum width of an item thumbnail.
Versions 09 and later MaxValue New in version 09 MaxValue 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 later Memo New in version 09 Memo Memo	..Memo is used to find out whether an item is a memo item.
Versions 09 and later Millisecond New in version 09 Millisecond 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)
Versions 09 and later MinAutoID New in version 09 MinAutoID MinAutoID	..MinAutoID is used to find out the minimum automatic identifier on a replicated file.
Versions 14 and later MinimumLength New in version 14 MinimumLength MinimumLength	..MinimumLength is used to configure the minimum length of the words to index.
Versions 09 and later MinLinkedCardinality New in version 09 MinLinkedCardinality MinLinkedCardinality	..MinLinkedCardinality is used to find out and modify the minimum cardinality of the linked item in the link.
Versions 09 and later MinSourceCardinality New in version 09 MinSourceCardinality MinSourceCardinality	..MinSourceCardinality is used to find out and modify the minimum cardinality of the source item in the link.
Versions 09 and later Minute New in version 09 Minute 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
Versions 09 and later MinValue New in version 09 MinValue 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.
Versions 09 and later MmoCryptMethod New in version 09 MmoCryptMethod MmoCryptMethod	..MmoCryptMethod is used to configure the encryption mode of memo file (.MMO extension) associated with the data file.
Versions 09 and later MmoPackMethod New in version 09 MmoPackMethod MmoPackMethod	..MmoPackMethod is used to configure the compression mode of the MMO file (containing the binary and text memos) associated with a data file.
Versions 09 and later ModificationRule New in version 09 ModificationRule ModificationRule	..ModificationRule is used to configure the modification rule of records (integrity management) that will be applied to the file described by programming.
Versions 09 and later Month New in version 09 Month 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 later Name New in version 09 Name 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.
Versions 09 and later Name55 New in version 09 Name55 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.
Versions 09 and later NbArrayElement New in version 09 NbArrayElement NbArrayElement	..NbArrayElement is used to configure the number of elements in an array item.
Versions 09 and later NbComponent New in version 09 NbComponent NbComponent	..NbComponent is used to find out the number of elements found in a composite key.
Versions 10 and later NbDescribedThumbnail New in version 10 NbDescribedThumbnail NbDescribedThumbnail	..NbDescribedThumbnail is used to find out the number of thumbnails described for an item.
Versions 09 and later NbItem New in version 09 NbItem 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, a HFSQL view, a query.
Versions 09 and later NbKeyItem New in version 09 NbKeyItem 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, a HFSQL view, a query.
Versions 09 and later NbMemoItem New in version 09 NbMemoItem 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, a HFSQL view, a query.
Versions 10 and later NbThumbnail New in version 10 NbThumbnail NbThumbnail	..NbThumbnail is used to find out the number of thumbnails generated for an item.
Versions 09 and later NdxCryptMethod New in version 09 NdxCryptMethod NdxCryptMethod	..NdxCryptMethod is used to configure the encryption mode of index file (.NDX extension) associated with the data file.
Versions 12 and later NewRecord New in version 12 NewRecord 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 later Null New in version 09 Null 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.
Versions 09 and later NullSupported New in version 09 NullSupported NullSupported	..NullSupported is used to manage the NULL value in HFSQL data files.
Versions 09 and later Numerical New in version 09 Numerical Numerical	..Numerical is used to find out whether an item is a numeric item.
Versions 09 and later OperationLogDirectory New in version 09 OperationLogDirectory OperationLogDirectory	..OperationLogDirectory is used to manage the directory of the log operations file associated with a log data file.
Versions 09 and later Password New in version 09 Password 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.
Versions 09 and later PasswordProtected New in version 09 PasswordProtected PasswordProtected	..PasswordProtected is used to find out whether a data file is password protected.
Versions 21 and later PersistedCalculatedItem New in version 21 PersistedCalculatedItem 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).
Versions 09 and later PhysicalName New in version 09 PhysicalName PhysicalName	..PhysicalName is used to manage the physical name of HFSQL files.
Versions 10 and later Provider New in version 10 Provider Provider	..Provider is used to manage the type of connection (HFSQL Client/Server, OLE DB, etc.).
Versions 09 and later PunctuationSensitive New in version 09 PunctuationSensitive 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).
Versions 09 and later RecordSize New in version 09 RecordSize 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, a HFSQL view, a query.
Versions 19 and later RepeatableReadSupported New in version 19 RepeatableReadSupported 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).
Versions 09 and later Replication New in version 09 Replication 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).
Versions 09 and later ReplicationDirectory New in version 09 ReplicationDirectory ReplicationDirectory	..ReplicationDirectory is used to manage the directory of replica (".RPL" or ".RPM" file).
Versions 09 and later Second New in version 09 Second 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)
Versions 09 and later Secure New in version 09 Secure Secure	..Secure is used to configure the security level for file encryption.
Versions 10 and later Server New in version 10 Server Server	..Server is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...).
Versions 11 and later Size New in version 11 Size Size	..Size is used to find out and modify the size of an element.
Versions 09 and later SortType New in version 09 SortType 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).
Versions 10 and later Source New in version 10 Source 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.).
Versions 09 and later SourceFile New in version 09 SourceFile SourceFile	..SourceFile is used to configure the characteristics of a link.
Versions 09 and later SourceKey New in version 09 SourceKey SourceKey	..SourceKey is used to configure the characteristics of a link.
Versions 12 and later SQLCode New in version 12 SQLCode SQLCode	..SQLCode is used to find out the SQL code of a query created with the query editor (".WDR" file).
Versions 20 and later Stemming New in version 20 Stemming 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.
Versions 20 and later StopWord New in version 20 StopWord StopWord	..StopWord is used to define the stop words in a full-text index defined by programming.
Versions 09 and later Subscript New in version 09 Subscript Subscript	..Subscript is used to find out the physical subscript (physical order) of the item in the record.
Versions 20 and later Synonym New in version 20 Synonym Synonym	..Synonym is used to define the synonym in the full-text index defined by programming.
Versions 09 and later Text New in version 09 Text Text	..Text is used to find out whether an item is a text item.
Versions 09 and later TextItemCompleted New in version 09 TextItemCompleted TextItemCompleted	..TextItemCompleted is used to configure the management of text items in a HFSQL file.
Versions 10 and later Thumbnail New in version 10 Thumbnail 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 later Time New in version 09 Time 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).
Versions 21 and later TimestampType New in version 21 TimestampType 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).
Versions 21 and later TimestampUTC New in version 21 TimestampUTC 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).
Versions 09 and later TransactionFile New in version 09 TransactionFile TransactionFile	..TransactionFile is used to find out whether a data file is a transaction file or not.
Versions 09 and later Type New in version 09 Type 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.
Versions 20 and later TypeDescription New in version 20 TypeDescription 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).
Versions 23 and later Unalterable New in version 23 Unalterable 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 later User New in version 10 User User	..User is used to manage the user of a connection (HFSQL Client/Server, OLE DB, ...).
Versions 10 and later VisibleEndUser New in version 10 VisibleEndUser 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 later WDD55 New in version 09 WDD55 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.
Versions 09 and later WDD55Password New in version 09 WDD55Password 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 later Year New in version 09 Year Year	..Year is used to: Retrieve the year from a Date or DateTime variable or item. Modify the year in a Date or DateTime variable or item.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.