PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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
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 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 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:
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment