HFSQL constants

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

See also

Functions for HFSQL management

HFSQL constants

Display constants used by prefixed syntaxes only

Display constants used by non-prefixed syntaxes only

The following constants are used to manage HFSQL data files:


Constant	Affects	Used by the functions or properties
eltProcedure	The listed element is a stored procedure	HListStoredElement
eltQuery	The listed element is a query.	HListStoredElement
eltSetOfProcedures	The listed element is a set of procedures	HListStoredElement
Versions 15 and later h3G New in version 15 h3G h3G	Type of network to simulate: 3G	HSimulateNetwork
hAcceptOpenedFile	Allows you to read the source file that will be added to the memo if this source file is opened in write mode somewhere else.	HLinkMemo
hAccessHF7	Pseudo-connection to HFSQL Classic database.	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessHFClientServer	Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, HOpenConnection
hAccessJDBCSQLServer	Access to a SQL Server database via a JDBC driver	HDescribeConnection, HOpenConnection
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	HSetServer
hActiveSyncFrame	The size of the frame is optimized to be used with Mobile devices.	HCS.FrameSize
hActivityStatisticsPath	Path of the directory containing the activity statistics	HSetServer
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	HSetServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	HSimulateNetwork
hAffectBrowse	Addition affecting the current browse	HAdd, HModify
hAllowed	The relevant rights are granted to the user or group.	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hANSIFormat	Data format: Ansi format (used by Windows)	..Format
hApplication	Property of a database found on an HFSQL server: Name of the application from which the database was created.	HInfoDatabaseProperty, HInfoFileProperty
Versions 18 and later hAutoStatisticalCalc New in version 18 hAutoStatisticalCalc hAutoStatisticalCalc	Enable the automatic calculation of statistics for the data files (optimization of indexes).	HSetServer
Versions 15 and later hBackgroundTask New in version 15 hBackgroundTask hBackgroundTask	Perform the process in background task without locking the data file (available for the data files in Client/Server mode).	HStatCalculate, HIndex
hBackupCanceled	Status of backup: Backup canceled	HInfoBackup
hBackupCompleted	Status of backup: Backup completed	HInfoBackup
Versions 15 and later hBackupDifferential New in version 15 hBackupDifferential hBackupDifferential	Type of backup: Differential backup	HInfoBackup
hBackupError	Status of backup: Error during backup	HInfoBackup
Versions 15 and later hBackupFull New in version 15 hBackupFull hBackupFull	Type of backup: Full backup	HInfoBackup
hBackupInProgress	Status of backup: Backup in progress	HInfoBackup
Versions 24 and later hBlockingNonBlocking New in version 24 hBlockingNonBlocking hBlockingNonBlocking	Number of records in the view or query that can currently be browsed (no record lock).	HNbRec
hBoundSeparator	Used to separate the values of lower and upper bounds for the components of composite key	HFilterIncludedBetween
Versions 21 and later hCacheNbUnusedFiles New in version 21 hCacheNbUnusedFiles hCacheNbUnusedFiles	Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server.	HSetServer
hCardinality	Integrity constraints: Check the link cardinalities.	HSetIntegrity
hChangeCharset	The character set defined by ChangeCharset will be taken into account in the new data file. The sorts, the searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.	HCreation, HCreationIfNotFound, HIndex
hCheckDuplicates	Checks for duplicates for this action, even if the duplicate check is disabled (HSetDuplicates)	HAdd, HExecuteQuery, HExecuteSQLQuery, HModify
hCheckIntegrity	Checks the integrity of operation even if the automatic integrity check is disabled (HSetIntegrity)	HAdd, HExecuteQuery, HExecuteSQLQuery, HModify, HCross, HDelete
hCheckMemo	Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos)	HIndex
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, HOpenConnection
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	HCheckStructure
hComputer	Property of a database found on an HFSQL server: Name of the computer from which the element was created.	HInfoDatabaseProperty, HInfoFileProperty
hCopyAutoId	Copies the automatic identifier while keeping its value	HCopyRecord, HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	HCopyFile
hCopyIndex	Copies the index of the data file	HCopyFile
hCorrespondence	Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions	HInfoLog
hCreateIndex	The index of the data file is not copied. It is automatically re-created on the destination by re-indexing.	HCopyFile
hCreator	Property of a database found on an HFSQL server: Name of database owner.	HInfoDatabaseProperty, HInfoFileProperty
Versions 24 and later hCryptAES128 New in version 24 hCryptAES128 hCryptAES128	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
Versions 19 and later hCryptAuto New in version 19 hCryptAuto hCryptAuto	File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptNo	No file encryption.	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptRC5_12	The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptRC5_16	The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptStandard	The memo file is encrypted according to an optimized encryption algorithm on 128 bits.	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCurrentRecNum	Number of the current record.	HFSQL functions
hDaemonUser	User name that will be used by the server (Linux only)	HSetServer
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	HRegenerateFile
hDatabasePath	Path of directory containing all databases	HSetServer
hDate	Property of a database found on an HFSQL server: Creation date of the database.	HInfoDatabaseProperty, HInfoFileProperty
Versions 20 and later hDateLastRefresh New in version 20 hDateLastRefresh hDateLastRefresh	Requested information: Date of the last successful refresh for the materialized view.	Versions 20 and later HInfoView New in version 20 HInfoView HInfoView
hDBASCII	Sort according to ASCII order	HDBSortType
hDBLexicographic	Sort according to the lexicographic order	HDBSortType
hDebuggingPort	Port used to debug the stored procedures and the server triggers.	HSetServer
hDecreasing	Sort performed in descending order	..SortType
hDefault	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the values of the requested rights (in the same order).	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hDefaultFrame	The standard size will be used by default.	HCS.FrameSize
hDefaultVal	The items of destination record that are not affected by the copy are initialized with their default value. For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value.	HCopyRecord, HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hDelayedOpening	Optimize the opening of existing files: If the file already exists, it will be opened during the first access to the file. The file is created if it does not exist.	HCreationIfNotFound
hDeleteLog	Deletes the log file	HDeleteFile, HDeleteDatabase
hDestroyLink	Deletes all links related to the deleted data file.	HDeleteFile
hDetails	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the rights and there value.	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hDisconnection	Configures the disconnection message	HOnServerCall
hDisk	Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case	HChangeLocation, HDeclare
hDistinct	Management of duplicates during the browse: If duplicates are found when a browse is performed on a key item, a single record is browsed	HForward, HReadPrevious, HReadNext, HPrevious, HBackward, HNext
hDuplicateKey	Characteristics of an item: Key with duplicates	..KeyType
hDynamicCursor	Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users.	HDescribeConnection, HOpenConnection
hEffective	The rights returned correspond to the rights that will be actually granted to the user or to the group on the database. The inherited rights are taken into account (rights granted to the groups to which the user belongs for example).	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hErrADO	Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.	HErrorInfo
hErrADOMessage	Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO)	HErrorInfo
hErrAll	Customize all the errors	HOnError
hErrBase	Type of information about the error to return: Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant	HErrorInfo
hErrBaseMessage	Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase)	HErrorInfo
hErrClientInfo	Information about the client layer used by the Native Connector that returned the error.	HErrorInfo
hErrConnectionLoss	Customize the errors caused by a loss of connection with the server.	HOnError
hErrCurrent	Type of information about the error to return: Number of the current error	HError
hErrDatabaseAccess	Configure the access errors to an HFSQL Client/Server database.	HOnError
hErrDebugInfo	Type of information about the error to return: Specific information for debugging the problem that occurred. This information should only be displayed and communicated on express demand from PC SOFT. When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database.	HErrorInfo
hErrDuplicates	Customize duplicate errors	HOnError
hErrFIC	Type of information about the error to return: Full name of the data file associated with the error	HErrorInfo
hErrFile	Type of information about the error to return: Logical name of data file associated with the error	HErrorInfo
hErrFullDetails	Type of information about the error to return: Full error details (error line, current process, etc.) Remark: Returns the same information as the one retrieved when clicking the "Copy" button in the error window of WLanguage.	HErrorInfo
hErrIndex	Customize the reindexing errors (reindexing operation in progress during the access to the data file)	HOnError
hErrIntegrity	Customize integrity errors	HOnError
hErrItem	Type of information about the error to return: Name of item associated with the error	HErrorInfo
hErrLink	Type of information about the error to return: Name of link associated with the error	HErrorInfo
hErrLock	Customize lock errors	HOnError
hErrLockInfo	Type of information about the error to return: Information about the lock	HErrorInfo
hErrMain	Type of information about the error to return: Number of the main error	HError
hErrMessage	Type of information about the error to return: Message associated with the error	HErrorInfo
hErrMMO	Type of information about the error to return: Full name of the memo file associated with the error	HErrorInfo
hErrModify	Customize a modification conflict	HOnError
hErrNative	Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used	HErrorInfo
hErrNativeMessage	Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector.	HErrorInfo
hErrNDX	Type of information about the error to return: Full name of the index file associated with the error	HErrorInfo
hErrNeedValue	Customize the errors caused by a mandatory input with no data (OLE DB only).	HOnError
hErrOLEDB	Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection.	HErrorInfo
hErrOLEDBMessage	Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)	HErrorInfo
Versions 20 and later hErrorLastRefresh New in version 20 hErrorLastRefresh hErrorLastRefresh	Requested information: Last error while refreshing the materialized view.	Versions 20 and later HInfoView New in version 20 HInfoView HInfoView
hErrPassword	Customize password errors	HOnError
Versions 20 and later hErrPositionSQLError New in version 20 hErrPositionSQLError hErrPositionSQLError	Type of information about the error to return: Position of the SQL error in the SQL code of the query run by HExecuteSQLQuery.	HErrorInfo
hErrRecNum	Type of information about the error to return: Number of the record associated with the error	HErrorInfo
hErrServer	Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error	HErrorInfo
hErrServerInfo	Information about the server used by the Native Connector that returned the error.	HErrorInfo
hErrSystemCode	Type of information about the error to return: Number of the associated system error	HErrorInfo
hErrSystemMessage	Type of information about the error to return: Message of associated system error	HErrorInfo
hErrWDD	Type of information about the error to return: Full name of the analysis file associated with the error	HErrorInfo
hExisting	Type of search: Only the assignments for which a file actually exists	HListREP
hExpBreakable	Mode for creating the export file: The export can be interrupted by pressing Esc. If the export is interrupted, the export file is valid and it only contains the records exported before the interruption.	HExportXML Versions 21 and later HExportJSON New in version 21 HExportJSON HExportJSON Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
hExpCreation	Mode for creating the export file: The file is overwritten if it already exists.	HExportXML Versions 21 and later HExportJSON New in version 21 HExportJSON HExportJSON Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
Versions 24 and later hExpNoLineItemName New in version 24 hExpNoLineItemName hExpNoLineItemName	Mode for creating the CSV/XLSX file: The first line of the generated file will not contain the names of the items.	Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
hExpNormal	Mode for creating the export file: Standard operating mode	HExportXML Versions 21 and later HExportJSON New in version 21 HExportJSON HExportJSON Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
hExpWithoutXSL	The style sheet (".XSL" file) is not created	HExportXML
Versions 24 and later hFalsifieHorodatage New in version 24 hFalsifieHorodatage hFalsifieHorodatage	Management of wage types of type Timestamp: By default, a timestamp field contains the date and time the record was created/modified.. This constant makes it possible to force the value of the timestamp wage type with the value assigned to it (and not with the value calculated automatically)..	HAdd, HModify
hFicSize	Size of data file in bytes (".Fic" file)	HInfoFile
hFileAS400	Type of file: AS400 file	..Type
hFileClientServer	Type of file: HFSQL Client/Server file	..Type
hFileHF5	Type of file: Hyper File 5 file	..Type
hFileMySQL	Type of file: MySQL file	..Type
hFileNormal	Type of file: Standard file (HFSQL Classic)	..Type
hFileOLEDB	Type of file: OLEDB file	..Type
hFileOracle	Type of file: ORACLE file	..Type
hFileOracleLite	Type of file: ORACLE Lite file	..Type
hFileOther	Type of file: Other type of file	..Type
Versions 15 and later hFilePostgreSQL New in version 15 hFilePostgreSQL hFilePostgreSQL	Type of file: PostgreSQL file	..Type
hFileProgress	Type of file: Progress file	..Type
hFileQuery	Type of file: Query	..Type
hFileQueryAS400	Type of file: Query on an AS/400 database	..Type
hFileQueryClientServer	Type of file: Query on an HFSQL Client/Server database	..Type
hFileQueryMySQL	Type of file: Query on a MySQL database	..Type
hFileQueryOLEDB	Type of file: Query on a database accessed via an OLE DB provider	..Type
hFileQueryOracle	Type of file: Query on an Oracle database	..Type
hFileQueryOracleLite	Type of file: Query on an Oracle Lite database	..Type
Versions 15 and later hFileQueryPostgreSQL New in version 15 hFileQueryPostgreSQL hFileQueryPostgreSQL	Type of file: Query on a PostgreSQL database	..Type
hFileQueryProgress	Type of file: Query on a Progress database	..Type
Versions 16 and later hFileQuerySQLAzure New in version 16 hFileQuerySQLAzure hFileQuerySQLAzure	Type of file: Query on an SQL Azure database	..Type
hFileQuerySQLServer	Type of file: Query on an SQL Server database	..Type
hFileQuerySQLServerMobile	Type of file: Query on an SQL Server Mobile database	..Type
hFileQuerySybase	Type of file: Query on a Sybase database	..Type
hFileQueryXML	Type of file: Query on an XML database	..Type
hFileSQL	Type of file: SQL file	..Type
Versions 16 and later hFileSQLAzure New in version 16 hFileSQLAzure hFileSQLAzure	Type of file: SQL Azure file	..Type
Versions 16 and later hFileSQLite New in version 16 hFileSQLite hFileSQLite	Type of file: SQLite file	..Type
hFileSQLServer	Type of file: SQL Server file	..Type
hFileSQLServerMobile	Type of file: SQL Server Mobile file	..Type
hFileSybase	Type of file: Sybase file	..Type
hFileTemporary	Type of file: Temporary file	..Type
hFileView	Type of file: HFSQL view	..Type
hFileXBase	Type of file: xBase file	..Type
hFileXML	Type of file: XML file	..Type
Versions 22 and later hFindKey New in version 22 hFindKey hFindKey	Enable the search for keys on the HFSQL server.	HSetServer
hForbidden	The relevant rights are not granted to the user or group	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
Versions 17 and later hForwardOnly New in version 17 hForwardOnly hForwardOnly	Native Connectors only: Used to speed up the browse of data during a simple browse that does not use the following features: Reading the previous record. Modifying a record. Saving position. If one of these features is used, the result may differ from the expected one. This constant can be used for example during a browse used to fill a memory Table control.	HReadLast, HReadFirst, HReadSeekFirst, HReadSeekLast
hForwardOnlyCursor	Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible.	HDescribeConnection, HOpenConnection
Versions 20 and later hftPunctuationSimple New in version 20 hftPunctuationSimple hftPunctuationSimple	Full-text Index item described by programming: Taking into account the simple punctuation characters (non Unicode).	..Option property of FullTextIndex description variables.
Versions 20 and later hftPunctuationUnicode New in version 20 hftPunctuationUnicode hftPunctuationUnicode	Full-text Index item described by programming: Taking into account the Unicode punctuation characters.	..Option property of FullTextIndex description variables.
hFTX	Reindexing full-text indexes	HIndex
hFtxSize	Size of full-text index file in bytes (".Ftx" file)	HInfoFile
HGeneric	Type of search: Generic search	HReadSeekLast, HReadSeekFirst, HSeekLast, HSeekFirst
hGPRSFrame	The frame size is optimized for a use via GPRS	HCS.FrameSize
hHCreationIfNotFound	Type of test to run to check the connection: Checks the connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only.	HConnect
hHOpen	Type of test to run to check the connection: Checks the connection by opening a file. This value is used by default when accessing to an hORead database.	HConnect
hIdentical	The structures of files (read in the analysis and in the physical file) must be strictly identical.	HReadSeek, HSeek, HCheckStructure
hIgnoreDuplicates	Ignores the duplicate check for this operation, even if the automatic duplicate check is enabled (HSetDuplicates)	HAdd
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (HSetIntegrity)	HAdd, HModify, HDelete, HCross
hImpBreakable	The import can be interrupted by pressing ESC.	HImportHF55, HImportText, Versions 20 and later HImportXLS, New in version 20 HImportXLS, HImportXLS, HImportXML Versions 21 and later HImportJSON New in version 21 HImportJSON HImportJSON
hImpConversion	Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated.	HImportHF55
hImpCreation	Type of import: If the (HFSQL Classic) import file exists, it is overwritten.	HImportHF55, HImportText, Versions 20 and later HImportXLS, New in version 20 HImportXLS, HImportXLS, HImportXML Versions 21 and later HImportJSON New in version 21 HImportJSON HImportJSON
hImpIgnoreEmptyItem	If one or more items are not filled in the text file, the corresponding lines are still imported. The missing items contain: the default value of items if the hDefaultVal constant is specified. the value of items in the current record before the call to HImportText.	HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
Versions 20 and later hImpIgnoreFirstLine New in version 20 hImpIgnoreFirstLine hImpIgnoreFirstLine	Type of import: The first row of the imported file is ignored.	HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hImpIgnoreInvalidLine	Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing.	HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hImpIgnoreItem	Type of import: The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value. The items of imported file (Hyper File 5.5) with no match in the import file are ignored.	HImportHF55
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	HImportText
hImpNormal	Type of import: The import is not performed and an error occurs in the following cases: items found in the Hyper File 5.5 file with no match in the HFSQL Classic file. associated items in the two files but with a different size and/or format. If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created. No management of integrity and no management of duplicates. The non-imported items take the value of the current record. The automatic identifiers are recalculated.	HImportHF55, HImportText, Versions 20 and later HImportXLS, New in version 20 HImportXLS, HImportXLS, HImportXML Versions 21 and later HImportJSON New in version 21 HImportJSON HImportJSON
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	HImportHF55
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	HImportText
hImpTestDuplicates	Type of import: Checks the duplicates during the import	HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hImpTestIntegrity	Type of import: Checks the integrity during the import	HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hInaccessible	Undefined server status	HServerStatus
hIncreasing	Sort performed in ascending order	..SortType
hInfiniteCardinality	Maximum cardinality ("N")	..MaxLinkedCardinality, ..MaxSourceCardinality
hInfoAll	Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate). The different values are separated by CR characters (Carriage Return).	HInfoServer
Versions 15 and later hInfoCluster New in version 15 hInfoCluster hInfoCluster	Information about the HFSQL cluster.	HInfoServer
hInfoDate	Date and time of server on 8 bytes in UTC format (universal time)	HInfoServer
Versions 22 and later hInfoFreeDiskSpace New in version 22 hInfoFreeDiskSpace hInfoFreeDiskSpace	Available space on the server disk, expressed in MB.	HInfoServer
hInfoHardware	Information about the hardware used: Type of processor (for example: Intel Pentium) Size of server RAM (for example: 630 MB) This information is returned in the following format: <Type of CPU> = TAB + <Size of server RAM>	HInfoServer
hInfoLogicalName	Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center.	HInfoServer
hInfoName	Name of server (DNS)	HInfoServer
hInfoPlatform	Information about the server platform: Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX System version: corresponds to Service Pack in Windows or empty string if no Service Pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example). This information is returned in the following format: <System name> + TAB + <Version>	HInfoServer
Versions 19 and later hInfoSizeCacheNdxUsed New in version 19 hInfoSizeCacheNdxUsed hInfoSizeCacheNdxUsed	Size of index cache that is actually used on the server, expressed in MB.	HInfoServer
Versions 22 and later hInfoTotalDiskSpace New in version 22 hInfoTotalDiskSpace hInfoTotalDiskSpace	Total capacity of server disk, expressed in MB.	HInfoServer
hInfoVersion	Information about the version of programs required for the server to operate: Version of Manta.exe or Manta in Linux Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux) Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux) This information is returned in the following format: <Manta version> + TAB + <HFSQL version> +TAB + <SQL version<	HInfoServer
hInfoVersionDetails	Detailed information about the version of the programs required to operate the server: <Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date> The listed elements are as follows: Manta.exe or Manta in Linux HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux) SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux) Management of logs (HFLogger.exe) MantaManager the framework required to operate the server. This information is returned in the following format: <Manta version> + TAB + <HFSQL version> +TAB + <SQL version<	HInfoServer
hInfoVI	Version number of Manta.exe or Manta in Linux	HInfoServer
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hIntegrityCascade	Modification/Deletion rule: Cascading modification/deletion	..ModificationRule, ..DeletionRule
hIntegrityDefaultValue	Modification/Deletion rule: Default modification/deletion	..ModificationRule, ..DeletionRule
hIntegrityForbidden	Modification/Deletion rule: Modification/Deletion not allowed	..ModificationRule, ..DeletionRule
hIntegrityNone	Modification/Deletion rule: No integrity management	..ModificationRule, ..DeletionRule
hInternetFrame	The frame size is optimized for a use via Internet	HCS.FrameSize
hInternetPageSize	Size of page for using the RPC via Internet.	Remote access (RPC on HFSQL)
hIntranetFrame	The frame size is optimized for a use via Intranet	HCS.FrameSize
hIntranetPageSize	Size of page for using the RPC via Intranet.	Remote access (RPC on HFSQL)
hInvalidRecNum	Constant returned if there is no current record or if the specified file corresponds to a multi-file query.	HRecNum
hItemBinary	Item type: Binary	..Type
hItemBinaryMemo	Item type: Binary Memo	..Type
hItemBinaryMemo4	Item type: Binary memo (4 bytes)	..Type
hItemBoolean	Item type: Boolean	..Type
hItemCharacter	Item type: Character	..Type
Versions 20 and later hItemCombination New in version 20 hItemCombination hItemCombination	Item type: Combination	..Type
hItemCurrency	Item type: Currency	..Type
hItemDate6	Item type: Date	..Type
hItemDate8	Item type: Date	..Type
hItemDateTime	Item type: Date/Time	..Type
Versions 20 and later hItemEnumeration New in version 20 hItemEnumeration hItemEnumeration	Item type: Enumeration	..Type
hItemHour	Item type: Hour	..Type
hItemIdAuto	Item type: Automatic identifier (8 bytes)	..Type
hItemIdAuto4	Item type: Automatic identifier (4 bytes)	..Type
hItemInteger1	Item type: 1-byte integer	..Type
hItemInteger2	Item type: 2-byte integer	..Type
hItemInteger4	Item type: 4-byte integer	..Type
hItemInteger8	Item type: 8-byte integer	..Type
hItemInvalid	Invalid type of item	..Type
Versions 24 and later hItemJSON New in version 24 hItemJSON hItemJSON	Item type: JSON	..Type
hItemNumeric	Item type: High-precision numeric	..Type
hItemNumRec	Item type: Record number	..Type
hItemPicture	Item type: Image	..Type
hItemReal4	Item type: 4-byte real	..Type
hItemReal8	Item type: 8-byte real	..Type
hItemRealTurbo	Item type: Turbo real	..Type
hItemText	Item type: Text	..Type
hItemTextMemo	Item type: Text Memo	..Type
hItemTimeLength	Item type: Duration	..Type
hItemUnicodeMemo	Item type: Unicode Text Memo	..Type
hItemUnicodeText	Item type: Unicode text	..Type
hItemUnsignedInteger1	Item type: Unsigned 1-byte integer	..Type
hItemUnsignedInteger2	Item type: Unsigned 2-byte integer	..Type
hItemUnsignedInteger4	Item type: Unsigned 4-byte integer	..Type
hItemUnsignedInteger8	Item type: Unsigned 4-byte integer	..Type
Versions 24 and later hItemUUID128 New in version 24 hItemUUID128 hItemUUID128	Item type: UUID 128	..Type
Versions 24 and later hItemUUID128Auto New in version 24 hItemUUID128Auto hItemUUID128Auto	Item type: UUID 128 automatic identifier	..Type
Versions 24 and later hItemUUID256 New in version 24 hItemUUID256 hItemUUID256	Item type: UUID 256	..Type
Versions 24 and later hItemUUID256Auto New in version 24 hItemUUID256Auto hItemUUID256Auto	Item type: UUID 256 automatic identifier	..Type
hJNLBackupPath	Path of the directory containing the backups of the logs	HSetServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	HSetServer
Versions 23 and later hkaInterval New in version 23 hkaInterval hkaInterval	Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client.	HSetServer
Versions 23 and later hkaTimeout New in version 23 hkaTimeout hkaTimeout	Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected.	HSetServer
hKeepFilter	The filter set by HFilter will be taken into account, even if the search key is not optimized for the filter. Reminder: HFilter returns the search key optimized for the filter. Caution: in this case, performance problems may occur on large files.	HChangeKey, HLast, HReadLast, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadSeek, HFirst, HSeek, HSeekLast, HSeekFirst
hKeepTRS	Stores the transaction files during the deletion	HDeleteDatabase, HDeleteFile
Versions 17 and later hLanguageBinarySort New in version 17 hLanguageBinarySort hLanguageBinarySort	The sort will be performed by comparing the binary value of the bytes. This type of sort is very fast. It should be used to perform an exact-match search for example.	..Language, ..LanguageDescribed, H.LanguageCreationUnicode
hLanguageCreation	Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation".	..Language, ..LanguageDescribed
Versions 17 and later hLanguageFastSort New in version 17 hLanguageFastSort hLanguageFastSort	The sort will be performed by comparing the characters one by one according to a generic sort.	..Language, ..LanguageDescribed, H.LanguageCreationUnicode
hlbActive	Enable or disable the load balancing	HSetServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	HSetServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	HSetServer
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	HSetServer
hlbMaxTimeout	Value modifying the maximum time-out for a server request	HSetServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	HSetServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	HSetServer
hLimitParsing	Limits the file browse: The browse will stop as soon as the last sought value is found. The current record will correspond to this last record found. HFound will be set to False and HOut will be set to True. This constant is used to optimize the search speed in client/server mode.	HReadSeek, HReadSeekLast, HReadSeekFirst, HSeek, HSeekLast, HSeekFirst
hLockNo	Type of lock: No lock	HAdd, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, HModify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLockReadWrite	Type of lock: Lock in read/write	HAdd, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, HModify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLockWrite	Type of lock: Lock in write mode	HAdd, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, HModify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLogIdentification	Configures the file to re-create: Re-creates the "JournalIdentification.fic" file.	HLogRecreate
hLogJNLFile	Configures the file to re-create: Only <File name>JNL.FIC is recreated.	HLogRecreate
hLogLevel	Defines the elements that must be found in the log file	HSetServer
hLogNo	Format of log process: No log	Log
hLogOperation	Configures the file to re-create: Re-creates the "JournalOperation.fic" file.	HLogRecreate
hLogPath	Path of the directory containing the log files	HSetServer
hLogReadingWriting	Format of log process: Log the read and write operations performed in the file	..LogMethod
hLogUser	Configures the file to re-create: Re-creates the log of users ("UserLog.fic"). This file exists in HFSQL Client/Server only. This file contains the information (login, computer, ...) about the users who perform the logged actions.	HLogRecreate
hLogWriting	Format of log process: Log the write operations performed in the file	..LogMethod
Versions 20 and later hlpBackup New in version 20 hlpBackup hlpBackup	Type of scheduling to list: Scheduling of backups.	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpCalcStat New in version 22 hlpCalcStat hlpCalcStat	Type of operation performed on the server: statistical calculation.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpKeyDetection New in version 22 hlpKeyDetection hlpKeyDetection	Type of operation performed on the server: detection of keys.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpMaterializedView New in version 20 hlpMaterializedView hlpMaterializedView	Type of scheduling to list: Tasks for refreshing the materialized views.	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpOptimization New in version 20 hlpOptimization hlpOptimization	Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation).	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpReplication New in version 22 hlpReplication hlpReplication	Type of operation performed on the server: server replication.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpTask New in version 20 hlpTask hlpTask	Type of scheduling to list: Scheduled tasks that run a stored procedure.	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
hLstAll	Lists all the keys, all the files, all the items or all the connections	HListKey, HListFile, HListItem, HListConnection, HListStoredElement
hLstCompositeKey	Lists the composite key items only	HListKey, HListItem
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	HListDatabase
hLstDetail	Lists the detailed information	HListKey, HListFile, HListLink, HListItem, HListConnection, HListStoredElement
hLstDetailPlus	For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part.	HListKey, HListItem
hLstFile	Lists the databases and their files for the server defined by the connection	HListDatabase
hLstItem	Lists the non-key and non-memo items	HListItem
hLstKey	Lists the key items	HListKey, HListItem
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	HListKey, HListItem
Versions 20 and later hLstMaterializedView New in version 20 hLstMaterializedView hLstMaterializedView	Lists the materialized views found on an HFSQL server.	HListFile
hLstMemo	Lists the memo items	HListItem
hLstNormal	Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically.	HListKey, HListFile, HListItem, HListConnection
hLstOpened	Stores the opened connections only	HListConnection
hLstOriginalItem	Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file.	HListKey, HListItem
hLstQuery	Lists the queries found on a server Versions 19 and later Lists the queries that have been run. New in version 19 Lists the queries that have been run. Lists the queries that have been run.	HListStoredElement HListFile
hLstSet	Lists the sets of procedures found on a server	HListStoredElement
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	HListKey, HListFile, HListItem, HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, HListStoredElement
hLstSystemTable	List of system tables for a connection via Native Connectors or OLE DB	HListFile
hLstTable	List of user tables for a connection via Native Connectors or OLE DB	HListFile
hLstView	List the views of a connection via Native Connectors or OLE DB. Versions 20 and later List the SQL views on an HFSQL server. New in version 20 List the SQL views on an HFSQL server. List the SQL views on an HFSQL server.	HListFile
hMasterReplica	Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica)	..Replication
hMaxActivityStatisticsSize	Maximum size in megabytes (MB) of files for activity statistics	HSetServer
hMaxLogSize	Maximum size in megabytes (MB) of log files	HSetServer
Versions 24 and later hMaxNumberConnection New in version 24 hMaxNumberConnection hMaxNumberConnection	Maximum number of connections allowed per application.	HSetServer
hMaxVal	Defines an upper bound for a filter	HBuildKeyValue, HFilter, HFilterStartsWith, HFilterIncludedBetween
hMemoAuto	The memos are read during the access to the item	HSetMemo
hMemoBin	Type of file used for the memo: Any binary file	HLinkMemo
hMemoImg	Type of file used for the memo: Image file	HLinkMemo
hMemoNo	No management of memos	HSetMemo
hMemoOle	Type of file used for the memo: OLE file	HLinkMemo
hMemoWav	Type of file used for the memo: sound file	HLinkMemo
hMemoYes	The text memos are read whenever the record is read. Read the binary memos when accessing the item.	HSetMemo
hMessage	Configure the information message	HOnServerCall
hMinVal	Defines a lower bound for a filter	HBuildKeyValue, HFilter, HFilterStartsWith, HFilterIncludedBetween
Versions 20 and later hMmoCompact New in version 20 hMmoCompact hMmoCompact	Compression and defragmentation of "Mmo" files.	HIndex
hMmoSize	Size of memo file in bytes (".Mmo" file)	HInfoFile
hMode2GB	Indicates whether the system files support more than 2 GB	HSetServer
hModeDirect	Priority implementation of locks	HMode
hModeMono	Single-user lock mode	HMode
hModeMulti	Multi-user lock mode	HMode
hModeReservation	Non-priority implementation of locks	HMode
hModifyFile	When modifying the query result, these modifications will be applied to the files belonging to the query. If this option is not specified, only the query result is modified.	HExecuteQuery, HExecuteSQLQuery
Versions 17 and later hmsBackgroundTask New in version 17 hmsBackgroundTask hmsBackgroundTask	A hot automatic modification is performed (available for the HFSQL Client/Server data files only).	Versions 17 and later HModifyStructure New in version 17 HModifyStructure HModifyStructure
Versions 17 and later hmsNoCheck New in version 17 hmsNoCheck hmsNoCheck	The automatic data modification is performed even if the file description is more recent than the analysis description.	Versions 17 and later HModifyStructure New in version 17 HModifyStructure HModifyStructure
Versions 17 and later hmsNormal New in version 17 hmsNormal hmsNormal	Standard operating mode of the automatic data modification.	Versions 17 and later HModifyStructure New in version 17 HModifyStructure HModifyStructure
hNativeAccessAS400	Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessDB2	OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessInformix	OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 20 and later hNativeAccessMariaDB New in version 20 hNativeAccessMariaDB hNativeAccessMariaDB	OLE DB provider that will be used for the connection: Native MariaDB Connector (optional module of WINDEV/WEBDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessMySQL	OLE DB provider that will be used for the connection: Native MySQL Connector	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessOracle	OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessOracleLite	Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessPostgreSQL	OLE DB provider that will be used for the connection: Native PostgreSQL Connector	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessProgress	OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 16 and later hNativeAccessSQLAzure New in version 16 hNativeAccessSQLAzure hNativeAccessSQLAzure	OLE DB provider that will be used for the connection: Native SQL Azure Connector	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 15 and later hNativeAccessSQLite New in version 15 hNativeAccessSQLite hNativeAccessSQLite	OLE DB provider that will be used for the connection: Native Connector to an SQLite database	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSQLServer	OLE DB provider that will be used for the connection: Native SQL Server Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSQLServerMobile	Provider that will be used for the connection: Native SQL Server Mobile Connector (optional module of WINDEV Mobile)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSybase	OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXBase	OLE DB provider that will be used for the connection: Native xBase Connector	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXML	Provider that will be used for the connection: Native XML Connector (supplied with WINDEV/WEBDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	HSetServer
hNdxCompact	Re-index operation with compression	HIndex
hNdxDelete	Reindex and delete damaged records	HIndex
hNdxMinimal	Re-index operation while ignoring the corrupted keys	HIndex
hNdxNormal	Standard re-index operation	HIndex
hNdxNoStat	Reindex without statistical calculation	HIndex
hNdxSilent	Configure the re-index operation: No display while re-indexing	HIndex
hNdxSize	Size of index file in bytes (".Ndx" file)	HInfoFile
hNoBind	Run a query without enabling the bind	HExecuteQuery, HExecuteSQLQuery, HPrepareSQLQuery
hNoCheck	No check is performed, the analysis description may differ from the description of physical file.	HCheckStructure
hNoError	No error occurred	HError
Versions 21 and later hNoHourglass New in version 21 hNoHourglass hNoHourglass	When reading the query result, this read operation may be locked and a hourglass appears by default. This constant is used not to display the hourglass in this case.	HExecuteQuery, HExecuteSQLQuery
hNoIndex	The file index is not copied	HCopyFile
hNoLink	Management of integrity: The links are not updated on the server (creation, modification or deletion). Reminder: by default, the links are updated on the server when creating a file.	HCreation, HCreationIfNotFound
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	HSimulateNetwork
hNoRefresh	The table or query content will not be refreshed	HLast, HReadLast, HReadFirst, HFirst
hNotAKey	Characteristics of an item: Non-key item	..KeyType
hNotes	Property of a database found on an HFSQL server: Database description or any other information associated with the database by HModifyDatabaseProperty.	HInfoDatabaseProperty, HInfoFileProperty, HInfoServerProperty, HModifyDatabaseProperty, HModifyFileProperty, HModifyServerProperty
Versions 18 and later hNotifCCClassic New in version 18 hNotifCCClassic hNotifCCClassic	The notifications are sent by the Control Centers in HFSQL Classic mode.	Versions 18 and later HNotifConfigure New in version 18 HNotifConfigure HNotifConfigure
Versions 18 and later hNotifCCCS New in version 18 hNotifCCCS hNotifCCCS	The notifications are sent by the Control Centers in Client/Server mode.	Versions 18 and later HNotifConfigure New in version 18 HNotifConfigure HNotifConfigure
Versions 18 and later hNotifCritical New in version 18 hNotifCritical hNotifCritical	The notifications will be sent from the critical level (for the critical and error problems).	Versions 18 and later HNotifAddCCRecipient, HNotifAddEmailRecipient New in version 18 HNotifAddCCRecipient, HNotifAddEmailRecipient HNotifAddCCRecipient, HNotifAddEmailRecipient
Versions 18 and later hNotifEmail New in version 18 hNotifEmail hNotifEmail	The notifications are sent by email.	Versions 18 and later HNotifConfigure New in version 18 HNotifConfigure HNotifConfigure
Versions 18 and later hNotifError New in version 18 hNotifError hNotifError	The notifications will be sent for the error problems only.	Versions 18 and later HNotifAddCCRecipient, HNotifAddEmailRecipient New in version 18 HNotifAddCCRecipient, HNotifAddEmailRecipient HNotifAddCCRecipient, HNotifAddEmailRecipient
Versions 22 and later hNotifInformation New in version 22 hNotifInformation hNotifInformation	The notifications will be sent from the information level (for the information, warning, critical and error problems)	HNotifAddCCRecipient, HNotifAddEmailRecipient
Versions 18 and later hNotifWarning New in version 18 hNotifWarning hNotifWarning	The notifications will be sent from the warning level (for the warning, critical and error problems).	Versions 18 and later HNotifAddCCRecipient, HNotifAddEmailRecipient New in version 18 HNotifAddCCRecipient, HNotifAddEmailRecipient HNotifAddCCRecipient, HNotifAddEmailRecipient
hNotLocking	Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To find out whether the execution of the view or query is completed, use ..ExecutionCompleted. This constant is available for the views and queries in HFSQL Classic or Client/Server. This constant has no effect for the data files and for the Native Connectors	hNbRec
hNotReplicated	Replication mode: The data file is not configured for replication. To implement the replication, check "Replication" in the characteristics of the file in the data model editor.	..Replication
hNotSorted	Sort direction: Item not sorted	..SortType
hODBC	OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Used to access an ODBC source declared in the ODBC data sources of Windows	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbAccess2000	OLE DB provider that will be used for the connection: OLE DB provider for Access 2000	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbAccess2007	OLE DB provider that will be used for the connection: OLE DB provider for Access 2007	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
Versions 19 and later hOledbAccess2010 New in version 19 hOledbAccess2010 hOledbAccess2010	OLE DB provider that will be used for the connection: OLE DB provider for Access 2010	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbAccess97	OLE DB provider that will be used for the connection: OLE DB provider for Access 97	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbDBase5	OLE DB provider that will be used for the connection: OLE DB provider for dBase 5	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbExcel2000	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbExcel2007	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbExcel97	OLE DB provider that will be used for the connection: OLE DB provider for Excel 97	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbLotus4	OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbOracle	OLE DB provider that will be used for the connection: OLE DB provider for Oracle	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbSQLServer	OLE DB provider that will be used for the connection: OLE DB provider for SQL Server	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOnDelete	Integrity rule applied during a deletion	HSetIntegrity
hOnUpdate	Integrity rule applied during a modification	HSetIntegrity
hOpenKeysetCursor	Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions).	HDescribeConnection, HOpenConnection
hOptimisticCursor	The record is locked when it is updated	HDescribeConnection, HOpenConnection
Versions 15 and later hOptIndex New in version 15 hOptIndex hOptIndex	Optimization options: Provokes the re-indexing operation on the data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes.	hFileParameter variable
Versions 15 and later hOptStat New in version 15 hOptStat hOptStat	Optimization options: Provokes the recalculation of statistics on the data files.	hFileParameter variable
hORead	File accessible in read-only	..CtAccess, ..CtDescribedAccess, HConnect, HOpen
hOReadWrite	File accessible in read/write	..CtAccess, ..CtDescribedAccess, HConnect, HOpen
hOwner	Property of a database found on an HFSQL server: Owner of database.	HInfoDatabaseProperty, HInfoFileProperty, HModifyDatabaseProperty, HModifyFileProperty
hPackNo	Compression mode: No compression	..MmoPackMethod
hPackZLW	Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation.	..MmoPackMethod
hPageSize	Size of a block of caches. This block of caches will be used when browsing a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption.	HSetCache
hPessimisticCursor	The record is locked as soon as it becomes in edit to be modified.	HDescribeConnection, HOpenConnection
hPrecisionHigh	Position with high precision	HGetCurrentPosition, HSetPosition
hPrecisionLow	Position with low precision	HGetCurrentPosition, HSetPosition
hPrecisionMedium	Position with medium precision	HGetCurrentPosition, HSetPosition
hQueryBreakable	The query initialization can be interrupted with the ESC key	HExecuteQuery, HExecuteSQLQuery
hQueryDefault	The query is initialized without interruption	HExecuteQuery, HExecuteSQLQuery
hQueryWithoutCorrection	Native Connector or OLE DB only: No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.)	HExecuteQuery, HExecuteSQLQuery
hQueryWithoutHFCorrection	HFSQL only The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters.	HExecuteQuery, HExecuteSQLQuery
Versions 19 and later hReadCommitted New in version 19 hReadCommitted hReadCommitted	Isolation level of transaction: only the finalized transactions are visible by the other users.	Versions 19 and later HTransactionIsolation New in version 19 HTransactionIsolation HTransactionIsolation
hReadOnlyCursor	The set of records cannot be modified.	HDescribeConnection, HOpenConnection
Versions 19 and later hReadUncommitted New in version 19 hReadUncommitted hReadUncommitted	Isolation level of transaction: the non-finalized transactions are visible by the other users.	Versions 19 and later HTransactionIsolation New in version 19 HTransactionIsolation HTransactionIsolation
hRecalculateIdAuto	Mode for calculating the automatic identifier: Automatic identifier re-calculated during the write operation	HWrite, HModify
hRecFile	Record to read: Value of the item currently saved in the data file	HErrorModification, HErrorStatusModification
Versions 22 and later hRecNumAll New in version 22 hRecNumAll hRecNumAll	Used to track all records found in a data file. Versions 23 and later Used to check all unaltered records New in version 23 Used to check all unaltered records Used to check all unaltered records	Versions 22 and later HTrack, HTrackStop New in version 22 HTrack, HTrackStop HTrack, HTrackStop Versions 23 and later HCheckUnaltered New in version 23 HCheckUnaltered HCheckUnaltered
hRecRead	Record to read: Value of the item for the source record	HErrorModification, HErrorStatusModification
hRecUser	Record to read: Value of the item for the current record when performing the modification	HErrorModification, HErrorStatusModification
Versions 20 and later hRefreshInProgress New in version 20 hRefreshInProgress hRefreshInProgress	Requested information: Is the materialized view currently refreshed?	Versions 20 and later HInfoView New in version 20 HInfoView HInfoView
Versions 19 and later hRepeatableRead New in version 19 hRepeatableRead hRepeatableRead	Isolation level of transaction: the application in transaction sees a snapshot of the database when the transaction starts.	Versions 19 and later HTransactionIsolation New in version 19 HTransactionIsolation HTransactionIsolation
hReplicated	Replication mode: The data file is configured to be replicated.	..Replication
hRightsAll	List of all the rights	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hRightsAutoModif	Rights to perform the automatic modification of the data files on a file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsBackup	Rights to save the data files	HInfoDatabaseRights, HInfoServerRights, HModifyDatabaseRights, HModifyServerRights
hRightsChangeLink	Rights to modify the integrity rules on a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsChangeOwner	Rights to modify the owner of an element	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsChangePassword	Rights to change the password of a user on the server (the user can change his own password and the administrator can change the password of each user).	HInfoServerRights, HModifyServerRights
hRightsChangeRights	Rights to change rights.	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights, HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hRightsConnection	Rights to connect to a server (encrypted or unencrypted connection)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsCreateDB	Rights to create a database	HInfoServerRights, HModifyServerRights
hRightsCreateFile	Rights to create a data file (with HCreation)	HInfoDatabaseRights, HModifyDatabaseRights
Versions 20 and later hRightsCreateView New in version 20 hRightsCreateView hRightsCreateView	Rights to create a SQL view or a materialized view.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsDebug	Rights to debug the stored procedures.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsDelete	Rights to delete the records from a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsDeleteDB	Rights to delete a database	HInfoDatabaseRights, HModifyDatabaseRights
hRightsDeleteFile	Rights to delete a data file (HDeleteFile)	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
Versions 20 and later hRightsDeleteView New in version 20 hRightsDeleteView hRightsDeleteView	Rights to delete a SQL view or a materialized view.	Versions 20 and later HInfoViewRights, HModifyViewRights New in version 20 HInfoViewRights, HModifyViewRights HInfoViewRights, HModifyViewRights
hRightsDisconnectClient	Rights to disconnect the client computers.	HInfoServerRights, HModifyServerRights
hRightsEncryptedConnection	Rights to connect to a server (encrypted connection only)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsInsert	Rights to add new records into a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsLock	Rights to lock the data files or the records of a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsMaintenance	Rights to start a re-index operation or to perform statistical calculations on a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsManageDuplicate	Rights to enable and disable the management of duplicates.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsManageIntegrity	Rights to enable and disable the management of integrity.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsManageProcedure	Rights to add, modify and delete the stored procedures.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsManageServer	Rights to use HSetServer	HInfoServerRights, HModifyServerRights
hRightsManageTask	Rights to manage the scheduled tasks.	HInfoServerRights, HModifyServerRights
hRightsManageTrigger	Rights to manage the server triggers (addition, activation, deletion)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsManageUser	Rights to delete and add users or groups	HInfoServerRights, HModifyServerRights
hRightsNoDatabaseAccess	Rights to prevent (or not) access to a database (HNoDatabaseAccess and HEndNoDatabaseAccess)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsPriority	Rights to modify the priority of a client application	HInfoServerRights, HModifyServerRights
hRightsRead	Rights to read the records of a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsReadLogStat	Rights to see the activity statistics and the logs of the server.	HInfoServerRights, HModifyServerRights
hRightsRunProcedure	Rights to run the stored procedures.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsSeeUser	Rights to view the characteristics of a group or user.	HInfoServerRights, HModifyServerRights
hRightsSendMessageToClient	Rights to send messages to the client computers.	HInfoServerRights, HModifyServerRights
Versions 18 and later hRightsServerReplication New in version 18 hRightsServerReplication hRightsServerReplication	Rights to define and perform a replication between two HFSQL servers.	HInfoServerRights, HModifyServerRights
hRightsStopServer	Rights to stop a server (HStopServer)	HInfoServerRights, HModifyServerRights
hRightsUpdate	Rights to modify the records of a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRPDefault	Configure the restore operation: Position freed. The stored position is restored	HRestorePosition
hRPFilter	Configure the restore operation: Restore the filter set when HSavePosition is called	HRestorePosition
hRPHF5	Configure the restore operation: If the stored position was deleted or modified, this position is restored	HRestorePosition
hRPKeep	Configure the restore operation: Position not freed	HRestorePosition
Versions 22 and later hrsCopy New in version 22 hrsCopy hrsCopy	Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is locking.	HRSAddConfig
Versions 22 and later hrsCopyBackgroundTask New in version 22 hrsCopyBackgroundTask hrsCopyBackgroundTask	Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is performed in background task and it is not locking.	HRSAddConfig
Versions 22 and later hrsNoCopy New in version 22 hrsNoCopy hrsNoCopy	Configure the replication between servers: No copy is performed.	HRSAddConfig
Versions 22 and later hsAdd New in version 22 hsAdd hsAdd	Monitors the operations for adding records.	Versions 22 and later HTrack New in version 22 HTrack HTrack
hSaveItems	Saves the values of items in memory when using HSavePosition. These values will be restored next time HRestorePosition is called.	HSavePosition
Versions 22 and later hsCross New in version 22 hsCross hsCross	Monitors the operations for crossing records.	Versions 22 and later HTrack New in version 22 HTrack HTrack
Versions 22 and later hsDeletion New in version 22 hsDeletion hsDeletion	Monitors the operations for deleting records.	Versions 22 and later HTrack New in version 22 HTrack HTrack
Versions 19 and later hSecondaryThread New in version 19 hSecondaryThread hSecondaryThread	Option for running the procedure: the procedure is run in a secondary thread.	HOnServerCall
hServerCursor	Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.	HDescribeConnection, HOpenConnection
hServerPort	Network port used	HSetServer
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the addition	HAdd, HWrite, HModify
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the write operation	HAdd, HWrite, HModify
Versions 22 and later hsModification New in version 22 hsModification hsModification	Monitors the operations for modifying records.	Versions 22 and later HTrack New in version 22 HTrack HTrack
Versions 20 and later hSQLCode New in version 20 hSQLCode hSQLCode	Requested information: SQL code of the materialized view	Versions 20 and later HInfoView New in version 20 HInfoView HInfoView
hSQLUnicode	Used to specify that the query text must be sent in Unicode format to the server. *This constant is available in WINDEV Mobile only.*	HExecuteSQLQuery
hStarted	Server started	HServerStatus
hStateActive	Status of the record/Type of record taken into account: Active record	HState, hNbRec, HErrorStatusModification
hStateAll	Type of record: Total number of records in the data file	hNbRec
hStateCrossed	Status of the record/Type of record taken into account: Crossed record	HState, hNbRec, HErrorStatusModification
hStateDel	Status of the record/Type of record taken into account: Deleted record	HState, hNbRec, HErrorStatusModification
hStateInvalid	Record status not found (error)	HState, HErrorStatusModification
hStaticCursor	Makes a copy of all query records in memory (consumes a lot of memory). All types of moves are allowed.	HDescribeConnection, HOpenConnection
hStopped	Server stopped	HServerStatus
hStructure	Configure the file management: New empty file created from the file description	HRegenerateFile
hSubErrFirst	Type of error returned: Number of the first sub-error	HError
hSubErrLast	Type of error returned: Number of the last sub-error	HError
hSubErrNext	Type of error returned: Number of the previous sub-error	HError
hSubErrPrevious	Type of error returned: Number of the previous sub-error	HError
hSubscriberReplica	Replication mode: The data file is a subscriber replica (HCreateSubscriberReplica was used to create the subscriber replica)	..Replication
Versions 22 and later hTelemetryEnable New in version 22 hTelemetryEnable hTelemetryEnable	Configure the sending of data via the telemetry for the HFSQL server.	HSetServer
Versions 17 and later hTempDirectory New in version 17 hTempDirectory hTempDirectory	Path of temporary directory. This directory is used to create the temporary files if necessary (temporary files created when re-indexing large data files for example).	HSetServer
hTotalSize	Total file size in bytes (added size of data file, memo file and index file).	HInfoFile
hTriggerAfter	Indicates the type of trigger: The procedure is run after the HFSQL function	HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger
hTriggerBefore	Indicates the type of trigger: The procedure is run before the HFSQL function	HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger
Versions 21 and later htsCreation New in version 21 htsCreation htsCreation	Type ot timestamp for the item: the item will store the creation date of record.	..TimestampType
Versions 21 and later htsLastModification New in version 21 htsLastModification htsLastModification	Type ot timestamp for the item: the item will store the date of last modification performed on the record.	..TimestampType
Versions 21 and later htsNone New in version 21 htsNone htsNone	Type ot timestamp for the item: the item is not a timestamp item.	..TimestampType
hUnicode	Used to retrieve the record value in Unicode format.	HRetrieveRecord
hUNICODEFormat	Data format: UNICODE format	..Format
hUniqueKey	Characteristics of an item: Unique key	..KeyType
hViewAdd	Create a view with addition: Stores the view content next time HExecuteView is called	HCreateView, HMergeView
hViewBreakable	The view creation can be interrupted by pressing the ESC key	HCreateView
hViewDefault	Default creation of view	HCreateView, HMergeView
hViewDistinct	The view is created without duplicates according to the sort key	HCreateView, HMergeView
hViewExclusive	Optimizes the creation time of view by locking the entire source file	HCreateView, HMergeView
hViewIntersection	Merge views with intersection: Common rows between the two specified views	HMergeView
hViewJoin	Join between the first view and the second view.	HMergeView
hViewLocking	The records read in the file and included in the view are locked	HCreateView, HMergeView
hViewPostponed	The view is created but it will be run later by HExecuteView	HCreateView, HMergeView
hViewSubtraction	Merge views with subtraction: Row of the first view without the common rows of the second view	HMergeView
hViewUnion	Merging views: Merge the rows of the two specified views	HMergeView
hViewUnionEx	Exclusive merge of views: Merge the non-common rows of the two specified views	HMergeView
hWDL	The files are sought: In the main WDL. In the WDL according to their load order, then on disk or in the specified WDL, then on disk. In the main WDL of the component. In the secondary WDLs of the component according to the load order.	HChangeLocation, HDeclare
hWifiFrame	The frame size is optimized for a use via Wifi	HCS.FrameSize
Versions 19 and later hWindowsDiskCacheSize New in version 19 hWindowsDiskCacheSize hWindowsDiskCacheSize	Mode for managing the size of Windows disk cache.	HSetServer
hWithFilter	If this parameter is specified: the query result corresponds to a selection of filter records if the HFSQL engine allows it. Otherwise, the query result corresponds to an HFSQL view the following operations are not allowed: search on the query result, query on query, view on query, query on view. the browse items specified when browsing the result are ignored. the magnifier is not available for the tables linked to a query. hNbRec cannot be used on the queries. If this parameter is not specified (by default): the query result corresponds to an HFSQL view the following operations can be performed on the queries: search on the query result, query on query, view on query, query on view. the browse items specified when browsing the result are taken into account. the magnifier is available on tables linked to a query. hNbRec can be used on the queries.	HExecuteQuery, HExecuteSQLQuery
hWithTransaction	The query is run in a transaction. A transaction is started, the records are locked in read/write during the execution of the query and they are unlocked at the end of its execution, regardless of the result (failure or success). If the query cannot end properly (locked records, power failure, etc.), the transaction is canceled and the data files are restored to their previous status (before the query execution). Remark: The query execution may be slowed down.	HExecuteQuery, HExecuteSQLQuery
hWriteDefault	Addition not affecting the current browse/Identifier re-used or calculated for the record	HAdd, HWrite, HModify
hYield	For the UPDATE and DELETE queries performed on an important number of records, this constant is used to give control back to the other applications that use the files.	HExecuteQuery, HExecuteSQLQuery
Versions 20 and later NoWait New in version 20 NoWait NoWait	The refresh of materialized view is not a locking operation: it is performed in background task. HInfoView is used to find out the result of refresh performed on the materialized view.	Versions 20 and later HRefreshView New in version 20 HRefreshView HRefreshView
opCancel	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the code continues to run.	HOnError
opEndProcess	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the current process stops. Equivalent to the following code line: IF NOT <HFSQL function> THEN ReturnToCapture()	HOnError
opEndProgram	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the program stops. Equivalent to the following code line: IF NOT <HFSQL function> THEN EndProgram()	HOnError
opRelaunchProgram	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The program stops and the application is automatically restarted.	HOnError
opRetry	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. In this case, the function that triggered the error is re-run.	HOnError

