PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version: 22

Category: HFSQL properties
..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
..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).
..Access is used to manage the type of access for a connection (HFSQL Client/Server, OLE DB, ...).
..Binary is used to find out whether an item is a binary item or not.
..BrowsedFile is used to find out and modify the data source used to display the records in the controls based on a data file.
..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.
..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).
..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).
..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).
..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
..Component is used to configure the different components of a composite key.
..CompositeKey is used to find out whether an item is a composite key
..Compression is used to manage the compression of data during a connection (HFSQL Client/Server, ...).
..Connection is used to find out and modify the connection currently associated with a data file.
..CryptMethod is used to manage the type of encryption for the communication established between the client computers and the HFSQL server.
..CtAccess is used to manage the type of access to the data file during the OLE DB connection 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 identify the type of cursor that will be used during a connection to an external database.
..CtDatabase is used to manage the OLE DB data source during the OLE DB connection to a specific table.
..CtDescribedAccess is used to manage the type of access to the data file during the OLE DB connection 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 is used to define the password that will be used to open the file during an OLE DB connection (file defined by programming only).
..CtDescribedUserName is used to configure the name of the user that will be used during the OLE DB connection to a specific table.
..CtExtendedInfo is used to find out the additional information inserted into the connection string to the database.
..CtInitialCatalog is used to identify the default database defined for the access.
..CtOLEDBProvider is used to manage the name of the OLE DB provider (also called OLE DB server).
..CtUserName is used to configure the user name that will be used during the OLE DB connection to a specific table.
..CursorOptions is used to manage the type of cursor used during a connection (Native Accesses, OLE DB, ...).
..Database is used to manage the database associated with a connection (HFSQL Client/Server, OLE DB, ...).
..DecimalPart is used to configure the Numeric items.
..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)
..DeletionRule is used to configure the deletion rule (integrity management) of records that will be applied to the file described by programming.
..DescribedDirectory is used to manage the physical directory of HFSQL files.
..DescribedName is used to manage the logical name of HFSQL files
..DescribedPhysicalName is used to manage the physical name of HFSQL files.
..Directory is used to manage the physical directory of HFSQL files.
..ExecutionCompleted is used to find out whether the execution of a query or view (in HFSQL Classic or Client/Server format) is completed
..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
..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)
..FicCryptMethod is used to configure the encryption mode of the data file.
..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.
..FilterCondition is used to find out the selection condition implemented by HFilter on a data file, a HFSQL view or a query
..FilteredItem is used to find out the item on which a filter was implemented by HFilter
..FilterWithBounds is used to find out whether bounds have been specified for the filter implemented byHFilter on a HFSQL data file, view or query.
..Format is used to configure the format of data in a data file.
..GenerationNumber is used to find out the generation number of the physical file associated with the specified logical file
..GUIDAnalysis returns the GUID of the analysis that was used to create the data file
..GUIDFile is used to find out the GUID of the file defined in the analysis that was used to create the data file
..HugeFile is used to configure the maximum size of a data file.
..InfoThumbnailGeneration is used to find out whether the thumbnails of an item have been successfully generated.
..InitialFile is used to find out the initial name of the data file associated with an item found 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.
..KeyExpression is used to configure the different components of a composite key.
..KeySize is used to configure the characteristics of a Text Memo key item.
..KeyType is used to configure 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 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).
..LinkedFile is used to configure the characteristics of a link.
..LinkedKey is used to configure the characteristics of a link.
..LogBackupDirectory is used to manage the backup directory of the log files.
..LogDirectory 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 or not.
..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)
..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.
..MaxAutoID is used to find out the maximum automatic identifier on a replicated file.
..MaxLinkedCardinality is used to find out and modify the maximum cardinality of the linked item in the link.
..MaxSourceCardinality is used to find out and modify the maximum cardinality of the source item in the link.
..MaxThumbnailHeight is used to find out and modify the maximum height of an item thumbnail
..MaxThumbnailWidth is used to find out and modify the maximum width of an item thumbnail.
..Memo is used to find out whether an item is a memo item.
..MinAutoID is used to find out the minimum automatic identifier on a replicated file
..MinimumLength is used to configure the minimum length of the words to index.
..MinLinkedCardinality is used to find out and modify the minimum cardinality of the linked item in the link.
..MinSourceCardinality is used to find out and modify the minimum cardinality of the source item in the link.
..MmoCryptMethod is used to configure the encryption mode of the memo file (.MMO extension) associated with the data file.
..MmoPackMethod is used to configure the compression mode of the MMO file (containing the binary and text memos) associated with a data file.
..ModificationRule is used to configure the modification rule of records (integrity management) that will be applied to the file described by programming.
..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.
..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.
..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
..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
..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
..NbThumbnail is used to find out the number of thumbnails generated for an item.
..NdxCryptMethod is used to configure the encryption mode of index file (.NDX extension) associated with the data file.
..NewRecord is used to find out whether the record is a new record or whether it comes from 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
..NullAllowed is used to manage the NULL value in the items of HFSQL data files.
..NullSupported is used to manage the NULL value in HFSQL data files.
..OperationLogDirectory is used to manage the directory for the file of log operations associated with a logged file.
..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
..PasswordProtected is used to find out whether a data file 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).
..PhysicalName is used to manage the physical name of HFSQL files.
..Provider is used to manage the type of connection (HFSQL Client/Server, OLE DB, ...).
..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).
..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
..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)
..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)
..ReplicationDirectory is used to manage the directory of replica (".RPL" or ".RPM" file).
..Secure is used to configure the security level for file encryption.
..Server is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, ...).
..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)
..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, ...)
..SourceFile is used to configure the characteristics of a link.
..SourceKey is used to configure the characteristics of a link.
..SQLCode is used to find out the SQL code of a query created with the query editor (".WDR" file)
..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.
..StopWord is used to define the stop words in a full-text index defined by programming.
..Subscript is used to find out the physical subscript (physical order) of the item in the record
..Synonym is used to define the synonym in the full-text index defined by programming.
..Text is used to find out whether an item is a text item.
..TextItemCompleted is used to configure the management of text items in a HFSQL file.
..Thumbnail is used to find out the value of an item thumbnail.
..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).
....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).
..TransactionFile is used to find out whether 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).
..User is used to manage the user of a connection (HFSQL Client/Server, OLE DB, ...).
..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)
..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