PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

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
..Abbreviation is used to find out the abbreviation of the data file. This abbreviation was defined in the data model editor when describing the data file. This property is read-only
Versions 09 and later
AccentuationSensitive
New in version 09
AccentuationSensitive
AccentuationSensitive
..AccentuationSensitive is used to configure the management mode of the accented characters in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Versions 10 and later
Access
New in version 10
Access
Access
..Access is used to manage the type of access for a connection (HFSQL Client/Server, OLE DB, ...).
Versions 09 and later
Binary
New in version 09
Binary
Binary
..Binary is used to find out whether an item is a binary item or not.
Versions 09 and later
BrowsedFile
New in version 09
BrowsedFile
BrowsedFile
..BrowsedFile is used to find out and modify the data source used to display the records in the controls based on a data file.
Versions 10 and later
CacheSize
New in version 10
CacheSize
CacheSize
..CacheSize is used to:
  • Find out the maximum number of records that can be stored in the cache of Native MySQL Access.
  • Modify the maximum number of records that can be stored in the cache of Native MySQL Access.
Versions 21 and later
CalculatedDefaultItem
New in version 21
CalculatedDefaultItem
CalculatedDefaultItem
..CalculatedDefaultItem is used to:
  • Find out the SQL expression defining the default value of an item. This item was defined in the data model editor or by programming.
  • Define the SQL expression returning the default value of a item (when the item is described by programming).
Versions 21 and later
CalculatedItemExpression
New in version 21
CalculatedItemExpression
CalculatedItemExpression
..CalculatedItemExpression is used to:
  • Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or by programming.
  • Define the SQL expression returning the value of a calculated item (when describing the item by programming).
Versions 09 and later
Caption
New in version 09
Caption
Caption
In a database, ..Caption is used to:
  • Find out the caption associated with an item of a data file
  • Find out the caption associated with a data file
  • Find out and modify the caption of a connection
In a report, ..Caption is used to:
  • Find out the text displayed in a Static control or in a link control.
  • Modify the text displayed in a Static control or in a link control
In a window or in a page, ..Caption is used to:
  • Find out and modify the caption of a control in a window or in a page.
  • Find out and modify the caption of a menu option.
  • Find out and modify the title of a window or page.
  • Find out the content of a site map path
Versions 09 and later
CaseSensitive
New in version 09
CaseSensitive
CaseSensitive
..CaseSensitive is used to configure the management mode of case (uppercase/lowercase characters) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Versions 09 and later
Charset
New in version 09
Charset
Charset
..Charset is used to
  • Find out the character set used by a Font variable.
  • Modify the character set used by a Font variable.
  • Find out the character set used by a HFSQL file
