ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties
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 programmatically.
AbbreviationThe Abbreviation property gets the abbreviation of a data file. This abbreviation is defined in the data model editor when defining the data file. This property is read-only.
AccentSensitiveThe 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).
AccessThe Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.).
ActiveDirectoryThe ActiveDirectory property allows you to connect to an HFSQL server using Active Directory authentication.
BinaryThe Binary property is used to determine if an item is binary.
BrowsedFileThe BrowsedFile property gets and sets the data source used to display records in controls based on a data file.
CacheSizeThe 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.
CalculatedDefaultValueThe 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).
CalculatedItemExpressionThe 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).
CaptionIn 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.
CaseSensitiveThe 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).
CharsetThe Charset property is used to:
  • Get the character set used by a Font variable.
  • Change the character set used by a Font variable.
  • Get the character set used by an HFSQL data file.
ComponentThe Component property configures the different components of a composite key.
CompositeKeyThe CompositeKey property determines if an item is a composite key.
CompressionThe Compression property is used to manage data compression during a connection (HFSQL Client/Server, etc.)
ConnectionThe Connection property gets and sets the connection associated with a data file.
CtAccessThe CtAccess property sets the type of access to the data file when connecting to a specific table via OLE DB.
CtCacheSizeThe 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.
CtCursorOptionsThe CtCursorOptions property gets the cursor type used when connecting to an external database.
CtDatabaseThe CtDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB.
CtDescribedAccessThe CtDescribedAccess property is used to set the type of access to the data file when connecting to a specific table via OLE DB.
CtDescribedCaptionThe CtDescribedCaption property gets and sets the caption of the connection to the OLE DB data source.
CtDescribedDatabaseThe CtDescribedDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB.
CtDescribedOLEDBProviderThe CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server).
CtDescribedPasswordThe CtDescribedPassword property allows you to set the password used to open a data file in an OLE DB connection (only for data files defined programmatically).
CtDescribedUserNameThe CtDescribedUserName property sets the username used to connect to a specific table via OLE DB.
CtExtendedInfoThe CtExtendedInfo property gets the additional information inserted into the database connection string.
CtInitialCatalogThe CtInitialCatalog property is used to get the default database defined for the access.
CtOLEDBProviderThe CtOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server).
CtUserNameThe CtUserName property sets the username used to connect to a specific table via OLE DB.
CursorOptionsThe CursorOptions property is used to manage the type of cursor used for a connection (Native Connectors, OLE DB, etc.).
DatabaseThe Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.).
DateThe 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)
DayThe 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)
DecimalPartThe DecimalPart property is used to configure Numeric items.
DefaultValueThe DefaultValue property is used to:
  • Find out the default value of an item. This item was defined in the data model editor or programmatically.
  • Set the default value of an item (item described programmatically only).
DeletionRuleThe DeletionRule property is used to configure the deletion rule (integrity management) to be applied to the data file described programmatically.
DescribedDirectoryThe DescribedDirectory property is used to manage the physical directory of HFSQL files.
DescribedNameThe DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias).
DescribedPhysicalNameThe DescribedPhysicalName property is used to manage the physical name of HFSQL data files.
DirectoryThe Directory property is used to manage the physical directory of HFSQL files.
EncryptionThe Encryption property allows you to manage the type of encryption used between Client computers and an HFSQL server.
ExecutionCompletedThe ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.
ExtendedInfoThe 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.
ExtensionThe 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).
FicEncryptionThe FicEncryption property sets the encryption method of a data file.
FilterThe Filter property is used to identify and change the filter applied to records in:
  • Table controls based on a data file,
  • browsing TreeView Table controls,
  • browsing List Box controls,
  • Combo Box controls based on a data file,
  • browsing Looper controls.