Versions 23 and later
The following constants are used to manage HFSQL data files (prefixed syntax):


Constant	Affects	Used by the functions or properties
eltProcedure	The listed element is a stored procedure	<Connection variable>.ListStoredElement
eltQuery	The listed element is a query.	<Connection variable>.ListStoredElement
eltSetOfProcedures	The listed element is a set of procedures	<Connection variable>.ListStoredElement
Versions 15 and later h3G New in version 15 h3G h3G	Type of network to simulate: 3G	<Connection variable>.SimulateNetwork
hAcceptOpenedFile	Allows you to read the source file that will be added to the memo if this source file is opened in write mode somewhere else.	<Source>.LinkMemo
hAccessHF7	Pseudo-connection to HFSQL Classic database.	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessHFClientServer	Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, <Connection variable>.OpenConnection
hAccessJDBCSQLServer	Access to a SQL Server database via a JDBC driver	HDescribeConnection, <Connection variable>.OpenConnection
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	<Connection variable>.SetServer
hActiveSyncFrame	The size of the frame is optimized to be used with Mobile devices.	HCS.FrameSize
hActivityStatisticsPath	Path of the directory containing the activity statistics	<Connection variable>.SetServer
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	<Connection variable>.SetServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	<Connection variable>.SimulateNetwork
hAffectBrowse	Addition affecting the current browse	<Source>.Add, <Source>.Modify
hAllowed	The relevant rights are granted to the user or group.	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hANSIFormat	Data format: Ansi format (used by Windows)	..Format
hApplication	Property of a database found on an HFSQL server: Name of the application from which the database was created.	HInfoDatabaseProperty, HInfoFileProperty
Versions 18 and later hAutoStatisticalCalc New in version 18 hAutoStatisticalCalc hAutoStatisticalCalc	Enable the automatic calculation of statistics for the data files (optimization of indexes).	<Connection variable>.SetServer
Versions 15 and later hBackgroundTask New in version 15 hBackgroundTask hBackgroundTask	Perform the process in background task without locking the data file (available for the data files in Client/Server mode).	<Source>.StatCalculate, <Source>.Index
hBackupCanceled	Status of backup: Backup canceled	<Connection variable>.InfoBackup
hBackupCompleted	Status of backup: Backup completed	<Connection variable>.InfoBackup
Versions 15 and later hBackupDifferential New in version 15 hBackupDifferential hBackupDifferential	Type of backup: Differential backup	<Connection variable>.InfoBackup
hBackupError	Status of backup: Error during backup	<Connection variable>.InfoBackup
Versions 15 and later hBackupFull New in version 15 hBackupFull hBackupFull	Type of backup: Full backup	<Connection variable>.InfoBackup
hBackupInProgress	Status of backup: Backup in progress	<Connection variable>.InfoBackup
hBoundSeparator	Used to separate the values of lower and upper bounds for the components of composite key	<Source>.FilterIncludedBetween
Versions 21 and later hCacheNbUnusedFiles New in version 21 hCacheNbUnusedFiles hCacheNbUnusedFiles	Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server.	<Connection variable>.SetServer
hCardinality	Integrity constraints: Check the link cardinalities.	<Connection variable>.SetIntegrity
hChangeCharset	The character set defined by ChangeCharset will be taken into account in the new data file. The sorts, the searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.	<Source>.Creation, <Source>.CreationIfNotFound, <Source>.Index
hCheckDuplicates	Checks for duplicates for this action, even if the duplicate check is disabled (<Source>.SetDuplicates)	<Source>.Add, <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.Modify
hCheckIntegrity	Checks the integrity of operation even if the automatic integrity check is disabled (<Connection variable>.SetIntegrity)	<Source>.Add, <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.Modify, <HFSQL file>.Cross, <Source>.Delete
hCheckMemo	Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos)	<Source>.Index
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, <Connection variable>.OpenConnection
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	<Source>.CheckStructure
hComputer	Property of a database found on an HFSQL server: Name of the computer from which the element was created.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty
hCopyAutoId	Copies the automatic identifier while keeping its value	<Source>.CopyRecord, <Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	<Connection variable>.CopyFile
hCopyIndex	Copies the index of the data file	<Connection variable>.CopyFile
hCorrespondence	Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions	HInfoLog
hCreateIndex	The index of the data file is not copied. It is automatically recreated at the destination by reindexing.	<Connection variable>.CopyFile
hCreator	Property of a database found on an HFSQL server: Name of database owner.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty
Versions 24 and later hCryptAES128 New in version 24 hCryptAES128 hCryptAES128	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
Versions 19 and later hCryptAuto New in version 19 hCryptAuto hCryptAuto	File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptNo	No file encryption.	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptRC5_12	The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptRC5_16	The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptStandard	The memo file is encrypted according to an optimized encryption algorithm on 128 bits.	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCurrentRecNum	Number of the current record.	HFSQL functions
hDaemonUser	User name that will be used by the server (Linux only)	<Connection variable>.SetServer
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	<Connection variable>.RegenerateFile
hDatabasePath	Path of directory containing all databases	<Connection variable>.SetServer
hDate	Property of a database found on an HFSQL server: Creation date of the database.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty
Versions 20 and later hDateLastRefresh New in version 20 hDateLastRefresh hDateLastRefresh	Requested information: Date of the last successful refresh for the materialized view.	Versions 20 and later <Connection variable>.InfoView New in version 20 <Connection variable>.InfoView <Connection variable>.InfoView
hDBASCII	Sort according to ASCII order	HDBSortType
hDBLexicographic	Sort according to the lexicographic order	HDBSortType
hDebuggingPort	Port used to debug the stored procedures and the server triggers.	<Connection variable>.SetServer
hDecreasing	Sort performed in descending order	..SortType
hDefault	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the values of the requested rights (in the same order).	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights
hDefaultFrame	The standard size will be used by default.	HCS.FrameSize
hDefaultVal	The items of destination record that are not affected by the copy are initialized with their default value. For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value.	<Source>.CopyRecord, <Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hDelayedOpening	Optimize the opening of existing files: If the file already exists, it will be opened during the first access to the file. The file is created if it does not exist.	<Source>.CreationIfNotFound
hDeleteLog	Deletes the log file	<Connection variable>.DeleteFile, <Connection variable>.DeleteDatabase
hDestroyLink	Deletes all links related to the deleted data file.	<Connection variable>.DeleteFile
hDetails	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the rights and there value.	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights
hDisconnection	Configures the disconnection message	HOnServerCall
hDisk	Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case	<Source>.ChangeLocation, <Source>.Declare
hDistinct	Management of duplicates during the browse: If duplicates are found when a browse is performed on a key item, a single record is browsed	<Source>.Forward, <Source>.ReadPrevious, <Source>.ReadNext, <Source>.Previous, <Source>.Backward, <Source>.Next
hDuplicateKey	Characteristics of an item: Key with duplicates	..KeyType
hDynamicCursor	Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users.	HDescribeConnection, <Connection variable>.OpenConnection
hEffective	The rights returned correspond to the rights that will be actually granted to the user or to the group on the database. The inherited rights are taken into account (rights granted to the groups to which the user belongs for example).	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights
hErrADO	Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.	HErrorInfo
hErrADOMessage	Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO)	HErrorInfo
hErrAll	Customize all the errors	<Source>.OnError
hErrBase	Type of information about the error to return: Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant	HErrorInfo
hErrBaseMessage	Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase)	HErrorInfo
hErrClientInfo	Information about the client layer used by the Native Connector that returned the error.	HErrorInfo
hErrConnectionLoss	Customize the errors caused by a loss of connection with the server.	<Source>.OnError
hErrCurrent	Type of information about the error to return: Number of the current error	HError
hErrDatabaseAccess	Configure the access errors to an HFSQL Client/Server database.	<Source>.OnError
hErrDebugInfo	Type of information about the error to return: Specific information for debugging the problem that occurred. This information should only be displayed and communicated on express demand from PC SOFT. When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database.	HErrorInfo
hErrDuplicates	Customize duplicate errors	<Source>.OnError
hErrFIC	Type of information about the error to return: Full name of the data file associated with the error	HErrorInfo
hErrFile	Type of information about the error to return: Logical name of data file associated with the error	HErrorInfo
hErrFullDetails	Type of information about the error to return: Full error details (error line, current process, etc.) Remark: Returns the same information as the one retrieved when clicking the "Copy" button in the error window of WLanguage.	HErrorInfo
hErrIndex	Customize the reindexing errors (reindexing operation in progress during the access to the data file)	<Source>.OnError
hErrIntegrity	Customize integrity errors	<Source>.OnError
hErrItem	Type of information about the error to return: Name of item associated with the error	HErrorInfo
hErrLink	Type of information about the error to return: Name of link associated with the error	HErrorInfo
hErrLock	Customize lock errors	<Source>.OnError
hErrLockInfo	Type of information about the error to return: Information about the lock	HErrorInfo
hErrMain	Type of information about the error to return: Number of the main error	HError
hErrMessage	Type of information about the error to return: Message associated with the error	HErrorInfo
hErrMMO	Type of information about the error to return: Full name of the memo file associated with the error	HErrorInfo
hErrModify	Customize a modification conflict	<Source>.OnError
hErrNative	Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used	HErrorInfo
hErrNativeMessage	Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector.	HErrorInfo
hErrNDX	Type of information about the error to return: Full name of the index file associated with the error	HErrorInfo
hErrNeedValue	Customize the errors caused by a mandatory input with no data (OLE DB only).	<Source>.OnError
hErrOLEDB	Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection.	HErrorInfo
hErrOLEDBMessage	Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)	HErrorInfo
Versions 20 and later hErrorLastRefresh New in version 20 hErrorLastRefresh hErrorLastRefresh	Requested information: Last error while refreshing the materialized view.	Versions 20 and later <Connection variable>.InfoView New in version 20 <Connection variable>.InfoView <Connection variable>.InfoView
hErrPassword	Customize password errors	<Source>.OnError
Versions 20 and later hErrPositionSQLError New in version 20 hErrPositionSQLError hErrPositionSQLError	Type of information about the error to return: Position of the SQL error in the SQL code of the query run by <HFSQL file>.ExecuteSQLQuery.	HErrorInfo
hErrRecNum	Type of information about the error to return: Number of the record associated with the error	HErrorInfo
hErrServer	Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error	HErrorInfo
hErrServerInfo	Information about the server used by the Native Connector that returned the error.	HErrorInfo
hErrSystemCode	Type of information about the error to return: Number of the associated system error	HErrorInfo
hErrSystemMessage	Type of information about the error to return: Message of associated system error	HErrorInfo
hErrWDD	Type of information about the error to return: Full name of the analysis file associated with the error	HErrorInfo
hExisting	Type of search: Only the assignments for which a file actually exists	HListREP
hExpBreakable	Mode for creating the export file: The export can be interrupted by pressing Esc. If the export is interrupted, the export file is valid and it only contains the records exported before the interruption.	<Source>.ExportXML Versions 21 and later <Source>.ExportJSON New in version 21 <Source>.ExportJSON <Source>.ExportJSON Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
hExpCreation	Mode for creating the export file: The file is overwritten if it already exists.	<Source>.ExportXML Versions 21 and later <Source>.ExportJSON New in version 21 <Source>.ExportJSON <Source>.ExportJSON Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
Versions 24 and later hExpNoLineItemName New in version 24 hExpNoLineItemName hExpNoLineItemName	Mode for creating the CSV/XLSX file: The first line of the generated file will not contain the names of the items.	Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
hExpNormal	Mode for creating the export file: Standard operating mode	<Source>.ExportXML Versions 21 and later <Source>.ExportJSON New in version 21 <Source>.ExportJSON <Source>.ExportJSON Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
hExpWithoutXSL	The style sheet (".XSL" file) is not created	<Source>.ExportXML
hFicSize	Size of data file in bytes (".Fic" file)	<Source>.InfoFile
hFileAS400	Type of file: AS400 file	..Type
hFileClientServer	Type of file: HFSQL Client/Server file	..Type
hFileHF5	Type of file: Hyper File 5 file	..Type
hFileMySQL	Type of file: MySQL file	..Type
hFileNormal	Type of file: Standard file (HFSQL Classic)	..Type
hFileOLEDB	Type of file: OLEDB file	..Type
hFileOracle	Type of file: ORACLE file	..Type
hFileOracleLite	Type of file: ORACLE Lite file	..Type
hFileOther	Type of file: Other type of file	..Type
Versions 15 and later hFilePostgreSQL New in version 15 hFilePostgreSQL hFilePostgreSQL	Type of file: PostgreSQL file	..Type
hFileProgress	Type of file: Progress file	..Type
hFileQuery	Type of file: Query	..Type
hFileQueryAS400	Type of file: Query on an AS/400 database	..Type
hFileQueryClientServer	Type of file: Query on an HFSQL Client/Server database	..Type
hFileQueryMySQL	Type of file: Query on a MySQL database	..Type
hFileQueryOLEDB	Type of file: Query on a database accessed via an OLE DB provider	..Type
hFileQueryOracle	Type of file: Query on an Oracle database	..Type
hFileQueryOracleLite	Type of file: Query on an Oracle Lite database	..Type
Versions 15 and later hFileQueryPostgreSQL New in version 15 hFileQueryPostgreSQL hFileQueryPostgreSQL	Type of file: Query on a PostgreSQL database	..Type
hFileQueryProgress	Type of file: Query on a Progress database	..Type
Versions 16 and later hFileQuerySQLAzure New in version 16 hFileQuerySQLAzure hFileQuerySQLAzure	Type of file: Query on an SQL Azure database	..Type
hFileQuerySQLServer	Type of file: Query on an SQL Server database	..Type
hFileQuerySQLServerMobile	Type of file: Query on an SQL Server Mobile database	..Type
hFileQuerySybase	Type of file: Query on a Sybase database	..Type
hFileQueryXML	Type of file: Query on an XML database	..Type
hFileSQL	Type of file: SQL file	..Type
Versions 16 and later hFileSQLAzure New in version 16 hFileSQLAzure hFileSQLAzure	Type of file: SQL Azure file	..Type
Versions 16 and later hFileSQLite New in version 16 hFileSQLite hFileSQLite	Type of file: SQLite file	..Type
hFileSQLServer	Type of file: SQL Server file	..Type
hFileSQLServerMobile	Type of file: SQL Server Mobile file	..Type
hFileSybase	Type of file: Sybase file	..Type
hFileTemporary	Type of file: Temporary file	..Type
hFileView	Type of file: HFSQL view	..Type
hFileXBase	Type of file: xBase file	..Type
hFileXML	Type of file: XML file	..Type
Versions 22 and later hFindKey New in version 22 hFindKey hFindKey	Enable the search for keys on the HFSQL server.	<Connection variable>.SetServer
hForbidden	The relevant rights are not granted to the user or group	<Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights, <Connection variable>.ModifyServerRights
Versions 17 and later hForwardOnly New in version 17 hForwardOnly hForwardOnly	Native Connectors only: Used to speed up the browse of data during a simple browse that does not use the following features: Reading the previous record. Modifying a record. Saving position. If one of these features is used, the result may differ from the expected one. This constant can be used for example during a browse used to fill a memory Table control.	<Source>.ReadLast, <Source>.ReadFirst, <Source>.ReadSeekFirst, <Source>.ReadSeekLast
hForwardOnlyCursor	Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible.	HDescribeConnection, <Connection variable>.OpenConnection
Versions 20 and later hftPunctuationSimple New in version 20 hftPunctuationSimple hftPunctuationSimple	Full-text Index item described by programming: Taking into account the simple punctuation characters (non Unicode).	..Option property of FullTextIndex description variables.
Versions 20 and later hftPunctuationUnicode New in version 20 hftPunctuationUnicode hftPunctuationUnicode	Full-text Index item described by programming: Taking into account the Unicode punctuation characters.	..Option property of FullTextIndex description variables.
hFTX	Reindexing full-text indexes	<Source>.Index
hFtxSize	Size of full-text index file in bytes (".Ftx" file)	<Source>.InfoFile
HGeneric	Type of search: Generic search	<Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.SeekLast, <Source>.SeekFirst
hGPRSFrame	The frame size is optimized for a use via GPRS	HCS.FrameSize
hHCreationIfNotFound	Type of test to run to check the connection: Checks the connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only.	HConnect
hHOpen	Type of test to run to check the connection: Checks the connection by opening a file. This value is used by default when accessing to an hORead database.	HConnect
hIdentical	The structures of files (read in the analysis and in the physical file) must be strictly identical.	<Source>.ReadSeek, <Source>.Seek, <Source>.CheckStructure
hIgnoreDuplicates	Ignores the duplicate check for this operation, even if the automatic duplicate check is enabled (<Source>.SetDuplicates)	<Source>.Add
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (<Connection variable>.SetIntegrity)	<Source>.Add, <Source>.Modify, <Source>.Delete, <HFSQL file>.Cross
hImpBreakable	The import can be interrupted by pressing ESC.	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS, New in version 20 <Source>.ImportXLS, <Source>.ImportXLS, <Source>.ImportXML Versions 21 and later <Source>.ImportJSON New in version 21 <Source>.ImportJSON <Source>.ImportJSON
hImpConversion	Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated.	<Source>.ImportHF55
hImpCreation	Type of import: If the (HFSQL Classic) import file exists, it is overwritten.	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS, New in version 20 <Source>.ImportXLS, <Source>.ImportXLS, <Source>.ImportXML Versions 21 and later <Source>.ImportJSON New in version 21 <Source>.ImportJSON <Source>.ImportJSON
hImpIgnoreEmptyItem	If one or more items are not filled in the text file, the corresponding lines are still imported. The missing items contain: the default value of items if the hDefaultVal constant is specified. the value of items in the current record before the call to <Source>.ImportText.	<Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
Versions 20 and later hImpIgnoreFirstLine New in version 20 hImpIgnoreFirstLine hImpIgnoreFirstLine	Type of import: The first row of the imported file is ignored.	<Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hImpIgnoreInvalidLine	Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing.	<Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hImpIgnoreItem	Type of import: The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value. The items of imported file (Hyper File 5.5) with no match in the import file are ignored.	<Source>.ImportHF55
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	<Source>.ImportText
hImpNormal	Type of import: The import is not performed and an error occurs in the following cases: items found in the Hyper File 5.5 file with no match in the HFSQL Classic file. associated items in the two files but with a different size and/or format. If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created. No management of integrity and no management of duplicates. The non-imported items take the value of the current record. The automatic identifiers are recalculated.	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS, New in version 20 <Source>.ImportXLS, <Source>.ImportXLS, <Source>.ImportXML Versions 21 and later <Source>.ImportJSON New in version 21 <Source>.ImportJSON <Source>.ImportJSON
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	<Source>.ImportHF55
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	<Source>.ImportText
hImpTestDuplicates	Type of import: Checks the duplicates during the import	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hImpTestIntegrity	Type of import: Checks the integrity during the import	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hInaccessible	Undefined server status	HServerStatus
hIncreasing	Sort performed in ascending order	..SortType
hInfiniteCardinality	Maximum cardinality ("N")	..MaxLinkedCardinality, ..MaxSourceCardinality
hInfoAll	Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate). The different values are separated by CR characters (Carriage Return).	<Connection variable>.InfoServer
Versions 15 and later hInfoCluster New in version 15 hInfoCluster hInfoCluster	Information about the HFSQL cluster.	<Connection variable>.InfoServer
hInfoDate	Date and time of server on 8 bytes in UTC format (universal time)	<Connection variable>.InfoServer
Versions 22 and later hInfoFreeDiskSpace New in version 22 hInfoFreeDiskSpace hInfoFreeDiskSpace	Available space on the server disk, expressed in MB.	<Connection variable>.InfoServer
hInfoHardware	Information about the hardware used: Type of processor (for example: Intel Pentium) Size of server RAM (for example: 630 MB) This information is returned in the following format: <Type of CPU> = TAB + <Size of server RAM>	<Connection variable>.InfoServer
hInfoLogicalName	Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center.	<Connection variable>.InfoServer
hInfoName	Name of server (DNS)	<Connection variable>.InfoServer
hInfoPlatform	Information about the server platform: Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX System version: corresponds to Service Pack in Windows or empty string if no Service Pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example). This information is returned in the following format: <System name> + TAB + <Version>	<Connection variable>.InfoServer
Versions 19 and later hInfoSizeCacheNdxUsed New in version 19 hInfoSizeCacheNdxUsed hInfoSizeCacheNdxUsed	Size of index cache that is actually used on the server, expressed in MB.	<Connection variable>.InfoServer
Versions 22 and later hInfoTotalDiskSpace New in version 22 hInfoTotalDiskSpace hInfoTotalDiskSpace	Total capacity of server disk, expressed in MB.	<Connection variable>.InfoServer
hInfoVersion	Information about the version of programs required for the server to operate: Version of Manta.exe or Manta in Linux Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux) Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux) This information is returned in the following format: <Manta version> + TAB + <HFSQL version> +TAB + <SQL version<	<Connection variable>.InfoServer
hInfoVersionDetails	Detailed information about the version of the programs required to operate the server: <Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date> The listed elements are as follows: Manta.exe or Manta in Linux HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux) SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux) Management of logs (HFLogger.exe) MantaManager the framework required to operate the server. This information is returned in the following format: <Manta version> + TAB + <HFSQL version> +TAB + <SQL version<	<Connection variable>.InfoServer
hInfoVI	Version number of Manta.exe or Manta in Linux	<Connection variable>.InfoServer
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	<Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights, <Connection variable>.ModifyServerRights
hIntegrityCascade	Modification/Deletion rule: Cascading modification/deletion	..ModificationRule, ..DeletionRule
hIntegrityDefaultValue	Modification/Deletion rule: Default modification/deletion	..ModificationRule, ..DeletionRule
hIntegrityForbidden	Modification/Deletion rule: Modification/Deletion not allowed	..ModificationRule, ..DeletionRule
hIntegrityNone	Modification/Deletion rule: No integrity management	..ModificationRule, ..DeletionRule
hInternetFrame	The frame size is optimized for a use via Internet	HCS.FrameSize
hInternetPageSize	Size of page for using the RPC via Internet.	Remote access (RPC on HFSQL)
hIntranetFrame	The frame size is optimized for a use via Intranet	HCS.FrameSize
hIntranetPageSize	Size of page for using the RPC via Intranet.	Remote access (RPC on HFSQL)
hInvalidRecNum	Constant returned if there is no current record or if the specified file corresponds to a multi-file query.	<Source>.RecNum
hItemBinary	Item type: Binary	..Type
hItemBinaryMemo	Item type: Binary Memo	..Type
hItemBinaryMemo4	Item type: Binary memo (4 bytes)	..Type
hItemBoolean	Item type: Boolean	..Type
hItemCharacter	Item type: Character	..Type
Versions 20 and later hItemCombination New in version 20 hItemCombination hItemCombination	Item type: Combination	..Type
hItemCurrency	Item type: Currency	..Type
hItemDate6	Item type: Date	..Type
hItemDate8	Item type: Date	..Type
hItemDateTime	Item type: Date/Time	..Type
Versions 20 and later hItemEnumeration New in version 20 hItemEnumeration hItemEnumeration	Item type: Enumeration	..Type
hItemHour	Item type: Hour	..Type
hItemIdAuto	Item type: Automatic identifier (8 bytes)	..Type
hItemIdAuto4	Item type: Automatic identifier (4 bytes)	..Type
hItemInteger1	Item type: 1-byte integer	..Type
hItemInteger2	Item type: 2-byte integer	..Type
hItemInteger4	Item type: 4-byte integer	..Type
hItemInteger8	Item type: 8-byte integer	..Type
hItemInvalid	Invalid type of item	..Type
Versions 24 and later hItemJSON New in version 24 hItemJSON hItemJSON	Item type: JSON	..Type
hItemNumeric	Item type: High-precision numeric	..Type
hItemNumRec	Item type: Record number	..Type
hItemPicture	Item type: Image	..Type
hItemReal4	Item type: 4-byte real	..Type
hItemReal8	Item type: 8-byte real	..Type
hItemRealTurbo	Item type: Turbo real	..Type
hItemText	Item type: Text	..Type
hItemTextMemo	Item type: Text Memo	..Type
hItemTimeLength	Item type: Duration	..Type
hItemUnicodeMemo	Item type: Unicode Text Memo	..Type
hItemUnicodeText	Item type: Unicode text	..Type
hItemUnsignedInteger1	Item type: Unsigned 1-byte integer	..Type
hItemUnsignedInteger2	Item type: Unsigned 2-byte integer	..Type
hItemUnsignedInteger4	Item type: Unsigned 4-byte integer	..Type
hItemUnsignedInteger8	Item type: Unsigned 4-byte integer	..Type
Versions 24 and later hItemUUID128 New in version 24 hItemUUID128 hItemUUID128	Item type: UUID 128	..Type
Versions 24 and later hItemUUID128Auto New in version 24 hItemUUID128Auto hItemUUID128Auto	Item type: UUID 128 automatic identifier	..Type
Versions 24 and later hItemUUID256 New in version 24 hItemUUID256 hItemUUID256	Item type: UUID 256	..Type
Versions 24 and later hItemUUID256Auto New in version 24 hItemUUID256Auto hItemUUID256Auto	Item type: UUID 256 automatic identifier	..Type
hJNLBackupPath	Path of the directory containing the backups of the logs	<Connection variable>.SetServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	<Connection variable>.SetServer
Versions 23 and later hkaInterval New in version 23 hkaInterval hkaInterval	Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client.	<Connection variable>.SetServer
Versions 23 and later hkaTimeout New in version 23 hkaTimeout hkaTimeout	Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected.	<Connection variable>.SetServer
hKeepFilter	The filter set by HFilter will be taken into account, even if the search key is not optimized for the filter. Reminder: HFilter returns the search key optimized for the filter. Caution: in this case, performance problems may occur on large files.	<Source>.ChangeKey, <Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.ReadSeek, HFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst
hKeepTRS	Stores the transaction files during the deletion	<Connection variable>.DeleteDatabase, <Connection variable>.DeleteFile
Versions 17 and later hLanguageBinarySort New in version 17 hLanguageBinarySort hLanguageBinarySort	The sort will be performed by comparing the binary value of the bytes. This type of sort is very fast. It should be used to perform an exact-match search for example.	..Language, ..LanguageDescribed, H.LanguageCreationUnicode
hLanguageCreation	Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation".	..Language, ..LanguageDescribed
Versions 17 and later hLanguageFastSort New in version 17 hLanguageFastSort hLanguageFastSort	The sort will be performed by comparing the characters one by one according to a generic sort.	..Language, ..LanguageDescribed, H.LanguageCreationUnicode
hlbActive	Enable or disable the load balancing	<Connection variable>.SetServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	<Connection variable>.SetServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	<Connection variable>.SetServer
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	<Connection variable>.SetServer
hlbMaxTimeout	Value modifying the maximum time-out for a server request	<Connection variable>.SetServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	<Connection variable>.SetServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	<Connection variable>.SetServer
hLimitParsing	Limits the file browse: The browse will stop as soon as the last sought value is found. The current record will correspond to this last record found. <Source>.Found will be set to False and <Source>.Out will be set to True. This constant is used to optimize the search speed in client/server mode.	<Source>.ReadSeek, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst
hLockNo	Type of lock: No lock	<Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLockReadWrite	Type of lock: Lock in read/write	<Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLockWrite	Type of lock: Lock in write mode	<Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLogIdentification	Configures the file to re-create: Re-creates the "JournalIdentification.fic" file.	<Source>.LogRecreate
hLogJNLFile	Configures the file to re-create: Only <File name>JNL.FIC is recreated.	<Source>.LogRecreate
hLogLevel	Defines the elements that must be found in the log file	<Connection variable>.SetServer
hLogNo	Format of log process: No log	..LogMethod
hLogOperation	Configures the file to re-create: Re-creates the "JournalOperation.fic" file.	<Source>.LogRecreate
hLogPath	Path of the directory containing the log files	<Connection variable>.SetServer
hLogReadingWriting	Format of log process: Log the read and write operations performed in the file	..LogMethod
hLogUser	Configures the file to re-create: Re-creates the log of users ("UserLog.fic"). This file exists in HFSQL Client/Server only. This file contains the information (login, computer, ...) about the users who perform the logged actions.	<Source>.LogRecreate
hLogWriting	Format of log process: Log the write operations performed in the file	..LogMethod
Versions 20 and later hlpBackup New in version 20 hlpBackup hlpBackup	Type of scheduling to list: Scheduling of backups.	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpCalcStat New in version 22 hlpCalcStat hlpCalcStat	Type of operation performed on the server: statistical calculation.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpKeyDetection New in version 22 hlpKeyDetection hlpKeyDetection	Type of operation performed on the server: detection of keys.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpMaterializedView New in version 20 hlpMaterializedView hlpMaterializedView	Type of scheduling to list: Tasks for refreshing the materialized views.	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpOptimization New in version 20 hlpOptimization hlpOptimization	Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation).	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpReplication New in version 22 hlpReplication hlpReplication	Type of operation performed on the server: server replication.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpTask New in version 20 hlpTask hlpTask	Type of scheduling to list: Scheduled tasks that run a stored procedure.	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
hLstAll	Lists all the keys, all the files, all the items or all the connections	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection, <Connection variable>.ListStoredElement
hLstCompositeKey	Lists the composite key items only	<Source>.ListKey, <Source>.ListItem
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	<Connection variable>.ListDatabase
hLstDetail	Lists the detailed information	<Source>.ListKey, HListFile, <Source>.ListLink, <Source>.ListItem, HListConnection, <Connection variable>.ListStoredElement
hLstDetailPlus	For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part.	<Source>.ListKey, <Source>.ListItem
hLstFile	Lists the databases and their files for the server defined by the connection	<Connection variable>.ListDatabase
hLstItem	Lists the non-key and non-memo items	<Source>.ListItem
hLstKey	Lists the key items	<Source>.ListKey, <Source>.ListItem
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	<Source>.ListKey, <Source>.ListItem
Versions 20 and later hLstMaterializedView New in version 20 hLstMaterializedView hLstMaterializedView	Lists the materialized views found on an HFSQL server.	HListFile
hLstMemo	Lists the memo items	<Source>.ListItem
hLstNormal	Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically.	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection
hLstOpened	Stores the opened connections only	HListConnection
hLstOriginalItem	Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file.	<Source>.ListKey, <Source>.ListItem
hLstQuery	Lists the queries found on a server Versions 19 and later Lists the queries that have been run. New in version 19 Lists the queries that have been run. Lists the queries that have been run.	<Connection variable>.ListStoredElement HListFile
hLstSet	Lists the sets of procedures found on a server	<Connection variable>.ListStoredElement
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, <Connection variable>.ListStoredElement
hLstSystemTable	List of system tables for a connection via Native Connectors or OLE DB	HListFile
hLstTable	List of user tables for a connection via Native Connectors or OLE DB	HListFile
hLstView	List the views of a connection via Native Connectors or OLE DB. Versions 20 and later List the SQL views on an HFSQL server. New in version 20 List the SQL views on an HFSQL server. List the SQL views on an HFSQL server.	HListFile
hMasterReplica	Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica)	..Replication
hMaxActivityStatisticsSize	Maximum size in megabytes (MB) of files for activity statistics	<Connection variable>.SetServer
hMaxLogSize	Maximum size in megabytes (MB) of log files	<Connection variable>.SetServer
Versions 24 and later hMaxNumberConnection New in version 24 hMaxNumberConnection hMaxNumberConnection	Maximum number of connections allowed per application.	<Connection variable>.SetServer
hMaxVal	Defines an upper bound for a filter	<Source>.BuildKeyValue, <Source>.Filter, <Source>.FilterStartsWith, <Source>.FilterIncludedBetween
hMemoAuto	The memos are read during the access to the item	<Source>.SetMemo
hMemoBin	Type of file used for the memo: Any binary file	<Source>.LinkMemo
hMemoImg	Type of file used for the memo: Image file	<Source>.LinkMemo
hMemoNo	No management of memos	<Source>.SetMemo
hMemoOle	Type of file used for the memo: OLE file	<Source>.LinkMemo
hMemoWav	Type of file used for the memo: sound file	<Source>.LinkMemo
hMemoYes	The text memos are read whenever the record is read. Read the binary memos when accessing the item.	<Source>.SetMemo
hMessage	Configure the information message	HOnServerCall
hMinVal	Defines a lower bound for a filter	<Source>.BuildKeyValue, <Source>.Filter, <Source>.FilterStartsWith, <Source>.FilterIncludedBetween
Versions 20 and later hMmoCompact New in version 20 hMmoCompact hMmoCompact	Compression and defragmentation of "Mmo" files.	<Source>.Index
hMmoSize	Size of memo file in bytes (".Mmo" file)	<Source>.InfoFile
hMode2GB	Indicates whether the system files support more than 2 GB	<Connection variable>.SetServer
hModeDirect	Priority implementation of locks	<Source>.Mode
hModeMono	Single-user lock mode	<Source>.Mode
hModeMulti	Multi-user lock mode	<Source>.Mode
hModeReservation	Non-priority implementation of locks	<Source>.Mode
hModifyFile	When modifying the query result, these modifications will be applied to the files belonging to the query. If this option is not specified, only the query result is modified.	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
Versions 17 and later hmsBackgroundTask New in version 17 hmsBackgroundTask hmsBackgroundTask	A hot automatic modification is performed (available for the HFSQL Client/Server data files only).	Versions 17 and later <Source>.ModifyStructure New in version 17 <Source>.ModifyStructure <Source>.ModifyStructure
Versions 17 and later hmsNoCheck New in version 17 hmsNoCheck hmsNoCheck	The automatic data modification is performed even if the file description is more recent than the analysis description.	Versions 17 and later <Source>.ModifyStructure New in version 17 <Source>.ModifyStructure <Source>.ModifyStructure
Versions 17 and later hmsNormal New in version 17 hmsNormal hmsNormal	Standard operating mode of the automatic data modification.	Versions 17 and later <Source>.ModifyStructure New in version 17 <Source>.ModifyStructure <Source>.ModifyStructure
hNativeAccessAS400	Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessDB2	OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessInformix	OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 20 and later hNativeAccessMariaDB New in version 20 hNativeAccessMariaDB hNativeAccessMariaDB	OLE DB provider that will be used for the connection: Native MariaDB Connector (optional module of WINDEV/WEBDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessMySQL	OLE DB provider that will be used for the connection: Native MySQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessOracle	OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessOracleLite	Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessPostgreSQL	OLE DB provider that will be used for the connection: Native PostgreSQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessProgress	OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 16 and later hNativeAccessSQLAzure New in version 16 hNativeAccessSQLAzure hNativeAccessSQLAzure	OLE DB provider that will be used for the connection: Native SQL Azure Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 15 and later hNativeAccessSQLite New in version 15 hNativeAccessSQLite hNativeAccessSQLite	OLE DB provider that will be used for the connection: Native Connector to an SQLite database	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSQLServer	OLE DB provider that will be used for the connection: Native SQL Server Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSQLServerMobile	Provider that will be used for the connection: Native SQL Server Mobile Connector (optional module of WINDEV Mobile)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSybase	OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXBase	OLE DB provider that will be used for the connection: Native xBase Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXML	Provider that will be used for the connection: Native XML Connector (supplied with WINDEV/WEBDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	<Connection variable>.SetServer
hNdxCompact	Re-index operation with compression	<Source>.Index
hNdxDelete	Reindex and delete damaged records	<Source>.Index
hNdxMinimal	Re-index operation while ignoring the corrupted keys	<Source>.Index
hNdxNormal	Standard re-index operation	<Source>.Index
hNdxNoStat	Reindex without statistical calculation	<Source>.Index
hNdxSilent	Configure the re-index operation: No display while re-indexing	<Source>.Index
hNdxSize	Size of index file in bytes (".Ndx" file)	<Source>.InfoFile
hNoBind	Run a query without enabling the bind	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.PrepareSQLQuery
hNoCheck	No check is performed, the analysis description may differ from the description of physical file.	<Source>.CheckStructure
hNoError	No error occurred	HError
Versions 21 and later hNoHourglass New in version 21 hNoHourglass hNoHourglass	When reading the query result, this read operation may be locked and a hourglass appears by default. This constant is used not to display the hourglass in this case.	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hNoIndex	The file index is not copied	<Connection variable>.CopyFile
hNoLink	Management of integrity: The links are not updated on the server (creation, modification or deletion). Reminder: by default, the links are updated on the server when creating a file.	<Source>.Creation, <Source>.CreationIfNotFound
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	<Connection variable>.SimulateNetwork
hNoRefresh	The table or query content will not be refreshed	<Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.First
hNotAKey	Characteristics of an item: Non-key item	..KeyType
hNotes	Property of a database found on an HFSQL server: Database description or any other information associated with the database by <Connection variable>.ModifyDatabaseProperty.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.InfoServerProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty, <Connection variable>.ModifyServerProperty
Versions 18 and later hNotifCCClassic New in version 18 hNotifCCClassic hNotifCCClassic	The notifications are sent by the Control Centers in HFSQL Classic mode.	Versions 18 and later <Connection variable>.NotifConfigure New in version 18 <Connection variable>.NotifConfigure <Connection variable>.NotifConfigure
Versions 18 and later hNotifCCCS New in version 18 hNotifCCCS hNotifCCCS	The notifications are sent by the Control Centers in Client/Server mode.	Versions 18 and later <Connection variable>.NotifConfigure New in version 18 <Connection variable>.NotifConfigure <Connection variable>.NotifConfigure
Versions 18 and later hNotifCritical New in version 18 hNotifCritical hNotifCritical	The notifications will be sent from the critical level (for the critical and error problems).	Versions 18 and later <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient New in version 18 <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
Versions 18 and later hNotifEmail New in version 18 hNotifEmail hNotifEmail	The notifications are sent by email.	Versions 18 and later <Connection variable>.NotifConfigure New in version 18 <Connection variable>.NotifConfigure <Connection variable>.NotifConfigure
Versions 18 and later hNotifError New in version 18 hNotifError hNotifError	The notifications will be sent for the error problems only.	Versions 18 and later <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient New in version 18 <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
Versions 22 and later hNotifInformation New in version 22 hNotifInformation hNotifInformation	The notifications will be sent from the information level (for the information, warning, critical and error problems)	<Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
Versions 18 and later hNotifWarning New in version 18 hNotifWarning hNotifWarning	The notifications will be sent from the warning level (for the warning, critical and error problems).	Versions 18 and later <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient New in version 18 <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
hNotLocking	Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To find out whether the execution of the view or query is completed, use ..ExecutionCompleted. This constant is available for the views and queries in HFSQL Classic or Client/Server. This constant has no effect for the data files and for the Native Connectors	<Source>.NbRec
hNotReplicated	Replication mode: The data file is not configured for replication. To implement the replication, check "Replication" in the characteristics of the file in the data model editor.	..Replication
hNotSorted	Sort direction: Item not sorted	..SortType
hODBC	OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Used to access an ODBC source declared in the ODBC data sources of Windows	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbAccess2000	OLE DB provider that will be used for the connection: OLE DB provider for Access 2000	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbAccess2007	OLE DB provider that will be used for the connection: OLE DB provider for Access 2007	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
Versions 19 and later hOledbAccess2010 New in version 19 hOledbAccess2010 hOledbAccess2010	OLE DB provider that will be used for the connection: OLE DB provider for Access 2010	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbAccess97	OLE DB provider that will be used for the connection: OLE DB provider for Access 97	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbDBase5	OLE DB provider that will be used for the connection: OLE DB provider for dBase 5	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbExcel2000	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbExcel2007	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbExcel97	OLE DB provider that will be used for the connection: OLE DB provider for Excel 97	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbLotus4	OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbOracle	OLE DB provider that will be used for the connection: OLE DB provider for Oracle	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbSQLServer	OLE DB provider that will be used for the connection: OLE DB provider for SQL Server	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOnDelete	Integrity rule applied during a deletion	<Connection variable>.SetIntegrity
hOnUpdate	Integrity rule applied during a modification	<Connection variable>.SetIntegrity
hOpenKeysetCursor	Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions).	HDescribeConnection, <Connection variable>.OpenConnection
hOptimisticCursor	The record is locked when it is updated	HDescribeConnection, <Connection variable>.OpenConnection
Versions 15 and later hOptIndex New in version 15 hOptIndex hOptIndex	Optimization options: Provokes the re-indexing operation on the data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes.	hFileParameter variable
Versions 15 and later hOptStat New in version 15 hOptStat hOptStat	Optimization options: Provokes the recalculation of statistics on the data files.	hFileParameter variable
hORead	File accessible in read-only	..CtAccess, ..CtDescribedAccess, HConnect, <Source>.Open
hOReadWrite	File accessible in read/write	..CtAccess, ..CtDescribedAccess, HConnect, <Source>.Open
hOwner	Property of a database found on an HFSQL server: Owner of database.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty
hPackNo	Compression mode: No compression	..MmoPackMethod
hPackZLW	Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation.	..MmoPackMethod
hPageSize	Size of a block of caches. This block of caches will be used when browsing a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption.	HSetCache
hPessimisticCursor	The record is locked as soon as it becomes in edit to be modified.	HDescribeConnection, <Connection variable>.OpenConnection
hPrecisionHigh	Position with high precision	<Source>.GetCurrentPosition, <Source>.SetPosition
hPrecisionLow	Position with low precision	<Source>.GetCurrentPosition, <Source>.SetPosition
hPrecisionMedium	Position with medium precision	<Source>.GetCurrentPosition, <Source>.SetPosition
hQueryBreakable	The query initialization can be interrupted with the ESC key	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hQueryDefault	The query is initialized without interruption	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hQueryWithoutCorrection	Native Connector or OLE DB only: No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.)	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hQueryWithoutHFCorrection	HFSQL only The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters.	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
Versions 19 and later hReadCommitted New in version 19 hReadCommitted hReadCommitted	Isolation level of transaction: only the finalized transactions are visible by the other users.	Versions 19 and later <Connection variable>.TransactionIsolation New in version 19 <Connection variable>.TransactionIsolation <Connection variable>.TransactionIsolation
hReadOnlyCursor	The set of records cannot be modified.	HDescribeConnection, <Connection variable>.OpenConnection
Versions 19 and later hReadUncommitted New in version 19 hReadUncommitted hReadUncommitted	Isolation level of transaction: the non-finalized transactions are visible by the other users.	Versions 19 and later <Connection variable>.TransactionIsolation New in version 19 <Connection variable>.TransactionIsolation <Connection variable>.TransactionIsolation
hRecalculateIdAuto	Mode for calculating the automatic identifier: Automatic identifier re-calculated during the write operation	<Source>.Write, <Source>.Modify
hRecFile	Record to read: Value of the item currently saved in the data file	<Source>.ErrorModification, <Source>.ErrorStatusModification
Versions 22 and later hRecNumAll New in version 22 hRecNumAll hRecNumAll	Used to track all records found in a data file. Versions 23 and later Used to check all unaltered records New in version 23 Used to check all unaltered records Used to check all unaltered records	Versions 22 and later <Source>.Track, <Source>.TrackStop New in version 22 <Source>.Track, <Source>.TrackStop <Source>.Track, <Source>.TrackStop Versions 23 and later <Source>.CheckUnaltered New in version 23 <Source>.CheckUnaltered <Source>.CheckUnaltered
hRecRead	Record to read: Value of the item for the source record	<Source>.ErrorModification, <Source>.ErrorStatusModification
hRecUser	Record to read: Value of the item for the current record when performing the modification	<Source>.ErrorModification, <Source>.ErrorStatusModification
Versions 20 and later hRefreshInProgress New in version 20 hRefreshInProgress hRefreshInProgress	Requested information: Is the materialized view currently refreshed?	Versions 20 and later <Connection variable>.InfoView New in version 20 <Connection variable>.InfoView <Connection variable>.InfoView
Versions 19 and later hRepeatableRead New in version 19 hRepeatableRead hRepeatableRead	Isolation level of transaction: the application in transaction sees a snapshot of the database when the transaction starts.	Versions 19 and later <Connection variable>.TransactionIsolation New in version 19 <Connection variable>.TransactionIsolation <Connection variable>.TransactionIsolation
hReplicated	Replication mode: The data file is configured to be replicated.	..Replication
hRightsAll	List of all the rights	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights
hRightsAutoModif	Rights to perform the automatic modification of the data files on a file	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsBackup	Rights to save the data files	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoServerRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyServerRights
hRightsChangeLink	Rights to modify the integrity rules on a data file.	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsChangeOwner	Rights to modify the owner of an element	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsChangePassword	Rights to change the password of a user on the server (the user can change his own password and the administrator can change the password of each user).	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsChangeRights	Rights to change rights.	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights, <Connection variable>.ModifyServerRights
hRightsConnection	Rights to connect to a server (encrypted or unencrypted connection)	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsCreateDB	Rights to create a database	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsCreateFile	Rights to create a data file (with <Source>.Creation)	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
Versions 20 and later hRightsCreateView New in version 20 hRightsCreateView hRightsCreateView	Rights to create a SQL view or a materialized view.	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsDebug	Rights to debug the stored procedures.	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsDelete	Rights to delete the records from a data file	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsDeleteDB	Rights to delete a database	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsDeleteFile	Rights to delete a data file (<Connection variable>.DeleteFile)	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
Versions 20 and later hRightsDeleteView New in version 20 hRightsDeleteView hRightsDeleteView	Rights to delete a SQL view or a materialized view.	Versions 20 and later <Connection variable>.InfoViewRights, <Connection variable>.ModifyViewRights New in version 20 <Connection variable>.InfoViewRights, <Connection variable>.ModifyViewRights <Connection variable>.InfoViewRights, <Connection variable>.ModifyViewRights
hRightsDisconnectClient	Rights to disconnect the client computers.	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsEncryptedConnection	Rights to connect to a server (encrypted connection only)	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsInsert	Rights to add new records into a data file.	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsLock	Rights to lock the data files or the records of a data file.	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsMaintenance	Rights to start a re-index operation or to perform statistical calculations on a data file	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsManageDuplicate	Rights to enable and disable the management of duplicates.	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsManageIntegrity	Rights to enable and disable the management of integrity.	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsManageProcedure	Rights to add, modify and delete the stored procedures.	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsManageServer	Rights to use <Connection variable>.SetServer	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsManageTask	Rights to manage the scheduled tasks.	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsManageTrigger	Rights to manage the server triggers (addition, activation, deletion)	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsManageUser	Rights to delete and add users or groups	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsNoDatabaseAccess	Rights to prevent (or not) access to a database (<Connection variable>.NoDatabaseAccess and <Connection variable>.EndNoDatabaseAccess)	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsPriority	Rights to modify the priority of a client application	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsRead	Rights to read the records of a data file	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRightsReadLogStat	Rights to see the activity statistics and the logs of the server.	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsRunProcedure	Rights to run the stored procedures.	<Connection variable>.InfoDatabaseRights, <Connection variable>.ModifyDatabaseRights
hRightsSeeUser	Rights to view the characteristics of a group or user.	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsSendMessageToClient	Rights to send messages to the client computers.	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
Versions 18 and later hRightsServerReplication New in version 18 hRightsServerReplication hRightsServerReplication	Rights to define and perform a replication between two HFSQL servers.	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsStopServer	Rights to stop a server (<Connection variable>.StopServer)	<Connection variable>.InfoServerRights, <Connection variable>.ModifyServerRights
hRightsUpdate	Rights to modify the records of a data file	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights
hRPDefault	Configure the restore operation: Position freed. The stored position is restored	<Source>.RestorePosition
hRPFilter	Configure the restore operation: Restore the filter set when <HFSQL file>.SavePosition is called	<Source>.RestorePosition
hRPHF5	Configure the restore operation: If the stored position was deleted or modified, this position is restored	<Source>.RestorePosition
hRPKeep	Configure the restore operation: Position not freed	<Source>.RestorePosition
Versions 22 and later hrsCopy New in version 22 hrsCopy hrsCopy	Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is locking.	<Connection variable>.RSAddConfig
Versions 22 and later hrsCopyBackgroundTask New in version 22 hrsCopyBackgroundTask hrsCopyBackgroundTask	Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is performed in background task and it is not locking.	<Connection variable>.RSAddConfig
Versions 22 and later hrsNoCopy New in version 22 hrsNoCopy hrsNoCopy	Configure the replication between servers: No copy is performed.	<Connection variable>.RSAddConfig
Versions 22 and later hsAdd New in version 22 hsAdd hsAdd	Monitors the operations for adding records.	Versions 22 and later <Source>.Track New in version 22 <Source>.Track <Source>.Track
hSaveItems	Saves the values of items in memory when using HSavePosition. These values will be restored next time <Source>.RestorePosition is called.	<HFSQL file>.SavePosition
Versions 22 and later hsCross New in version 22 hsCross hsCross	Monitors the operations for crossing records.	Versions 22 and later <Source>.Track New in version 22 <Source>.Track <Source>.Track
Versions 22 and later hsDeletion New in version 22 hsDeletion hsDeletion	Monitors the operations for deleting records.	Versions 22 and later <Source>.Track New in version 22 <Source>.Track <Source>.Track
Versions 19 and later hSecondaryThread New in version 19 hSecondaryThread hSecondaryThread	Option for running the procedure: the procedure is run in a secondary thread.	HOnServerCall
hServerCursor	Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.	HDescribeConnection, <Connection variable>.OpenConnection
hServerPort	Network port used	<Connection variable>.SetServer
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the addition	<Source>.Add, <Source>.Write, <Source>.Modify
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the write operation	<Source>.Add, <Source>.Write, <Source>.Modify
Versions 22 and later hsModification New in version 22 hsModification hsModification	Monitors the operations for modifying records.	Versions 22 and later <Source>.Track New in version 22 <Source>.Track <Source>.Track
Versions 20 and later hSQLCode New in version 20 hSQLCode hSQLCode	Requested information: SQL code of the materialized view	Versions 20 and later <Connection variable>.InfoView New in version 20 <Connection variable>.InfoView <Connection variable>.InfoView
hSQLUnicode	Used to specify that the query text must be sent in Unicode format to the server. *This constant is available in WINDEV Mobile only.*	<HFSQL file>.ExecuteSQLQuery
hStarted	Server started	HServerStatus
hStateActive	Status of the record/Type of record taken into account: Active record	<Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification
hStateAll	Type of record: Total number of records in the data file	<Source>.NbRec
hStateCrossed	Status of the record/Type of record taken into account: Crossed record	<Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification
hStateDel	Status of the record/Type of record taken into account: Deleted record	<Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification
hStateInvalid	Record status not found (error)	<Source>.State, <Source>.ErrorStatusModification
hStaticCursor	Makes a copy of all query records in memory (consumes a lot of memory). All types of moves are allowed.	HDescribeConnection, <Connection variable>.OpenConnection
hStopped	Server stopped	HServerStatus
hStructure	Configure the file management: New empty file created from the file description	<Connection variable>.RegenerateFile
hSubErrFirst	Type of error returned: Number of the first sub-error	HError
hSubErrLast	Type of error returned: Number of the last sub-error	HError
hSubErrNext	Type of error returned: Number of the previous sub-error	HError
hSubErrPrevious	Type of error returned: Number of the previous sub-error	HError
hSubscriberReplica	Replication mode: The data file is a subscriber replica (HCreateSubscriberReplica was used to create the subscriber replica)	..Replication
Versions 22 and later hTelemetryEnable New in version 22 hTelemetryEnable hTelemetryEnable	Configure the sending of data via the telemetry for the HFSQL server.	<Connection variable>.SetServer
Versions 17 and later hTempDirectory New in version 17 hTempDirectory hTempDirectory	Path of temporary directory. This directory is used to create the temporary files if necessary (temporary files created when re-indexing large data files for example).	<Connection variable>.SetServer
hTotalSize	Total file size in bytes (added size of data file, memo file and index file).	<Source>.InfoFile
hTriggerAfter	Indicates the type of trigger: The procedure is run after the HFSQL function	HActivateTrigger, HDeactivateTrigger, <Source>.DeleteTrigger, <Source>.DescribeTrigger
hTriggerBefore	Indicates the type of trigger: The procedure is run before the HFSQL function	HActivateTrigger, HDeactivateTrigger, <Source>.DeleteTrigger, <Source>.DescribeTrigger
Versions 21 and later htsCreation New in version 21 htsCreation htsCreation	Type ot timestamp for the item: the item will store the creation date of record.	..TimestampType
Versions 21 and later htsLastModification New in version 21 htsLastModification htsLastModification	Type ot timestamp for the item: the item will store the date of last modification performed on the record.	..TimestampType
Versions 21 and later htsNone New in version 21 htsNone htsNone	Type ot timestamp for the item: the item is not a timestamp item.	..TimestampType
hUnicode	Used to retrieve the record value in Unicode format.	<Source>.RetrieveRecord
hUNICODEFormat	Data format: UNICODE format	..Format
hUniqueKey	Characteristics of an item: Unique key	..KeyType
hViewAdd	Create a view with addition: Stores the view content next time <Source>.ExecuteView is called	<Source>.CreateView, <Source>.MergeView
hViewBreakable	The view creation can be interrupted by pressing the ESC key	<Source>.CreateView
hViewDefault	Default creation of view	<Source>.CreateView, <Source>.MergeView
hViewDistinct	The view is created without duplicates according to the sort key	<Source>.CreateView, <Source>.MergeView
hViewExclusive	Optimizes the creation time of view by locking the entire source file	<Source>.CreateView, <Source>.MergeView
hViewIntersection	Merge views with intersection: Common rows between the two specified views	<Source>.MergeView
hViewJoin	Join between the first view and the second view.	<Source>.MergeView
hViewLocking	The records read in the file and included in the view are locked	<Source>.CreateView, <Source>.MergeView
hViewPostponed	The view is created but it will be run later by <Source>.ExecuteView	<Source>.CreateView, <Source>.MergeView
hViewSubtraction	Merge views with subtraction: Row of the first view without the common rows of the second view	<Source>.MergeView
hViewUnion	Merging views: Merge the rows of the two specified views	<Source>.MergeView
hViewUnionEx	Exclusive merge of views: Merge the non-common rows of the two specified views	<Source>.MergeView
hWDL	The files are sought: In the main WDL. In the WDL according to their load order, then on disk or in the specified WDL, then on disk. In the main WDL of the component. In the secondary WDLs of the component according to the load order.	<Source>.ChangeLocation, <Source>.Declare
hWifiFrame	The frame size is optimized for a use via Wifi	HCS.FrameSize
Versions 19 and later hWindowsDiskCacheSize New in version 19 hWindowsDiskCacheSize hWindowsDiskCacheSize	Mode for managing the size of Windows disk cache.	<Connection variable>.SetServer
hWithFilter	If this parameter is specified: the query result corresponds to a selection of filter records if the HFSQL engine allows it. Otherwise, the query result corresponds to an HFSQL view the following operations are not allowed: search on the query result, query on query, view on query, query on view. the browse items specified when browsing the result are ignored. the magnifier is not available for the tables linked to a query. hNbRec cannot be used on the queries. If this parameter is not specified (by default): the query result corresponds to an HFSQL view the following operations can be performed on the queries: search on the query result, query on query, view on query, query on view. the browse items specified when browsing the result are taken into account. the magnifier is available on tables linked to a query. hNbRec can be used on the queries.	HExecuteQuery, HExecuteSQLQuery
hWithTransaction	The query is run in a transaction. A transaction is started, the records are locked in read/write during the execution of the query and they are unlocked at the end of its execution, regardless of the result (failure or success). If the query cannot end properly (locked records, power failure, etc.), the transaction is canceled and the data files are restored to their previous status (before the query execution). Remark: The query execution may be slowed down.	HExecuteQuery, HExecuteSQLQuery
hWriteDefault	Addition not affecting the current browse/Identifier re-used or calculated for the record	<Source>.Add, <Source>.Write, <Source>.Modify
hYield	For the UPDATE and DELETE queries performed on an important number of records, this constant is used to give control back to the other applications that use the files.	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
Versions 20 and later NoWait New in version 20 NoWait NoWait	The refresh of materialized view is not a locking operation: it is performed in background task. <Connection variable>.InfoView is used to find out the result of refresh performed on the materialized view.	Versions 20 and later <Connection variable>.RefreshView New in version 20 <Connection variable>.RefreshView <Connection variable>.RefreshView
opCancel	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the code continues to run.	<Source>.OnError
opEndProcess	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the current process stops. Equivalent to the following code line: IF NOT <HFSQL function> THEN ReturnToCapture()	<Source>.OnError
opEndProgram	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the program stops. Equivalent to the following code line: IF NOT <HFSQL function> THEN EndProgram()	<Source>.OnError
opRelaunchProgram	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The program stops and the application is automatically restarted.	<Source>.OnError
opRetry	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. In this case, the function that triggered the error is re-run.	<Source>.OnError