Versions 09 and later
Component
New in version 09
Component
Component
..Component is used to configure the different components of a composite key.
Versions 09 and later
CompositeKey
New in version 09
CompositeKey
CompositeKey
..CompositeKey is used to find out whether an item is a composite key
Versions 14 and later
Compression
New in version 14
Compression
Compression
..Compression is used to manage the compression of data during a connection (HFSQL Client/Server, ...).
Versions 09 and later
Connection
New in version 09
Connection
Connection
..Connection is used to find out and modify the connection currently associated with a data file.
Versions 10 and later
CryptMethod
New in version 10
CryptMethod
CryptMethod
..CryptMethod is used to manage the type of encryption for the communication established between the client computers and the HFSQL server.
Versions 09 and later
CtAccess
New in version 09
CtAccess
CtAccess
..CtAccess is used to manage the type of access to the data file during the OLE DB connection to a specific table.
Versions 09 and later
CtCacheSize
New in version 09
CtCacheSize
CtCacheSize
..CtCacheSize is used to find out and modify the maximum number of records that can be stored in the cache of the Native MySQL Access.
Versions 09 and later
CtCursorOptions
New in version 09
CtCursorOptions
CtCursorOptions
..CtCursorOptions is used identify the type of cursor that will be used during a connection to an external database.
Versions 09 and later
CtDatabase
New in version 09
CtDatabase
CtDatabase
..CtDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table.
Versions 09 and later
CtDescribedAccess
New in version 09
CtDescribedAccess
CtDescribedAccess
..CtDescribedAccess is used to manage the type of access to the data file during the OLE DB connection to a specific table.
Versions 09 and later
CtDescribedCaption
New in version 09
CtDescribedCaption
CtDescribedCaption
..CtDescribedCaption is used to manage the caption of the connection to the OLE DB data source.
Versions 09 and later
CtDescribedDatabase
New in version 09
CtDescribedDatabase
CtDescribedDatabase
..CtDescribedDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table.
Versions 09 and later
CtDescribedOLEDBProvider
New in version 09
CtDescribedOLEDBProvider
CtDescribedOLEDBProvider
..CtDescribedOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server).
Versions 09 and later
CtDescribedPassword
New in version 09
CtDescribedPassword
CtDescribedPassword
..CtDescribedPassword is used to define the password that will be used to open the file during an OLE DB connection (file defined by programming only).
Versions 09 and later
CtDescribedUserName
New in version 09
CtDescribedUserName
CtDescribedUserName
..CtDescribedUserName is used to configure the name of the user that will be used during the OLE DB connection to a specific table.
Versions 09 and later
CtExtendedInfo
New in version 09
CtExtendedInfo
CtExtendedInfo
..CtExtendedInfo is used to find out the additional information inserted into the connection string to the database.
Versions 09 and later
CtInitialCatalog
New in version 09
CtInitialCatalog
CtInitialCatalog
..CtInitialCatalog is used to identify the default database defined for the access.
Versions 09 and later
CtOLEDBProvider
New in version 09
CtOLEDBProvider
CtOLEDBProvider
..CtOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server).
Versions 09 and later
CtUserName
New in version 09
CtUserName
CtUserName
..CtUserName is used to configure the user name that will be used during the OLE DB connection to a specific table.
Versions 10 and later
CursorOptions
New in version 10
CursorOptions
CursorOptions
..CursorOptions is used to manage the type of cursor used during a connection (Native Accesses, OLE DB, ...).
Versions 10 and later
Database
New in version 10
Database
Database
..Database is used to manage the database associated with a connection (HFSQL Client/Server, OLE DB, ...).
Versions 09 and later
Date
New in version 09
Date
Date
..Date is used to:
  • Retrieve the date from a DateTime variable.
  • Modify the date in a DateTime variable.
  • Retrieve the date from a Date item (in "Date and Time" format) .
  • Modify the date in a Date item (in "Date and Time" format)
Versions 09 and later
Day
New in version 09
Day
Day
..Day is used to:
  • Retrieve the day from a Date, DateTime variable or retrieve the number of days from a Duration variable.
  • Modify the day in a Date, DateTime variable or modify the number of days in a Duration variable.
  • Retrieve the day or the number of days from a Date item (in "Date", "Date and Time" or "Duration" format)
  • Modify the day or the number of days in a Date item (in "Date", "Date and Time" or "Duration" format)
Versions 12 and later
DecimalPart
New in version 12
DecimalPart
DecimalPart
..DecimalPart is used to configure the Numeric items.
Versions 09 and later
DefaultValue
New in version 09
DefaultValue
DefaultValue
..DefaultValue is used to:
  • Find out the default value of an item. This item was defined in the data model editor or by programming.
  • Define the default value of an item (when describing the item by programming)
Versions 09 and later
DeletionRule
New in version 09
DeletionRule
DeletionRule
..DeletionRule is used to configure the deletion rule (integrity management) of records that will be applied to the file described by programming.
Versions 09 and later
DescribedDirectory
New in version 09
DescribedDirectory
DescribedDirectory
..DescribedDirectory is used to manage the physical directory of HFSQL files.
Versions 09 and later
DescribedName
New in version 09
DescribedName
DescribedName
..DescribedName is used to manage the logical name of HFSQL files
Versions 09 and later
DescribedPhysicalName
New in version 09
DescribedPhysicalName
DescribedPhysicalName
..DescribedPhysicalName is used to manage the physical name of HFSQL files.
Versions 09 and later
Directory
New in version 09
Directory
Directory
..Directory is used to manage the physical directory of HFSQL files.
Versions 11 and later
ExecutionCompleted
New in version 11
ExecutionCompleted
ExecutionCompleted
..ExecutionCompleted is used to find out whether the execution of a query or view (in HFSQL Classic or Client/Server format) is completed
Versions 09 and later
ExtendedInfo
New in version 09
ExtendedInfo
ExtendedInfo
..ExtendedInfo is used to get additional information:
  • about a data file accessed by a Native Access or HFSQL Client/Server.
  • about an item accessed by a Native Access or HFSQL Client/Server.
  • about a connection. In this case, this property is equivalent to ..CtExtendedInfo
