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 constants for managing HFSQL data files are as follows:


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 to the 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
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 operation, even if the duplicate check is switched off (function 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 its 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: When a browse is performed on a key item, a single record is browsed if duplicates are found	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 the Esc key on the keyboard. 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
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: Request	..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 to the 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	Ignore the duplicate check for this operation, even if the automatic duplicate check is connected (HSetDuplicates function).	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 the ESC key on the keyboard.	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. or the value of the wage types in the current record before calling the HImportText function.	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 line of 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 path will take into account the filter set up with the HFilter function, even if the path key used is not optimized for the filter.. Reminder: the function HFilter returns the optimized path key for the filter. Caution: In this case, on large files, performance problems may occur.	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: replication of servers.	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	Re-indexation with deletion of damaged records	HIndex
hNdxMinimal	Re-index operation while ignoring the corrupted keys	HIndex
hNdxNormal	Standard re-index operation	HIndex
hNdxNoStat	Re-indexation without calculation of statistics	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: Description of the database or any other information associated with the database using the HModifyDatabaseProperty function.	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, ...)	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 the 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	Right to forbid or not to forbid access to a database (functions 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: Restoration of the filter installed at the time of HSavePosition	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 when calling the HRestorePosition function.	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: Keeps the contents of the view the next time the HExecuteView function 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 search 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 search items specified when browsing the result are taken into account. the magnifier is available for the 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, ...), 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 constants for the management of HFSQL data files (Prefixed syntax) are as follows:


Constant	Affects	Used by the functions or properties
eltProcedure	The listed element is a stored procedure	<Login variable>.StoredList
eltQuery	The listed element is a query.	<Login variable>.StoredList
eltSetOfProcedures	The listed element is a set of procedures	<Login variable>.StoredList
Versions 15 and later h3G New in version 15 h3G h3G	Type of network to simulate: 3G	<Variable Connection>.NetworkSimulation
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>.AttachmentMemo
hAccessHF7	Pseudo-connection to HFSQL Classic database.	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, <Variable Connection>.OpenConnection
hAccessJDBCSQLServer	Access to a SQL Server database via a JDBC driver	HDescribeConnection, <Variable Connection>.OpenConnection
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	<Variable Connection>.ManageServer
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	<Variable Connection>.ManageServer
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	<Variable Connection>.ManageServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	<Variable Connection>.NetworkSimulation
hAffectBrowse	Addition affecting the current browse	<Source>.Adds, <Source>.Modify
hAllowed	The relevant rights are granted to the user or to the 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).	<Variable Connection>.ManageServer
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>.StatCalcule, <Source>.Reindex
hBackupCanceled	Status of backup: Backup canceled	<Variable Connection>.InfoBackup
hBackupCompleted	Status of backup: Backup completed	<Variable Connection>.InfoBackup
Versions 15 and later hBackupDifferential New in version 15 hBackupDifferential hBackupDifferential	Type of backup: Differential backup	<Variable Connection>.InfoBackup
hBackupError	Status of backup: Error during backup	<Variable Connection>.InfoBackup
Versions 15 and later hBackupFull New in version 15 hBackupFull hBackupFull	Type of backup: Full backup	<Variable Connection>.InfoBackup
hBackupInProgress	Status of backup: Backup in progress	<Variable Connection>.InfoBackup
hBoundSeparator	Used to separate the values of lower and upper bounds for the components of composite key	<Source>.FilterComprised (Function)
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.	<Variable Connection>.ManageServer
hCardinality	Integrity constraints: Check the link cardinalities.	<Variable Connection>.ManageIntegrity
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>.CreationIfNonexistent, <Source>.Reindex
hCheckDuplicates	Checks for duplicates for this operation, even if the duplicate check is switched off (function <Source>.GérerDoublon).	<Source>.Adds, <HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL, <Source>.Modify
hCheckIntegrity	Checks the integrity of operation even if the automatic integrity check is disabled (<Variable Connection>.ManageIntegrity)	<Source>.Adds, <HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL, <Source>.Modify, <Fichier HFSQL>.Raye, <Source>.Delete
hCheckMemo	Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos)	<Source>.Reindex
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, <Variable Connection>.OpenConnection
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	<Source>.VerifyStructure
hComputer	Property of a database found on an HFSQL server: Name of the computer from which the element was created.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile
hCopyAutoId	Copies the automatic identifier while keeping its value	<Source>.SaveCopy, <Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	<Variable Connection>.CopyFile
hCopyIndex	Copies the index of the data file	<Variable Connection>.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 re-indexing.	<Variable Connection>.CopyFile
hCreator	Property of a database found on an HFSQL server: Name of database owner.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile
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)	<Variable Connection>.ManageServer
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	<Variable Connection>.RegenerateFile
hDatabasePath	Path of directory containing all databases	<Variable Connection>.ManageServer
hDate	Property of a database found on an HFSQL server: Creation date of the database.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile
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 <Variable Login>.InfoVue New in version 20 <Variable Login>.InfoVue <Variable Login>.InfoVue
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.	<Variable Connection>.ManageServer
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).	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer
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>.SaveCopy, <Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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>.CreationIfNonexistent
hDeleteLog	Deletes the log file	<Login>.DeleteFile, <Connection Variable>.DeleteDatabase
hDestroyLink	Deletes all links related to the deleted data file.	<Login>.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 its value.	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer
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>.Declares
hDistinct	Management of duplicates during the browse: When a browse is performed on a key item, a single record is browsed if duplicates are found	<Source>.Advance, <Source>.LitPrevious, <Source>.LitNext, <Source>.Previous, <Source>.Recule, <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, <Variable Connection>.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).	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer
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>.SurError
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>.SurError
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>.SurError
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>.SurError
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>.SurError
hErrIntegrity	Customize integrity errors	<Source>.SurError
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>.SurError
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>.SurError
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>.SurError
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 <Variable Login>.InfoVue New in version 20 <Variable Login>.InfoVue <Variable Login>.InfoVue
hErrPassword	Customize password errors	<Source>.SurError
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>.ExecuteQuerySQL.	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 the Esc key on the keyboard. If the export is interrupted, the export file is valid and it only contains the records exported before the interruption.	<Source>.ExporteXML Versions 21 and later <Source>.ExporteJSON New in version 21 <Source>.ExporteJSON <Source>.ExporteJSON Versions 24 and later <Source>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
hExpCreation	Mode for creating the export file: The file is overwritten if it already exists.	<Source>.ExporteXML Versions 21 and later <Source>.ExporteJSON New in version 21 <Source>.ExporteJSON <Source>.ExporteJSON Versions 24 and later <Source>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
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>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
hExpNormal	Mode for creating the export file: Standard operating mode	<Source>.ExporteXML Versions 21 and later <Source>.ExporteJSON New in version 21 <Source>.ExporteJSON <Source>.ExporteJSON Versions 24 and later <Source>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
hExpWithoutXSL	The style sheet (".XSL" file) is not created	<Source>.ExporteXML
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: Request	..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.	<Variable Connection>.ManageServer
hForbidden	The relevant rights are not granted to the user or to the group	<ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile, <Variable Connection>.ModifyRightServer
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>.LitDernier, <Source>.LitFirst (Function), <Source>.LitResearchFirst, <Source>.LastResearchList
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, <Variable Connection>.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>.Reindex
hFtxSize	Size of full-text index file in bytes (".Ftx" file)	<Source>.InfoFile
HGeneric	Type of search: Generic search	<Source>.LastResearchList, <Source>.LitResearchFirst, <Source>.LastSearch, <Source>.ResearchFirst
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>.LitSearch, <Source>.Research, <Source>.VerifyStructure
hIgnoreDuplicates	Ignore the duplicate check for this operation, even if the automatic duplicate check is connected (<Source>.GérerDoublon function).	<Source>.Adds
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (<Variable Connection>.ManageIntegrity)	<Source>.Adds, <Source>.Modify, <Source>.Delete, <Fichier HFSQL>.Raye
hImpBreakable	The import can be interrupted by pressing the ESC key on the keyboard.	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS, New in version 20 <Source>.ImporteXLS, <Source>.ImporteXLS, <Source>.ImporteXML Versions 21 and later <Source>.ImporteJSON New in version 21 <Source>.ImporteJSON <Source>.ImporteJSON
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>.ImporteHF55
hImpCreation	Type of import: If the (HFSQL Classic) import file exists, it is overwritten.	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS, New in version 20 <Source>.ImporteXLS, <Source>.ImporteXLS, <Source>.ImporteXML Versions 21 and later <Source>.ImporteJSON New in version 21 <Source>.ImporteJSON <Source>.ImporteJSON
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. or the value of the wage types in the current record before calling the <Source>.ImporteTexte function.	<Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
Versions 20 and later hImpIgnoreFirstLine New in version 20 hImpIgnoreFirstLine hImpIgnoreFirstLine	Type of import: The first line of imported file is ignored.	<Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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>.ImporteHF55
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	<Source>.ImporteTexte
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>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS, New in version 20 <Source>.ImporteXLS, <Source>.ImporteXLS, <Source>.ImporteXML Versions 21 and later <Source>.ImporteJSON New in version 21 <Source>.ImporteJSON <Source>.ImporteJSON
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	<Source>.ImporteHF55
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	<Source>.ImporteTexte
hImpTestDuplicates	Type of import: Checks the duplicates during the import	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
hImpTestIntegrity	Type of import: Checks the integrity during the import	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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).	<Variable Login>.InfoServer Info
Versions 15 and later hInfoCluster New in version 15 hInfoCluster hInfoCluster	Information about the HFSQL cluster.	<Variable Login>.InfoServer Info
hInfoDate	Date and time of server on 8 bytes in UTC format (universal time)	<Variable Login>.InfoServer Info
Versions 22 and later hInfoFreeDiskSpace New in version 22 hInfoFreeDiskSpace hInfoFreeDiskSpace	Available space on the server disk, expressed in MB.	<Variable Login>.InfoServer Info
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>	<Variable Login>.InfoServer Info
hInfoLogicalName	Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center.	<Variable Login>.InfoServer Info
hInfoName	Name of server (DNS)	<Variable Login>.InfoServer Info
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>	<Variable Login>.InfoServer Info
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.	<Variable Login>.InfoServer Info
Versions 22 and later hInfoTotalDiskSpace New in version 22 hInfoTotalDiskSpace hInfoTotalDiskSpace	Total capacity of server disk, expressed in MB.	<Variable Login>.InfoServer Info
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<	<Variable Login>.InfoServer Info
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<	<Variable Login>.InfoServer Info
hInfoVI	Version number of Manta.exe or Manta in Linux	<Variable Login>.InfoServer Info
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	<ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile, <Variable Connection>.ModifyRightServer
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>.NumEnr
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	<Variable Connection>.ManageServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	<Variable Connection>.ManageServer
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.	<Variable Connection>.ManageServer
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.	<Variable Connection>.ManageServer
hKeepFilter	The path will take into account the filter set up with the HFilter function, even if the path key used is not optimized for the filter.. Reminder: the function HFilter returns the optimized path key for the filter. Caution: In this case, on large files, performance problems may occur.	<Source>.ChangeClé, <Source>.Last, <Source>.LitDernier, <Source>.LitPremier, <Source>.LastResearchList, <Source>.LitResearchFirst, <Source>.LitSearch, HFirst, <Source>.Research, <Source>.LastSearch, <Source>.ResearchFirst
hKeepTRS	Stores the transaction files during the deletion	<Connection Variable>.DeleteDatabase, <Login>.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	<Variable Connection>.ManageServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	<Variable Connection>.ManageServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	<Variable Connection>.ManageServer
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	<Variable Connection>.ManageServer
hlbMaxTimeout	Value modifying the maximum time-out for a server request	<Variable Connection>.ManageServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	<Variable Connection>.ManageServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	<Variable Connection>.ManageServer
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>.Find will be set to False and <Source: Outside. will be set to True. This constant is used to optimize the search speed in client/server mode.	<Source>.LitSearch, <Source>.LastResearchList, <Source>.LitResearchFirst, <Source>.Research, <Source>.LastSearch, <Source>.ResearchFirst
hLockNo	Type of lock: No lock	<Source>.Adds, 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>.Adds, 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>.Adds, 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>.JournalRecreated
hLogJNLFile	Configures the file to re-create: Only <File name>JNL.FIC is recreated.	<Source>.JournalRecreated
hLogLevel	Defines the elements that must be found in the log file	<Variable Connection>.ManageServer
hLogNo	Format of log process: No log	..LogMethod
hLogOperation	Configures the file to re-create: Re-creates the "JournalOperation.fic" file.	<Source>.JournalRecreated
hLogPath	Path of the directory containing the log files	<Variable Connection>.ManageServer
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>.JournalRecreated
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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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: replication of servers.	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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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>.KeyList, HListFile, <Source>.ItemList, HListConnection, <Login variable>.StoredList
hLstCompositeKey	Lists the composite key items only	<Source>.KeyList, <Source>.ItemList
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	<Variable Login>.DatabaseList
hLstDetail	Lists the detailed information	<Source>.KeyList, HListFile, <Source>.LinkList, <Source>.ItemList, HListConnection, <Login variable>.StoredList
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>.KeyList, <Source>.ItemList
hLstFile	Lists the databases and their files for the server defined by the connection	<Variable Login>.DatabaseList
hLstItem	Lists the non-key and non-memo items	<Source>.ItemList
hLstKey	Lists the key items	<Source>.KeyList, <Source>.ItemList
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	<Source>.KeyList, <Source>.ItemList
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>.ItemList
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>.KeyList, HListFile, <Source>.ItemList, 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>.KeyList, <Source>.ItemList
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.	<Login variable>.StoredList HListFile
hLstSet	Lists the sets of procedures found on a server	<Login variable>.StoredList
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	<Source>.KeyList, HListFile, <Source>.ItemList, HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, <Login variable>.StoredList
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	<Variable Connection>.ManageServer
hMaxLogSize	Maximum size in megabytes (MB) of log files	<Variable Connection>.ManageServer
Versions 24 and later hMaxNumberConnection New in version 24 hMaxNumberConnection hMaxNumberConnection	Maximum number of connections allowed per application.	<Variable Connection>.ManageServer
hMaxVal	Defines an upper bound for a filter	<Source>.BuildsKeyValue, <Source>.Filter, <Source>.FilterStartBy, <Source>.FilterComprised (Function)
hMemoAuto	The memos are read during the access to the item	<Source>.ManageMemo
hMemoBin	Type of file used for the memo: Any binary file	<Source>.AttachmentMemo
hMemoImg	Type of file used for the memo: Image file	<Source>.AttachmentMemo
hMemoNo	No management of memos	<Source>.ManageMemo
hMemoOle	Type of file used for the memo: OLE file	<Source>.AttachmentMemo
hMemoWav	Type of file used for the memo: sound file	<Source>.AttachmentMemo
hMemoYes	The text memos are read whenever the record is read. Read the binary memos when accessing the item.	<Source>.ManageMemo
hMessage	Configure the information message	HOnServerCall
hMinVal	Defines a lower bound for a filter	<Source>.BuildsKeyValue, <Source>.Filter, <Source>.FilterStartBy, <Source>.FilterComprised (Function)
Versions 20 and later hMmoCompact New in version 20 hMmoCompact hMmoCompact	Compression and defragmentation of "Mmo" files.	<Source>.Reindex
hMmoSize	Size of memo file in bytes (".Mmo" file)	<Source>.InfoFile
hMode2GB	Indicates whether the system files support more than 2 GB	<Variable Connection>.ManageServer
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>.RunQuery, <HFSQL File>.ExecuteQuerySQL
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>.ModifieStructure New in version 17 <Source>.ModifieStructure <Source>.ModifieStructure
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>.ModifieStructure New in version 17 <Source>.ModifieStructure <Source>.ModifieStructure
Versions 17 and later hmsNormal New in version 17 hmsNormal hmsNormal	Standard operating mode of the automatic data modification.	Versions 17 and later <Source>.ModifieStructure New in version 17 <Source>.ModifieStructure <Source>.ModifieStructure
hNativeAccessAS400	Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessMySQL	OLE DB provider that will be used for the connection: Native MySQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessPostgreSQL	OLE DB provider that will be used for the connection: Native PostgreSQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXBase	OLE DB provider that will be used for the connection: Native xBase Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	<Variable Connection>.ManageServer
hNdxCompact	Re-index operation with compression	<Source>.Reindex
hNdxDelete	Re-indexation with deletion of damaged records	<Source>.Reindex
hNdxMinimal	Re-index operation while ignoring the corrupted keys	<Source>.Reindex
hNdxNormal	Standard re-index operation	<Source>.Reindex
hNdxNoStat	Re-indexation without calculation of statistics	<Source>.Reindex
hNdxSilent	Configure the re-index operation: No display while re-indexing	<Source>.Reindex
hNdxSize	Size of index file in bytes (".Ndx" file)	<Source>.InfoFile
hNoBind	Run a query without enabling the bind	<HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL, <Source>.PrepareSQLQuery
hNoCheck	No check is performed, the analysis description may differ from the description of physical file.	<Source>.VerifyStructure
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>.RunQuery, <HFSQL File>.ExecuteQuerySQL
hNoIndex	The file index is not copied	<Variable Connection>.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>.CreationIfNonexistent
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	<Variable Connection>.NetworkSimulation
hNoRefresh	The table or query content will not be refreshed	<Source>.Last, <Source>.LitDernier, <Source>.LitPremier, <Source>.First (Function)
hNotAKey	Characteristics of an item: Non-key item	..KeyType
hNotes	Property of a database found on an HFSQL server: Description of the database or any other information associated with the database using the <ChangeOwnershipDatabase function.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile, <Variable Login>.ServerProperty Info, <ChangeOwnershipDatabase, < Connection Variable>.ChangePropertyFile, <Connection Variable>.ChangeServer Properties
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 <Variable Connection>.NotifConfigure New in version 18 <Variable Connection>.NotifConfigure <Variable Connection>.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 <Variable Connection>.NotifConfigure New in version 18 <Variable Connection>.NotifConfigure <Variable Connection>.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 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail New in version 18 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail
Versions 18 and later hNotifEmail New in version 18 hNotifEmail hNotifEmail	The notifications are sent by email.	Versions 18 and later <Variable Connection>.NotifConfigure New in version 18 <Variable Connection>.NotifConfigure <Variable Connection>.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 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail New in version 18 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail
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)	<Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail
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 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail New in version 18 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail
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>.NbEnr
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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.OpenConnection, SQLConnect
hOledbOracle	OLE DB provider that will be used for the connection: OLE DB provider for Oracle	..CtOLEDBProvider, ..CtDescribedOLEDBProvider, HConnect, <Source>.DeclareExternal, HListFile, <Variable Connection>.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, <Variable Connection>.OpenConnection, SQLConnect
hOnDelete	Integrity rule applied during a deletion	<Variable Connection>.ManageIntegrity
hOnUpdate	Integrity rule applied during a modification	<Variable Connection>.ManageIntegrity
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, <Variable Connection>.OpenConnection
hOptimisticCursor	The record is locked when it is updated	HDescribeConnection, <Variable Connection>.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.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile, <ChangeOwnershipDatabase, < Connection Variable>.ChangePropertyFile
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, <Variable Connection>.OpenConnection
hPrecisionHigh	Position with high precision	<Source>.CurrentPosition, <Source>.Position
hPrecisionLow	Position with low precision	<Source>.CurrentPosition, <Source>.Position
hPrecisionMedium	Position with medium precision	<Source>.CurrentPosition, <Source>.Position
hQueryBreakable	The query initialization can be interrupted with the ESC key	<HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL
hQueryDefault	The query is initialized without interruption	<HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL
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, ...)	<HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL
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>.RunQuery, <HFSQL File>.ExecuteQuerySQL
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, <Variable Connection>.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>.Written, <Source>.Modify
hRecFile	Record to read: Value of the item currently saved in the data file	<Source>.ModificationError, <Source>.ErrorStatusErrorModification
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>.Monitor, <Source>.WatchStop. New in version 22 <Source>.Monitor, <Source>.WatchStop. <Source>.Monitor, <Source>.WatchStop. Versions 23 and later <Source>.VerifyImpaired. New in version 23 <Source>.VerifyImpaired. <Source>.VerifyImpaired.
hRecRead	Record to read: Value of the item for the source record	<Source>.ModificationError, <Source>.ErrorStatusErrorModification
hRecUser	Record to read: Value of the item for the current record when performing the modification	<Source>.ModificationError, <Source>.ErrorStatusErrorModification
Versions 20 and later hRefreshInProgress New in version 20 hRefreshInProgress hRefreshInProgress	Requested information: Is the materialized view currently refreshed?	Versions 20 and later <Variable Login>.InfoVue New in version 20 <Variable Login>.InfoVue <Variable Login>.InfoVue
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	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer
hRightsAutoModif	Rights to perform the automatic modification of the data files on a file	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsBackup	Rights to save the data files	<Variable Login>.RightDatabaseInfo, <Variable Login>.InfoRightServer, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Variable Connection>.ModifyRightServer
hRightsChangeLink	Rights to modify the integrity rules on a data file.	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsChangeOwner	Rights to modify the owner of an element	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
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).	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsChangeRights	Rights to change the rights.	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile, <Variable Connection>.ModifyRightServer
hRightsConnection	Rights to connect to a server (encrypted or unencrypted connection)	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsCreateDB	Rights to create a database	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsCreateFile	Rights to create a data file (with <Source>.Creation)	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
Versions 20 and later hRightsCreateView New in version 20 hRightsCreateView hRightsCreateView	Rights to create a SQL view or a materialized view.	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsDebug	Rights to debug the stored procedures.	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsDelete	Rights to delete the records from a data file	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsDeleteDB	Rights to delete a database	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsDeleteFile	Rights to delete a data file (<Login>.DeleteFile)	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
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 <Variable Login>.InfoRightView, <Connection>.ChangeRightView New in version 20 <Variable Login>.InfoRightView, <Connection>.ChangeRightView <Variable Login>.InfoRightView, <Connection>.ChangeRightView
hRightsDisconnectClient	Rights to disconnect the client computers.	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsEncryptedConnection	Rights to connect to a server (encrypted connection only)	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsInsert	Rights to add new records into a data file.	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsLock	Rights to lock the data files or the records of a data file.	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsMaintenance	Rights to start a re-index operation or to perform statistical calculations on a data file	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsManageDuplicate	Rights to enable and disable the management of duplicates.	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsManageIntegrity	Rights to enable and disable the management of integrity.	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsManageProcedure	Rights to add, modify and delete the stored procedures.	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsManageServer	Rights to use <Variable Connection>.ManageServer	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsManageTask	Rights to manage the scheduled tasks.	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsManageTrigger	Rights to manage the server triggers (addition, activation, deletion)	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsManageUser	Rights to delete and add users or groups	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsNoDatabaseAccess	Right to forbid or not to forbid access to a database (functions <Connection Variable>.ProhibitedDatabase Access and <Variable Login>.EndProhibitedDatabaseAccess)	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsPriority	Rights to modify the priority of a client application	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsRead	Rights to read the records of a data file	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRightsReadLogStat	Rights to see the activity statistics and the logs of the server.	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsRunProcedure	Rights to run the stored procedures.	<Variable Login>.RightDatabaseInfo, <ChangeRightDatabasecontrol>.ModifyRightDatabase
hRightsSeeUser	Rights to view the characteristics of a group or user.	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsSendMessageToClient	Rights to send messages to the client computers.	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
Versions 18 and later hRightsServerReplication New in version 18 hRightsServerReplication hRightsServerReplication	Rights to define and perform a replication between two HFSQL servers.	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsStopServer	Rights to stop a server (<Variable Login>.StopServer)	<Variable Login>.InfoRightServer, <Variable Connection>.ModifyRightServer
hRightsUpdate	Rights to modify the records of a data file	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile
hRPDefault	Configure the restore operation: Position freed. The stored position is restored	<Source>.ReturnPosition
hRPFilter	Configure the restore operation: Restoration of the filter installed at the time of <HFSQL File>.SavePosition	<Source>.ReturnPosition
hRPHF5	Configure the restore operation: If the stored position was deleted or modified, this position is restored	<Source>.ReturnPosition
hRPKeep	Configure the restore operation: Position not freed	<Source>.ReturnPosition
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.	<Variable Connection>.RSAaddsConfig
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.	<Variable Connection>.RSAaddsConfig
Versions 22 and later hrsNoCopy New in version 22 hrsNoCopy hrsNoCopy	Configure the replication between servers: No copy is performed.	<Variable Connection>.RSAaddsConfig
Versions 22 and later hsAdd New in version 22 hsAdd hsAdd	Monitors the operations for adding records.	Versions 22 and later <Source>.Monitor New in version 22 <Source>.Monitor <Source>.Monitor
hSaveItems	Saves the values of items in memory when using HSavePosition. These values will be restored when calling the <Source>.ReturnPosition function.	<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>.Monitor New in version 22 <Source>.Monitor <Source>.Monitor
Versions 22 and later hsDeletion New in version 22 hsDeletion hsDeletion	Monitors the operations for deleting records.	Versions 22 and later <Source>.Monitor New in version 22 <Source>.Monitor <Source>.Monitor
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, <Variable Connection>.OpenConnection
hServerPort	Network port used	<Variable Connection>.ManageServer
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the addition	<Source>.Adds, <Source>.Written, <Source>.Modify
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the write operation	<Source>.Adds, <Source>.Written, <Source>.Modify
Versions 22 and later hsModification New in version 22 hsModification hsModification	Monitors the operations for modifying records.	Versions 22 and later <Source>.Monitor New in version 22 <Source>.Monitor <Source>.Monitor
Versions 20 and later hSQLCode New in version 20 hSQLCode hSQLCode	Requested information: SQL code of the materialized view	Versions 20 and later <Variable Login>.InfoVue New in version 20 <Variable Login>.InfoVue <Variable Login>.InfoVue
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>.ExecuteQuerySQL
hStarted	Server started	HServerStatus
hStateActive	Status of the record/Type of record taken into account: Active record	<Source>.Report, <Source>.NbEnr, <Source>.ErrorStatusErrorModification
hStateAll	Type of record: Total number of records in the data file	<Source>.NbEnr
hStateCrossed	Status of the record/Type of record taken into account: Crossed record	<Source>.Report, <Source>.NbEnr, <Source>.ErrorStatusErrorModification
hStateDel	Status of the record/Type of record taken into account: Deleted record	<Source>.Report, <Source>.NbEnr, <Source>.ErrorStatusErrorModification
hStateInvalid	Record status not found (error)	<Source>.Report, <Source>.ErrorStatusErrorModification
hStaticCursor	Makes a copy of all query records in memory (consumes a lot of memory). All types of moves are allowed.	HDescribeConnection, <Variable Connection>.OpenConnection
hStopped	Server stopped	HServerStatus
hStructure	Configure the file management: New empty file created from the file description	<Variable Connection>.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.	<Variable Connection>.ManageServer
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).	<Variable Connection>.ManageServer
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>.DestroyTrigger, <Source>.DescribeTrigger
hTriggerBefore	Indicates the type of trigger: The procedure is run before the HFSQL function	HActivateTrigger, HDeactivateTrigger, <Source>.DestroyTrigger, <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>.RetrieveRecording
hUNICODEFormat	Data format: UNICODE format	..Format
hUniqueKey	Characteristics of an item: Unique key	..KeyType
hViewAdd	Create a view with addition: Keeps the contents of the view the next time the <Source>.RunView function 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>.RunView	<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>.Declares
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.	<Variable Connection>.ManageServer
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 search 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 search items specified when browsing the result are taken into account. the magnifier is available for the 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, ...), 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>.Adds, <Source>.Written, <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>.RunQuery, <HFSQL File>.ExecuteQuerySQL
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. <Variable Login>.InfoVue 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>.SurError
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>.SurError
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>.SurError
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>.SurError
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>.SurError