New in version 23
The following constants are used to manage HFSQL data files (prefixed syntax):


Constant	Affects	Used by the functions or properties
eltProcedure	The listed element is a stored procedure	<Connection variable>.ListStoredElement
eltQuery	The listed element is a query.	<Connection variable>.ListStoredElement
eltSetOfProcedures	The listed element is a set of procedures	<Connection variable>.ListStoredElement
Versions 15 and later h3G New in version 15 h3G h3G	Type of network to simulate: 3G	<Connection variable>.SimulateNetwork
hAcceptOpenedFile	Allows you to read the source file that will be added to the memo if this source file is opened in write mode somewhere else.	<Source>.LinkMemo
hAccessHF7	Pseudo-connection to HFSQL Classic database.	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessHFClientServer	Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, <Connection variable>.OpenConnection
hAccessJDBCSQLServer	Access to a SQL Server database via a JDBC driver	HDescribeConnection, <Connection variable>.OpenConnection
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	<Connection variable>.SetServer
hActiveSyncFrame	The size of the frame is optimized to be used with Mobile devices.	HCS.FrameSize
hActivityStatisticsPath	Path of the directory containing the activity statistics	<Connection variable>.SetServer
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	<Connection variable>.SetServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	<Connection variable>.SimulateNetwork
hAffectBrowse	Addition affecting the current browse	<Source>.Add, <Source>.Modify
hAllowed	The relevant rights are granted to the user or group.	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hANSIFormat	Data format: Ansi format (used by Windows)	..Format
hApplication	Property of a database found on an HFSQL server: Name of the application from which the database was created.	HInfoDatabaseProperty, HInfoFileProperty
Versions 18 and later hAutoStatisticalCalc New in version 18 hAutoStatisticalCalc hAutoStatisticalCalc	Enable the automatic calculation of statistics for the data files (optimization of indexes).	<Connection variable>.SetServer
Versions 15 and later hBackgroundTask New in version 15 hBackgroundTask hBackgroundTask	Perform the process in background task without locking the data file (available for the data files in Client/Server mode).	<Source>.StatCalculate, <Source>.Index
hBackupCanceled	Status of backup: Backup canceled	<Connection variable>.InfoBackup
hBackupCompleted	Status of backup: Backup completed	<Connection variable>.InfoBackup
Versions 15 and later hBackupDifferential New in version 15 hBackupDifferential hBackupDifferential	Type of backup: Differential backup	<Connection variable>.InfoBackup
hBackupError	Status of backup: Error during backup	<Connection variable>.InfoBackup
Versions 15 and later hBackupFull New in version 15 hBackupFull hBackupFull	Type of backup: Full backup	<Connection variable>.InfoBackup
hBackupInProgress	Status of backup: Backup in progress	<Connection variable>.InfoBackup
hBoundSeparator	Used to separate the values of lower and upper bounds for the components of composite key	<Source>.FilterIncludedBetween
Versions 21 and later hCacheNbUnusedFiles New in version 21 hCacheNbUnusedFiles hCacheNbUnusedFiles	Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server.	<Connection variable>.SetServer
hCardinality	Integrity constraints: Check the link cardinalities.	<Connection variable>.SetIntegrity
hChangeCharset	The character set defined by ChangeCharset will be taken into account in the new data file. The sorts, the searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.	<Source>.Creation, <Source>.CreationIfNotFound, <Source>.Index
hCheckDuplicates	Checks for duplicates for this action, even if the duplicate check is disabled (<Source>.SetDuplicates)	<Source>.Add, <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.Modify
hCheckIntegrity	Checks the integrity of operation even if the automatic integrity check is disabled (<Connection variable>.SetIntegrity)	<Source>.Add, <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.Modify, <HFSQL file>.Cross, <Source>.Delete
hCheckMemo	Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos)	<Source>.Index
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, <Connection variable>.OpenConnection
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	<Source>.CheckStructure
hComputer	Property of a database found on an HFSQL server: Name of the computer from which the element was created.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty
hCopyAutoId	Copies the automatic identifier while keeping its value	<Source>.CopyRecord, <Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	<Connection variable>.CopyFile
hCopyIndex	Copies the index of the data file	<Connection variable>.CopyFile
hCorrespondence	Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions	HInfoLog
hCreateIndex	The index of the data file is not copied. It is automatically recreated at the destination by reindexing.	<Connection variable>.CopyFile
hCreator	Property of a database found on an HFSQL server: Name of database owner.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty
Versions 24 and later hCryptAES128 New in version 24 hCryptAES128 hCryptAES128	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
Versions 19 and later hCryptAuto New in version 19 hCryptAuto hCryptAuto	File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptNo	No file encryption.	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptRC5_12	The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptRC5_16	The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCryptStandard	The memo file is encrypted according to an optimized encryption algorithm on 128 bits.	..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod
hCurrentRecNum	Number of the current record.	HFSQL functions
hDaemonUser	User name that will be used by the server (Linux only)	<Connection variable>.SetServer
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	<Connection variable>.RegenerateFile
hDatabasePath	Path of directory containing all databases	<Connection variable>.SetServer
hDate	Property of a database found on an HFSQL server: Creation date of the database.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty
Versions 20 and later hDateLastRefresh New in version 20 hDateLastRefresh hDateLastRefresh	Requested information: Date of the last successful refresh for the materialized view.	Versions 20 and later <Connection variable>.InfoView New in version 20 <Connection variable>.InfoView <Connection variable>.InfoView
hDBASCII	Sort according to ASCII order	HDBSortType
hDBLexicographic	Sort according to the lexicographic order	HDBSortType
hDebuggingPort	Port used to debug the stored procedures and the server triggers.	<Connection variable>.SetServer
hDecreasing	Sort performed in descending order	..SortType
hDefault	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the values of the requested rights (in the same order).	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights
hDefaultFrame	The standard size will be used by default.	HCS.FrameSize
hDefaultVal	The items of destination record that are not affected by the copy are initialized with their default value. For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value.	<Source>.CopyRecord, <Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hDelayedOpening	Optimize the opening of existing files: If the file already exists, it will be opened during the first access to the file. The file is created if it does not exist.	<Source>.CreationIfNotFound
hDeleteLog	Deletes the log file	<Connection variable>.DeleteFile, <Connection variable>.DeleteDatabase
hDestroyLink	Deletes all links related to the deleted data file.	<Connection variable>.DeleteFile
hDetails	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the rights and there value.	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights
hDisconnection	Configures the disconnection message	HOnServerCall
hDisk	Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case	<Source>.ChangeLocation, <Source>.Declare
hDistinct	Management of duplicates during the browse: If duplicates are found when a browse is performed on a key item, a single record is browsed	<Source>.Forward, <Source>.ReadPrevious, <Source>.ReadNext, <Source>.Previous, <Source>.Backward, <Source>.Next
hDuplicateKey	Characteristics of an item: Key with duplicates	..KeyType
hDynamicCursor	Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users.	HDescribeConnection, <Connection variable>.OpenConnection
hEffective	The rights returned correspond to the rights that will be actually granted to the user or to the group on the database. The inherited rights are taken into account (rights granted to the groups to which the user belongs for example).	<Connection variable>.InfoDatabaseRights, <Connection variable>.InfoFileRights, <Connection variable>.InfoServerRights
hErrADO	Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.	HErrorInfo
hErrADOMessage	Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO)	HErrorInfo
hErrAll	Customize all the errors	<Source>.OnError
hErrBase	Type of information about the error to return: Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant	HErrorInfo
hErrBaseMessage	Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase)	HErrorInfo
hErrClientInfo	Information about the client layer used by the Native Connector that returned the error.	HErrorInfo
hErrConnectionLoss	Customize the errors caused by a loss of connection with the server.	<Source>.OnError
hErrCurrent	Type of information about the error to return: Number of the current error	HError
hErrDatabaseAccess	Configure the access errors to an HFSQL Client/Server database.	<Source>.OnError
hErrDebugInfo	Type of information about the error to return: Specific information for debugging the problem that occurred. This information should only be displayed and communicated on express demand from PC SOFT. When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database.	HErrorInfo
hErrDuplicates	Customize duplicate errors	<Source>.OnError
hErrFIC	Type of information about the error to return: Full name of the data file associated with the error	HErrorInfo
hErrFile	Type of information about the error to return: Logical name of data file associated with the error	HErrorInfo
hErrFullDetails	Type of information about the error to return: Full error details (error line, current process, etc.) Remark: Returns the same information as the one retrieved when clicking the "Copy" button in the error window of WLanguage.	HErrorInfo
hErrIndex	Customize the reindexing errors (reindexing operation in progress during the access to the data file)	<Source>.OnError
hErrIntegrity	Customize integrity errors	<Source>.OnError
hErrItem	Type of information about the error to return: Name of item associated with the error	HErrorInfo
hErrLink	Type of information about the error to return: Name of link associated with the error	HErrorInfo
hErrLock	Customize lock errors	<Source>.OnError
hErrLockInfo	Type of information about the error to return: Information about the lock	HErrorInfo
hErrMain	Type of information about the error to return: Number of the main error	HError
hErrMessage	Type of information about the error to return: Message associated with the error	HErrorInfo
hErrMMO	Type of information about the error to return: Full name of the memo file associated with the error	HErrorInfo
hErrModify	Customize a modification conflict	<Source>.OnError
hErrNative	Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used	HErrorInfo
hErrNativeMessage	Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector.	HErrorInfo
hErrNDX	Type of information about the error to return: Full name of the index file associated with the error	HErrorInfo
hErrNeedValue	Customize the errors caused by a mandatory input with no data (OLE DB only).	<Source>.OnError
hErrOLEDB	Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection.	HErrorInfo
hErrOLEDBMessage	Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)	HErrorInfo
Versions 20 and later hErrorLastRefresh New in version 20 hErrorLastRefresh hErrorLastRefresh	Requested information: Last error while refreshing the materialized view.	Versions 20 and later <Connection variable>.InfoView New in version 20 <Connection variable>.InfoView <Connection variable>.InfoView
hErrPassword	Customize password errors	<Source>.OnError
Versions 20 and later hErrPositionSQLError New in version 20 hErrPositionSQLError hErrPositionSQLError	Type of information about the error to return: Position of the SQL error in the SQL code of the query run by <HFSQL file>.ExecuteSQLQuery.	HErrorInfo
hErrRecNum	Type of information about the error to return: Number of the record associated with the error	HErrorInfo
hErrServer	Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error	HErrorInfo
hErrServerInfo	Information about the server used by the Native Connector that returned the error.	HErrorInfo
hErrSystemCode	Type of information about the error to return: Number of the associated system error	HErrorInfo
hErrSystemMessage	Type of information about the error to return: Message of associated system error	HErrorInfo
hErrWDD	Type of information about the error to return: Full name of the analysis file associated with the error	HErrorInfo
hExisting	Type of search: Only the assignments for which a file actually exists	HListREP
hExpBreakable	Mode for creating the export file: The export can be interrupted by pressing Esc. If the export is interrupted, the export file is valid and it only contains the records exported before the interruption.	<Source>.ExportXML Versions 21 and later <Source>.ExportJSON New in version 21 <Source>.ExportJSON <Source>.ExportJSON Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
hExpCreation	Mode for creating the export file: The file is overwritten if it already exists.	<Source>.ExportXML Versions 21 and later <Source>.ExportJSON New in version 21 <Source>.ExportJSON <Source>.ExportJSON Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
Versions 24 and later hExpNoLineItemName New in version 24 hExpNoLineItemName hExpNoLineItemName	Mode for creating the CSV/XLSX file: The first line of the generated file will not contain the names of the items.	Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
hExpNormal	Mode for creating the export file: Standard operating mode	<Source>.ExportXML Versions 21 and later <Source>.ExportJSON New in version 21 <Source>.ExportJSON <Source>.ExportJSON Versions 24 and later <Source>.ExportCSV New in version 24 <Source>.ExportCSV <Source>.ExportCSV Versions 24 and later <Source>.ExportXLS New in version 24 <Source>.ExportXLS <Source>.ExportXLS
hExpWithoutXSL	The style sheet (".XSL" file) is not created	<Source>.ExportXML
hFicSize	Size of data file in bytes (".Fic" file)	<Source>.InfoFile
hFileAS400	Type of file: AS400 file	..Type
hFileClientServer	Type of file: HFSQL Client/Server file	..Type
hFileHF5	Type of file: Hyper File 5 file	..Type
hFileMySQL	Type of file: MySQL file	..Type
hFileNormal	Type of file: Standard file (HFSQL Classic)	..Type
hFileOLEDB	Type of file: OLEDB file	..Type
hFileOracle	Type of file: ORACLE file	..Type
hFileOracleLite	Type of file: ORACLE Lite file	..Type
hFileOther	Type of file: Other type of file	..Type
Versions 15 and later hFilePostgreSQL New in version 15 hFilePostgreSQL hFilePostgreSQL	Type of file: PostgreSQL file	..Type
hFileProgress	Type of file: Progress file	..Type
hFileQuery	Type of file: Query	..Type
hFileQueryAS400	Type of file: Query on an AS/400 database	..Type
hFileQueryClientServer	Type of file: Query on an HFSQL Client/Server database	..Type
hFileQueryMySQL	Type of file: Query on a MySQL database	..Type
hFileQueryOLEDB	Type of file: Query on a database accessed via an OLE DB provider	..Type
hFileQueryOracle	Type of file: Query on an Oracle database	..Type
hFileQueryOracleLite	Type of file: Query on an Oracle Lite database	..Type
Versions 15 and later hFileQueryPostgreSQL New in version 15 hFileQueryPostgreSQL hFileQueryPostgreSQL	Type of file: Query on a PostgreSQL database	..Type
hFileQueryProgress	Type of file: Query on a Progress database	..Type
Versions 16 and later hFileQuerySQLAzure New in version 16 hFileQuerySQLAzure hFileQuerySQLAzure	Type of file: Query on an SQL Azure database	..Type
hFileQuerySQLServer	Type of file: Query on an SQL Server database	..Type
hFileQuerySQLServerMobile	Type of file: Query on an SQL Server Mobile database	..Type
hFileQuerySybase	Type of file: Query on a Sybase database	..Type
hFileQueryXML	Type of file: Query on an XML database	..Type
hFileSQL	Type of file: SQL file	..Type
Versions 16 and later hFileSQLAzure New in version 16 hFileSQLAzure hFileSQLAzure	Type of file: SQL Azure file	..Type
Versions 16 and later hFileSQLite New in version 16 hFileSQLite hFileSQLite	Type of file: SQLite file	..Type
hFileSQLServer	Type of file: SQL Server file	..Type
hFileSQLServerMobile	Type of file: SQL Server Mobile file	..Type
hFileSybase	Type of file: Sybase file	..Type
hFileTemporary	Type of file: Temporary file	..Type
hFileView	Type of file: HFSQL view	..Type
hFileXBase	Type of file: xBase file	..Type
hFileXML	Type of file: XML file	..Type
Versions 22 and later hFindKey New in version 22 hFindKey hFindKey	Enable the search for keys on the HFSQL server.	<Connection variable>.SetServer
hForbidden	The relevant rights are not granted to the user or group	<Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights, <Connection variable>.ModifyServerRights
Versions 17 and later hForwardOnly New in version 17 hForwardOnly hForwardOnly	Native Connectors only: Used to speed up the browse of data during a simple browse that does not use the following features: Reading the previous record. Modifying a record. Saving position. If one of these features is used, the result may differ from the expected one. This constant can be used for example during a browse used to fill a memory Table control.	<Source>.ReadLast, <Source>.ReadFirst, <Source>.ReadSeekFirst, <Source>.ReadSeekLast
hForwardOnlyCursor	Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible.	HDescribeConnection, <Connection variable>.OpenConnection
Versions 20 and later hftPunctuationSimple New in version 20 hftPunctuationSimple hftPunctuationSimple	Full-text Index item described by programming: Taking into account the simple punctuation characters (non Unicode).	..Option property of FullTextIndex description variables.
Versions 20 and later hftPunctuationUnicode New in version 20 hftPunctuationUnicode hftPunctuationUnicode	Full-text Index item described by programming: Taking into account the Unicode punctuation characters.	..Option property of FullTextIndex description variables.
hFTX	Reindexing full-text indexes	<Source>.Index
hFtxSize	Size of full-text index file in bytes (".Ftx" file)	<Source>.InfoFile
HGeneric	Type of search: Generic search	<Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.SeekLast, <Source>.SeekFirst
hGPRSFrame	The frame size is optimized for a use via GPRS	HCS.FrameSize
hHCreationIfNotFound	Type of test to run to check the connection: Checks the connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only.	HConnect
hHOpen	Type of test to run to check the connection: Checks the connection by opening a file. This value is used by default when accessing to an hORead database.	HConnect
hIdentical	The structures of files (read in the analysis and in the physical file) must be strictly identical.	<Source>.ReadSeek, <Source>.Seek, <Source>.CheckStructure
hIgnoreDuplicates	Ignores the duplicate check for this operation, even if the automatic duplicate check is enabled (<Source>.SetDuplicates)	<Source>.Add
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (<Connection variable>.SetIntegrity)	<Source>.Add, <Source>.Modify, <Source>.Delete, <HFSQL file>.Cross
hImpBreakable	The import can be interrupted by pressing ESC.	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS, New in version 20 <Source>.ImportXLS, <Source>.ImportXLS, <Source>.ImportXML Versions 21 and later <Source>.ImportJSON New in version 21 <Source>.ImportJSON <Source>.ImportJSON
hImpConversion	Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated.	<Source>.ImportHF55
hImpCreation	Type of import: If the (HFSQL Classic) import file exists, it is overwritten.	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS, New in version 20 <Source>.ImportXLS, <Source>.ImportXLS, <Source>.ImportXML Versions 21 and later <Source>.ImportJSON New in version 21 <Source>.ImportJSON <Source>.ImportJSON
hImpIgnoreEmptyItem	If one or more items are not filled in the text file, the corresponding lines are still imported. The missing items contain: the default value of items if the hDefaultVal constant is specified. the value of items in the current record before the call to <Source>.ImportText.	<Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
Versions 20 and later hImpIgnoreFirstLine New in version 20 hImpIgnoreFirstLine hImpIgnoreFirstLine	Type of import: The first row of the imported file is ignored.	<Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hImpIgnoreInvalidLine	Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing.	<Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hImpIgnoreItem	Type of import: The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value. The items of imported file (Hyper File 5.5) with no match in the import file are ignored.	<Source>.ImportHF55
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	<Source>.ImportText
hImpNormal	Type of import: The import is not performed and an error occurs in the following cases: items found in the Hyper File 5.5 file with no match in the HFSQL Classic file. associated items in the two files but with a different size and/or format. If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created. No management of integrity and no management of duplicates. The non-imported items take the value of the current record. The automatic identifiers are recalculated.	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS, New in version 20 <Source>.ImportXLS, <Source>.ImportXLS, <Source>.ImportXML Versions 21 and later <Source>.ImportJSON New in version 21 <Source>.ImportJSON <Source>.ImportJSON
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	<Source>.ImportHF55
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	<Source>.ImportText
hImpTestDuplicates	Type of import: Checks the duplicates during the import	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hImpTestIntegrity	Type of import: Checks the integrity during the import	<Source>.ImportHF55, <Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
hInaccessible	Undefined server status	HServerStatus
hIncreasing	Sort performed in ascending order	..SortType
hInfiniteCardinality	Maximum cardinality ("N")	..MaxLinkedCardinality, ..MaxSourceCardinality
hInfoAll	Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate). The different values are separated by CR characters (Carriage Return).	<Connection variable>.InfoServer
Versions 15 and later hInfoCluster New in version 15 hInfoCluster hInfoCluster	Information about the HFSQL cluster.	<Connection variable>.InfoServer
hInfoDate	Date and time of server on 8 bytes in UTC format (universal time)	<Connection variable>.InfoServer
Versions 22 and later hInfoFreeDiskSpace New in version 22 hInfoFreeDiskSpace hInfoFreeDiskSpace	Available space on the server disk, expressed in MB.	<Connection variable>.InfoServer
hInfoHardware	Information about the hardware used: Type of processor (for example: Intel Pentium) Size of server RAM (for example: 630 MB) This information is returned in the following format: <Type of CPU> = TAB + <Size of server RAM>	<Connection variable>.InfoServer
hInfoLogicalName	Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center.	<Connection variable>.InfoServer
hInfoName	Name of server (DNS)	<Connection variable>.InfoServer
hInfoPlatform	Information about the server platform: Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX System version: corresponds to Service Pack in Windows or empty string if no Service Pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example). This information is returned in the following format: <System name> + TAB + <Version>	<Connection variable>.InfoServer
Versions 19 and later hInfoSizeCacheNdxUsed New in version 19 hInfoSizeCacheNdxUsed hInfoSizeCacheNdxUsed	Size of index cache that is actually used on the server, expressed in MB.	<Connection variable>.InfoServer
Versions 22 and later hInfoTotalDiskSpace New in version 22 hInfoTotalDiskSpace hInfoTotalDiskSpace	Total capacity of server disk, expressed in MB.	<Connection variable>.InfoServer
hInfoVersion	Information about the version of programs required for the server to operate: Version of Manta.exe or Manta in Linux Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux) Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux) This information is returned in the following format: <Manta version> + TAB + <HFSQL version> +TAB + <SQL version<	<Connection variable>.InfoServer
hInfoVersionDetails	Detailed information about the version of the programs required to operate the server: <Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date> The listed elements are as follows: Manta.exe or Manta in Linux HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux) SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux) Management of logs (HFLogger.exe) MantaManager the framework required to operate the server. This information is returned in the following format: <Manta version> + TAB + <HFSQL version> +TAB + <SQL version<	<Connection variable>.InfoServer
hInfoVI	Version number of Manta.exe or Manta in Linux	<Connection variable>.InfoServer
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	<Connection variable>.ModifyDatabaseRights, <Connection variable>.ModifyFileRights, <Connection variable>.ModifyServerRights
hIntegrityCascade	Modification/Deletion rule: Cascading modification/deletion	..ModificationRule, ..DeletionRule
hIntegrityDefaultValue	Modification/Deletion rule: Default modification/deletion	..ModificationRule, ..DeletionRule
hIntegrityForbidden	Modification/Deletion rule: Modification/Deletion not allowed	..ModificationRule, ..DeletionRule
hIntegrityNone	Modification/Deletion rule: No integrity management	..ModificationRule, ..DeletionRule
hInternetFrame	The frame size is optimized for a use via Internet	HCS.FrameSize
hInternetPageSize	Size of page for using the RPC via Internet.	Remote access (RPC on HFSQL)
hIntranetFrame	The frame size is optimized for a use via Intranet	HCS.FrameSize
hIntranetPageSize	Size of page for using the RPC via Intranet.	Remote access (RPC on HFSQL)
hInvalidRecNum	Constant returned if there is no current record or if the specified file corresponds to a multi-file query.	<Source>.RecNum
hItemBinary	Item type: Binary	..Type
hItemBinaryMemo	Item type: Binary Memo	..Type
hItemBinaryMemo4	Item type: Binary memo (4 bytes)	..Type
hItemBoolean	Item type: Boolean	..Type
hItemCharacter	Item type: Character	..Type
Versions 20 and later hItemCombination New in version 20 hItemCombination hItemCombination	Item type: Combination	..Type
hItemCurrency	Item type: Currency	..Type
hItemDate6	Item type: Date	..Type
hItemDate8	Item type: Date	..Type
hItemDateTime	Item type: Date/Time	..Type
Versions 20 and later hItemEnumeration New in version 20 hItemEnumeration hItemEnumeration	Item type: Enumeration	..Type
hItemHour	Item type: Hour	..Type
hItemIdAuto	Item type: Automatic identifier (8 bytes)	..Type
hItemIdAuto4	Item type: Automatic identifier (4 bytes)	..Type
hItemInteger1	Item type: 1-byte integer	..Type
hItemInteger2	Item type: 2-byte integer	..Type
hItemInteger4	Item type: 4-byte integer	..Type
hItemInteger8	Item type: 8-byte integer	..Type
hItemInvalid	Invalid type of item	..Type
Versions 24 and later hItemJSON New in version 24 hItemJSON hItemJSON	Item type: JSON	..Type
hItemNumeric	Item type: High-precision numeric	..Type
hItemNumRec	Item type: Record number	..Type
hItemPicture	Item type: Image	..Type
hItemReal4	Item type: 4-byte real	..Type
hItemReal8	Item type: 8-byte real	..Type
hItemRealTurbo	Item type: Turbo real	..Type
hItemText	Item type: Text	..Type
hItemTextMemo	Item type: Text Memo	..Type
hItemTimeLength	Item type: Duration	..Type
hItemUnicodeMemo	Item type: Unicode Text Memo	..Type
hItemUnicodeText	Item type: Unicode text	..Type
hItemUnsignedInteger1	Item type: Unsigned 1-byte integer	..Type
hItemUnsignedInteger2	Item type: Unsigned 2-byte integer	..Type
hItemUnsignedInteger4	Item type: Unsigned 4-byte integer	..Type
hItemUnsignedInteger8	Item type: Unsigned 4-byte integer	..Type
Versions 24 and later hItemUUID128 New in version 24 hItemUUID128 hItemUUID128	Item type: UUID 128	..Type
Versions 24 and later hItemUUID128Auto New in version 24 hItemUUID128Auto hItemUUID128Auto	Item type: UUID 128 automatic identifier	..Type
Versions 24 and later hItemUUID256 New in version 24 hItemUUID256 hItemUUID256	Item type: UUID 256	..Type
Versions 24 and later hItemUUID256Auto New in version 24 hItemUUID256Auto hItemUUID256Auto	Item type: UUID 256 automatic identifier	..Type
hJNLBackupPath	Path of the directory containing the backups of the logs	<Connection variable>.SetServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	<Connection variable>.SetServer
Versions 23 and later hkaInterval New in version 23 hkaInterval hkaInterval	Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client.	<Connection variable>.SetServer
Versions 23 and later hkaTimeout New in version 23 hkaTimeout hkaTimeout	Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected.	<Connection variable>.SetServer
hKeepFilter	The filter set by HFilter will be taken into account, even if the search key is not optimized for the filter. Reminder: HFilter returns the search key optimized for the filter. Caution: in this case, performance problems may occur on large files.	<Source>.ChangeKey, <Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.ReadSeek, HFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst
hKeepTRS	Stores the transaction files during the deletion	<Connection variable>.DeleteDatabase, <Connection variable>.DeleteFile
Versions 17 and later hLanguageBinarySort New in version 17 hLanguageBinarySort hLanguageBinarySort	The sort will be performed by comparing the binary value of the bytes. This type of sort is very fast. It should be used to perform an exact-match search for example.	..Language, ..LanguageDescribed, H.LanguageCreationUnicode
hLanguageCreation	Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation".	..Language, ..LanguageDescribed
Versions 17 and later hLanguageFastSort New in version 17 hLanguageFastSort hLanguageFastSort	The sort will be performed by comparing the characters one by one according to a generic sort.	..Language, ..LanguageDescribed, H.LanguageCreationUnicode
hlbActive	Enable or disable the load balancing	<Connection variable>.SetServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	<Connection variable>.SetServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	<Connection variable>.SetServer
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	<Connection variable>.SetServer
hlbMaxTimeout	Value modifying the maximum time-out for a server request	<Connection variable>.SetServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	<Connection variable>.SetServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	<Connection variable>.SetServer
hLimitParsing	Limits the file browse: The browse will stop as soon as the last sought value is found. The current record will correspond to this last record found. <Source>.Found will be set to False and <Source>.Out will be set to True. This constant is used to optimize the search speed in client/server mode.	<Source>.ReadSeek, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst
hLockNo	Type of lock: No lock	<Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLockReadWrite	Type of lock: Lock in read/write	<Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLockWrite	Type of lock: Lock in write mode	<Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext
hLogIdentification	Configures the file to re-create: Re-creates the "JournalIdentification.fic" file.	<Source>.LogRecreate
hLogJNLFile	Configures the file to re-create: Only <File name>JNL.FIC is recreated.	<Source>.LogRecreate
hLogLevel	Defines the elements that must be found in the log file	<Connection variable>.SetServer
hLogNo	Format of log process: No log	..LogMethod
hLogOperation	Configures the file to re-create: Re-creates the "JournalOperation.fic" file.	<Source>.LogRecreate
hLogPath	Path of the directory containing the log files	<Connection variable>.SetServer
hLogReadingWriting	Format of log process: Log the read and write operations performed in the file	..LogMethod
hLogUser	Configures the file to re-create: Re-creates the log of users ("UserLog.fic"). This file exists in HFSQL Client/Server only. This file contains the information (login, computer, ...) about the users who perform the logged actions.	<Source>.LogRecreate
hLogWriting	Format of log process: Log the write operations performed in the file	..LogMethod
Versions 20 and later hlpBackup New in version 20 hlpBackup hlpBackup	Type of scheduling to list: Scheduling of backups.	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpCalcStat New in version 22 hlpCalcStat hlpCalcStat	Type of operation performed on the server: statistical calculation.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpKeyDetection New in version 22 hlpKeyDetection hlpKeyDetection	Type of operation performed on the server: detection of keys.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpMaterializedView New in version 20 hlpMaterializedView hlpMaterializedView	Type of scheduling to list: Tasks for refreshing the materialized views.	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpOptimization New in version 20 hlpOptimization hlpOptimization	Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation).	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpReplication New in version 22 hlpReplication hlpReplication	Type of operation performed on the server: server replication.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpTask New in version 20 hlpTask hlpTask	Type of scheduling to list: Scheduled tasks that run a stored procedure.	Versions 20 and later <Connection variable>.ListScheduling New in version 20 <Connection variable>.ListScheduling <Connection variable>.ListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
hLstAll	Lists all the keys, all the files, all the items or all the connections	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection, <Connection variable>.ListStoredElement
hLstCompositeKey	Lists the composite key items only	<Source>.ListKey, <Source>.ListItem
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	<Connection variable>.ListDatabase
hLstDetail	Lists the detailed information	<Source>.ListKey, HListFile, <Source>.ListLink, <Source>.ListItem, HListConnection, <Connection variable>.ListStoredElement
hLstDetailPlus	For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part.	<Source>.ListKey, <Source>.ListItem
hLstFile	Lists the databases and their files for the server defined by the connection	<Connection variable>.ListDatabase
hLstItem	Lists the non-key and non-memo items	<Source>.ListItem
hLstKey	Lists the key items	<Source>.ListKey, <Source>.ListItem
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	<Source>.ListKey, <Source>.ListItem
Versions 20 and later hLstMaterializedView New in version 20 hLstMaterializedView hLstMaterializedView	Lists the materialized views found on an HFSQL server.	HListFile
hLstMemo	Lists the memo items	<Source>.ListItem
hLstNormal	Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically.	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection
hLstOpened	Stores the opened connections only	HListConnection
hLstOriginalItem	Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file.	<Source>.ListKey, <Source>.ListItem
hLstQuery	Lists the queries found on a server Versions 19 and later Lists the queries that have been run. New in version 19 Lists the queries that have been run. Lists the queries that have been run.	<Connection variable>.ListStoredElement HListFile
hLstSet	Lists the sets of procedures found on a server	<Connection variable>.ListStoredElement
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, <Connection variable>.ListStoredElement
hLstSystemTable	List of system tables for a connection via Native Connectors or OLE DB	HListFile
hLstTable	List of user tables for a connection via Native Connectors or OLE DB	HListFile
hLstView	List the views of a connection via Native Connectors or OLE DB. Versions 20 and later List the SQL views on an HFSQL server. New in version 20 List the SQL views on an HFSQL server. List the SQL views on an HFSQL server.	HListFile
hMasterReplica	Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica)	..Replication
hMaxActivityStatisticsSize	Maximum size in megabytes (MB) of files for activity statistics	<Connection variable>.SetServer
hMaxLogSize	Maximum size in megabytes (MB) of log files	<Connection variable>.SetServer
Versions 24 and later hMaxNumberConnection New in version 24 hMaxNumberConnection hMaxNumberConnection	Maximum number of connections allowed per application.	<Connection variable>.SetServer
hMaxVal	Defines an upper bound for a filter	<Source>.BuildKeyValue, <Source>.Filter, <Source>.FilterStartsWith, <Source>.FilterIncludedBetween
hMemoAuto	The memos are read during the access to the item	<Source>.SetMemo
hMemoBin	Type of file used for the memo: Any binary file	<Source>.LinkMemo
hMemoImg	Type of file used for the memo: Image file	<Source>.LinkMemo
hMemoNo	No management of memos	<Source>.SetMemo
hMemoOle	Type of file used for the memo: OLE file	<Source>.LinkMemo
hMemoWav	Type of file used for the memo: sound file	<Source>.LinkMemo
hMemoYes	The text memos are read whenever the record is read. Read the binary memos when accessing the item.	<Source>.SetMemo
hMessage	Configure the information message	HOnServerCall
hMinVal	Defines a lower bound for a filter	<Source>.BuildKeyValue, <Source>.Filter, <Source>.FilterStartsWith, <Source>.FilterIncludedBetween
Versions 20 and later hMmoCompact New in version 20 hMmoCompact hMmoCompact	Compression and defragmentation of "Mmo" files.	<Source>.Index
hMmoSize	Size of memo file in bytes (".Mmo" file)	<Source>.InfoFile
hMode2GB	Indicates whether the system files support more than 2 GB	<Connection variable>.SetServer
hModeDirect	Priority implementation of locks	<Source>.Mode
hModeMono	Single-user lock mode	<Source>.Mode
hModeMulti	Multi-user lock mode	<Source>.Mode
hModeReservation	Non-priority implementation of locks	<Source>.Mode
hModifyFile	When modifying the query result, these modifications will be applied to the files belonging to the query. If this option is not specified, only the query result is modified.	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
Versions 17 and later hmsBackgroundTask New in version 17 hmsBackgroundTask hmsBackgroundTask	A hot automatic modification is performed (available for the HFSQL Client/Server data files only).	Versions 17 and later <Source>.ModifyStructure New in version 17 <Source>.ModifyStructure <Source>.ModifyStructure
Versions 17 and later hmsNoCheck New in version 17 hmsNoCheck hmsNoCheck	The automatic data modification is performed even if the file description is more recent than the analysis description.	Versions 17 and later <Source>.ModifyStructure New in version 17 <Source>.ModifyStructure <Source>.ModifyStructure
Versions 17 and later hmsNormal New in version 17 hmsNormal hmsNormal	Standard operating mode of the automatic data modification.	Versions 17 and later <Source>.ModifyStructure New in version 17 <Source>.ModifyStructure <Source>.ModifyStructure
hNativeAccessAS400	Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessDB2	OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessInformix	OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 20 and later hNativeAccessMariaDB New in version 20 hNativeAccessMariaDB hNativeAccessMariaDB	OLE DB provider that will be used for the connection: Native MariaDB Connector (optional module of WINDEV/WEBDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessMySQL	OLE DB provider that will be used for the connection: Native MySQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessOracle	OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessOracleLite	Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessPostgreSQL	OLE DB provider that will be used for the connection: Native PostgreSQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessProgress	OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 16 and later hNativeAccessSQLAzure New in version 16 hNativeAccessSQLAzure hNativeAccessSQLAzure	OLE DB provider that will be used for the connection: Native SQL Azure Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
Versions 15 and later hNativeAccessSQLite New in version 15 hNativeAccessSQLite hNativeAccessSQLite	OLE DB provider that will be used for the connection: Native Connector to an SQLite database	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSQLServer	OLE DB provider that will be used for the connection: Native SQL Server Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSQLServerMobile	Provider that will be used for the connection: Native SQL Server Mobile Connector (optional module of WINDEV Mobile)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessSybase	OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXBase	OLE DB provider that will be used for the connection: Native xBase Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXML	Provider that will be used for the connection: Native XML Connector (supplied with WINDEV/WEBDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Connection variable>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	<Connection variable>.SetServer
hNdxCompact	Re-index operation with compression	<Source>.Index
hNdxDelete	Reindex and delete damaged records	<Source>.Index
hNdxMinimal	Re-index operation while ignoring the corrupted keys	<Source>.Index
hNdxNormal	Standard re-index operation	<Source>.Index
hNdxNoStat	Reindex without statistical calculation	<Source>.Index
hNdxSilent	Configure the re-index operation: No display while re-indexing	<Source>.Index
hNdxSize	Size of index file in bytes (".Ndx" file)	<Source>.InfoFile
hNoBind	Run a query without enabling the bind	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.PrepareSQLQuery
hNoCheck	No check is performed, the analysis description may differ from the description of physical file.	<Source>.CheckStructure
hNoError	No error occurred	HError
Versions 21 and later hNoHourglass New in version 21 hNoHourglass hNoHourglass	When reading the query result, this read operation may be locked and a hourglass appears by default. This constant is used not to display the hourglass in this case.	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hNoIndex	The file index is not copied	<Connection variable>.CopyFile
hNoLink	Management of integrity: The links are not updated on the server (creation, modification or deletion). Reminder: by default, the links are updated on the server when creating a file.	<Source>.Creation, <Source>.CreationIfNotFound
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	<Connection variable>.SimulateNetwork
hNoRefresh	The table or query content will not be refreshed	<Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.First
hNotAKey	Characteristics of an item: Non-key item	..KeyType
hNotes	Property of a database found on an HFSQL server: Database description or any other information associated with the database by <Connection variable>.ModifyDatabaseProperty.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.InfoServerProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty, <Connection variable>.ModifyServerProperty
Versions 18 and later hNotifCCClassic New in version 18 hNotifCCClassic hNotifCCClassic	The notifications are sent by the Control Centers in HFSQL Classic mode.	Versions 18 and later <Connection variable>.NotifConfigure New in version 18 <Connection variable>.NotifConfigure <Connection variable>.NotifConfigure
Versions 18 and later hNotifCCCS New in version 18 hNotifCCCS hNotifCCCS	The notifications are sent by the Control Centers in Client/Server mode.	Versions 18 and later <Connection variable>.NotifConfigure New in version 18 <Connection variable>.NotifConfigure <Connection variable>.NotifConfigure
Versions 18 and later hNotifCritical New in version 18 hNotifCritical hNotifCritical	The notifications will be sent from the critical level (for the critical and error problems).	Versions 18 and later <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient New in version 18 <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
Versions 18 and later hNotifEmail New in version 18 hNotifEmail hNotifEmail	The notifications are sent by email.	Versions 18 and later <Connection variable>.NotifConfigure New in version 18 <Connection variable>.NotifConfigure <Connection variable>.NotifConfigure
Versions 18 and later hNotifError New in version 18 hNotifError hNotifError	The notifications will be sent for the error problems only.	Versions 18 and later <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient New in version 18 <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
Versions 22 and later hNotifInformation New in version 22 hNotifInformation hNotifInformation	The notifications will be sent from the information level (for the information, warning, critical and error problems)	<Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
Versions 18 and later hNotifWarning New in version 18 hNotifWarning hNotifWarning	The notifications will be sent from the warning level (for the warning, critical and error problems).	Versions 18 and later <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient New in version 18 <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient
hNotLocking	Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To find out whether the execution of the view or query is completed, use ..ExecutionCompleted. This constant is available for the views and queries in HFSQL Classic or Client/Server. This constant has no effect for the data files and for the Native Connectors	<Source>.NbRec
hNotReplicated	Replication mode: The data file is not configured for replication. To implement the replication, check "Replication" in the characteristics of the file in the data model editor.	..Replication
hNotSorted	Sort direction: Item not sorted	..SortType
hODBC	OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Used to access an ODBC source declared in the ODBC data sources of Windows	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbAccess2000	OLE DB provider that will be used for the connection: OLE DB provider for Access 2000	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbAccess2007	OLE DB provider that will be used for the connection: OLE DB provider for Access 2007	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
Versions 19 and later hOledbAccess2010 New in version 19 hOledbAccess2010 hOledbAccess2010	OLE DB provider that will be used for the connection: OLE DB provider for Access 2010	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbAccess97	OLE DB provider that will be used for the connection: OLE DB provider for Access 97	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbDBase5	OLE DB provider that will be used for the connection: OLE DB provider for dBase 5	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbExcel2000	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbExcel2007	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbExcel97	OLE DB provider that will be used for the connection: OLE DB provider for Excel 97	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbLotus4	OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbOracle	OLE DB provider that will be used for the connection: OLE DB provider for Oracle	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOledbSQLServer	OLE DB provider that will be used for the connection: OLE DB provider for SQL Server	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect
hOnDelete	Integrity rule applied during a deletion	<Connection variable>.SetIntegrity
hOnUpdate	Integrity rule applied during a modification	<Connection variable>.SetIntegrity
hOpenKeysetCursor	Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions).	HDescribeConnection, <Connection variable>.OpenConnection
hOptimisticCursor	The record is locked when it is updated	HDescribeConnection, <Connection variable>.OpenConnection
Versions 15 and later hOptIndex New in version 15 hOptIndex hOptIndex	Optimization options: Provokes the re-indexing operation on the data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes.	hFileParameter variable
Versions 15 and later hOptStat New in version 15 hOptStat hOptStat	Optimization options: Provokes the recalculation of statistics on the data files.	hFileParameter variable
hORead	File accessible in read-only	..CtAccess, ..CtDescribedAccess, HConnect, <Source>.Open
hOReadWrite	File accessible in read/write	..CtAccess, ..CtDescribedAccess, HConnect, <Source>.Open
hOwner	Property of a database found on an HFSQL server: Owner of database.	<Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty
hPackNo	Compression mode: No compression	..MmoPackMethod
hPackZLW	Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation.	..MmoPackMethod
hPageSize	Size of a block of caches. This block of caches will be used when browsing a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption.	HSetCache
hPessimisticCursor	The record is locked as soon as it becomes in edit to be modified.	HDescribeConnection, <Connection variable>.OpenConnection
hPrecisionHigh	Position with high precision	<Source>.GetCurrentPosition, <Source>.SetPosition
hPrecisionLow	Position with low precision	<Source>.GetCurrentPosition, <Source>.SetPosition
hPrecisionMedium	Position with medium precision	<Source>.GetCurrentPosition, <Source>.SetPosition
hQueryBreakable	The query initialization can be interrupted with the ESC key	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hQueryDefault	The query is initialized without interruption	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hQueryWithoutCorrection	Native Connector or OLE DB only: No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.)	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hQueryWithoutHFCorrection	HFSQL only The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters.	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
Versions 19 and later hReadCommitted New in version 19 hReadCommitted hReadCommitted	Isolation level of transaction: only the finalized transactions are visible by the other users.	Versions 19 and later <Connection variable>.TransactionIsolation New in version 19 <Connection variable>.TransactionIsolation <Connection variable>.TransactionIsolation
hReadOnlyCursor	The set of records cannot be modified.	HDescribeConnection,