Versions 09 and later
Extension
New in version 09
Extension
Extension
..Extension is used to:
  • find out the extension of a file defined in the data model editor or by programming.
  • define the extension of a file (when the file is described by programming only)
Versions 09 and later
FicCryptMethod
New in version 09
FicCryptMethod
FicCryptMethod
..FicCryptMethod is used to configure the encryption mode of the data file.
Versions 09 and later
Filter
New in version 09
Filter
Filter
..Filter is used to find out and modify the filter used to display records in the browsing Table controls, browsing List Box controls or browsing Combo Box controls.
Versions 09 and later
FilterCondition
New in version 09
FilterCondition
FilterCondition
..FilterCondition is used to find out the selection condition implemented by HFilter on a data file, a HFSQL view or a query
Versions 09 and later
FilteredItem
New in version 09
FilteredItem
FilteredItem
..FilteredItem is used to find out the item on which a filter was implemented by HFilter
Versions 09 and later
FilterWithBounds
New in version 09
FilterWithBounds
FilterWithBounds
..FilterWithBounds is used to find out whether bounds have been specified for the filter implemented byHFilter on a HFSQL data file, view or query.
Versions 09 and later
Format
New in version 09
Format
Format
..Format is used to configure the format of data in a data file.
Versions 09 and later
GenerationNumber
New in version 09
GenerationNumber
GenerationNumber
..GenerationNumber is used to find out the generation number of the physical file associated with the specified logical file
Versions 09 and later
GUIDAnalysis
New in version 09
GUIDAnalysis
GUIDAnalysis
..GUIDAnalysis returns the GUID of the analysis that was used to create the data file
Versions 09 and later
GUIDFile
New in version 09
GUIDFile
GUIDFile
..GUIDFile is used to find out the GUID of the file defined in the analysis that was used to create the data file
Versions 09 and later
Hour
New in version 09
Hour
Hour
..Hour is used to:
  • Retrieve the hour from a Time, DateTime variable or retrieve the number of hours from a Duration variable.
  • Modify the hour in a Time, DateTime variable or modify the number of hours in a Duration variable.
  • Retrieve the hour or the number of hours from a Date item (in "Date and time" or "Duration" format) or from a Time item.
  • Modify the hour or the number of hours in a Date item (in "Date and time" or "Duration" format) or in a Time item
