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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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 Property Abbreviation gives the abbreviation of the data file. This abbreviation was defined in the data model editor when describing the data file. This property is read-only.
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
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 to manage an Connection with authentication to an HFSQL server by Active Directory.
Versions 09 and later
Binary
New in version 09
Binary
Binary
The Property Binary makes it possible to know if an Item is of binary type or not.
Versions 09 and later
BrowsedFile
New in version 09
BrowsedFile
BrowsedFile
The Property BrowseFile allows you to know and modify the HEX@ of data used to display records in a data file based fields.
Versions 10 and later
CacheSize
New in version 10
CacheSize
CacheSize
The Property SizeCache makes it possible to:
  • Find out the maximum number of records that can be stored in the cache of Native MySQL Access.
  • Modify the maximum number of records that can be stored in the cache of Native MySQL Access.
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 by programming.
  • Define the SQL expression that returns the default value of an item (item described by programming only).
Versions 21 and later
CalculatedItemExpression
New in version 21
CalculatedItemExpression
CalculatedItemExpression
The Property CalculatedRubricFormula allows to:
  • Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or by programming.
  • Define the SQL expression returning the value of a calculated item (when describing the item by programming).
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 or Link control.
  • Modify the text displayed in a Static or Link control.
In a window or in a page, ..Caption is used to:
  • Find out and modify the caption of a control in a window or in a page.
  • Find out and modify the caption of a menu option.
  • Find out and modify the title of a window or page.
  • Find out the content of a site map path.
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 an HFSQL data 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
The Property CompoundKey allows to know if an Item is a compound key.
Versions 14 and later
Compression
New in version 14
Compression
Compression
The Compression property is used to manage data compression during an Connection (HFSQL Client/Server, ...).
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
The Property Encryption allows to manage the type of encryption of the communication between the Client workstations and the HFSQL Server workstation.
Versions 09 and later
CtAccess
New in version 09
CtAccess
CtAccess
The CxAccess property is used to manage the type of access to the data file when Connection OLE DB 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
The CxBaseData property allows you to manage the OLE DB data source when Connection OLE DB to a specific table.
Versions 09 and later
CtDescribedAccess
New in version 09
CtDescribedAccess
CtDescribedAccess
The CxAccessDécrit property is used to manage the type of access to the data file during Connection OLE DB 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 enables you to define the password 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
The CxUserDescript property is used to set the user name used in the Connection OLE DB to a specific table.
Versions 09 and later
CtExtendedInfo
New in version 09
CtExtendedInfo
CtExtendedInfo
The CxInfosExtended property allows to know the additional information inserted in the string from Connection to the database.
Versions 09 and later
CtInitialCatalog
New in version 09
CtInitialCatalog
CtInitialCatalog
CtInitialCatalog is used to find out 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
The CxUser property is used to set the user name used in the Connection OLE DB 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, etc.).
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
The Property Default Value allows you to:
  • Find out the default value of an item. This item was defined in the data model editor or by programming.
  • Define the default value of an item (when describing the item by programming).
Versions 09 and later
DeletionRule
New in version 09
DeletionRule
DeletionRule
..DeletionRule is used to configure the deletion rule (integrity management) that will be applied to the data file described by programming.
Versions 09 and later
DescribedDirectory
New in version 09
DescribedDirectory
DescribedDirectory
The Property WrittenDirectory allows you 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
The Property Directory allows you 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 17 and later
Filter
New in version 17
Filter
Filter
The Property Filter makes it possible to know and modify the filter used for the display of 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 Property ConditionFiltre allows you to know the selection condition set up by the HFilter function on a data file, a HFSQL view or a query..
Versions 09 and later
FilteredItem
New in version 09
FilteredItem
FilteredItem
The Property Item Filtered makes it possible to know the Item on which a filter has been set by the HFilter function..
Versions 09 and later
FilterWithBounds
New in version 09
FilterWithBounds
FilterWithBounds
The Property FilterWithTerminals allows to know if terminals have been specified on the filter set up by the HFilter function on a data file, a HFSQL view or a query.
Versions 09 and later
Format
New in version 09
Format
Format
Format is used to configure the format of the data in the 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 Property GenerationNumber allows to know the generation number of the physical HEX@ associated to the specified logical HEX@.
Versions 09 and later
GUIDAnalysis
New in version 09
GUIDAnalysis
GUIDAnalysis
The Property GUIDAnalyse returns the GUID of the analysis that created 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 09 and later
Index
New in version 09
Index
Index
The Index indicates the physical index (physical order) of an item in a record.
Versions 10 and later
InfoThumbnailGeneration
New in version 10
InfoThumbnailGeneration
InfoThumbnailGeneration
InfoThumbnailGeneration is used to find out whether the thumbnails of an item were generated properly.
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
The Property FormulaKey allows you to set the different components of a compound key.
Versions 14 and later
KeySize
New in version 14
KeySize
KeySize
The Property KeySize allows you to set the characteristics of an Item key of the text memo type.
Versions 09 and later
KeyType
New in version 09
KeyType
KeyType
The Property TypeKey allows to set 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
The Property LogBackupDirectory allows to manage the log files backup directory.
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.
Versions 09 and later
LogMethod
New in version 09
LogMethod
LogMethod
The Property Logging allows you to:
  • find out the log mode used for a data file (file defined in the data model editor or by programming).
  • define the log mode used for a data file (when the file is described by programming).
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
The Property Linked CardinalityMax allows to know and modify the maximum cardinality of the Item linked in the Link.
Versions 09 and later
MaxSourceCardinality
New in version 09
MaxSourceCardinality
MaxSourceCardinality
The Property CardinalitySourceMax makes it possible to know and modify the maximum cardinality of the Item source 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
The Property WidthMaxVignette makes it possible to know or modify the maximum width of a vignette of an Item.
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
The IdAutoMin property allows to know the minimum automatic identifier on a replicated HEX@.
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
The Property Linked CardinalityMin allows to know and modify the minimum cardinality of the Item linked in the Link.
Versions 09 and later
MinSourceCardinality
New in version 09
MinSourceCardinality
MinSourceCardinality
The Property CardinalitySourceMin makes it possible to know and modify the minimum cardinality of the Item source 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
0
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
The Property RuleModification is used to set up the rule of modification (integrity management) of the records to be applied to the HEX@ of data 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,
  • an HFSQL view,
  • a query.
