PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 26

Home | Sign in | English EN
Category: HFSQL properties
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.
The Property SensitiveAccentuation allows you to set the accentuation to be taken into account in the various searches carried out on the heading or on the full-text index (with the HLitSearch, HLitSearchFirst and HLitSearchLast functions for example).
The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.).
The ActiveDirectory property allows you to connect to an HFSQL server with authentication through Active Directory.
The Property Binary allows you to know if a field is of binary type or not.
The Property FilePath allows you to know and modify the data source used to display records in fields based on a data file.
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.
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).
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).
The Property Case Sensitive allows you to set the case sensitivity (upper/lower case) of the different searches performed on the topic or on the full-text index (with the functions HLitSearch, HLitSearchFirst and HLitSearchLast, for example).
The Charset property is used to:
  • Find out the character set used by a Font variable.
  • Modify the character set used by a Font variable.
  • Find out the character set used by an HFSQL data file.
The Property Component allows the different components of a compound key to be parameterized.
The Property CompoundKey allows to know if an Item is a compound key.
The Compression property is used to manage data compression during an Connection (HFSQL Client/Server, ...).
The Connection property is used to find out and modify the connection currently associated with a data file.
The Property Encryption allows to manage the type of encryption of the communication between the Client workstations and the HFSQL Server workstation.
The Property CxAccess allows you to manage the type of data file access when connecting OLE DB to a specific table.
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.
CtCursorOptions is used to find out the type of cursor used during a connection to an external database.
The Property CxDatabase is used to manage the OLE DB data source when connecting OLE DB to a specific table.
The Property CxAccèsDécrit is used to manage the type of access to the data file when connecting OLE DB to a specific table.
CtDescribedCaption is used to manage the caption of the connection to the OLE DB data source.
CtDescribedDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table.
CtDescribedOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server).
CtDescribedPassword enables you to define the password used to open the file during an OLE DB connection (file defined by programming only).
The CxUserDescript property is used to set the user name used in the Connection OLE DB to a specific table.
The CxInfosExtended property allows to know the additional information inserted in the string from Connection to the database.
CtInitialCatalog is used to find out the default database defined for the access.
CtOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server).
The CxUser property is used to set the user name used in the Connection OLE DB to a specific table.
The Property CursorOptions allows to manage the type of cursor used during a connection (Native Access, OLE DB, ...).
The Property Database allows to manage the database associated with a connection (HFSQL Client/Server, OLE DB, ...).
The DecimalPart property is used to configure Numeric items.
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).
The Property DeletionRule is used to set the record deletion rule (integrity management) to be applied to the data file described by programming.
The Property WrittenDirectory allows you to manage the physical directory of HFSQL files.
The Property DescribedName is used to manage the logical name of HFSQL files.
The Property PhysicalName is used to manage the physical name of HFSQL files.
The Property Directory allows you to manage the physical directory of HFSQL files.
The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.
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.
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).
The FicCryptMethod property is used to configure the encryption mode of the data file.
The Filter property is used to identify and change the filter applied to records in:
  • browsing Table controls,
  • browsing TreeView Table controls,
  • browsing List Box controls,
  • browsing Combo Box controls,
  • browsing Looper controls.
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..
The Property FilteredTopic is used to find out the topic on which a filter has been set up by the HFilter function..
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.
Format is used to configure the format of the data in the data file.
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).
The Property GenerationNumber allows to know the generation number of the physical file associated to the specified logical file.
The Property GUIDAnalyse returns the GUID of the analysis that created the data file.
The Property GUIDFile returns the GUID of the file defined in the analysis that created the data file.
HugeFile is used to configure the maximum size of a data file.
The Index property indicates the physical index (physical order) of an item in a record.
InfoThumbnailGeneration is used to find out whether the thumbnails of an item were generated properly.
The Property FileOrigin is used to find out the original name of the data file associated of a field in a query.
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.
..IntegerPart is used to configure the Numeric items.
Items is used to configure the different items included in a full-text index.
The Property FormulaKey allows you to set the different components of a compound key.
The Property KeySize allows you to set the characteristics of an Item key of the text memo type.
The Property TypeKey allows to set the characteristics of a key Item.
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).
LanguageDescribed 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).
LinkedFile is used to configure the characteristics of a link.
The Property LinkKey is used to set the characteristics of a link.
The Property LogBackupDirectory allows to manage the log files backup directory.
The Property DirectoryJournal is used to manage the directory of the log file described in the analysis.
LogFile is used to find out whether a data file is a log file.
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).
..ManageHTML is used to configure the HTML management mode in a full-text index.
..ManageRTF is used to configure the management mode of RTF in a full-text index.
The IdAutoMax property allows to know the maximum automatic identifier on a replicated file.
The Property Linked CardinalityMax allows to know and modify the maximum cardinality of the Item linked in the Link.
The MaxSourceCardinality property is used to get and modify the maximum cardinality of the source item in the link
The Property MaxHeightTag allows you to know and modify the maximum height of a tag in a field.
The Property WidthMaxVignette makes it possible to know or modify the maximum width of a vignette of an Item.
..Memo is used to find out whether an item is a memo item.
The IdAutoMin property allows to know the minimum automatic identifier on a replicated file.
..MinimumLength is used to configure the minimum length of the words to index.
The Property Linked CardinalityMin allows to know and modify the minimum cardinality of the Item linked in the Link.
The MinSourceCardinality property is used to get and modify the minimum cardinality of the source item in the link.
The Property EncryptionMmo allows you to set the encryption mode of the memo file (.MMO extension) associated to the data file.
The Property CompressionMmo is used to set the compression mode of the MMO file (containing binary and text memos) associated to the data file.
The ModificationRule property is used to configure the modification rule (integrity management) to be applied to the data file described in the code.
The Property Nom55 allows to manage the logical name of a data file in Hyper File 5.5 format not migrated and present in an analysis in WINDEV 19 format.
NbArrayElement is used to configure the number of elements in an array item.
..NbComponent is used to find out the number of elements found in a composite key.
NbDescribedThumbnail is used to find out the number of thumbnails described for an item.
The NbRubric property gives the total number of headings (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.
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.
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.
NbThumbnail is used to find out the number of thumbnails generated for an item.
The NdxCryptMethod property is used to configure the encryption method for the index (.NDX) file associated with the data file.
The NewRecord property allows to know if the Record is a new Record or comes from of the data file.
..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.
The Property NullAuthorized allows to manage the NULL value in the fields of the HFSQL data files.
The Property NullSupported allows to manage the NULL value in HFSQL data files.
The Property LogOperationDirectory is used to maintain the directory of the log operation file associated to a data file logged.
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.
The PasswordProtected property is used to determine if a datafile is password-protected.
..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).
The Property PhysicalName allows to manage the physical name of HFSQL files.
The Property Provider allows to manage the type of a connection (HFSQL Client/Server, OLE DB, ...).
The Property SensitivePunctuation allows you to set the parameters for taking punctuation (comma, full stop, etc.) into account in the various searches performed on the topic (with the HLitSearch, HLitSearchFirst and HLitSearchLast functions for example).
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.
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).
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).
The Property ReplicaDirectory is used to manage the replica directory (".RPL" or ".RPM" file).
The Property Secured allows you to set the security level of file encryption.
The Property Server allows to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...).
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).
Source applies to:
  • a Chart control: in this case, the Property Source allows to know the source of the series: Table column, list of values, ...
  • a connection: in this case, the Property Source allows to know or define the source of a connection (HFSQL Client/Server, OLE DB, ...).
SourceFile is used to configure the characteristics of a link.
SourceKey is used to configure the characteristics of a link.
The Property CodeSQL allows you to know the SQL code of a query created with the query editor (file extension ".WDR").
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.
The Property MotVide allows to define hollow words in a full-text index defined by programming.
The Property Synonym allows to define synonyms in a full-text index defined by programming.
Text is used to find out whether an item is a text item.
The Property CompleteTextField allows you to set up the management of text fields in an HFSQL file.
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.
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).
....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).
The Property TransactionFile allows to know if a data file is a transaction file or not.
..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).
The Property Unalterable allows to set the inalterability of a data file: the data file cannot be modified; only additions will be possible..
The User property allows to manage the user of an Connection (HFSQL Client/Server, OLE DB, ...).
The Property VisibleUserFinal allows you 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).
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.
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.