Versions 09 and later
HugeFile
New in version 09
HugeFile
HugeFile
..HugeFile is used to configure the maximum size of a data file.
Versions 10 and later
InfoThumbnailGeneration
New in version 10
InfoThumbnailGeneration
InfoThumbnailGeneration
..InfoThumbnailGeneration is used to find out whether the thumbnails of an item have been successfully generated.
Versions 09 and later
InitialFile
New in version 09
InitialFile
InitialFile
..InitialFile is used to find out the initial name of the data file associated with an item found in a query
Versions 09 and later
InitialItem
New in version 09
InitialItem
InitialItem
..InitialItem is used to find out the initial name of an item found in a query. This name is known from the alias of this item
Versions 12 and later
IntegerPart
New in version 12
IntegerPart
IntegerPart
..IntegerPart is used to configure the Numeric items.
Versions 14 and later
Items
New in version 14
Items
Items
..Items is used to configure the different items included in a full-text index.
Versions 09 and later
KeyExpression
New in version 09
KeyExpression
KeyExpression
..KeyExpression is used to configure the different components of a composite key.
Versions 14 and later
KeySize
New in version 14
KeySize
KeySize
..KeySize is used to configure the characteristics of a Text Memo key item.
Versions 09 and later
KeyType
New in version 09
KeyType
KeyType
..KeyType is used to configure the characteristics of a key item.
Versions 12 and later
Language
New in version 12
Language
Language
..Language is used to manage the language used to perform the comparisons and the sort for the Unicode items (Unicode Text item or Unicode Text Memo item).
Versions 14 and later
LanguageDescribed
New in version 14
LanguageDescribed
LanguageDescribed
..LanguageDescribed allows you to manage the language used to perform the comparisons and the sort for the Unicode items (Unicode Text item or Unicode Text Memo item).
Versions 09 and later
LinkedFile
New in version 09
LinkedFile
LinkedFile
..LinkedFile is used to configure the characteristics of a link.
Versions 09 and later
LinkedKey
New in version 09
LinkedKey
LinkedKey
..LinkedKey is used to configure the characteristics of a link.
Versions 10 and later
LogBackupDirectory
New in version 10
LogBackupDirectory
LogBackupDirectory
..LogBackupDirectory is used to manage the backup directory of the log files.
Versions 09 and later
LogDirectory
New in version 09
LogDirectory
LogDirectory
..LogDirectory is used to manage the directory of the log file described in the analysis.
Versions 09 and later
LogFile
New in version 09
LogFile
LogFile
..LogFile is used to find out whether a data file is a log file or not.
Versions 09 and later
LogMethod
New in version 09
LogMethod
LogMethod
..LogMethod is used to:
  • find out the log mode used for a data file (file defined in the data model editor or by programming).
  • define the log mode used for a data file (when the file is described by programming)
Versions 14 and later
ManageHTML
New in version 14
ManageHTML
ManageHTML
..ManageHTML is used to configure the HTML management mode in a full-text index.
Versions 14 and later
ManageRTF
New in version 14
ManageRTF
ManageRTF
..ManageRTF is used to configure the management mode of RTF in a full-text index.
Versions 09 and later
MaxAutoID
New in version 09
MaxAutoID
MaxAutoID
..MaxAutoID is used to find out the maximum automatic identifier on a replicated file.
Versions 09 and later
MaxLinkedCardinality
New in version 09
MaxLinkedCardinality
MaxLinkedCardinality
..MaxLinkedCardinality is used to find out and modify the maximum cardinality of the linked item in the link.
Versions 09 and later
MaxSourceCardinality
New in version 09
MaxSourceCardinality
MaxSourceCardinality
..MaxSourceCardinality is used to find out and modify the maximum cardinality of the source item in the link.
Versions 10 and later
MaxThumbnailHeight
New in version 10
MaxThumbnailHeight
MaxThumbnailHeight
..MaxThumbnailHeight is used to find out and modify the maximum height of an item thumbnail
Versions 10 and later
MaxThumbnailWidth
New in version 10
MaxThumbnailWidth
MaxThumbnailWidth
..MaxThumbnailWidth is used to find out and modify the maximum width of an item thumbnail.
Versions 09 and later
MaxValue
New in version 09
MaxValue
MaxValue
..MaxValue is used to:
  • find out and modify the upper bound of a report based on a data file
  • find out the upper bound defined for the current filter.
  • find out the maximum value of a chart series.
  • find out and modify the maximum value for some types of controls
Versions 09 and later
Memo
New in version 09
Memo
Memo
..Memo is used to find out whether an item is a memo item.
Versions 09 and later
Millisecond
New in version 09
Millisecond
Millisecond
..Millisecond is used to:
  • Retrieve the number of milliseconds from a Time, DateTime or Duration variable.
  • Modify the number of milliseconds in a Time, DateTime or Duration variable.
  • Retrieve the milliseconds or the number of milliseconds from a Date item (in "Date and Time" or "Duration" format)
  • Modify the milliseconds or number of milliseconds in a Date item ("Date and Time" or "Duration" format)