New in version 23
The constants for the management of HFSQL data files (Prefixed syntax) are as follows:


Constant	Affects	Used by the functions or properties
eltProcedure	The listed element is a stored procedure	<Login variable>.StoredList
eltQuery	The listed element is a query.	<Login variable>.StoredList
eltSetOfProcedures	The listed element is a set of procedures	<Login variable>.StoredList
Versions 15 and later h3G New in version 15 h3G h3G	Type of network to simulate: 3G	<Variable Connection>.NetworkSimulation
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>.AttachmentMemo
hAccessHF7	Pseudo-connection to HFSQL Classic database.	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, <Variable Connection>.OpenConnection
hAccessJDBCSQLServer	Access to a SQL Server database via a JDBC driver	HDescribeConnection, <Variable Connection>.OpenConnection
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	<Variable Connection>.ManageServer
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	<Variable Connection>.ManageServer
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	<Variable Connection>.ManageServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	<Variable Connection>.NetworkSimulation
hAffectBrowse	Addition affecting the current browse	<Source>.Adds, <Source>.Modify
hAllowed	The relevant rights are granted to the user or to the 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).	<Variable Connection>.ManageServer
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>.StatCalcule, <Source>.Reindex
hBackupCanceled	Status of backup: Backup canceled	<Variable Connection>.InfoBackup
hBackupCompleted	Status of backup: Backup completed	<Variable Connection>.InfoBackup
Versions 15 and later hBackupDifferential New in version 15 hBackupDifferential hBackupDifferential	Type of backup: Differential backup	<Variable Connection>.InfoBackup
hBackupError	Status of backup: Error during backup	<Variable Connection>.InfoBackup
Versions 15 and later hBackupFull New in version 15 hBackupFull hBackupFull	Type of backup: Full backup	<Variable Connection>.InfoBackup
hBackupInProgress	Status of backup: Backup in progress	<Variable Connection>.InfoBackup
hBoundSeparator	Used to separate the values of lower and upper bounds for the components of composite key	<Source>.FilterComprised (Function)
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.	<Variable Connection>.ManageServer
hCardinality	Integrity constraints: Check the link cardinalities.	<Variable Connection>.ManageIntegrity
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>.CreationIfNonexistent, <Source>.Reindex
hCheckDuplicates	Checks for duplicates for this operation, even if the duplicate check is switched off (function <Source>.GérerDoublon).	<Source>.Adds, <HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL, <Source>.Modify
hCheckIntegrity	Checks the integrity of operation even if the automatic integrity check is disabled (<Variable Connection>.ManageIntegrity)	<Source>.Adds, <HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL, <Source>.Modify, <Fichier HFSQL>.Raye, <Source>.Delete
hCheckMemo	Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos)	<Source>.Reindex
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, <Variable Connection>.OpenConnection
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	<Source>.VerifyStructure
hComputer	Property of a database found on an HFSQL server: Name of the computer from which the element was created.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile
hCopyAutoId	Copies the automatic identifier while keeping its value	<Source>.SaveCopy, <Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	<Variable Connection>.CopyFile
hCopyIndex	Copies the index of the data file	<Variable Connection>.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 re-indexing.	<Variable Connection>.CopyFile
hCreator	Property of a database found on an HFSQL server: Name of database owner.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile
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)	<Variable Connection>.ManageServer
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	<Variable Connection>.RegenerateFile
hDatabasePath	Path of directory containing all databases	<Variable Connection>.ManageServer
hDate	Property of a database found on an HFSQL server: Creation date of the database.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile
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 <Variable Login>.InfoVue New in version 20 <Variable Login>.InfoVue <Variable Login>.InfoVue
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.	<Variable Connection>.ManageServer
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).	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer
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>.SaveCopy, <Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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>.CreationIfNonexistent
hDeleteLog	Deletes the log file	<Login>.DeleteFile, <Connection Variable>.DeleteDatabase
hDestroyLink	Deletes all links related to the deleted data file.	<Login>.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 its value.	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer
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>.Declares
hDistinct	Management of duplicates during the browse: When a browse is performed on a key item, a single record is browsed if duplicates are found	<Source>.Advance, <Source>.LitPrevious, <Source>.LitNext, <Source>.Previous, <Source>.Recule, <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, <Variable Connection>.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).	<Variable Login>.RightDatabaseInfo, <Variable Connection>.RightFile Info, <Variable Login>.InfoRightServer
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>.SurError
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>.SurError
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>.SurError
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>.SurError
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>.SurError
hErrIntegrity	Customize integrity errors	<Source>.SurError
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>.SurError
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>.SurError
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>.SurError
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 <Variable Login>.InfoVue New in version 20 <Variable Login>.InfoVue <Variable Login>.InfoVue
hErrPassword	Customize password errors	<Source>.SurError
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>.ExecuteQuerySQL.	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 the Esc key on the keyboard. If the export is interrupted, the export file is valid and it only contains the records exported before the interruption.	<Source>.ExporteXML Versions 21 and later <Source>.ExporteJSON New in version 21 <Source>.ExporteJSON <Source>.ExporteJSON Versions 24 and later <Source>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
hExpCreation	Mode for creating the export file: The file is overwritten if it already exists.	<Source>.ExporteXML Versions 21 and later <Source>.ExporteJSON New in version 21 <Source>.ExporteJSON <Source>.ExporteJSON Versions 24 and later <Source>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
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>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
hExpNormal	Mode for creating the export file: Standard operating mode	<Source>.ExporteXML Versions 21 and later <Source>.ExporteJSON New in version 21 <Source>.ExporteJSON <Source>.ExporteJSON Versions 24 and later <Source>.ExporteCSV New in version 24 <Source>.ExporteCSV <Source>.ExporteCSV Versions 24 and later <Source>.ExporteXLS New in version 24 <Source>.ExporteXLS <Source>.ExporteXLS
hExpWithoutXSL	The style sheet (".XSL" file) is not created	<Source>.ExporteXML
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: Request	..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.	<Variable Connection>.ManageServer
hForbidden	The relevant rights are not granted to the user or to the group	<ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile, <Variable Connection>.ModifyRightServer
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>.LitDernier, <Source>.LitFirst (Function), <Source>.LitResearchFirst, <Source>.LastResearchList
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, <Variable Connection>.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>.Reindex
hFtxSize	Size of full-text index file in bytes (".Ftx" file)	<Source>.InfoFile
HGeneric	Type of search: Generic search	<Source>.LastResearchList, <Source>.LitResearchFirst, <Source>.LastSearch, <Source>.ResearchFirst
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>.LitSearch, <Source>.Research, <Source>.VerifyStructure
hIgnoreDuplicates	Ignore the duplicate check for this operation, even if the automatic duplicate check is connected (<Source>.GérerDoublon function).	<Source>.Adds
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (<Variable Connection>.ManageIntegrity)	<Source>.Adds, <Source>.Modify, <Source>.Delete, <Fichier HFSQL>.Raye
hImpBreakable	The import can be interrupted by pressing the ESC key on the keyboard.	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS, New in version 20 <Source>.ImporteXLS, <Source>.ImporteXLS, <Source>.ImporteXML Versions 21 and later <Source>.ImporteJSON New in version 21 <Source>.ImporteJSON <Source>.ImporteJSON
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>.ImporteHF55
hImpCreation	Type of import: If the (HFSQL Classic) import file exists, it is overwritten.	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS, New in version 20 <Source>.ImporteXLS, <Source>.ImporteXLS, <Source>.ImporteXML Versions 21 and later <Source>.ImporteJSON New in version 21 <Source>.ImporteJSON <Source>.ImporteJSON
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. or the value of the wage types in the current record before calling the <Source>.ImporteTexte function.	<Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
Versions 20 and later hImpIgnoreFirstLine New in version 20 hImpIgnoreFirstLine hImpIgnoreFirstLine	Type of import: The first line of imported file is ignored.	<Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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>.ImporteHF55
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	<Source>.ImporteTexte
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>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS, New in version 20 <Source>.ImporteXLS, <Source>.ImporteXLS, <Source>.ImporteXML Versions 21 and later <Source>.ImporteJSON New in version 21 <Source>.ImporteJSON <Source>.ImporteJSON
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	<Source>.ImporteHF55
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	<Source>.ImporteTexte
hImpTestDuplicates	Type of import: Checks the duplicates during the import	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
hImpTestIntegrity	Type of import: Checks the integrity during the import	<Source>.ImporteHF55, <Source>.ImporteTexte, Versions 20 and later <Source>.ImporteXLS New in version 20 <Source>.ImporteXLS <Source>.ImporteXLS
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).	<Variable Login>.InfoServer Info
Versions 15 and later hInfoCluster New in version 15 hInfoCluster hInfoCluster	Information about the HFSQL cluster.	<Variable Login>.InfoServer Info
hInfoDate	Date and time of server on 8 bytes in UTC format (universal time)	<Variable Login>.InfoServer Info
Versions 22 and later hInfoFreeDiskSpace New in version 22 hInfoFreeDiskSpace hInfoFreeDiskSpace	Available space on the server disk, expressed in MB.	<Variable Login>.InfoServer Info
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>	<Variable Login>.InfoServer Info
hInfoLogicalName	Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center.	<Variable Login>.InfoServer Info
hInfoName	Name of server (DNS)	<Variable Login>.InfoServer Info
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>	<Variable Login>.InfoServer Info
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.	<Variable Login>.InfoServer Info
Versions 22 and later hInfoTotalDiskSpace New in version 22 hInfoTotalDiskSpace hInfoTotalDiskSpace	Total capacity of server disk, expressed in MB.	<Variable Login>.InfoServer Info
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<	<Variable Login>.InfoServer Info
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<	<Variable Login>.InfoServer Info
hInfoVI	Version number of Manta.exe or Manta in Linux	<Variable Login>.InfoServer Info
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	<ChangeRightDatabasecontrol>.ModifyRightDatabase, <Connection variable>.ChangeRightFile, <Variable Connection>.ModifyRightServer
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>.NumEnr
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	<Variable Connection>.ManageServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	<Variable Connection>.ManageServer
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.	<Variable Connection>.ManageServer
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.	<Variable Connection>.ManageServer
hKeepFilter	The path will take into account the filter set up with the HFilter function, even if the path key used is not optimized for the filter.. Reminder: the function HFilter returns the optimized path key for the filter. Caution: In this case, on large files, performance problems may occur.	<Source>.ChangeClé, <Source>.Last, <Source>.LitDernier, <Source>.LitPremier, <Source>.LastResearchList, <Source>.LitResearchFirst, <Source>.LitSearch, HFirst, <Source>.Research, <Source>.LastSearch, <Source>.ResearchFirst
hKeepTRS	Stores the transaction files during the deletion	<Connection Variable>.DeleteDatabase, <Login>.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	<Variable Connection>.ManageServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	<Variable Connection>.ManageServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	<Variable Connection>.ManageServer
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	<Variable Connection>.ManageServer
hlbMaxTimeout	Value modifying the maximum time-out for a server request	<Variable Connection>.ManageServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	<Variable Connection>.ManageServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	<Variable Connection>.ManageServer
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>.Find will be set to False and <Source: Outside. will be set to True. This constant is used to optimize the search speed in client/server mode.	<Source>.LitSearch, <Source>.LastResearchList, <Source>.LitResearchFirst, <Source>.Research, <Source>.LastSearch, <Source>.ResearchFirst
hLockNo	Type of lock: No lock	<Source>.Adds, 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>.Adds, 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>.Adds, 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>.JournalRecreated
hLogJNLFile	Configures the file to re-create: Only <File name>JNL.FIC is recreated.	<Source>.JournalRecreated
hLogLevel	Defines the elements that must be found in the log file	<Variable Connection>.ManageServer
hLogNo	Format of log process: No log	..LogMethod
hLogOperation	Configures the file to re-create: Re-creates the "JournalOperation.fic" file.	<Source>.JournalRecreated
hLogPath	Path of the directory containing the log files	<Variable Connection>.ManageServer
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>.JournalRecreated
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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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: replication of servers.	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>.ListPlanning New in version 20 <Connection variable>.ListPlanning <Connection variable>.ListPlanning 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>.KeyList, HListFile, <Source>.ItemList, HListConnection, <Login variable>.StoredList
hLstCompositeKey	Lists the composite key items only	<Source>.KeyList, <Source>.ItemList
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	<Variable Login>.DatabaseList
hLstDetail	Lists the detailed information	<Source>.KeyList, HListFile, <Source>.LinkList, <Source>.ItemList, HListConnection, <Login variable>.StoredList
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>.KeyList, <Source>.ItemList
hLstFile	Lists the databases and their files for the server defined by the connection	<Variable Login>.DatabaseList
hLstItem	Lists the non-key and non-memo items	<Source>.ItemList
hLstKey	Lists the key items	<Source>.KeyList, <Source>.ItemList
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	<Source>.KeyList, <Source>.ItemList
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>.ItemList
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>.KeyList, HListFile, <Source>.ItemList, 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>.KeyList, <Source>.ItemList
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.	<Login variable>.StoredList HListFile
hLstSet	Lists the sets of procedures found on a server	<Login variable>.StoredList
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	<Source>.KeyList, HListFile, <Source>.ItemList, HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, <Login variable>.StoredList
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	<Variable Connection>.ManageServer
hMaxLogSize	Maximum size in megabytes (MB) of log files	<Variable Connection>.ManageServer
Versions 24 and later hMaxNumberConnection New in version 24 hMaxNumberConnection hMaxNumberConnection	Maximum number of connections allowed per application.	<Variable Connection>.ManageServer
hMaxVal	Defines an upper bound for a filter	<Source>.BuildsKeyValue, <Source>.Filter, <Source>.FilterStartBy, <Source>.FilterComprised (Function)
hMemoAuto	The memos are read during the access to the item	<Source>.ManageMemo
hMemoBin	Type of file used for the memo: Any binary file	<Source>.AttachmentMemo
hMemoImg	Type of file used for the memo: Image file	<Source>.AttachmentMemo
hMemoNo	No management of memos	<Source>.ManageMemo
hMemoOle	Type of file used for the memo: OLE file	<Source>.AttachmentMemo
hMemoWav	Type of file used for the memo: sound file	<Source>.AttachmentMemo
hMemoYes	The text memos are read whenever the record is read. Read the binary memos when accessing the item.	<Source>.ManageMemo
hMessage	Configure the information message	HOnServerCall
hMinVal	Defines a lower bound for a filter	<Source>.BuildsKeyValue, <Source>.Filter, <Source>.FilterStartBy, <Source>.FilterComprised (Function)
Versions 20 and later hMmoCompact New in version 20 hMmoCompact hMmoCompact	Compression and defragmentation of "Mmo" files.	<Source>.Reindex
hMmoSize	Size of memo file in bytes (".Mmo" file)	<Source>.InfoFile
hMode2GB	Indicates whether the system files support more than 2 GB	<Variable Connection>.ManageServer
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>.RunQuery, <HFSQL File>.ExecuteQuerySQL
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>.ModifieStructure New in version 17 <Source>.ModifieStructure <Source>.ModifieStructure
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>.ModifieStructure New in version 17 <Source>.ModifieStructure <Source>.ModifieStructure
Versions 17 and later hmsNormal New in version 17 hmsNormal hmsNormal	Standard operating mode of the automatic data modification.	Versions 17 and later <Source>.ModifieStructure New in version 17 <Source>.ModifieStructure <Source>.ModifieStructure
hNativeAccessAS400	Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessMySQL	OLE DB provider that will be used for the connection: Native MySQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessPostgreSQL	OLE DB provider that will be used for the connection: Native PostgreSQL Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNativeAccessXBase	OLE DB provider that will be used for the connection: Native xBase Connector	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Variable Connection>.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, <Variable Connection>.OpenConnection, ..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	<Variable Connection>.ManageServer
hNdxCompact	Re-index operation with compression	<Source>.Reindex
hNdxDelete	Re-indexation with deletion of damaged records	<Source>.Reindex
hNdxMinimal	Re-index operation while ignoring the corrupted keys	<Source>.Reindex
hNdxNormal	Standard re-index operation	<Source>.Reindex
hNdxNoStat	Re-indexation without calculation of statistics	<Source>.Reindex
hNdxSilent	Configure the re-index operation: No display while re-indexing	<Source>.Reindex
hNdxSize	Size of index file in bytes (".Ndx" file)	<Source>.InfoFile
hNoBind	Run a query without enabling the bind	<HFSQL File>.RunQuery, <HFSQL File>.ExecuteQuerySQL, <Source>.PrepareSQLQuery
hNoCheck	No check is performed, the analysis description may differ from the description of physical file.	<Source>.VerifyStructure
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>.RunQuery, <HFSQL File>.ExecuteQuerySQL
hNoIndex	The file index is not copied	<Variable Connection>.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>.CreationIfNonexistent
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	<Variable Connection>.NetworkSimulation
hNoRefresh	The table or query content will not be refreshed	<Source>.Last, <Source>.LitDernier, <Source>.LitPremier, <Source>.First (Function)
hNotAKey	Characteristics of an item: Non-key item	..KeyType
hNotes	Property of a database found on an HFSQL server: Description of the database or any other information associated with the database using the <ChangeOwnershipDatabase function.	<Variable Login>.PropertyDatabaseInfo, <Variable Login>.Owner InfoFile, <Variable Login>.ServerProperty Info, <ChangeOwnershipDatabase, < Connection Variable>.ChangePropertyFile, <Connection Variable>.ChangeServer Properties
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 <Variable Connection>.NotifConfigure New in version 18 <Variable Connection>.NotifConfigure <Variable Connection>.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 <Variable Connection>.NotifConfigure New in version 18 <Variable Connection>.NotifConfigure <Variable Connection>.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 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail New in version 18 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail
Versions 18 and later hNotifEmail New in version 18 hNotifEmail hNotifEmail	The notifications are sent by email.	Versions 18 and later <Variable Connection>.NotifConfigure New in version 18 <Variable Connection>.NotifConfigure <Variable Connection>.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 <Login>.NotifyAddRecipientCC, <Login>.NotifyAddRecipientEmail New in version 18 <Login>.NotifyAddRecipientCC,