HFSQL constants

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

See also

HFSQL management functions

HFSQL constants

Display constants used by prefixed syntaxes only

Display constants used by non-prefixed syntaxes only

The following constants are used to manage HFSQL data files:


Constant	Description	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 Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hAccessHFClientServer	Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, HOpenConnection
hAccessJDBCSQLServer	Access to a SQL Server database via a JDBC driver	HDescribeConnection, HOpenConnection
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	HSetServer
hActiveSyncFrame	The size of the frame is optimized to be used with Mobile devices.	HCS.FrameSize
hActivityStatisticsPath	Path of the directory containing the activity statistics	HSetServer
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	HSetServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	HSimulateNetwork
hAffectBrowse	Addition affecting the current browse	HAdd, HModify
hAllowed	The relevant rights are granted to the user or group.	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hANSIFormat	Data format: Ansi format (used by Windows)	Format Property
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 24 and later hBrowsableNonBlocking New in version 24 hBrowsableNonBlocking hBrowsableNonBlocking	Number of records in the view or query that can currently be browsed (no record locking).	HNbRec
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	Duplicate check 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).	Property CryptageFic, Property CryptageMmo, Property CryptageNdx
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).	Property CryptageFic, Property CryptageMmo, Property CryptageNdx
hCryptNo	No file encryption.	Property CryptageFic, Property CryptageMmo, Property CryptageNdx
hCryptRC5_12	The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits).	Property CryptageFic, Property CryptageMmo, Property CryptageNdx
hCryptRC5_16	The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	Property CryptageFic, Property CryptageMmo, Property CryptageNdx
hCryptStandard	The memo file is encrypted according to an optimized encryption algorithm on 128 bits.	Property CryptageFic, Property CryptageMmo, Property CryptageNdx
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	Property TypeTri
hDefault	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the values of the requested rights (in the same order).	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hDefaultFrame	The standard size will be used by default.	HCS.FrameSize
hDefaultVal	The items of destination record that are not affected by the copy are initialized with their default value. For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value.	HCopyRecord, HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hDelayedOpening	Optimize the opening of existing files: If the file already exists, it will be opened during the first access to the file. The file is created if it does not exist.	HCreationIfNotFound
hDeleteLog	Deletes the log file	HDeleteFile, HDeleteDatabase
hDestroyLink	Deletes all links related to the deleted data file.	HDeleteFile
hDetails	The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs). If no rights were defined, the value will be set to hInherit. <Result> contains the rights and there value.	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hDisconnection	Configures the disconnection message	HOnServerCall
hDisk	Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case	HChangeLocation, HDeclare
hDistinct	Management of duplicates during the browse: If duplicates are found when a browse is performed on a key item, a single record is browsed	HForward, HReadPrevious, HReadNext, HPrevious, HBackward, HNext
hDuplicateKey	Characteristics of an item: Key with duplicates	Property TypeClé
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
Versions 26 and later heqaCanceled New in version 26 heqaCanceled heqaCanceled	Procedure of end of execution of the request: The procedure carried out for each Record returned False. The motion and the various proceedings have been quashed.	Versions 26 and later HExecuteQueryAsynchronous New in version 26 HExecuteQueryAsynchronous HExecuteQueryAsynchronous Versions 26 and later HExecuteSQLQueryAsynchronous New in version 26 HExecuteSQLQueryAsynchronous HExecuteSQLQueryAsynchronous
Versions 26 and later heqaError New in version 26 heqaError heqaError	Procedure of end of execution of the request: The query and/or the procedure called for each record encountered an error.	Versions 26 and later HExecuteQueryAsynchronous New in version 26 HExecuteQueryAsynchronous HExecuteQueryAsynchronous Versions 26 and later HExecuteSQLQueryAsynchronous New in version 26 HExecuteSQLQueryAsynchronous HExecuteSQLQueryAsynchronous
Versions 26 and later heqaOK New in version 26 heqaOK heqaOK	Procedure of end of execution of the request: The query and the procedure were correctly executed for each record.	Versions 26 and later HExecuteQueryAsynchronous New in version 26 HExecuteQueryAsynchronous HExecuteQueryAsynchronous Versions 26 and later HExecuteSQLQueryAsynchronous New in version 26 HExecuteSQLQueryAsynchronous HExecuteSQLQueryAsynchronous
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
Versions 26 and later hErrCode New in version 26 hErrCode hErrCode	Type of information about the error to return: Number of the last error triggered by the HFSQL engine.	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
Versions 25 and later hErrFicList New in version 25 hErrFicList hErrFicList	Type of information about the error to return: List of HFSQL files in 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 the item associated with the error	HErrorInfo
hErrLink	Type of information about the error to return: Name of link associated with the error	HErrorInfo
hErrLock	Customize lock errors	HOnError
hErrLockInfo	Type of information about the error to return: Information about the lock	HErrorInfo
hErrMain	Type of information about the error to return: Number of the main error	HError
hErrMessage	Type of information about the error to return: Message associated with the error	HErrorInfo
hErrMMO	Type of information about the error to return: Full name of the memo file associated with the error	HErrorInfo
hErrModify	Customize a modification conflict	HOnError
hErrNative	Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used	HErrorInfo
hErrNativeMessage	Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector.	HErrorInfo
hErrNDX	Type of information about the error to return: Full name of the index file associated with the error	HErrorInfo
hErrNeedValue	Customize the errors caused by a mandatory input with no data (OLE DB only).	HOnError
hErrOLEDB	Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection.	HErrorInfo
hErrOLEDBMessage	Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB)	HErrorInfo
Versions 20 and later hErrorLastRefresh New in version 20 hErrorLastRefresh hErrorLastRefresh	Requested information: Last error while refreshing the materialized view.	Versions 20 and later HInfoView New in version 20 HInfoView HInfoView
hErrPassword	Customize password errors	HOnError
Versions 20 and later hErrPositionSQLError New in version 20 hErrPositionSQLError hErrPositionSQLError	Type of information about the error to return: Position of the SQL error in the SQL code of the query run by HExecuteSQLQuery.	HErrorInfo
hErrRecNum	Type of information about the error to return: Number of the record associated with the error	HErrorInfo
hErrServer	Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error	HErrorInfo
hErrServerInfo	Information about the server used by the Native Connector that returned the error.	HErrorInfo
hErrSystemCode	Type of information about the error to return: Number of the associated system error	HErrorInfo
hErrSystemMessage	Type of information about the error to return: Message of associated system error	HErrorInfo
hErrWDD	Type of information about the error to return: Full name of the analysis file associated with the error	HErrorInfo
hExisting	Type of search: Only the assignments for which a file actually exists	HListREP
hExpBreakable	Mode for creating the export file: The export can be interrupted by pressing Esc. If the export is interrupted, the export file is valid and it only contains the records exported before the interruption.	HExportXML Versions 21 and later HExportJSON New in version 21 HExportJSON HExportJSON Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
hExpCreation	Mode for creating the export file: The file is overwritten if it already exists.	HExportXML Versions 21 and later HExportJSON New in version 21 HExportJSON HExportJSON Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
Versions 24 and later hExpNoLineItemName New in version 24 hExpNoLineItemName hExpNoLineItemName	Mode for creating the CSV/XLSX file: The first line of the generated file will not contain the names of the items.	Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
hExpNormal	Mode for creating the export file: Standard operating mode	HExportXML Versions 21 and later HExportJSON New in version 21 HExportJSON HExportJSON Versions 24 and later HExportCSV New in version 24 HExportCSV HExportCSV Versions 24 and later HExportXLS New in version 24 HExportXLS HExportXLS
hExpWithoutXSL	The style sheet (".XSL" file) is not created	HExportXML
Versions 24 and later hFalsifyTimestamp New in version 24 hFalsifyTimestamp hFalsifyTimestamp	Management of Timestamp items: By default, a Timestamp item contains the date and time the record was created/modified. This constant is used to force the value of the Timestamp item with the value assigned to it (and not with the value calculated automatically).	HAdd, HModify
hFicSize	Size of data file in bytes (".Fic" file)	HInfoFile
hFileAS400	Type of file: AS400 file	Type property
hFileClientServer	Type of file: HFSQL Client/Server file	Type property
hFileHF5	Type of file: Hyper File 5 file	Type property
hFileMySQL	Type of file: MySQL file	Type property
hFileNormal	Type of file: Standard file (HFSQL Classic)	Type property
hFileOLEDB	Type of file: OLEDB file	Type property
hFileOracle	Type of file: ORACLE file	Type property
hFileOracleLite	Type of file: ORACLE Lite file	Type property
hFileOther	Type of file: Other type of file	Type property
Versions 15 and later hFilePostgreSQL New in version 15 hFilePostgreSQL hFilePostgreSQL	Type of file: PostgreSQL file	Type property
hFileProgress	Type of file: Progress file	Type property
hFileQuery	Type of file: Query	Type property
hFileQueryAS400	Type of file: Query on an AS/400 database	Type property
hFileQueryClientServer	Type of file: Query on an HFSQL Client/Server database	Type property
hFileQueryMySQL	Type of file: Query on a MySQL database	Type property
hFileQueryOLEDB	Type of file: Query on a database accessed via an OLE DB provider	Type property
hFileQueryOracle	Type of file: Query on an Oracle database	Type property
hFileQueryOracleLite	Type of file: Query on an Oracle Lite database	Type property
Versions 15 and later hFileQueryPostgreSQL New in version 15 hFileQueryPostgreSQL hFileQueryPostgreSQL	Type of file: Query on a PostgreSQL database	Type property
hFileQueryProgress	Type of file: Query on a Progress database	Type property
Versions 16 and later hFileQuerySQLAzure New in version 16 hFileQuerySQLAzure hFileQuerySQLAzure	Type of file: Query on an SQL Azure database	Type property
hFileQuerySQLServer	Type of file: Query on an SQL Server database	Type property
hFileQuerySQLServerMobile	Type of file: Query on an SQL Server Mobile database	Type property
hFileQuerySybase	Type of file: Query on a Sybase database	Type property
hFileQueryXML	Type of file: Query on an XML database	Type property
hFileSQL	Type of file: SQL file	Type property
Versions 16 and later hFileSQLAzure New in version 16 hFileSQLAzure hFileSQLAzure	Type of file: SQL Azure file	Type property
Versions 16 and later hFileSQLite New in version 16 hFileSQLite hFileSQLite	Type of file: SQLite file	Type property
hFileSQLServer	Type of file: SQL Server file	Type property
hFileSQLServerMobile	Type of file: SQL Server Mobile file	Type property
hFileSybase	Type of file: Sybase file	Type property
hFileTemporary	Type of file: Temporary file	Type property
hFileView	Type of file: HFSQL view	Type property
hFileXBase	Type of file: xBase file	Type property
hFileXML	Type of file: XML file	Type property
Versions 22 and later hFindKey New in version 22 hFindKey hFindKey	Enable the search for keys on the HFSQL server.	HSetServer
hForbidden	The relevant rights are not granted to the user or group	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
Versions 17 and later hForwardOnly New in version 17 hForwardOnly hForwardOnly	Native Connectors only: Used to speed up the browse of data during a simple browse that does not use the following features: Reading the previous record. Modifying a record. Saving position. If one of these features is used, the result may differ from the expected one. This constant can be used for example during a browse used to fill a memory Table control.	HReadLast, HReadFirst, HReadSeekFirst, HReadSeekLast
hForwardOnlyCursor	Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible.	HDescribeConnection, HOpenConnection
Versions 20 and later hftPunctuationSimple New in version 20 hftPunctuationSimple hftPunctuationSimple	Full-text Index item described by programming: Taking into account the simple punctuation characters (non Unicode).	Property Option of variables of type FullTextIndex description.
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.	Property Option of variables of type FullTextIndex description.
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 ESC.	HImportHF55, HImportText, Versions 20 and later HImportXLS, New in version 20 HImportXLS, HImportXLS, HImportXML Versions 21 and later HImportJSON New in version 21 HImportJSON HImportJSON
hImpConversion	Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated.	HImportHF55
hImpCreation	Type of import: If the (HFSQL Classic) import file exists, it is overwritten.	HImportHF55, HImportText, Versions 20 and later HImportXLS, New in version 20 HImportXLS, HImportXLS, HImportXML Versions 21 and later HImportJSON New in version 21 HImportJSON HImportJSON
hImpIgnoreEmptyItem	If one or more items are not filled in the text file, the corresponding lines are still imported. The missing items contain: the default value of items if the hDefaultVal constant is specified. or the value of the wage types in the current Record before the HImportText function is called.	HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
Versions 20 and later hImpIgnoreFirstLine New in version 20 hImpIgnoreFirstLine hImpIgnoreFirstLine	Type of import: The first row of the imported file is ignored.	HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hImpIgnoreInvalidLine	Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing.	HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hImpIgnoreItem	Type of import: The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value. The items of imported file (Hyper File 5.5) with no match in the import file are ignored.	HImportHF55
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	HImportText
hImpNormal	Type of import: The import is not performed and an error occurs in the following cases: items found in the Hyper File 5.5 file with no match in the HFSQL Classic file. associated items in the two files but with a different size and/or format. If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created. No management of integrity and no management of duplicates. The non-imported items take the value of the current record. The automatic identifiers are recalculated.	HImportHF55, HImportText, Versions 20 and later HImportXLS, New in version 20 HImportXLS, HImportXLS, HImportXML Versions 21 and later HImportJSON New in version 21 HImportJSON HImportJSON
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	HImportHF55
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	HImportText
hImpTestDuplicates	Type of import: Checks the duplicates during the import	HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hImpTestIntegrity	Type of import: Checks the integrity during the import	HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hInaccessible	Undefined server status	HServerStatus
hIncreasing	Sort performed in ascending order	Property TypeTri
hInfiniteCardinality	Maximum cardinality ("N")	MaxLinkedCardinality Property, MaxSourceCardinality Property
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 Property, DeletionRule Property
hIntegrityDefaultValue	Modification/Deletion rule: Default modification/deletion	ModificationRule Property, DeletionRule Property
hIntegrityForbidden	Modification/Deletion rule: Modification/Deletion not allowed	ModificationRule Property, DeletionRule Property
hIntegrityNone	Modification/Deletion rule: No integrity management	ModificationRule Property, DeletionRule Property
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 property
hItemBinaryMemo	Item type: Binary Memo	Type property
hItemBinaryMemo4	Item type: Binary memo (4 bytes)	Type property
hItemBoolean	Item type: Boolean	Type property
hItemCharacter	Item type: Character	Type property
Versions 20 and later hItemCombination New in version 20 hItemCombination hItemCombination	Item type: Combination	Type property
hItemCurrency	Item type: Currency	Type property
hItemDate6	Item type: Date	Type property
hItemDate8	Item type: Date	Type property
hItemDateTime	Item type: Date/Time	Type property
Versions 20 and later hItemEnumeration New in version 20 hItemEnumeration hItemEnumeration	Item type: Enumeration	Type property
hItemHour	Item type: Hour	Type property
hItemIdAuto	Item type: Automatic identifier (8 bytes)	Type property
hItemIdAuto4	Item type: Automatic identifier (4 bytes)	Type property
hItemInteger1	Item type: 1-byte integer	Type property
hItemInteger2	Item type: 2-byte integer	Type property
hItemInteger4	Item type: 4-byte integer	Type property
hItemInteger8	Item type: 8-byte integer	Type property
hItemInvalid	Invalid type of item	Type property
Versions 24 and later hItemJSON New in version 24 hItemJSON hItemJSON	Item type: JSON	Type property
hItemNumeric	Item type: High-precision numeric	Type property
hItemNumRec	Item type: Record number	Type property
hItemPicture	Item type: Image	Type property
hItemReal4	Item type: 4-byte real	Type property
hItemReal8	Item type: 8-byte real	Type property
hItemRealTurbo	Item type: Turbo real	Type property
hItemText	Item type: Text	Type property
hItemTextMemo	Item type: Text Memo	Type property
hItemTimeLength	Item type: Duration	Type property
hItemUnicodeMemo	Item type: Unicode Text Memo	Type property
hItemUnicodeText	Item type: Unicode text	Type property
hItemUnsignedInteger1	Item type: Unsigned 1-byte integer	Type property
hItemUnsignedInteger2	Item type: Unsigned 2-byte integer	Type property
hItemUnsignedInteger4	Item type: Unsigned 4-byte integer	Type property
hItemUnsignedInteger8	Item type: Unsigned 4-byte integer	Type property
Versions 24 and later hItemUUID128 New in version 24 hItemUUID128 hItemUUID128	Item type: UUID 128	Type property
Versions 24 and later hItemUUID128Auto New in version 24 hItemUUID128Auto hItemUUID128Auto	Item type: UUID 128 automatic identifier	Type property
Versions 24 and later hItemUUID256 New in version 24 hItemUUID256 hItemUUID256	Item type: UUID 256	Type property
Versions 24 and later hItemUUID256Auto New in version 24 hItemUUID256Auto hItemUUID256Auto	Item type: UUID 256 automatic identifier	Type property
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: function HFilter returns the optimized path key for the filter. Caution: in this case, performance problems may occur on large files.	HChangeKey, HLast, HReadLast, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadSeek, HFirst, HSeek, HSeekLast, HSeekFirst
hKeepTRS	Stores the transaction files during the deletion	HDeleteDatabase, HDeleteFile
Versions 17 and later hLanguageBinarySort New in version 17 hLanguageBinarySort hLanguageBinarySort	The sort will be performed by comparing the binary value of the bytes. This type of sort is very fast. It should be used to perform an exact-match search for example.	Property Langue, Property LanguageDescribed, H.LanguageCreationUnicode
hLanguageCreation	Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation".	Property Langue, Property 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.	Property Langue, Property 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 property
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 property
Versions 20 and later hlpBackup New in version 20 hlpBackup hlpBackup	Type of scheduling to list: Scheduling of backups.	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpCalcStat New in version 22 hlpCalcStat hlpCalcStat	Type of operation performed on the server: statistical calculation.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpKeyDetection New in version 22 hlpKeyDetection hlpKeyDetection	Type of operation performed on the server: detection of keys.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpMaterializedView New in version 20 hlpMaterializedView hlpMaterializedView	Type of scheduling to list: Tasks for refreshing the materialized views.	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpOptimization New in version 20 hlpOptimization hlpOptimization	Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation).	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 22 and later hlpReplication New in version 22 hlpReplication hlpReplication	Type of operation performed on the server: server replication.	Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
Versions 20 and later hlpTask New in version 20 hlpTask hlpTask	Type of scheduling to list: Scheduled tasks that run a stored procedure.	Versions 20 and later HListScheduling New in version 20 HListScheduling HListScheduling Versions 22 and later Type hServerOperation New in version 22 Type hServerOperation Type hServerOperation
hLstAll	Lists all the keys, all the files, all the items or all the connections	HListKey, HListFile, HListItem, HListConnection, HListStoredElement
hLstCompositeKey	Lists the composite key items only	HListKey, HListItem
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	HListDatabase
hLstDetail	Lists the detailed information	HListKey, HListFile, HListLink, HListItem, HListConnection, HListStoredElement
hLstDetailPlus	For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part.	HListKey, HListItem
hLstFile	Lists the databases and their files for the server defined by the connection	HListDatabase
hLstItem	Lists the non-key and non-memo items	HListItem
hLstKey	Lists the key items	HListKey, HListItem
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	HListKey, HListItem
Versions 20 and later hLstMaterializedView New in version 20 hLstMaterializedView hLstMaterializedView	Lists the materialized views found on an HFSQL server.	HListFile
hLstMemo	Lists the memo items	HListItem
hLstNormal	Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically.	HListKey, HListFile, HListItem, HListConnection
hLstOpened	Stores the opened connections only	HListConnection
hLstOriginalItem	Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file.	HListKey, HListItem
hLstQuery	Lists the queries found on a server Versions 19 and later Lists the queries that have been run. New in version 19 Lists the queries that have been run. Lists the queries that have been run.	HListStoredElement HListFile
hLstSet	Lists the sets of procedures found on a server	HListStoredElement
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	HListKey, HListFile, HListItem, HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, HListStoredElement
hLstSystemTable	List of system tables for a connection via Native Connectors or OLE DB	HListFile
hLstTable	List of user tables for a connection via Native Connectors or OLE DB	HListFile
hLstView	List the views of a connection via Native Connectors or OLE DB. Versions 20 and later List the SQL views on an HFSQL server. New in version 20 List the SQL views on an HFSQL server. List the SQL views on an HFSQL server.	HListFile
hMasterReplica	Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica)	Replication Property
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 Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessDB2	OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessInformix	OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
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 Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessMySQL	OLE DB provider that will be used for the connection: Native MySQL Connector	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessOracle	OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessOracleLite	Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessPostgreSQL	OLE DB provider that will be used for the connection: Native PostgreSQL Connector	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessProgress	OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
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 Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
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 Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
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 Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
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 Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessSybase	OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessXBase	OLE DB provider that will be used for the connection: Native xBase Connector	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNativeAccessXML	Provider that will be used for the connection: Native XML Connector (supplied with WINDEV/WEBDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider Property, CtOLEDBProvider Property, CtDescribedOLEDBProvider Property
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	HSetServer
hNdxCompact	Re-index operation with compression	HIndex
hNdxDelete	Reindex and delete damaged records	HIndex
hNdxMinimal	Re-index operation while ignoring the corrupted keys	HIndex
hNdxNormal	Standard re-index operation	HIndex
hNdxNoStat	Reindex without statistical calculation	HIndex
hNdxSilent	Configure the re-index operation: No display while re-indexing	HIndex
hNdxSize	Size of index file in bytes (".Ndx" file)	HInfoFile
hNoBind	Run a query without enabling the bind	HExecuteQuery, HExecuteSQLQuery, HPrepareSQLQuery
hNoCheck	No check is performed, the analysis description may differ from the description of physical file.	HCheckStructure
hNoError	No error occurred	HError
Versions 21 and later hNoHourglass New in version 21 hNoHourglass hNoHourglass	When reading the query result, this read operation may be locked and an 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
hNonBlocking	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 property. 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
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	Property TypeClé
hNotes	Property of a database found on an HFSQL server: description of the database or any other information associated with the database through 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
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 Property
hNotSorted	Sort direction: Item not sorted	Property TypeTri
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 Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbAccess2000	OLE DB provider that will be used for the connection: OLE DB provider for Access 2000	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbAccess2007	OLE DB provider that will be used for the connection: OLE DB provider for Access 2007	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, 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 Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbAccess97	OLE DB provider that will be used for the connection: OLE DB provider for Access 97	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbDBase5	OLE DB provider that will be used for the connection: OLE DB provider for dBase 5	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbExcel2000	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbExcel2007	OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbExcel97	OLE DB provider that will be used for the connection: OLE DB provider for Excel 97	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbLotus4	OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbOracle	OLE DB provider that will be used for the connection: OLE DB provider for Oracle	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hOledbSQLServer	OLE DB provider that will be used for the connection: OLE DB provider for SQL Server	CtOLEDBProvider Property, CtDescribedOLEDBProvider Property, 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. Modifications performed by other users are visible (but records added are not).	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 Property, CtDescribedAccess Property, HConnect, HOpen
hOReadWrite	File accessible in read/write	CtAccess Property, CtDescribedAccess Property, HConnect, HOpen
hOwner	Property of a database found on an HFSQL server: Owner of database.	HInfoDatabaseProperty, HInfoFileProperty, HModifyDatabaseProperty, HModifyFileProperty
hPackNo	Compression mode: No compression	Property CompressionMmo
hPackZLW	Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation.	Property CompressionMmo
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 goes into edit mode to be modified.	HDescribeConnection, HOpenConnection
hPrecisionHigh	Position with high precision	HGetCurrentPosition, HSetPosition
hPrecisionLow	Position with low precision	HGetCurrentPosition, HSetPosition
hPrecisionMedium	Position with medium precision	HGetCurrentPosition, HSetPosition
hQueryBreakable	The query initialization can be interrupted with the ESC key	HExecuteQuery, HExecuteSQLQuery
hQueryDefault	The query is initialized without interruption	HExecuteQuery, HExecuteSQLQuery
hQueryWithoutCorrection	Native Connector or OLE DB only: No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.)	HExecuteQuery, HExecuteSQLQuery
hQueryWithoutHFCorrection	HFSQL only The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters.	HExecuteQuery, HExecuteSQLQuery
Versions 19 and later hReadCommitted New in version 19 hReadCommitted hReadCommitted	Isolation level of transaction: other users can only view completed transactions.	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: other users can view incomplete transactions.	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, HSave
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 Property
hRightsAll	List of all the rights	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hRightsAutoModif	Rights to perform the automatic modification of the data files on a file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsBackup	Rights to save the data files	HInfoDatabaseRights, HInfoServerRights, HModifyDatabaseRights, HModifyServerRights
hRightsChangeLink	Rights to modify the integrity rules on a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsChangeOwner	Rights to modify the owner of an element	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsChangePassword	Rights to change the password of a user on the server (the user can change his own password and the administrator can change the password of each user).	HInfoServerRights, HModifyServerRights
hRightsChangeRights	Rights to change rights.	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights, HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hRightsConnection	Rights to connect to a server (encrypted or unencrypted connection)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsCreateDB	Rights to create a database	HInfoServerRights, HModifyServerRights
hRightsCreateFile	Rights to create a data file (with HCreation)	HInfoDatabaseRights, HModifyDatabaseRights
Versions 20 and later hRightsCreateView New in version 20 hRightsCreateView hRightsCreateView	Rights to create a SQL view or a materialized view.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsDebug	Rights to debug the stored procedures.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsDelete	Rights to delete the records from a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsDeleteDB	Rights to delete a database	HInfoDatabaseRights, HModifyDatabaseRights
hRightsDeleteFile	Rights to delete a data file (HDeleteFile)	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
Versions 20 and later hRightsDeleteView New in version 20 hRightsDeleteView hRightsDeleteView	Rights to delete a SQL view or a materialized view.	Versions 20 and later HInfoViewRights, HModifyViewRights New in version 20 HInfoViewRights, HModifyViewRights HInfoViewRights, HModifyViewRights
hRightsDisconnectClient	Rights to disconnect the client computers.	HInfoServerRights, HModifyServerRights
hRightsEncryptedConnection	Rights to connect to a server (encrypted connection only)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsInsert	Rights to add new records into a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsLock	Rights to lock the data files or the records of a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsMaintenance	Rights to start a re-index operation or to perform statistical calculations on a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsManageDuplicate	Rights to enable and disable the management of duplicates.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsManageIntegrity	Rights to enable and disable the management of integrity.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsManageProcedure	Rights to add, modify and delete the stored procedures.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsManageServer	Rights to use HSetServer	HInfoServerRights, HModifyServerRights
hRightsManageTask	Rights to manage the scheduled tasks.	HInfoServerRights, HModifyServerRights
hRightsManageTrigger	Rights to manage the server triggers (addition, activation, deletion)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsManageUser	Rights to delete and add users or groups	HInfoServerRights, HModifyServerRights
hRightsNoDatabaseAccess	Rights to prevent (or not) access to a database (HNoDatabaseAccess and HEndNoDatabaseAccess)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsPriority	Rights to modify the priority of a client application	HInfoServerRights, HModifyServerRights
hRightsRead	Rights to read the records of a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsReadLogStat	Rights to see the activity statistics and the server logs.	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 the HRestorePosition function is called.	HSavePosition
Versions 22 and later hsCross New in version 22 hsCross hsCross	Monitors the operations for crossing records.	Versions 22 and later HTrack New in version 22 HTrack HTrack
Versions 22 and later hsDeletion New in version 22 hsDeletion hsDeletion	Monitors the operations for deleting records.	Versions 22 and later HTrack New in version 22 HTrack HTrack
Versions 19 and later hSecondaryThread New in version 19 hSecondaryThread hSecondaryThread	Option for running the procedure: the procedure is run in a secondary thread.	HOnServerCall
hServerCursor	Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.	HDescribeConnection, HOpenConnection
hServerPort	Network port used	HSetServer
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the write operation	HAdd, HWrite, HModify
hSetIdAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the addition	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 Property
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.	Property 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.	Property 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.	Property TimestampType
hUnicode	Used to retrieve the record value in Unicode format.	HRetrieveRecord, HRecordToString
hUNICODEFormat	Data format: UNICODE format	Format Property
hUniqueKey	Characteristics of an item: Unique key	Property TypeClé
hViewAdd	Create a view with addition: Preserves the contents of the view the next time the HExecuteView function is called	HCreateView, HMergeView
hViewBreakable	Interrupt view creation by pressing the ESC key	HCreateView
hViewDefault	Default creation of view	HCreateView, HMergeView
hViewDistinct	Create view without duplicates with respect to the sort key	HCreateView, HMergeView
hViewExclusive	Lock the entire source file to reduce the view creation time	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	Lock records read in the file and included in the view	HCreateView, HMergeView
hViewPostponed	The view is created but it will be run later by HExecuteView	HCreateView, HMergeView
hViewSubtraction	Merge views with subtraction: Row of the first view without the common rows of the second view	HMergeView
hViewUnion	Merging views: Merge the rows of the two specified views	HMergeView
hViewUnionEx	Exclusive merge of views: Merge the non-common rows of the two specified views	HMergeView
hWDL	The files are sought: In the main WDL. In the WDL according to their load order, then on disk or in the specified WDL, then on disk. In the main WDL of the component. In the secondary WDLs of the component according to the load order.	HChangeLocation, HDeclare
hWifiFrame	The frame size is optimized for a use via Wifi	HCS.FrameSize
Versions 19 and later hWindowsDiskCacheSize New in version 19 hWindowsDiskCacheSize hWindowsDiskCacheSize	Mode for managing the size of Windows disk cache.	HSetServer
hWithFilter	If this parameter is specified: the query result corresponds to a selection of filter records if the HFSQL engine allows it. Otherwise, the query result corresponds to an HFSQL view the following operations are not allowed: search on the query result, query on query, view on query, query on view. the browse items specified when browsing the result are ignored. the magnifier is not available for the tables linked to a query. hNbRec cannot be used on the queries. If this parameter is not specified (by default): the query result corresponds to an HFSQL view the following operations can be performed on the queries: search on the query result, query on query, view on query, query on view. the browse items specified when browsing the result are taken into account. the magnifier is available on tables linked to a query. hNbRec can be used on the queries.	HExecuteQuery, HExecuteSQLQuery
hWithTransaction	The query is run in a transaction. A transaction is started, the records are locked in read/write during the execution of the query and they are unlocked at the end of its execution, regardless of the result (failure or success). If the query cannot end properly (locked records, power failure, etc.), the transaction is canceled and the data files are restored to their previous status (before the query execution). Remark: The query execution may be slowed down.	HExecuteQuery, HExecuteSQLQuery
hWriteDefault	Addition not affecting the current browse/Identifier re-used or calculated for the record	HAdd, HWrite, HModify
hYield	For the UPDATE and DELETE queries performed on an important number of records, this constant is used to give control back to the other applications that use the files.	HExecuteQuery, HExecuteSQLQuery
Versions 20 and later NoWait New in version 20 NoWait NoWait	The refresh of materialized view is not a locking operation: it is performed in background task. The HInfoView function allows to know the result of the refresh of the materialized view.	Versions 20 and later HRefreshView New in version 20 HRefreshView HRefreshView
opCancel	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the code continues to run.	HOnError
opEndProcess	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the current process stops. Equivalent to the following code line: IF NOT <HFSQL function> THEN ReturnToCapture()	HOnError
opEndProgram	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The function that triggered the error returns an error and the program stops. Equivalent to the following code line: IF NOT <HFSQL function> THEN EndProgram()	HOnError
opRelaunchProgram	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. The program stops and the application is automatically restarted.	HOnError
opRetry	This constant must be returned by the procedure or window used to customize the process of HFSQL errors. In this case, the function that triggered the error is re-run.	HOnError

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


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

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


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