Versions 09 and later
MinAutoID
New in version 09
MinAutoID
MinAutoID
..MinAutoID is used to find out the minimum automatic identifier on a replicated file
Versions 14 and later
MinimumLength
New in version 14
MinimumLength
MinimumLength
..MinimumLength is used to configure the minimum length of the words to index.
Versions 09 and later
MinLinkedCardinality
New in version 09
MinLinkedCardinality
MinLinkedCardinality
..MinLinkedCardinality is used to find out and modify the minimum cardinality of the linked item in the link.
Versions 09 and later
MinSourceCardinality
New in version 09
MinSourceCardinality
MinSourceCardinality
..MinSourceCardinality is used to find out and modify the minimum cardinality of the source item in the link.
Versions 09 and later
Minute
New in version 09
Minute
Minute
..Minute is used to:
  • Retrieve the minutes from a Time or DateTime variable or the number of minutes from a Duration.
  • Modify the minutes in a Time or DateTime variable or the number of minutes in a Duration.
  • Retrieve the minutes or the number of minutes from a Date item (in "Date and Time" or "Duration" format) or from a Time item
  • Modify the minutes or the number of minutes in a Date item (in "Date and Time" or "Duration" format) or in a Time item
Versions 09 and later
MinValue
New in version 09
MinValue
MinValue
..MinValue is used to:
  • find out and modify the lower bound of a report based on a data file
  • find out the lower bound defined for the current filter.
  • find out the minimum value of a chart series.
  • find out and modify the minimum value for some types of controls
Versions 09 and later
MmoCryptMethod
New in version 09
MmoCryptMethod
MmoCryptMethod
..MmoCryptMethod is used to configure the encryption mode of the memo file (.MMO extension) associated with the data file.
Versions 09 and later
MmoPackMethod
New in version 09
MmoPackMethod
MmoPackMethod
..MmoPackMethod is used to configure the compression mode of the MMO file (containing the binary and text memos) associated with a data file.
Versions 09 and later
ModificationRule
New in version 09
ModificationRule
ModificationRule
..ModificationRule is used to configure the modification rule of records (integrity management) that will be applied to the file described by programming.
Versions 09 and later
Month
New in version 09
Month
Month
..Month is used to:
  • Retrieve the month from a Date or DateTime variable.
  • Modify the month in a Date or DateTime variable.
  • Retrieve the month from a Date item (in "Simple date" or "Date and Time" format)
  • Modify the month in a Date item (in "Simple Date" or "Date and Time" format)
Versions 09 and later
Name
New in version 09
Name
Name
..Name is used to find out:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page
Versions 09 and later
Name55
New in version 09
Name55
Name55
..Name55 is used to manage the logical name of a data file in Hyper File 5.5 format not migrated and found in an analysis in WINDEV 19 format.
Versions 09 and later
NbArrayElement
New in version 09
NbArrayElement
NbArrayElement
..NbArrayElement is used to configure the number of elements in an array item.
Versions 09 and later
NbComponent
New in version 09
NbComponent
NbComponent
..NbComponent is used to find out the number of elements found in a composite key
Versions 10 and later
NbDescribedThumbnail
New in version 10
NbDescribedThumbnail
NbDescribedThumbnail
..NbDescribedThumbnail is used to find out the number of thumbnails described for an item.
Versions 09 and later
NbItem
New in version 09
NbItem
NbItem
..NbItem is used to find out the total number of items (including composite keys) in a record found in:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 09 and later
NbKeyItem
New in version 09
NbKeyItem
NbKeyItem
..NbKeyItem returns the total number of key items (including composite keys) found in a record of:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 09 and later
NbMemoItem
New in version 09
NbMemoItem
NbMemoItem
..NbMemoItem returns the total number of memo items found in a record of:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 10 and later
NbThumbnail
New in version 10
NbThumbnail
NbThumbnail
..NbThumbnail is used to find out the number of thumbnails generated for an item.
Versions 09 and later
NdxCryptMethod
New in version 09
NdxCryptMethod
NdxCryptMethod
..NdxCryptMethod is used to configure the encryption mode of index file (.NDX extension) associated with the data file.
Versions 12 and later
NewRecord
New in version 12
NewRecord
NewRecord
..NewRecord is used to find out whether the record is a new record or whether it comes from the data file.
Versions 09 and later
Null
New in version 09
Null
Null
..Null is used to:
  • Assign NULL to the item for the current record.
  • Find out whether the item is associated with the NULL value for the current record.
  • Define the default value of an item when the item is described by programming