FilterConditionThe FilterCondition property gets the selection condition set by HFilter on a data file, HFSQL view or query.
FilteredItemThe FilteredItem property is used to identify the item that has a filter implemented by HFilter.
FilterWithBoundsThe 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.
FormatThe Format property is used to define the data format of a data file.
GDPRThe 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).
GenerationNumberThe GenerationNumber property is used to get the generation number of the physical data file associated with the logical data file.
GUIDAnalysisThe GUIDAnalysis property returns the GUID of the analysis that was used to create the data file.
GUIDFileThe GUIDFile property returns the GUID of the file defined in the analysis that was used to create the data file.
HourThe 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.
HugeFileThe HugeFile property sets the maximum possible size of a data file.
IndexThe Index property indicates the physical index (physical order) of an item in a record.
InfoThumbnailGenerationThe InfoThumbnailGeneration property is used to determine if the thumbnails of an item have been generated successfully.
InitialFileThe InitialFile property is used to get the original name of the data file associated to an item in a query.
InitialItemInitialItem 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.
IntegerPartThe IntegerPart property is used to configure Numeric items.
ItemsThe Items property is used to configure the different items of a full-text index.
KeyExpressionThe KeyExpression property is used to set the different components of a composite key.
KeySizeThe KeySize property is used to set the characteristics of a text memo key item.
KeyTypeThe KeyType property is used to set the characteristics of a key item.
LanguageThe Language property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item).
LanguageDescribedThe LanguageDescribed property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item).
LinkedFileThe LinkedFile property is used to set the characteristics of a link.
LinkedKeyThe LinkedKey property sets the characteristics of a link.
LogBackupDirectoryThe LogBackupDirectory property is used to manage the backup directory of log files.
LogDirectoryThe LogDirectory property is used to manage the directory of the log file described in the analysis.
LogFileThe LogFile property is used to determine if a data file is a log file.
LogMethodThe 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).
ManageHTMLManageHTML is used to configure the management mode of the HTML format in a full-text index.
ManageRTFManageRTF is used to configure the management mode of the RTF format in a full-text index.
MaskingRuleThe MaskingRule property gets the masking rule applied to a data file item.
MaxAutoIDThe MaxAutoID property is used to get the maximum automatic identifier of a replicated data file.
MaxLinkedCardinalityThe MaxLinkedCardinality property gets and changes the maximum cardinality of the related item.
MaxSourceCardinalityThe MaxSourceCardinality property gets and changes the maximum cardinality of the source item in the link.
MaxThumbnailHeightThe MaxThumbnailHeight property is used to get and change the maximum height of a thumbnail of an Image item (binary memo).
MaxThumbnailWidthThe MaxThumbnailWidth property is used to get or change the maximum width of a thumbnail of an Image item (binary memo).
MaxValueThe MaxValue property is used to:
  • get and set the top value of a report based on a data file.
  • get the maximum value of the current filter.
  • get the maximum value of a data series in a chart.
  • get and set the maximum value for some types of controls.
MemoThe Memo property is used to determine if an item is of type memo.
MillisecondThe 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)
MinAutoIDThe MinAutoID property is used to get the minimum automatic identifier of a replicated data file.
MinimumLengthThe MinimumLength property is used to configure the minimum length of the words to be indexed.
MinLinkedCardinalityThe MinLinkedCardinality property gets and changes the minimum cardinality of the related item.
MinSourceCardinalityThe MinSourceCardinality property gets and changes the minimum cardinality of the source item in the link.
MinuteThe 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.
MinValueThe MinValue property is used to:
  • get and set the bottom value of a report based on a data file.
  • get the minimum value of the current filter.
  • get the minimum value of a data series in a chart.
  • get and set the minimum value for some types of controls.
MmoEncryptionThe MmoEncryption property sets the encryption method of the memo file (.MMO) associated with a data file.
MmoPackMethodThe MmoPackMethod property sets the compression mode of a MMO file (containing text and binary memos) associated with a data file.
ModificationRuleThe ModificationRule property is used to configure the modification rule (integrity management) to be applied to the data file described in the code.
MonthThe 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)
NameThe 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.
Name55The 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.
NbArrayElementNbArrayElement is used to configure the number of elements in an array item.
NbComponentThe NbComponent property is used to get the number of elements in a composite key.
NbDescribedThumbnailThe NbDescribedThumbnail property is used to get the number of thumbnails expected for an item.
NbItemThe 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 programmatically,
  • an HFSQL view,
  • a query.
