HFSQL properties

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Font management properties

HFSQL properties

Properties associated with reports and controls

Properties associated with windows, pages and controls

Time and date management properties

Various properties

HFSQL properties

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 through programming.


Versions 09 and later Abbreviation New in version 09 Abbreviation Abbreviation	The Abbreviation property is used to get 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 AccentSensitive New in version 09 AccentSensitive AccentSensitive	The AccentSensitive property is used to determine if accented characters are taken into account in the different searches performed on the item (with HReadSeek, HReadSeekFirst and HReadSeekLast, for example).
Versions 10 and later Access New in version 10 Access Access	The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 23 and later ActiveDirectory New in version 23 ActiveDirectory ActiveDirectory	The ActiveDirectory property allows you to connect to an HFSQL server with authentication through Active Directory.
Versions 09 and later Binary New in version 09 Binary Binary	The Binary property is used to determine if an item is binary.
Versions 09 and later BrowsedFile New in version 09 BrowsedFile BrowsedFile	The BrowsedFile property is used to get and change the data source used to display records in controls based on a data file.
Versions 10 and later CacheSize New in version 10 CacheSize CacheSize	The CacheSize property is used to: Get the maximum number of records that can be stored in the cache of the Native MySQL Connector. Change the maximum number of records that can be stored in the cache of the Native MySQL Connector.
Versions 21 and later CalculatedDefaultValue New in version 21 CalculatedDefaultValue 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 through programming. Define the SQL expression that returns the default value of an item (item described through programming only).
Versions 21 and later CalculatedItemExpression New in version 21 CalculatedItemExpression CalculatedItemExpression	The CalculatedItemExpression property 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 through programming. Define the SQL expression returning the value of a calculated item (when describing the item through programming).
Versions 09 and later Caption New in version 09 Caption 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.
Versions 09 and later CaseSensitive New in version 09 CaseSensitive CaseSensitive	The CaseSensitive property is used to determine if the different searches performed on the item distinguish between uppercase and lowercase characters (with HReadSeek, HReadSeekFirst and HReadSeekLast, for example).
Versions 09 and later Charset New in version 09 Charset 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.
Versions 09 and later Component New in version 09 Component Component	The Component property configures the different components of a composite key.
Versions 09 and later CompositeKey New in version 09 CompositeKey CompositeKey	The CompositeKey property is used to determine if an item is a composite key.
Versions 14 and later Compression New in version 14 Compression Compression	The Compression property is used to manage data compression during a connection (HFSQL Client/Server, etc.)
Versions 09 and later Connection New in version 09 Connection Connection	The Connection property 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	The Encryption property allows you to manage the type of encryption used between Client computers and an HFSQL server.
Versions 09 and later CtAccess New in version 09 CtAccess CtAccess	The CtAccess property is used to set the type of access to the data file when connecting to a specific table via OLE DB.
Versions 09 and later CtCacheSize New in version 09 CtCacheSize CtCacheSize	The CtCacheSize property is used to determine and change the maximum number of records that can be stored in the cache of the Native MySQL Connector.
Versions 09 and later CtCursorOptions New in version 09 CtCursorOptions CtCursorOptions	The CtCursorOptions property is used to get the type of cursor used when connecting to an external database.
Versions 09 and later CtDatabase New in version 09 CtDatabase CtDatabase	The CtDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB.
Versions 09 and later CtDescribedAccess New in version 09 CtDescribedAccess CtDescribedAccess	The CtDescribedAccess property is used to set the type of access to the data file when connecting to a specific table via OLE DB.
Versions 09 and later CtDescribedCaption New in version 09 CtDescribedCaption CtDescribedCaption	The CtDescribedCaption property is used to get and set the caption of the connection to the OLE DB data source.
Versions 09 and later CtDescribedDatabase New in version 09 CtDescribedDatabase CtDescribedDatabase	The CtDescribedDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB.
Versions 09 and later CtDescribedOLEDBProvider New in version 09 CtDescribedOLEDBProvider CtDescribedOLEDBProvider	The CtDescribedOLEDBProvider property is used to get and set the name of the OLE DB provider (also called OLE DB server).
Versions 09 and later CtDescribedPassword New in version 09 CtDescribedPassword CtDescribedPassword	The CtDescribedPassword property allows you to set the password used to open the data file in an OLE DB connection (file defined in the code only).
Versions 09 and later CtDescribedUserName New in version 09 CtDescribedUserName CtDescribedUserName	The CtDescribedUserName property is used to set the username that will be used when connecting to a specific table via OLE DB.
Versions 09 and later CtExtendedInfo New in version 09 CtExtendedInfo CtExtendedInfo	The CtExtendedInfo property is used to get the additional information inserted into database connection string.
Versions 09 and later CtInitialCatalog New in version 09 CtInitialCatalog CtInitialCatalog	The CtInitialCatalog property is used to get the default database defined for the access.
Versions 09 and later CtOLEDBProvider New in version 09 CtOLEDBProvider CtOLEDBProvider	The CtOLEDBProvider property is used to get and set the name of the OLE DB provider (also called OLE DB server).
Versions 09 and later CtUserName New in version 09 CtUserName CtUserName	The CtUserName property is used to set the username that will be used when connecting to a specific table via OLE DB.
Versions 10 and later CursorOptions New in version 10 CursorOptions CursorOptions	The CursorOptions property is used to manage the type of cursor used for a connection (Native Connectors, OLE DB, etc.).
Versions 10 and later Database New in version 10 Database Database	The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 09 and later Date New in version 09 Date Date	The Date property 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	The Day property is used to: Get the day from a Date or DateTime variable, or get the number of days from a Duration variable. Change the day of a Date or DateTime variable, or change the number of days of a Duration variable. Get 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	The DecimalPart property is used to configure Numeric items.
Versions 09 and later DefaultValue New in version 09 DefaultValue DefaultValue	The DefaultValue property is used to: Find out the default value of an item. This item was defined in the data model editor or through programming. Define the default value of an item (when describing the item through programming).
Versions 09 and later DeletionRule New in version 09 DeletionRule DeletionRule	The DeletionRule property is used to configure the deletion rule (integrity management) to be applied to the data file described through programming.
Versions 09 and later DescribedDirectory New in version 09 DescribedDirectory DescribedDirectory	The DescribedDirectory property is used to manage the physical directory of HFSQL files.
Versions 09 and later DescribedName New in version 09 DescribedName DescribedName	The DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias).
Versions 09 and later DescribedPhysicalName New in version 09 DescribedPhysicalName DescribedPhysicalName	The DescribedPhysicalName property is used to manage the physical name of HFSQL data files.
Versions 09 and later Directory New in version 09 Directory Directory	The Directory property is used to manage the physical directory of HFSQL files.
Versions 11 and later ExecutionCompleted New in version 11 ExecutionCompleted ExecutionCompleted	The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.
Versions 09 and later ExtendedInfo New in version 09 ExtendedInfo ExtendedInfo	The ExtendedInfo property 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	The Extension property is used to: get the extension of a file defined in the data model editor or through programming. define the extension of a file (when the file is described through programming only).
Versions 09 and later FicCryptMethod New in version 09 FicCryptMethod FicCryptMethod	The FicCryptMethod property is used to set the encryption method of a data file.
Versions 17 and later Filter New in version 17 Filter 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.
Versions 09 and later FilterCondition New in version 09 FilterCondition FilterCondition	The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query.
Versions 09 and later FilteredItem New in version 09 FilteredItem FilteredItem	The FilteredItem property is used to identify the item that has a filter implemented by HFilter.
Versions 09 and later FilterWithBounds New in version 09 FilterWithBounds FilterWithBounds	The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query.
Versions 09 and later Format New in version 09 Format Format	The Format property is used to define the data format of a data file.
Versions 26 and later GDPR New in version 26 GDPR 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).
Versions 09 and later GenerationNumber New in version 09 GenerationNumber GenerationNumber	The GenerationNumber property is used to get the generation number of the physical data file associated with the logical data file.
Versions 09 and later GUIDAnalysis New in version 09 GUIDAnalysis GUIDAnalysis	The GUIDAnalysis property 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	The GUIDFile property returns 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	The Hour property is used to: Get the time from a variable of type Time or DateTime, or the number of hours from a variable of type Duration. Change the time in a variable of type Time or DateTime, or the number of hours in a variable of type Duration. 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	The HugeFile property is used to configure the maximum size of a data file.
Versions 09 and later Index New in version 09 Index Index	The Index property indicates the physical index (physical order) of an item in a record.
Versions 10 and later InfoThumbnailGeneration New in version 10 InfoThumbnailGeneration InfoThumbnailGeneration	The InfoThumbnailGeneration property is used to determine if the thumbnails of an item have been generated successfully.
Versions 09 and later InitialFile New in version 09 InitialFile InitialFile	The InitialFile property is used to get the original name of the data file associated to an item 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	The IntegerPart property is used to configure Numeric items.
Versions 14 and later Items New in version 14 Items Items	The Items property is used to configure the different items of a full-text index.
Versions 09 and later KeyExpression New in version 09 KeyExpression KeyExpression	The KeyExpression property is used to set the different components of a composite key.
Versions 14 and later KeySize New in version 14 KeySize KeySize	The KeySize property is used to set the characteristics of a text memo key item.
Versions 09 and later KeyType New in version 09 KeyType KeyType	The KeyType property is used to set the characteristics of a key item.
Versions 12 and later Language New in version 12 Language Language	The Language property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item).
Versions 14 and later LanguageDescribed New in version 14 LanguageDescribed LanguageDescribed	The LanguageDescribed property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item).
Versions 09 and later LinkedFile New in version 09 LinkedFile LinkedFile	The LinkedFile property is used to set the characteristics of a link.
Versions 09 and later LinkedKey New in version 09 LinkedKey LinkedKey	The LinkedKey property is used to set the characteristics of a link
Versions 10 and later LogBackupDirectory New in version 10 LogBackupDirectory LogBackupDirectory	The LogBackupDirectory property is used to manage the backup directory of log files.
Versions 09 and later LogDirectory New in version 09 LogDirectory LogDirectory	The LogDirectory property 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	The LogFile property is used to determine if a data file is a log file.
Versions 09 and later LogMethod New in version 09 LogMethod LogMethod	The LogMethod property is used to: find out the log mode used for a data file (file defined in the data model editor or through programming). define the log mode used for a data file (when the file is described through programming).
Versions 14 and later ManageHTML New in version 14 ManageHTML ManageHTML	ManageHTML is used to configure the management mode of the HTML format 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 the RTF format in a full-text index.
Versions 09 and later MaxAutoID New in version 09 MaxAutoID MaxAutoID	The MaxAutoID property is used to get the maximum automatic identifier of a replicated data file.
Versions 09 and later MaxLinkedCardinality New in version 09 MaxLinkedCardinality MaxLinkedCardinality	The MaxLinkedCardinality property is used to get and modify the maximum cardinality of the related item in the link.
Versions 09 and later MaxSourceCardinality New in version 09 MaxSourceCardinality MaxSourceCardinality	The MaxSourceCardinality property is used to get and modify the maximum cardinality of the source item in the link.
Versions 10 and later MaxThumbnailHeight New in version 10 MaxThumbnailHeight MaxThumbnailHeight	The MaxThumbnailHeight property is used to get and change the maximum height of a thumbnail of an Image item (binary memo).
Versions 10 and later MaxThumbnailWidth New in version 10 MaxThumbnailWidth MaxThumbnailWidth	The MaxThumbnailWidth property is used to get or change the maximum width of a thumbnail of an Image item (binary memo).
Versions 09 and later MaxValue New in version 09 MaxValue MaxValue	The MaxValue property 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 27 and later mdpsAge New in version 27 mdpsAge mdpsAge	Propriété pour les rubriques de type mot de passe sécurise
Versions 27 and later mdpsDérivation New in version 27 mdpsDérivation mdpsDérivation	proprité de l'algorithme de dérivation d'un mot de passe sécurisé
Versions 27 and later mdpsTaille New in version 27 mdpsTaille mdpsTaille	propriété de la taille du mot de passe sécurisé
Versions 09 and later Memo New in version 09 Memo Memo	The Memo property is used to determine if an item is of type memo.
Versions 09 and later Millisecond New in version 09 Millisecond Millisecond	The Millisecond property 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	The MinAutoID property is used to get the minimum automatic identifier of a replicated data file.
Versions 14 and later MinimumLength New in version 14 MinimumLength MinimumLength	The MinimumLength property is used to configure the minimum length of the words to be indexed.
Versions 09 and later MinLinkedCardinality New in version 09 MinLinkedCardinality MinLinkedCardinality	The MinLinkedCardinality property is used to get and modify the minimum cardinality of the related item in the link.
Versions 09 and later MinSourceCardinality New in version 09 MinSourceCardinality MinSourceCardinality	The MinSourceCardinality property is used to get and modify the minimum cardinality of the source item in the link.
Versions 09 and later Minute New in version 09 Minute Minute	The Minute property is used to: Retrieve the minutes from a Time or DateTime variable, or the number of minutes from a Duration. Change 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	The MinValue property 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	The MmoCryptMethod property is used to set the encryption method of the memo file (.MMO) associated with the data file.
Versions 09 and later MmoPackMethod New in version 09 MmoPackMethod MmoPackMethod	The MmoPackMethod property is used to set the compression mode of the MMO file (containing text and binary memos) associated with the data file.
Versions 09 and later ModificationRule New in version 09 ModificationRule 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 later Month New in version 09 Month Month	The Month property 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	The Name property is used to get: 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	The Name55 property is used to manipulate the logical name of a Hyper File 5.5 data file that has not been migrated and is located in a WINDEV 19 analysis.
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	The NbComponent property is used to get the number of elements in a composite key.
Versions 10 and later NbDescribedThumbnail New in version 10 NbDescribedThumbnail NbDescribedThumbnail	The NbDescribedThumbnail property is used to get the number of thumbnails expected for an item.
Versions 09 and later NbItem New in version 09 NbItem NbItem	The NbItem property is used to get the total number of items (including composite keys) in a record of: a file described in the data model editor, a file described through programming, an HFSQL view, a query.
Versions 09 and later NbKeyItem New in version 09 NbKeyItem NbKeyItem	The NbKeyItem property is used to get the total number of key items (including composite keys) in a record of: a file described in the data model editor, a file described through programming, an HFSQL view, a query.
Versions 09 and later NbMemoItem New in version 09 NbMemoItem NbMemoItem	The NbMemoItem property is used to get the total number of memo items in a record of: a file described in the data model editor, a file described through programming, an HFSQL view, a query.
Versions 10 and later NbThumbnail New in version 10 NbThumbnail NbThumbnail	The NbThumbnail property is used to get the number of thumbnails generated for an item.
Versions 09 and later NdxCryptMethod New in version 09 NdxCryptMethod NdxCryptMethod	The NdxCryptMethod property is used to configure the encryption method for the index (.NDX) file associated with the data file.
Versions 12 and later NewRecord New in version 12 NewRecord NewRecord	The NewRecord property is used to determine if the record is a new record or if it comes from the data file.
Versions 09 and later Null New in version 09 Null Null	The Null property 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 through programming.
Versions 09 and later NullSupported New in version 09 NullSupported NullSupported	The NullSupported property 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	The OperationLogDirectory property is used to manage the directory of the operation log file associated with a data file.
Versions 09 and later Password New in version 09 Password Password	The Password property 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	The PasswordProtected property is used to determine if a datafile is password-protected.
Versions 21 and later PersistedCalculatedItem New in version 21 PersistedCalculatedItem PersistedCalculatedItem	The PersistedCalculatedItem property 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 through programming. Define whether the value of a calculated item is stored in the data file (when describing the item through programming).
Versions 09 and later PhysicalName New in version 09 PhysicalName PhysicalName	The PhysicalName property is used to manage the physical name of HFSQL data files.
Versions 10 and later Provider New in version 10 Provider Provider	The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 09 and later PunctuationSensitive New in version 09 PunctuationSensitive PunctuationSensitive	The PunctuationSensitive property is used to determine if punctuation characters (comma, period, etc.) are taken into account in the different searches performed on the item (with HReadSeek, HReadSeekFirst and HReadSeekLast, for example).
Versions 09 and later RecordSize New in version 09 RecordSize RecordSize	The RecordSize property is used to get the size (in bytes) of a record in: a file described in the data model editor, a file described through programming, an HFSQL view, a query.
Versions 19 and later RepeatableReadSupported New in version 19 RepeatableReadSupported RepeatableReadSupported	The RepeatableReadSupported property is used to: Find out whether the data file (file defined in the data model editor or through 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 through programming only).
Versions 09 and later Replication New in version 09 Replication Replication	The Replication property is used to: find out the replication mode used for a data file (file defined in the data model editor or through programming). specify the replication mode used for a data file (when the file is described through programming).
Versions 09 and later ReplicationDirectory New in version 09 ReplicationDirectory ReplicationDirectory	The ReplicationDirectory property is used to manage the directory of replication files (".RPL" or ".RPM").
Versions 09 and later Second New in version 09 Second Second	The Second property 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	The Secure property is used to configure the security level of data file encryption.
Versions 10 and later Server New in version 10 Server Server	The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 11 and later Size New in version 11 Size Size	The Size property is used to determine and change the size of an element.
Versions 09 and later SortType New in version 09 SortType SortType	The SortType property 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 through programming. Define the sort direction for an item or for a component of a composite key (when describing the item through programming).
Versions 10 and later Source New in version 10 Source Source	The Source property can be used on: a Chart control: in this case, the Source property is used to get the source of the series: Table column, list of values, ... a connection: in this case, the Source property is used to get or set the source of a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 09 and later SourceFile New in version 09 SourceFile SourceFile	The SourceFile property is used to set the characteristics of a link.
Versions 09 and later SourceKey New in version 09 SourceKey SourceKey	The SourceKey property is used to set the characteristics of a link.
Versions 27 and later spHash New in version 27 spHash spHash	Propriété pour les rubriques de type mot de passe sécurise
Versions 27 and later spHash New in version 27 spHash spHash	algorithme de hash du mot de passe sécurisé
Versions 27 and later spIterationCount New in version 27 spIterationCount spIterationCount	mot de passe sécurisé : Nombre d'itérations de l'algorithme de l'algo de dérivation
Versions 12 and later SQLCode New in version 12 SQLCode SQLCode	The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file).
Versions 20 and later Stemming New in version 20 Stemming Stemming	The Stemming property is used to enable stemming and to define the language used for stemming in a full-text index defined through programming.
Versions 20 and later StopWord New in version 20 StopWord StopWord	The StopWord property is used to define stopwords in a full-text index defined through programming.
Versions 20 and later Synonym New in version 20 Synonym Synonym	The Synonym property is used to define synonyms in a programmatically defined full-text index.
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	The TextItemCompleted property is used to manage text items in an HFSQL data file.
Versions 10 and later Thumbnail New in version 10 Thumbnail Thumbnail	The Thumbnail property is used to: get the value of an item thumbnail. This item was defined in the data model editor or through programming. get and change the image associated with a Thumbnail control.
Versions 09 and later Time New in version 09 Time Time	The Time property enables you 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	The TimestampType property is used to: Find out the type of timestamp for an item. This item was defined in the data model editor or through programming. Define the type of timestamp for a Date, Time or DateTime item (when describing the item through programming).
Versions 21 and later TimestampUTC New in version 21 TimestampUTC TimestampUTC	The TimestampUTC property is used to: Find out whether a timestamp item will use UTC time or local time. This item was defined in the data model editor or through programming. Define whether a timestamp item will use UTC time or local time (when describing the item through programming).
Versions 09 and later TransactionFile New in version 09 TransactionFile TransactionFile	The TransactionFile property is used to determine if a data file is a transaction file.
Versions 09 and later Type New in version 09 Type Type	The Type property is used to get: the type of element described through 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	The TypeDescription property is used to: Find out the type used by an Enumeration or Combination item. This item was defined in the data model editor or through programming. Define the type used by an Enumeration or Combination item (when describing the item through programming).
Versions 23 and later Unalterable New in version 23 Unalterable Unalterable	The Unalterable property is used to configure the unalterability of a data file: the data file cannot be modified; only additions can be made.
Versions 10 and later User New in version 10 User User	The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.).
Versions 10 and later VisibleEndUser New in version 10 VisibleEndUser VisibleEndUser	The VisibleEndUser property 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 through programming. Define whether an item must be visible or not to the end users (when describing the item through 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	The WDD55Password property is used to specify the password of the 5.5 analysis that contains a Hyper File 5.5 data file used in an HFSQL Classic analysis.
Versions 09 and later Year New in version 09 Year Year	The Year property 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.