Versions 09 and later
NullSupported
New in version 09
NullSupported
NullSupported
..NullSupported is used to manage the NULL value in HFSQL data files.
Versions 09 and later
Numerical
New in version 09
Numerical
Numerical
..Numerical is used to find out whether an item is a numeric item.
Versions 09 and later
OperationLogDirectory
New in version 09
OperationLogDirectory
OperationLogDirectory
..OperationLogDirectory is used to manage the directory for the file of log operations associated with a logged file.
Versions 09 and later
Password
New in version 09
Password
Password
..Password can be used
  • on the edit controls (or on the text table columns) to find out whether the control is a "Password" control or to modify the "Password" type of the control
  • on the connections (HFSQL Client/Server, OLE DB, ...) to define the password of the user who is using the connection
Versions 09 and later
PasswordProtected
New in version 09
PasswordProtected
PasswordProtected
..PasswordProtected is used to find out whether a data file is password protected
Versions 21 and later
PersistedCalculatedItem
New in version 21
PersistedCalculatedItem
PersistedCalculatedItem
..PersistedCalculatedItem is used to:
  • Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or by programming.
  • Define whether the value of a calculated item is stored in the data file (when describing the item by programming).
Versions 09 and later
PhysicalName
New in version 09
PhysicalName
PhysicalName
..PhysicalName is used to manage the physical name of HFSQL files.
Versions 10 and later
Provider
New in version 10
Provider
Provider
..Provider is used to manage the type of connection (HFSQL Client/Server, OLE DB, ...).
Versions 09 and later
PunctuationSensitive
New in version 09
PunctuationSensitive
PunctuationSensitive
..PunctuationSensitive is used to configure the management mode of the punctuation (comma, dot, etc.) in the different searches performed on the item or on the full-text index (by HReadSeek, HReadSeekFirst and HReadSeekLast for example).
Versions 09 and later
RecordSize
New in version 09
RecordSize
RecordSize
..RecordSize is used to find out and modify the size (in bytes) of a record found in:
  • a file described in the data model editor,
  • a file described by programming,
  • a HFSQL view,
  • a query
Versions 19 and later
RepeatableReadSupported
New in version 19
RepeatableReadSupported
RepeatableReadSupported
..RepeatableReadSupported is used to
  • Find out whether the data file (file defined in the data model editor or by programming) can be used in HFSQL Client/Server in a transaction that includes a "Repeatable Read" isolation mode.
  • Allow the use of a transaction that includes a "Repeatable Read" isolation mode for a data file (when the file is described by programming only)
Versions 09 and later
Replication
New in version 09
Replication
Replication
..Replication is used to:
  • find out the replication mode used for a data file (file defined in the data model editor or by programming).
  • specify the replication mode used for a data file (when the file is described by programming)
Versions 09 and later
ReplicationDirectory
New in version 09
ReplicationDirectory
ReplicationDirectory
..ReplicationDirectory is used to manage the directory of replica (".RPL" or ".RPM" file).
Versions 09 and later
Second
New in version 09
Second
Second
..Second is used to:
  • Retrieve the number of seconds from a Time, DateTime or Duration variable.
  • Modify the number of seconds in a Time, DateTime or Duration variable.
  • Retrieve the seconds or the number of seconds from a Date item (in "Date and Time" or "Duration" format)
  • Modify the seconds or the number of seconds in a Date item (in "Date and Time" or "Duration" format)
Versions 09 and later
Secure
New in version 09
Secure
Secure
..Secure is used to configure the security level for file encryption.
Versions 10 and later
Server
New in version 10
Server
Server
..Server is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...).
Versions 11 and later
Size
New in version 11
Size
Size
..Size is used to find out and modify the size of an element
Versions 09 and later
SortType
New in version 09
SortType
SortType
..SortType is used to:
  • Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or by programming.
  • Define the sort direction for an item or for a component of a composite key (when describing the item by programming)