NbKeyItemThe 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.
NbMemoItemThe 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.
NbThumbnailThe NbThumbnail property is used to get the number of thumbnails generated for an item.
NdxEncryptionThe NdxEncryption property sets the encryption method of the index file (.NDX) associated with a data file.
NewRecordThe NewRecord property is used to determine if the record is a new record or if it comes from the data file.
NullThe 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.
NullableIndexThe NullIableIndex property determines if a key item supports the "Null" value.
NullAllowedThe NullAllowed property is used to manage the NULL value in the items of HFSQL data files.
NullSupportedThe NullSupported property is used to manage the NULL value in HFSQL data files.
NumericalNumerical is used to find out whether an item is a numeric item.
OperationLogDirectoryThe OperationLogDirectory property is used to manage the directory of the operation log file associated with a data file.
PasswordThe 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 uses the connection.
PasswordProtectedThe PasswordProtected property is used to determine if a datafile is password-protected.
PersistedCalculatedItemThe 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).
PhysicalNameThe PhysicalName property is used to manage the physical name of HFSQL data files.
ProviderThe Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.).
PunctuationSensitiveThe 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).
RecordSizeThe 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.
RepeatableReadSupportedThe RepeatableReadSupported property is used to:
  • Determine if the data file (defined in the data model editor or programmatically) can be used in HFSQL Client/Server in a transaction that includes a "REPEATABLE READ" isolation level.
  • Allow the use of a transaction that includes a "REPEATABLE READ" isolation level for a data file (files described programmatically only).
ReplicationThe Replication property is used to:
  • determine the replication mode used for a data file (defined in the data model editor or programmatically).
  • specify the replication mode used for a data file (file described programmatically only).
ReplicationDirectoryThe ReplicationDirectory property is used to manage the directory of replication files (".rpl" or ".rpm").
SecondThe 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)
SecureThe Secure property is used to configure the data file encryption security level.
ServerThe Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).
SizeThe Size property is used to determine and change the size of an element.
SortTypeThe 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 programmatically.
  • Define the sort direction for an item or for a component of a composite key (when describing the item through programming).
SourceThe 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.).
SourceFileThe SourceFile property is used to set the characteristics of a link.
SourceKeyThe SourceKey property sets the characteristics of a link.
spAgeThe spAge property gets the time elapsed since the password was last changed.
spDerivationThe spDerivation property is used to:
  • Get the key derivation function used to hash an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
  • Set the key derivation function used for hashing (only for "Password" items defined programmatically).
spHashThe spHash property is used to:
  • Get the algorithm used for salting an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
  • Set the algorithm used for salting (only for "Password" items described programmatically).
spIterationCountThe spIterationCount property is used to:
  • Get the iteration count of the hash algorithm used for an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
  • Sets the iteration count of the hash algorithm used for an item of type "Password" (only for "Password" items described programmatically).
spLengthThe spLength property is used to:
  • Get the hash output length. This property can be used for items of type "Password" defined in the data model editor or programmatically.
  • Set the hash output length (only for "Password" items defined programmatically).
spMatchesDescriptionThe spMatchesDescription property determines if the parameters (key derivation function, hash algorithm, iteration count and output length) of the item of type "Password" in the data file match the parameters described programmatically or in the analysis.
SQLCodeThe SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file).
SQLCodeExecutedThe SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value.
StemmingThe Stemming property is used to enable stemming and to define the language used for stemming in a full-text index defined through programming.
StopWordThe StopWord property is used to define stopwords in a full-text index defined through programming.
SynonymThe Synonym property is used to define synonyms in a programmatically defined full-text index.
TextText is used to find out whether an item is a text item.
TextItemCompletedThe TextItemCompleted property is used to manage text items in an HFSQL data file.
ThumbnailThe 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.
TimeThe 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).
TimestampTypeThe TimestampType property is used to:
  • Find out the type of timestamp for an item. This item was defined in the data model editor or programmatically.
  • Define the type of timestamp for a Date, Time or DateTime item (when describing the item through programming).
TimestampUTCThe 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).
TransactionFileThe TransactionFile property is used to determine if a data file is a transaction file.
TypeThe Type property is used to get:
  • the type of element (data file or item) defined programmatically or in the data model editor, view or query.
  • the type of object.
  • the type of data held in a Variant.
TypeDescriptionThe 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 programmatically.
  • Define the type used by an Enumeration or Combination item (when describing the item through programming).
UnalterableThe Unalterable property is used to configure the unalterability of a data file: the data file cannot be modified; only additions can be made.
UserThe User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.).
VisibleEndUserThe 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 programmatically.
  • Define whether an item must be visible or not to the end users (item described programmatically only).
WDD55The WDD55 property is used to:
  • Get the name and full path of the Hyper File 5.5 WDD file.
  • Set the name and full path of the Hyper File 5.5 WDD file.
WDD55PasswordThe 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.
YearThe Year property is used to:
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/04/2024

Send a report | Local help