Versions 09 and later
NbKeyItem
New in version 09
NbKeyItem
NbKeyItem
The KeyNumber property gives the total number of key fields (including compound keys) present in an Record of:
  • a file described in the data model editor,
  • a file described by programming,
  • an HFSQL view,
  • a query.
Versions 09 and later
NbMemoItem
New in version 09
NbMemoItem
NbMemoItem
The NbRubriqueMémo property gives the total number of memo headings present in an Record of:
  • a file described in the data model editor,
  • a file described by programming,
  • an HFSQL view,
  • a query.
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
The Property EncryptionNdx allows you to set the encryption mode of the index HEX@ (extension .NDX) associated with the data HEX@.
Versions 12 and later
NewRecord
New in version 12
NewRecord
NewRecord
The NewRecord property allows to know if the Record is a new Record or comes from of 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
The Property NullSupported allows 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 Property LogOperationDirectory is used to maintain the directory of the log operation file associated to a data file logged.
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
The Property PhysicalName allows 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
The RecordSize property allows to obtain the Length( in bytes) of an Record of:
  • a file described in the data model editor,
  • a file described by programming,
  • an HFSQL view,
  • a query.
Versions 19 and later
RepeatableReadSupported
New in version 19
RepeatableReadSupported
RepeatableReadSupported
The Property RepeatableRead Supported allows to:
  • Find out whether the data file (file defined in the data model editor or by programming) can be used in HFSQL Client/Server in a transaction that includes a "Repeatable Read" isolation mode.
  • Allow the use of a transaction that includes a "Repeatable Read" isolation mode for a data file (when the file is described by programming only).
Versions 09 and later
Replication
New in version 09
Replication
Replication
The Property Replication allows to:
  • find out the replication mode used for a data file (file defined in the data model editor or by programming).
  • specify the replication mode used for a data file (when the file is described by programming).
Versions 09 and later
ReplicationDirectory
New in version 09
ReplicationDirectory
ReplicationDirectory
The Property ReplicationDirectory is used to manage the replication directory (HEX@ ".RPL" or ".RPM").
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
The Property Secured allows you to set the security level of file encryption.
Versions 10 and later
Server
New in version 10
Server
Server
The Server property is used to manage the data source of an Connection (HFSQL Client/Server, OLE DB, ...).
Versions 11 and later
Size
New in version 11
Size
Size
The Property Size allows to know and modify the size of an element.
Versions 09 and later
SortType
New in version 09
SortType
SortType
The Property TypeTri allows to:
  • Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or by programming.
  • Define the sort direction for an item or for a component of a composite key (when describing the item by programming).
Versions 10 and later
Source
New in version 10
Source
Source
Source can be used on:
  • a Chart control: in this case, the Property HEX@ allows to know the HEX@ of the series: Table column, list of values, ...
  • a connection: in this case, the Source property allows to know or define the source of an Connection (HFSQL Client/Server, OLE DB, ...).
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
The Property CodeSQL allows to know the SQL code of a query created with the query editor (HEX@ with ".WDR" extension).
Versions 20 and later
Stemming
New in version 20
Stemming
Stemming
The Property Racinization allows to activate the rootization and to define the language used to perform a rootization in a programming defined full-text index.
Versions 20 and later
StopWord
New in version 20
StopWord
StopWord
The Property MotVide allows to define hollow words in a full-text index defined by programming.
Versions 20 and later
Synonym
New in version 20
Synonym
Synonym
The Property Synonym allows to define synonyms in a 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
The Property CompleteTextTopic allows you to configure the management of text fields in an HEX@ HFSQL.
Versions 10 and later
Thumbnail
New in version 10
Thumbnail
Thumbnail
The Property Vignette allows you to:
  • find out the value of an item thumbnail. This item was defined in the data model editor or by programming.
  • find out and modify the image associated with a Thumbnail control.
Versions 09 and 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
The Property TimestampType allows:
  • Find out the type of timestamp for an item. This item was defined in the data model editor or by programming.
  • Define the type of timestamp for a Date, Time or DateTime item (when describing the item by programming).
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
The Property HEX@ Transaction makes it possible to know if a data file is a transaction HEX@ 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
The Property Unalterable allows to set the inalterability of a data file: the data file cannot be modified; only additions will be possible..
Versions 10 and later
User
New in version 10
User
User
The User property allows to manage the user of an 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
The Property Year makes it possible 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