Versions 10 and later
Source
New in version 10
Source
Source
..Source can be used on:
  • a Chart control: in this case, ..Source is used to find out the source of the series: Table column, list of values, ...
  • a connection: in this case, ..Source is used to find out and define the source of a connection (HFSQL Client/Server, OLE DB, ...)
Versions 09 and later
SourceFile
New in version 09
SourceFile
SourceFile
..SourceFile is used to configure the characteristics of a link.
Versions 09 and later
SourceKey
New in version 09
SourceKey
SourceKey
..SourceKey is used to configure the characteristics of a link.
Versions 12 and later
SQLCode
New in version 12
SQLCode
SQLCode
..SQLCode is used to find out the SQL code of a query created with the query editor (".WDR" file)
Versions 20 and later
Stemming
New in version 20
Stemming
Stemming
..Stemming is used to enable the stemming and to define the language used to perform a stemming in a full-text index defined by programming.
Versions 20 and later
StopWord
New in version 20
StopWord
StopWord
..StopWord is used to define the stop words in a full-text index defined by programming.
Versions 09 and later
Subscript
New in version 09
Subscript
Subscript
..Subscript is used to find out the physical subscript (physical order) of the item in the record
Versions 20 and later
Synonym
New in version 20
Synonym
Synonym
..Synonym is used to define the synonym in the full-text index defined by programming.
Versions 09 and later
Text
New in version 09
Text
Text
..Text is used to find out whether an item is a text item.
Versions 09 and later
TextItemCompleted
New in version 09
TextItemCompleted
TextItemCompleted
..TextItemCompleted is used to configure the management of text items in a HFSQL file.
Versions 10 and later
Thumbnail
New in version 10
Thumbnail
Thumbnail
..Thumbnail is used to find out the value of an item thumbnail.
Versions 09 and later
Time
New in version 09
Time
Time
..Time is used to:
  • Retrieve the time from a DateTime variable.
  • Modify the time in a DateTime variable.
  • Retrieve the time from in a Date item (in "Date and Time" format)
  • Modify the time in a Date item ("Date and Time" format)
Versions 21 and later
TimestampType
New in version 21
TimestampType
TimestampType
..TimestampType is used to:
  • Find out the type of timestamp for an item. This item was defined in the data model editor or by programming.
  • Define the type of timestamp for a Date, Time or DateTime item (when describing the item by programming).
Versions 21 and later
TimestampUTC
New in version 21
TimestampUTC
TimestampUTC
....TimestampUTC is used to:
  • Find out whether a timestamp item will use a UTC time or a local time. This item was defined in the data model editor or by programming.
  • Define whether a timestamp item will use a UTC time or a local time (when describing the item by programming).
Versions 09 and later
TransactionFile
New in version 09
TransactionFile
TransactionFile
..TransactionFile is used to find out whether a data file is a transaction file or not.
Versions 09 and later
Type
New in version 09
Type
Type
..Type is used to find out:
  • the type of an 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 an object.
  • the type of the 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 10 and later
User
New in version 10
User
User
..User is used to manage the user of a connection (HFSQL Client/Server, OLE DB, ...).
Versions 10 and later
VisibleEndUser
New in version 10
VisibleEndUser
VisibleEndUser
..VisibleEndUser is used to:
  • Find out whether an item is visible or not to the end users. This item was defined in the data model editor or by programming.
  • Define whether an item must be visible or not to the end users (when describing the item by programming)
Versions 09 and later
WDD55
New in version 09
WDD55
WDD55
..WDD55 is used to:
  • Find out the name and full path of the WDD file in Hyper File 5.5 format
  • Define the name and full path of the WDD file in Hyper File 5.5 format
Versions 09 and later
WDD55Password
New in version 09
WDD55Password
WDD55Password
..WDD55Password is used to specify the password of the analysis in 5.5 format during the description by programming of a file in Hyper File 5.5 format in an analysis in Hyper File Classic format
Versions 09 and later
Year
New in version 09
Year
Year
..Year is used to:
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment