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 prefix syntaxes only

Display constants used by non-prefix syntaxes only

The following constants are used to manage HFSQL data files:

Constant	Description	Functions/Properties

eltSetOfProcedures	The listed element is a set of procedures	HListStoredElement
eltProcedure	The listed element is a stored procedure	HListStoredElement
eltQuery	The listed element is a query.	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 an SQL Server database via a JDBC driver	HDescribeConnection, HOpenConnection
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 (included with WINDEV/WEBDEV)	HConnect, HDeclareExternal, HDescribeConnection, HListFile, HOpenConnection, Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	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
hApplication	Property of a database found on an HFSQL server: Name of the application from which the database was created.	HInfoDatabaseProperty, HInfoFileProperty
hStopped	Server stopped	HServerStatus
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	HSimulateNetwork
hAllowed	The relevant rights are granted to the user or group.	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hWithFilter	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.	HExecuteQuery, HExecuteSQLQuery
hWithTransaction	The query is run in a transaction.	HExecuteQuery, HExecuteSQLQuery
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
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
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
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
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
hCardinality	Integrity constraints: Check the link cardinalities.	HSetIntegrity
hInfiniteCardinality	Maximum cardinality ("N")	MaxLinkedCardinality property, MaxSourceCardinality property
hChangeCharset	The character set defined by ChangeCharset will be taken into account in the new data file. Sorts, searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.	HCreation, HCreationIfNotFound, HIndex
hDatabasePath	Path of directory containing all databases	HSetServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	HSetServer
hJNLBackupPath	Path of the directory containing the backups of the logs	HSetServer
hLogPath	Path of the directory containing the log files	HSetServer
hActivityStatisticsPath	Path of the directory containing the activity statistics	HSetServer
hDuplicateKey	Characteristics of an item: Key with duplicates	KeyType property
hUniqueKey	Characteristics of an item: Unique key	KeyType property
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
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	HCheckStructure
hPackNo	Compression mode: No compression	MmoPackMethod property
hPackZLW	Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation.	MmoPackMethod property
hKeepTRS	Stores the transaction files during the deletion	HDeleteDatabase, HDeleteFile
hCopyAutoID	Copies the automatic identifier while keeping its value	HCopyRecord, HImportHF55, HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
hCopyIndex	Copies the index of the data file	HCopyFile
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	HCopyFile
hCorrespondence	Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions	HInfoLog
hCreator	Property of a database found on an HFSQL server: Name of database owner.	HInfoDatabaseProperty, HInfoFileProperty
hCreateIndex	The index of the data file is not copied. It is automatically re-created on the destination by re-indexing.	HCopyFile
hIncreasing	Sort performed in ascending order	SortType property
Versions 24 and later hCryptAES128 New in version 24 hCryptAES128 hCryptAES128	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
Versions 27 and later hCryptAES128 New in version 27 hCryptAES128 hCryptAES128	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 192-bit AES algorithm with Output feedback (OFB).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
Versions 27 and later hEncryptionAES256 New in version 27 hEncryptionAES256 hEncryptionAES256	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 256-bit AES algorithm with Output feedback (OFB).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
Versions 19 and later hEncryptionAuto New in version 19 hEncryptionAuto hEncryptionAuto	File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionNO	No file encryption.	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionRC5_12	The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionRC5_16	The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionStandard	The memo file is encrypted according to an optimized encryption algorithm on 128 bits.	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, HOpenConnection
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
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
hReadOnlyCursor	The set of records cannot be modified.	HDescribeConnection, HOpenConnection
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
hPessimisticCursor	The record is locked as soon as it goes into edit mode to be modified.	HDescribeConnection, HOpenConnection
hServerCursor	Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.	HDescribeConnection, HOpenConnection
hStaticCursor	Makes a copy of all query records in memory (high memory usage). All types of moves are allowed.	HDescribeConnection, HOpenConnection
hDaemonUser	Username that will be used by the server (Linux only)	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
hDisconnection	Configures the disconnection message	HOnServerCall
hDBLexicographic	Sort according to the lexicographic order	HDBSortType
hDecreasing	Sort performed in descending order	SortType property
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
hStarted	Server started	HServerStatus
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
hDestroyLink	Deletes all links related to the deleted data file.	HDeleteFile
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: Only one record is read if duplicates are found when looping through a key item	HForward, HReadPrevious, HReadNext, HPrevious, HBackward, HNext
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	HRegenerateFile
hRightsInsert	Rights to add new records into a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsStopServer	Rights to stop a server (HStopServer)	HInfoServerRights, HModifyServerRights
hRightsLock	Rights to lock the data files or the records of a data file.	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsChangeRights	Rights to change rights.	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights, HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hRightsChangeLink	Rights to modify the integrity rules on a data file.	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
hRightsChangeOwner	Rights to modify the owner of an element	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsConnection	Rights to connect to a server (encrypted or unencrypted connection)	HInfoDatabaseRights, HModifyDatabaseRights
hRightsEncryptedConnection	Rights to connect to a server (encrypted connection only)	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
hRightsDisconnectClient	Rights to disconnect the client computers.	HInfoServerRights, HModifyServerRights
hRightsSendMessageToClient	Rights to send messages to the client computers.	HInfoServerRights, HModifyServerRights
hRightsRunProcedure	Rights to run the stored procedures.	HInfoDatabaseRights, HModifyDatabaseRights
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
hRightsManageTask	Rights to manage the scheduled tasks.	HInfoServerRights, HModifyServerRights
hRightsManageProcedure	Rights to add, modify and delete the stored procedures.	HInfoDatabaseRights, HModifyDatabaseRights
hRightsManageServer	Rights to use HSetServer	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 access to a database (HNoDatabaseAccess and HEndNoDatabaseAccess)	HInfoDatabaseRights, HModifyDatabaseRights
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
hRightsMaintenance	Rights to start a re-index operation or to perform statistical calculations on a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsAutoModif	Rights to perform the automatic modification of the data files on a file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsUpdate	Rights to modify the records of a data file	HInfoDatabaseRights, HInfoFileRights, HModifyDatabaseRights, HModifyFileRights
hRightsPriority	Rights to modify the priority of a client application	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
hRightsBackup	Rights to save the data files	HInfoDatabaseRights, HInfoServerRights, HModifyDatabaseRights, HModifyServerRights
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
hRightsAll	List of all the rights	HInfoDatabaseRights, HInfoFileRights, HInfoServerRights
hRightsSeeUser	Rights to view the characteristics of a group or user.	HInfoServerRights, HModifyServerRights
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	HSetServer
hlbActive	Enable or disable the load balancing	HSetServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	HSetServer
hlbMaxTimeout	Value modifying the maximum timeout for a server request	HSetServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	HSetServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	HSetServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	HSetServer
hWriteDefault	Addition not affecting the current browse/Identifier re-used or calculated for the record	HAdd, HWrite, HModify
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
hOnUpdate	Integrity rule applied during a modification	HSetIntegrity
hRecFile	Record to read: Value of the item currently saved in the data file	HErrorModification, HErrorStatusModification
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
hOnDelete	Integrity rule applied during a deletion	HSetIntegrity
Versions 26 and later heqaCanceled New in version 26 heqaCanceled heqaCanceled	Procedure for the end of the execution of the query: The procedure executed for each record returned False. The query and the different procedures were canceled.	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 for the end of the execution of the query: 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 for the end of the execution of the query: 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
hErrDatabaseAccess	Configure the access errors to an HFSQL Client/Server database.	HOnError
hErrADO	Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.	HErrorInfo
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
hErrLock	Customize lock errors	HOnError
Versions 26 and later hErrCode New in version 26 hErrCode hErrCode	Type of information about the error to return: Number of the last error raised by the HFSQL engine.	HErrorInfo
hErrSystemCode	Type of information about the error to return: Number of the associated system 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 via the "Copy" button in the WLanguage error window.	HErrorInfo
hErrDuplicates	Customize duplicate errors	HOnError
hErrCurrent	Type of information about the error to return: Number of the current error	HError
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
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
hErrLockInfo	Type of information about the error to return: Information about the lock	HErrorInfo
hErrClientInfo	Information about the client layer used by the Native Connector that returned the error.	HErrorInfo
hErrDebugInfo	Type of information about the error to return: Specific information for debugging the problem that occurred.	HErrorInfo
hErrServerInfo	Information about the server used by the Native Connector that returned the error.	HErrorInfo
hErrIntegrity	Customize integrity errors	HOnError
hErrLink	Type of information about the error to return: Name of the link 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 with errors.	HErrorInfo
hErrMessage	Type of information about the error to return: Message associated with the error	HErrorInfo
hErrADOMessage	Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO)	HErrorInfo
hErrBaseMessage	Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase)	HErrorInfo
hErrNativeMessage	Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector.	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
hErrSystemMessage	Type of information about the error to return: Message of associated system 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
hErrPassword	Customize password errors	HOnError
hErrNative	Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used	HErrorInfo
hErrNDX	Type of information about the error to return: Full name of the index file associated with the error	HErrorInfo
hErrRecNum	Type of information about the error to return: Number of the record associated with the error	HErrorInfo
hErrOLEDB	Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection.	HErrorInfo
hErrConnectionLoss	Customize the errors caused by a loss of connection with the server.	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
hErrMain	Type of information about the error to return: Number of the main error	HError
hErrIndex	Customize reindexing errors (reindexing in progress when accessing the data file)	HOnError
hErrItem	Type of information about the error to return: Name of the item 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
hErrAll	Customize all errors	HOnError
hErrNeedValue	Customize errors caused by a required value that has not been specified (OLE DB only).	HOnError
hErrWDD	Type of information about the error to return: Full name of the analysis file associated with the error	HErrorInfo
hStateActive	Status of the record/Type of record taken into account: Active record	HState, hNbRec, HErrorStatusModification
hStateInvalid	Record status not found (error)	HState, HErrorStatusModification
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
hStateAll	Type of record: Total number of records in the data file	hNbRec
hExisting	Type of search: Only the assignments for which a file actually exists	HListREP
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
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
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
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
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 date/time is automatically calculated. This constant prevents the Timestamp item from being updated: the last value in the record will be kept.	HAdd, HModify
hFileAS400	Type of file: AS400 file	Type property
hFileOther	Type of file: Other type of 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
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
hSetIDAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the addition	HAdd, HWrite, HModify
hSetIDAuto	Mode for calculating the automatic identifier: Identifier value equals to the one stored during the write operation	HAdd, HWrite, HModify
hANSIFormat	Data format: Ansi format (used by Windows)	Format property
hUNICODEFormat	Data format: UNICODE format	Format property
Versions 17 and later hForwardOnly New in version 17 hForwardOnly hForwardOnly	Native Connectors only: Allows looping through records faster.	HReadLast, HReadFirst, HReadSeekFirst, HReadSeekLast
Versions 20 and later hftPunctuationSimple New in version 20 hftPunctuationSimple hftPunctuationSimple	Full-text Index item described programmatically: Taking into account the simple punctuation characters (non Unicode).	Option property of FullTextIndex Description variables.
Versions 20 and later hftPunctuationUnicode New in version 20 hftPunctuationUnicode hftPunctuationUnicode	Full-text Index item described programmatically: Taking into account the Unicode punctuation characters.	Option property of FullTextIndex Description variables.
hFTX	Reindexing full-text indexes	HIndex
HGeneric	Type of search: Generic search	HReadSeekLast, HReadSeekFirst, HSeekLast, HSeekFirst
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
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
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	Does not check for duplicates for this action, even if the automatic duplicate check is enabled (HSetDuplicates)	HAdd
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (HSetIntegrity)	HAdd, HModify, HDelete, HCross
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
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
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
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
hImpIgnoreEmptyItem	If one or more items are not filled in the text file, the corresponding lines are still imported. The missing items contain: the default value of items if the hDefaultVal constant is specified. the value of items in the current record before the call to HImportText.	HImportText, Versions 20 and later HImportXLS New in version 20 HImportXLS HImportXLS
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
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.	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
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	HImportText
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	HImportText
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	HImportHF55
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
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
Versions 22 and later hInfoTotalDiskSpace New in version 22 hInfoTotalDiskSpace hInfoTotalDiskSpace	Total capacity of server disk, expressed in MB.	HInfoServer
hInfoHardware	Information about the hardware used.	HInfoServer
hInfoName	Name of server (DNS)	HInfoServer
hInfoLogicalName	Name of server given in HFConf.ini or specified during the setup.	HInfoServer
hInfoPlatform	Information about the server platform.	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
hInfoAll	Full server details.	HInfoServer
hInfoVersion	Information about the version of programs required for the server to operate.	HInfoServer
hInfoVersionDetails	Detailed information about the version of the programs required to operate the server.	HInfoServer
hInfoVI	Version number of Manta.exe or Manta in Linux	HInfoServer
hIntegrityNone	Modification/Deletion rule: No integrity management	ModificationRule property, DeletionRule property
hIntegrityCascade	Modification/Deletion rule: Cascading modification/deletion	ModificationRule property, DeletionRule property
hIntegrityForbidden	Modification/Deletion rule: Modification/Deletion not allowed	ModificationRule property, DeletionRule property
hIntegrityDefaultValue	Modification/Deletion rule: Default modification/deletion	ModificationRule property, DeletionRule property
hForbidden	The relevant rights are not granted to the user or group	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
hLogJNLFile	Configures the file to recreate: Only <File name>JNL.FIC is recreated.	HLogRecreate
hLogIdentification	Configures the file to recreate: Re-creates the "JournalIdentification.fic" file.	HLogRecreate
hLogWriting	Format of log process: Log the write operations performed in the file	LogMethod property
hLogReadingWriting	Format of log process: Log the read and write operations performed in the file	LogMethod property
hLogNo	Format of log process: No log	LogMethod
hLogOperation	Configures the file to recreate: Re-creates the "JournalOperation.fic" file.	HLogRecreate
hLogUser	Configures the file to recreate: Recreates 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
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 timeout (in seconds) for the server when checking the presence of client. If the client is not found at the end of this timeout, the client is automatically disconnected.	HSetServer
hLanguageCreation	Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation".	Language property, LanguageDescribed property
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.	Language property, LanguageDescribed property, H.LanguageCreationUnicode property
Versions 17 and later hLanguageFastSort New in version 17 hLanguageFastSort hLanguageFastSort	The sort will be performed by comparing the characters one by one according to a generic sort.	Language property, LanguageDescribed property, H.LanguageCreationUnicode property
hLimitParsing	Limits the file browse: The browse will stop as soon as the last sought value is found.	HReadSeek, HReadSeekLast, HReadSeekFirst, HSeek, HSeekLast, HSeekFirst
Versions 22 and later hlpCalcStat New in version 22 hlpCalcStat hlpCalcStat	Type of operation performed on the server: statistical calculation.	Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 hServerOperation type New in version 22 hServerOperation type hServerOperation type
Versions 22 and later hlpReplication New in version 22 hlpReplication hlpReplication	Type of operation performed on the server: server replication.	Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 hServerOperation type New in version 22 hServerOperation type hServerOperation type
hLstKey	Lists the key items	HListKey, HListItem
hLstCompositeKey	Lists the composite key items only	HListKey, HListItem
hLstSet	Lists the sets of procedures found on a server	HListStoredElement
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
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
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	HListKey, HListItem
hLstOpened	Stores the opened connections only	HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, HListStoredElement
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
hLstItem	Lists the non-key and non-memo items	HListItem
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
hLstTable	List of user tables for a connection via Native Connectors or OLE DB	HListFile
hLstSystemTable	List of system tables for a connection via Native Connectors or OLE DB	HListFile
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	HListDatabase
hLstAll	Lists all the keys, all the files, all the items or all the connections	HListKey, HListFile, HListItem, HListConnection, HListStoredElement
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	HListKey, HListFile, HListItem, HListConnection
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
Versions 20 and later hLstMaterializedView New in version 20 hLstMaterializedView hLstMaterializedView	Lists the materialized views found on an HFSQL server.	HListFile
hComputer	Property of a database found on an HFSQL server: Name of the computer from which the element was created.	HInfoDatabaseProperty, HInfoFileProperty
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
hMemoYes	The text memos are read whenever the record is read. Read the binary memos when accessing the item.	HSetMemo
hMemoWav	Type of file used for the memo: sound file	HLinkMemo
hMessage	Configures the information message	HOnServerCall
hMode2GB	Indicates whether system files support more than 2 GB	HSetServer
Versions 20 and later hMmoCompact New in version 20 hMmoCompact hMmoCompact	Compression and defragmentation of "Mmo" files.	HIndex
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 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
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 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
hNdxCompact	Reindexing with compression	HIndex
hNdxMinimal	Reindex and ignore corrupted keys	HIndex
hNdxSilent	Configure reindexing: No display during reindexing	HIndex
hNdxNormal	Standard reindexing	HIndex
hNdxNoStat	Reindex without calculating statistics	HIndex
hNdxDelete	Reindex and delete damaged records	HIndex
hLogLevel	Defines the elements that must be in the log file	HSetServer
Versions 24 and later hMaxNumberConnection New in version 24 hMaxNumberConnection hMaxNumberConnection	Maximum number of connections allowed per application.	HSetServer
hNonBlocking	Number of records retrieved in the view or query without waiting for the view or query to be entirely filled.	hNbRec
hNotAKey	Characteristics of an item: Non-key item	KeyType property
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	SortType property
hNotes	Property of a database found on an HFSQL server: Database description or any other information associated with the database by HModifyDatabaseProperty.	HInfoDatabaseProperty, HInfoFileProperty, HInfoServerProperty, HModifyDatabaseProperty, HModifyFileProperty, HModifyServerProperty
Versions 18 and later 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
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
hCurrentRecNum	Number of the current record.	HFSQL functions
hInvalidRecNum	Constant returned if there is no current record or if the specified file corresponds to a multi-file query.	HRecNum
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
hODBC	OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Allows you to access an ODBC source declared in the ODBC data sources of Windows	CtOLEDBProvider property, CtDescribedOLEDBProvider property, HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect
hORead	File accessible in read-only	CtAccess property, CtDescribedAccess property, HConnect, HOpen
hOReadWrite	File accessible in read/write	CtAccess property, CtDescribedAccess property, HConnect, HOpen
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
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
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
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
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
Versions 24 and later hBrowsableNonBlocking New in version 24 hBrowsableNonBlocking hBrowsableNonBlocking	Number of records in the view or query that can currently be read (no record locking).	HNbRec
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	HSetServer
hDebuggingPort	Port used to debug the stored procedures and the server triggers.	HSetServer
hServerPort	Network port used	HSetServer
hPrecisionHigh	Position with high precision	HGetCurrentPosition, HSetPosition
hPrecisionLow	Position with low precision	HGetCurrentPosition, HSetPosition
hPrecisionMedium	Position with medium precision	HGetCurrentPosition, HSetPosition
hOwner	Property of a database found on an HFSQL server: Owner of database.	HInfoDatabaseProperty, HInfoFileProperty, HModifyDatabaseProperty, HModifyFileProperty
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 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
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
Versions 22 and later hFindKey New in version 22 hFindKey hFindKey	Enable the search for keys on the HFSQL server.	HSetServer
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
hSubscriberReplica	Replication mode: The data file is a subscriber replica (HCreateSubscriberReplica was used to create the subscriber replica)	Replication property
hMasterReplica	Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica)	Replication property
hReplicated	Replication mode: The data file is configured to be replicated.	Replication property
hQueryDefault	The query is initialized without interruption	HExecuteQuery, HExecuteSQLQuery
hQueryBreakable	The query initialization can be interrupted with the ESC key	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 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
hKeepFilter	The filter set by HFilter will be taken into account, even if the search key is not optimized for the filter. Reminder: HFilter returns the search key optimized for the filter. Caution: in this case, performance problems may occur on large files.	HChangeKey, HLast, HReadLast, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadSeek, HFirst, HSeek, HSeekLast, HSeekFirst
hRPKeep	Configure the restore operation: Position not freed	HRestorePosition
hRPDefault	Configure the restore operation: Position freed. The stored position is restored	HRestorePosition
hRPFilter	Configure the restore operation: Restore the filter set when HSavePosition is called	HRestorePosition
hRPHF5	Configure the restore operation: If the stored position was deleted or modified, this position is restored	HRestorePosition
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
hItemBinary	Item type: Binary	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
hItemDate6	Item type: Date	Type property
hItemDate8	Item type: Date	Type property
hItemDateTime	Item type: Date/Time	Type property
hItemTimeLength	Item type: Duration	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
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 20 and later hItemEnumeration New in version 20 hItemEnumeration hItemEnumeration	Item type: Enumeration	Type property
hItemHour	Item type: Time	Type property
hItemIDAuto	Item type: Automatic identifier (8 bytes)	Type property
hItemIDAuto4	Item type: Automatic identifier (4 bytes)	Type property
hItemPicture	Item type: Image	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
hItemBinaryMemo	Item type: Binary Memo	Type property
hItemBinaryMemo4	Item type: Binary memo (4 bytes)	Type property
hItemTextMemo	Item type: Text Memo	Type property
hItemUnicodeMemo	Item type: Unicode Text Memo	Type property
hItemCurrency	Item type: Currency	Type property
Versions 27 and later hItemSecurePassword New in version 27 hItemSecurePassword hItemSecurePassword	Item type: Password	Type property
hItemNumRec	Item type: Record number	Type property
hItemNumeric	Item type: High-precision numeric	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
hItemUnicodeText	Item type: Unicode text	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
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
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 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 20 and later NoWait New in version 20 NoWait NoWait	The refresh of materialized view is not a locking operation: it is performed in background task. HInfoView returns the information of the materialized view after being refreshed.	Versions 20 and later HRefreshView New in version 20 HRefreshView HRefreshView
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
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
hNoRefresh	The table or query content will not be refreshed	HLast, HReadLast, HReadFirst, HFirst
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
hSaveItems	Saves the values of items in memory when using HSavePosition. These values will be restored next time HRestorePosition is called.	HSavePosition
hBoundSeparator	Used to separate the values of lower and upper bounds for the components of composite key	HFilterIncludedBetween
hSubErrLast	Type of error returned: Number of the last sub-error	HError
hSubErrPrevious	Type of error returned: Number of the previous sub-error	HError
hSubErrFirst	Type of error returned: Number of the first sub-error	HError
hSubErrNext	Type of error returned: Number of the previous sub-error	HError
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
hStructure	Configure the file management: New empty file created from the file description	HRegenerateFile
hNoError	No error occurred	HError
hDeleteLog	Deletes the log file	HDeleteFile, HDeleteDatabase
hBackupCanceled	Status of backup: Backup canceled	HInfoBackup
Versions 15 and later hBackupFull New in version 15 hBackupFull hBackupFull	Type of backup: Full backup	HInfoBackup
Versions 15 and later hBackupDifferential New in version 15 hBackupDifferential hBackupDifferential	Type of backup: Differential backup	HInfoBackup
hBackupInProgress	Status of backup: Backup in progress	HInfoBackup
hBackupError	Status of backup: Error during backup	HInfoBackup
hBackupCompleted	Status of backup: Backup completed	HInfoBackup
Versions 15 and later hBackgroundTask New in version 15 hBackgroundTask hBackgroundTask	Execute process in the background, without locking the data file (available for data files in Client/Server mode).	HStatCalculate, HIndex
Versions 19 and later hWindowsDiskCacheSize New in version 19 hWindowsDiskCacheSize hWindowsDiskCacheSize	Mode for managing the size of Windows disk cache.	HSetServer
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	HSetServer
hFtxSize	Size of full-text index file in bytes (".Ftx" file)	HInfoFile
hFicSize	Size of data file in bytes (".Fic" file)	HInfoFile
hMaxLogSize	Maximum size in megabytes (MB) of log files	HSetServer
hMaxActivityStatisticsSize	Maximum size in megabytes (MB) of files for activity statistics	HSetServer
hMmoSize	Size of memo file in bytes (".Mmo" file)	HInfoFile
hNdxSize	Size of index file in bytes (".Ndx" file)	HInfoFile
hInternetPageSize	Size of page for using the RPC via Internet.	Remote access (RPC on HFSQL)
hIntranetPageSize	Size of page for using the RPC via Intranet.	Remote access (RPC on HFSQL)
hPageSize	Size of a block of caches. This block of caches will be used when looping through a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption.	HSetCache
hTotalSize	Total file size in bytes (added size of data file, memo file and index file).	HInfoFile
Versions 22 and later hTelemetryEnable New in version 22 hTelemetryEnable hTelemetryEnable	Configure the sending of data via the telemetry for the HFSQL server.	HSetServer
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 19 and later hSecondaryThread New in version 19 hSecondaryThread hSecondaryThread	Option for running the procedure: the procedure is run in a secondary thread.	HOnServerCall
hActiveSyncFrame	The size of the frame is optimized to be used with Mobile devices.	HCS.FrameSize
hDefaultFrame	The standard size will be used by default.	HCS.FrameSize
hGPRSFrame	The frame size is optimized for a use via GPRS	HCS.FrameSize
hInternetFrame	The frame size is optimized for a use via Internet	HCS.FrameSize
hIntranetFrame	The frame size is optimized for a use via Intranet	HCS.FrameSize
hWifiFrame	The frame size is optimized for a use via Wifi	HCS.FrameSize
hTriggerBefore	Indicates the type of trigger: The procedure is run before the HFSQL function	HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger
hTriggerAfter	Indicates the type of trigger: The procedure is run after the HFSQL function	HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger
Versions 21 and later htsNone New in version 21 htsNone htsNone	Type ot timestamp for the item: the item is not a timestamp item.	TimestampType property
Versions 21 and later htsCreation New in version 21 htsCreation htsCreation	Type ot timestamp for the item: the item will store the creation date of record.	TimestampType property
Versions 21 and later htsLastModification New in version 21 htsLastModification htsLastModification	Type ot timestamp for the item: the item will store the date of last modification performed on the record.	TimestampType property
hUnicode	Used to retrieve the record value in Unicode format.	HRetrieveRecord, HRecordToString
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
hMaxVal	Defines an upper bound for a filter	HBuildKeyValue, HFilter, HFilterStartsWith, HFilterIncludedBetween
hMinVal	Defines a lower bound for a filter	HBuildKeyValue, HFilter, HFilterStartsWith, HFilterIncludedBetween
hCheckDuplicates	Checks for duplicates for this operation, even if the duplicate check is disabled (HSetDuplicates)	HAdd, HExecuteQuery, HExecuteSQLQuery, HModify
hCheckIntegrity	Checks the integrity of operation even if the automatic integrity check is disabled (HSetIntegrity)	HAdd, HExecuteQuery, HExecuteSQLQuery, HModify, HCross, HDelete
hCheckMemo	Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos)	HIndex
hViewAdd	Create a view with addition: Stores the content of the view next time HExecuteView is called	HCreateView, HMergeView
hViewLocking	Lock records read in the file and included in the view	HCreateView, HMergeView
hViewDefault	Default creation of view	HCreateView, HMergeView
hViewPostponed	The view is created but it will be run later by HExecuteView	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
hViewBreakable	Interrupt view creation by pressing the ESC key	HCreateView
hViewIntersection	Merge views with intersection: Common rows between the two specified views	HMergeView
hViewJoin	Join between the first view and the second view.	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
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
Versions 27 and later SP_PBKDF2 New in version 27 SP_PBKDF2 SP_PBKDF2	Key derivation function used to hash an item of type "Password": Password-Based Key Derivation Function 2 (PBKDF2) is used.	Versions 27 and later spDerivation property New in version 27 spDerivation property spDerivation property
Versions 27 and later SP_SHA2_256 New in version 27 SP_SHA2_256 SP_SHA2_256	Algorithm used for salting an item of type "Password": Secure Hash Algorithm 256 (SHA-256) is used.	Versions 27 and later spHash property New in version 27 spHash property spHash property
Versions 27 and later SP_SHA2_512 New in version 27 SP_SHA2_512 SP_SHA2_512	Algorithm used for salting an item of type "Password": Secure Hash Algorithm 512 (SHA-512) is used.	Versions 27 and later spHash property New in version 27 spHash property spHash property
Versions 27 and later SP_SHA3_256 New in version 27 SP_SHA3_256 SP_SHA3_256	Algorithm used for salting an item of type "Password": Secure Hash Algorithm 3-256 (SHA-3 256) is used.	Versions 27 and later spHash property New in version 27 spHash property spHash property
Versions 27 and later SP_SHA3_512 New in version 27 SP_SHA3_512 SP_SHA3_512	Algorithm used for salting an item of type "Password": Secure Hash Algorithm 3-512 (SHA-3 512) is used.	Versions 27 and later spHash property New in version 27 spHash property spHash property
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 line of code: IF NOT <HFSQL function> THEN EndProgram()	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 line of code: IF NOT <HFSQL function> THEN SetFocusAndReturnToUserInput()	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
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

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

Constant	Description	Functions/Properties

eltSetOfProcedures	The listed element is a set of procedures	<Cnt>.ListStoredElement
eltProcedure	The listed element is a stored procedure	<Cnt>.ListStoredElement
eltQuery	The listed element is a query.	<Cnt>.ListStoredElement
Versions 15 and later h3G New in version 15 h3G h3G	Type of network to simulate: 3G	<Cnt>.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, <Cnt>.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, <Cnt>.OpenConnection, Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, <Cnt>.OpenConnection
hAccessJDBCSQLServer	Access to an SQL Server database via a JDBC driver	HDescribeConnection, <Cnt>.OpenConnection
hNativeAccessAS400	Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.OpenConnection, Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property
hNativeAccessXML	Provider that will be used for the connection: Native XML Connector (included with WINDEV/WEBDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Cnt>.OpenConnection, Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	<Cnt>.SetServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	<Cnt>.SimulateNetwork
hAffectBrowse	Addition affecting the current browse	<Source>.Add, <Source>.Modify
hApplication	Property of a database found on an HFSQL server: Name of the application from which the database was created.	HInfoDatabaseProperty, HInfoFileProperty
hStopped	Server stopped	HServerStatus
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	<Cnt>.SimulateNetwork
hAllowed	The relevant rights are granted to the user or group.	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
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 looping through 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 looping through 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
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
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
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
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.	<Cnt>.SetServer
Versions 18 and later hAutoStatisticalCalc New in version 18 hAutoStatisticalCalc hAutoStatisticalCalc	Enable the automatic calculation of statistics for the data files (optimization of indexes).	<Cnt>.SetServer
hCardinality	Integrity constraints: Check the link cardinalities.	<Cnt>.SetIntegrity
hInfiniteCardinality	Maximum cardinality ("N")	MaxLinkedCardinality property, MaxSourceCardinality property
hChangeCharset	The character set defined by ChangeCharset will be taken into account in the new data file. Sorts, searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.	<Source>.Creation, <Source>.CreationIfNotFound, <Source>.Index
hDatabasePath	Path of directory containing all databases	<Cnt>.SetServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	<Cnt>.SetServer
hJNLBackupPath	Path of the directory containing the backups of the logs	<Cnt>.SetServer
hLogPath	Path of the directory containing the log files	<Cnt>.SetServer
hActivityStatisticsPath	Path of the directory containing the activity statistics	<Cnt>.SetServer
hDuplicateKey	Characteristics of an item: Key with duplicates	KeyType property
hUniqueKey	Characteristics of an item: Unique key	KeyType property
Versions 20 and later hSQLCode New in version 20 hSQLCode hSQLCode	Requested information: SQL code of the materialized view	Versions 20 and later <Cnt>.InfoView New in version 20 <Cnt>.InfoView <Cnt>.InfoView
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	<Source>.CheckStructure
hPackNo	Compression mode: No compression	MmoPackMethod property
hPackZLW	Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation.	MmoPackMethod property
hKeepTRS	Stores the transaction files during the deletion	<Cnt>.DeleteDatabase, <Cnt>.DeleteFile
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
hCopyIndex	Copies the index of the data file	<Cnt>.CopyFile
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	<Cnt>.CopyFile
hCorrespondence	Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions	HInfoLog
hCreator	Property of a database found on an HFSQL server: Name of database owner.	<Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty
hCreateIndex	The index of the data file is not copied. It is automatically recreated at the destination by reindexing.	<Cnt>.CopyFile
hIncreasing	Sort performed in ascending order	SortType property
Versions 24 and later hCryptAES128 New in version 24 hCryptAES128 hCryptAES128	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
Versions 19 and later hEncryptionAuto New in version 19 hEncryptionAuto hEncryptionAuto	File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionNO	No file encryption.	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionRC5_12	The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionRC5_16	The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionStandard	The memo file is encrypted according to an optimized encryption algorithm on 128 bits.	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, <Cnt>.OpenConnection
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, <Cnt>.OpenConnection
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, <Cnt>.OpenConnection
hReadOnlyCursor	The set of records cannot be modified.	HDescribeConnection, <Cnt>.OpenConnection
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, <Cnt>.OpenConnection
hOptimisticCursor	The record is locked when it is updated	HDescribeConnection, <Cnt>.OpenConnection
hPessimisticCursor	The record is locked as soon as it goes into edit mode to be modified.	HDescribeConnection, <Cnt>.OpenConnection
hServerCursor	Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.	HDescribeConnection, <Cnt>.OpenConnection
hStaticCursor	Makes a copy of all query records in memory (high memory usage). All types of moves are allowed.	HDescribeConnection, <Cnt>.OpenConnection
hDaemonUser	Username that will be used by the server (Linux only)	<Cnt>.SetServer
hDate	Property of a database found on an HFSQL server: Creation date of the database.	<Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty
Versions 20 and later hDateLastRefresh New in version 20 hDateLastRefresh hDateLastRefresh	Requested information: Date of the last successful refresh for the materialized view.	Versions 20 and later <Cnt>.InfoView New in version 20 <Cnt>.InfoView <Cnt>.InfoView
hDBASCII	Sort according to ASCII order	HDBSortType
hDisconnection	Configures the disconnection message	HOnServerCall
hDBLexicographic	Sort according to the lexicographic order	HDBSortType
hDecreasing	Sort performed in descending order	SortType property
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).	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hStarted	Server started	HServerStatus
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.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hDestroyLink	Deletes all links related to the deleted data file.	<Cnt>.DeleteFile
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: Only one record is read if duplicates are found when looping through a key item	<Source>.Forward, <Source>.ReadPrevious, <Source>.ReadNext, <Source>.Previous, <Source>.Backward, <Source>.Next
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	<Cnt>.RegenerateFile
hRightsInsert	Rights to add new records into a data file.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsStopServer	Rights to stop a server (<Connection>.StopServer)	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsLock	Rights to lock the data files or the records of a data file.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsChangeRights	Rights to change rights.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights, <Cnt>.ModifyServerRights
hRightsChangeLink	Rights to modify the integrity rules on a data file.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsChangePassword	Rights to change the password of a user on the server (the user can change his own password and the administrator can change the password of each user).	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsChangeOwner	Rights to modify the owner of an element	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsConnection	Rights to connect to a server (encrypted or unencrypted connection)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsEncryptedConnection	Rights to connect to a server (encrypted connection only)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsCreateDB	Rights to create a database	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsCreateFile	Rights to create a data file (with <Source>.Creation)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
Versions 20 and later hRightsCreateView New in version 20 hRightsCreateView hRightsCreateView	Rights to create a SQL view or a materialized view.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsDebug	Rights to debug the stored procedures.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsDisconnectClient	Rights to disconnect the client computers.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsSendMessageToClient	Rights to send messages to the client computers.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsRunProcedure	Rights to run the stored procedures.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageDuplicate	Rights to enable and disable the management of duplicates.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsManageIntegrity	Rights to enable and disable the management of integrity.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageTask	Rights to manage the scheduled tasks.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsManageProcedure	Rights to add, modify and delete the stored procedures.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageServer	Rights to use <Cnt>.SetServer	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsManageTrigger	Rights to manage the server triggers (addition, activation, deletion)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageUser	Rights to delete and add users or groups	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsNoDatabaseAccess	Rights to prevent access to a database (<Cnt>.NoDatabaseAccess and <Cnt>.EndNoDatabaseAccess)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsRead	Rights to read the records of a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsReadLogStat	Rights to see the activity statistics and the server logs.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsMaintenance	Rights to start a re-index operation or to perform statistical calculations on a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsAutoModif	Rights to perform the automatic modification of the data files on a file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsUpdate	Rights to modify the records of a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsPriority	Rights to modify the priority of a client application	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
Versions 18 and later hRightsServerReplication New in version 18 hRightsServerReplication hRightsServerReplication	Rights to define and perform a replication between two HFSQL servers.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsBackup	Rights to save the data files	<Cnt>.InfoDatabaseRights, <Cnt>.InfoServerRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyServerRights
hRightsDelete	Rights to delete the records from a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsDeleteDB	Rights to delete a database	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsDeleteFile	Rights to delete a data file (<Cnt>.DeleteFile)	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
Versions 20 and later hRightsDeleteView New in version 20 hRightsDeleteView hRightsDeleteView	Rights to delete a SQL view or a materialized view.	Versions 20 and later <Cnt>.InfoViewRights, <Cnt>.ModifyViewRights New in version 20 <Cnt>.InfoViewRights, <Cnt>.ModifyViewRights <Cnt>.InfoViewRights, <Cnt>.ModifyViewRights
hRightsAll	List of all the rights	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hRightsSeeUser	Rights to view the characteristics of a group or user.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	<Cnt>.SetServer
hlbActive	Enable or disable the load balancing	<Cnt>.SetServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	<Cnt>.SetServer
hlbMaxTimeout	Value modifying the maximum timeout for a server request	<Cnt>.SetServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	<Cnt>.SetServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	<Cnt>.SetServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	<Cnt>.SetServer
hWriteDefault	Addition not affecting the current browse/Identifier re-used or calculated for the record	<Source>.Add, <Source>.Write, <Source>.Modify
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).	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hOnUpdate	Integrity rule applied during a modification	<Cnt>.SetIntegrity
hRecFile	Record to read: Value of the item currently saved in the data file	<Source>.ErrorModification, <Source>.ErrorStatusModification
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
hOnDelete	Integrity rule applied during a deletion	<Cnt>.SetIntegrity
hErrDatabaseAccess	Configure the access errors to an HFSQL Client/Server database.	<Source>.OnError
hErrADO	Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.	HErrorInfo
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
hErrLock	Customize lock errors	<Source>.OnError
hErrSystemCode	Type of information about the error to return: Number of the associated system 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 via the "Copy" button in the WLanguage error window.	HErrorInfo
hErrDuplicates	Customize duplicate errors	<Source>.OnError
hErrCurrent	Type of information about the error to return: Number of the current error	HError
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>.InfoView New in version 20 <Connection>.InfoView <Connection>.InfoView
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
hErrLockInfo	Type of information about the error to return: Information about the lock	HErrorInfo
hErrClientInfo	Information about the client layer used by the Native Connector that returned the error.	HErrorInfo
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
hErrServerInfo	Information about the server used by the Native Connector that returned the error.	HErrorInfo
hErrIntegrity	Customize integrity errors	<Source>.OnError
hErrLink	Type of information about the error to return: Name of the link associated with the error	HErrorInfo
hErrMessage	Type of information about the error to return: Message associated with the error	HErrorInfo
hErrADOMessage	Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO)	HErrorInfo
hErrBaseMessage	Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase)	HErrorInfo
hErrNativeMessage	Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector.	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
hErrSystemMessage	Type of information about the error to return: Message of associated system 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
hErrPassword	Customize password errors	<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
hErrNDX	Type of information about the error to return: Full name of the index file associated with the error	HErrorInfo
hErrRecNum	Type of information about the error to return: Number of the record associated with the error	HErrorInfo
hErrOLEDB	Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection.	HErrorInfo
hErrConnectionLoss	Customize the errors caused by a loss of connection with the server.	<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
hErrMain	Type of information about the error to return: Number of the main error	HError
hErrIndex	Customize reindexing errors (reindexing in progress when accessing the data file)	<Source>.OnError
hErrItem	Type of information about the error to return: Name of the item 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
hErrAll	Customize all errors	<Source>.OnError
hErrNeedValue	Customize errors caused by a required value that has not been specified (OLE DB only).	<Source>.OnError
hErrWDD	Type of information about the error to return: Full name of the analysis file associated with the error	HErrorInfo
hStateActive	Status of the record/Type of record taken into account: Active record	<Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification
hStateInvalid	Record status not found (error)	<Source>.State, <Source>.ErrorStatusModification
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
hStateAll	Type of record: Total number of records in the data file	<Source>.NbRec
hExisting	Type of search: Only the assignments for which a file actually exists	HListREP
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
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
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
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
hExpWithoutXSL	The style sheet (".XSL" file) is not created	<Source>.ExportXML
hFileAS400	Type of file: AS400 file	Type property
hFileOther	Type of file: Other type of 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
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
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
hANSIFormat	Data format: Ansi format (used by Windows)	Format property
hUNICODEFormat	Data format: UNICODE format	Format property
Versions 17 and later hForwardOnly New in version 17 hForwardOnly hForwardOnly	Native Connectors only: Optimizes simple iterations that do 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. For example, this constant can be used when looping through records to populate a Table control programmatically.	<Source>.ReadLast, <Source>.ReadFirst, <Source>.ReadSeekFirst, <Source>.ReadSeekLast
Versions 20 and later hftPunctuationSimple New in version 20 hftPunctuationSimple hftPunctuationSimple	Full-text Index item described programmatically: Taking into account the simple punctuation characters (non Unicode).	Option property of variables of type FullTextIndex Description.
Versions 20 and later hftPunctuationUnicode New in version 20 hftPunctuationUnicode hftPunctuationUnicode	Full-text Index item described programmatically: Taking into account the Unicode punctuation characters.	Option property of variables of type FullTextIndex Description.
hFTX	Reindexing full-text indexes	<Source>.Index
HGeneric	Type of search: Generic search	<Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.SeekLast, <Source>.SeekFirst
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
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	<Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights, <Cnt>.ModifyServerRights
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	Does not check for duplicates for this action, even if the automatic duplicate check is enabled (<Source>.SetDuplicates)	<Source>.Add
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (<Cnt>.SetIntegrity)	<Source>.Add, <Source>.Modify, <Source>.Delete, <HFSQL file>.Cross
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
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
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
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
hImpIgnoreEmptyItem	If one or more items are not filled in the text file, the corresponding lines are still imported. The missing items contain: the default value of items if the hDefaultVal constant is specified. the value of items in the current record before the call to <Source>.ImportText.	<Source>.ImportText, Versions 20 and later <Source>.ImportXLS New in version 20 <Source>.ImportXLS <Source>.ImportXLS
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
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
hImpOEM2ANSI	Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility.	<Source>.ImportText
hImpNoDelimiter	Type of import: The string separators (if they exist) are part of the item	<Source>.ImportText
hImpNoSpace	Type of import: The space characters found at the end of string are automatically deleted during the import	<Source>.ImportHF55
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
Versions 15 and later hInfoCluster New in version 15 hInfoCluster hInfoCluster	Information about the HFSQL cluster.	<Cnt>.InfoServer
hInfoDate	Date and time of server on 8 bytes in UTC format (universal time)	<Cnt>.InfoServer
Versions 22 and later hInfoFreeDiskSpace New in version 22 hInfoFreeDiskSpace hInfoFreeDiskSpace	Available space on the server disk, expressed in MB.	<Cnt>.InfoServer
Versions 22 and later hInfoTotalDiskSpace New in version 22 hInfoTotalDiskSpace hInfoTotalDiskSpace	Total capacity of server disk, expressed in MB.	<Cnt>.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>	<Cnt>.InfoServer
hInfoName	Name of server (DNS)	<Cnt>.InfoServer
hInfoLogicalName	Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center.	<Cnt>.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>	<Cnt>.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.	<Cnt>.InfoServer
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).	<Cnt>.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<	<Cnt>.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<	<Cnt>.InfoServer
hInfoVI	Version number of Manta.exe or Manta in Linux	<Cnt>.InfoServer
hIntegrityNone	Modification/Deletion rule: No integrity management	ModificationRule property, DeletionRule property
hIntegrityCascade	Modification/Deletion rule: Cascading modification/deletion	ModificationRule property, DeletionRule property
hIntegrityForbidden	Modification/Deletion rule: Modification/Deletion not allowed	ModificationRule property, DeletionRule property
hIntegrityDefaultValue	Modification/Deletion rule: Default modification/deletion	ModificationRule property, DeletionRule property
hForbidden	The relevant rights are not granted to the user or group	<Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights, <Cnt>.ModifyServerRights
hLogJNLFile	Configures the file to recreate: Only <File name>JNL.FIC is recreated.	<Source>.LogRecreate
hLogIdentification	Configures the file to recreate: Re-creates the "JournalIdentification.fic" file.	<Source>.LogRecreate
hLogWriting	Format of log process: Log the write operations performed in the file	LogMethod property
hLogReadingWriting	Format of log process: Log the read and write operations performed in the file	LogMethod property
hLogNo	Format of log process: No log	LogMethod property
hLogOperation	Configures the file to recreate: Re-creates the "JournalOperation.fic" file.	<Source>.LogRecreate
hLogUser	Configures the file to recreate: Recreates 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
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.	<Cnt>.SetServer
Versions 23 and later hkaTimeout New in version 23 hkaTimeout hkaTimeout	Maximum timeout (in seconds) for the server when checking the presence of client. If the client is not found at the end of this timeout, the client is automatically disconnected.	<Cnt>.SetServer
hLanguageCreation	Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation".	Language property, LanguageDescribed property
Versions 17 and later hLanguageBinarySort New in version 17 hLanguageBinarySort hLanguageBinarySort	The sort will be performed by comparing the binary value of the bytes. This type of sort is very fast. It should be used to perform an exact-match search for example.	Language property, LanguageDescribed property, H.LanguageCreationUnicode
Versions 17 and later hLanguageFastSort New in version 17 hLanguageFastSort hLanguageFastSort	The sort will be performed by comparing the characters one by one according to a generic sort.	Language property, LanguageDescribed property, H.LanguageCreationUnicode
hLimitParsing	Limits the file browse: The iteration will stop when the last searched 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
Versions 22 and later hlpCalcStat New in version 22 hlpCalcStat hlpCalcStat	Type of operation performed on the server: statistical calculation.	Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 hServerOperation type New in version 22 hServerOperation type hServerOperation type
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>.ListScheduling New in version 20 <Connection>.ListScheduling <Connection>.ListScheduling Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
Versions 22 and later hlpReplication New in version 22 hlpReplication hlpReplication	Type of operation performed on the server: server replication.	Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
Versions 20 and later hlpBackup New in version 20 hlpBackup hlpBackup	Type of scheduling to list: Scheduling of backups.	Versions 20 and later <Cnt>.ListScheduling New in version 20 <Cnt>.ListScheduling <Cnt>.ListScheduling Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 <Cnt>.ListScheduling New in version 20 <Cnt>.ListScheduling <Cnt>.ListScheduling Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
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 <Cnt>.ListScheduling New in version 20 <Cnt>.ListScheduling <Cnt>.ListScheduling Versions 22 and later hServerOperation type New in version 22 hServerOperation type hServerOperation type
hLstKey	Lists the key items	<Source>.ListKey, <Source>.ListItem
hLstCompositeKey	Lists the composite key items only	<Source>.ListKey, <Source>.ListItem
hLstSet	Lists the sets of procedures found on a server	<Cnt>.ListStoredElement
hLstDetail	Lists the detailed information	<Source>.ListKey, HListFile, <Source>.ListLink, <Source>.ListItem, HListConnection, <Cnt>.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	<Cnt>.ListDatabase
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
hLstLogicalOrder	Lists the items or the keys according to the logical order of items	<Source>.ListKey, <Source>.ListItem
hLstOpened	Stores the opened connections only	HListConnection
hLstStoredProcedure	Lists the stored procedures of a connection via Native Connectors or OLE DB	HListFile, <Cnt>.ListStoredElement
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.	<Cnt>.ListStoredElement HListFile
hLstItem	Lists the non-key and non-memo items	<Source>.ListItem
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
hLstTable	List of user tables for a connection via Native Connectors or OLE DB	HListFile
hLstSystemTable	List of system tables for a connection via Native Connectors or OLE DB	HListFile
Versions 22 and later hLstDatabaseSize New in version 22 hLstDatabaseSize hLstDatabaseSize	List of connection databases as well as their size.	<Cnt>.ListDatabase
hLstAll	Lists all the keys, all the files, all the items or all the connections	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection, <Cnt>.ListStoredElement
hLstSorted	Sorts the list of keys, files, items or connection in ascending order	<Source>.ListKey, HListFile, <Source>.ListItem, HListConnection
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
Versions 20 and later hLstMaterializedView New in version 20 hLstMaterializedView hLstMaterializedView	Lists the materialized views found on an HFSQL server.	HListFile
hComputer	Property of a database found on an HFSQL server: Name of the computer from which the element was created.	<Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty
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
hMemoYes	The text memos are read whenever the record is read. Read the binary memos when accessing the item.	<Source>.SetMemo
hMemoWav	Type of file used for the memo: sound file	<Source>.LinkMemo
hMessage	Configures the information message	HOnServerCall
hMode2GB	Indicates whether system files support more than 2 GB	<Cnt>.SetServer
Versions 20 and later hMmoCompact New in version 20 hMmoCompact hMmoCompact	Compression and defragmentation of "Mmo" files.	<Source>.Index
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 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
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 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
hNdxCompact	Reindexing with compression	<Source>.Index
hNdxMinimal	Reindex and ignore corrupted keys	<Source>.Index
hNdxSilent	Configure reindexing: No display during reindexing	<Source>.Index
hNdxNormal	Standard reindexing	<Source>.Index
hNdxNoStat	Reindex without calculating statistics	<Source>.Index
hNdxDelete	Reindex and delete damaged records	<Source>.Index
hLogLevel	Defines the elements that must be in the log file	<Cnt>.SetServer
Versions 24 and later hMaxNumberConnection New in version 24 hMaxNumberConnection hMaxNumberConnection	Maximum number of connections allowed per application.	<Cnt>.SetServer
hNonBlocking	Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To knwo if the execution of the view or query is completed, use the ExecutionCompleted property 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
hNotAKey	Characteristics of an item: Non-key item	KeyType property
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	SortType property
hNotes	Property of a database found on an HFSQL server: Database description or any other information associated with the database by <Cnt>.ModifyDatabaseProperty.	<Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty, <Cnt>.InfoServerProperty, <Cnt>.ModifyDatabaseProperty, <Cnt>.ModifyFileProperty, <Cnt>.ModifyServerProperty
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 <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient New in version 18 <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient
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 <Cnt>.NotifConfigure New in version 18 <Cnt>.NotifConfigure <Cnt>.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 <Cnt>.NotifConfigure New in version 18 <Cnt>.NotifConfigure <Cnt>.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 <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient New in version 18 <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient
Versions 18 and later hNotifEmail New in version 18 hNotifEmail hNotifEmail	The notifications are sent by email.	Versions 18 and later <Cnt>.NotifConfigure New in version 18 <Cnt>.NotifConfigure <Cnt>.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 <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient New in version 18 <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient
Versions 22 and later hNotifInformation New in version 22 hNotifInformation hNotifInformation	The notifications will be sent from the information level (for the information, warning, critical and error problems)	<Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient
hCurrentRecNum	Number of the current record.	HFSQL functions
hInvalidRecNum	Constant returned if there is no current record or if the specified file corresponds to a multi-file query.	<Source>.RecNum
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
hODBC	OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Allows you to access an ODBC source declared in the ODBC data sources of Windows	CtOLEDBProvider property, CtDescribedOLEDBProvider property, HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect
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
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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.OpenConnection, SQLConnect
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
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
hActivityStatisticsPeriod	Indicates the period (in second) between each backup of values for the different activity counters.	<Cnt>.SetServer
hDebuggingPort	Port used to debug the stored procedures and the server triggers.	<Cnt>.SetServer
hServerPort	Network port used	<Cnt>.SetServer
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
hOwner	Property of a database found on an HFSQL server: Owner of database.	<Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty, <Cnt>.ModifyDatabaseProperty, <Cnt>.ModifyFileProperty
Versions 20 and later hRefreshInProgress New in version 20 hRefreshInProgress hRefreshInProgress	Requested information: Is the materialized view currently refreshed?	Versions 20 and later <Cnt>.InfoView New in version 20 <Cnt>.InfoView <Cnt>.InfoView
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 <Cnt>.TransactionIsolation New in version 19 <Cnt>.TransactionIsolation <Cnt>.TransactionIsolation
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 <Cnt>.TransactionIsolation New in version 19 <Cnt>.TransactionIsolation <Cnt>.TransactionIsolation
hRecalculateIDAuto	Mode for calculating the automatic identifier: Automatic identifier re-calculated during the write operation	<Source>.Write, <Source>.Modify
Versions 22 and later hFindKey New in version 22 hFindKey hFindKey	Enable the search for keys on the HFSQL server.	<Cnt>.SetServer
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 <Cnt>.TransactionIsolation New in version 19 <Cnt>.TransactionIsolation <Cnt>.TransactionIsolation
hSubscriberReplica	Replication mode: The data file is a subscriber replica (HCreateSubscriberReplica was used to create the subscriber replica)	Replication property
hMasterReplica	Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica)	Replication property
hReplicated	Replication mode: The data file is configured to be replicated.	Replication property
hQueryDefault	The query is initialized without interruption	<HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery
hQueryBreakable	The query initialization can be interrupted with the ESC key	<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 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).	<Cnt>.SetServer
hKeepFilter	The filter set by HFilter will be taken into account, even if the search key is not optimized for the filter. Reminder: HFilter returns the search key optimized for the filter. Caution: in this case, performance problems may occur on large files.	<Source>.ChangeKey, <Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.ReadSeek, HFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst
hRPKeep	Configure the restore operation: Position not freed	<Source>.RestorePosition
hRPDefault	Configure the restore operation: Position freed. The stored position is restored	<Source>.RestorePosition
hRPFilter	Configure the restore operation: Restore the filter set when <HFSQL file>.SavePosition is called	<Source>.RestorePosition
hRPHF5	Configure the restore operation: If the stored position was deleted or modified, this position is restored	<Source>.RestorePosition
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.	<Cnt>.RSAddConfig
Versions 22 and later hrsCopyBackgroundTask New in version 22 hrsCopyBackgroundTask hrsCopyBackgroundTask	Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is performed in background task and it is not locking.	<Cnt>.RSAddConfig
Versions 22 and later hrsNoCopy New in version 22 hrsNoCopy hrsNoCopy	Configure the replication between servers: No copy is performed.	<Cnt>.RSAddConfig
hItemBinary	Item type: Binary	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
hItemDate6	Item type: Date	Type property
hItemDate8	Item type: Date	Type property
hItemDateTime	Item type: Date/Time	Type property
hItemTimeLength	Item type: Duration	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
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 20 and later hItemEnumeration New in version 20 hItemEnumeration hItemEnumeration	Item type: Enumeration	Type property
hItemHour	Item type: Time	Type property
hItemIDAuto	Item type: Automatic identifier (8 bytes)	Type property
hItemIDAuto4	Item type: Automatic identifier (4 bytes)	Type property
hItemPicture	Item type: Image	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
hItemBinaryMemo	Item type: Binary Memo	Type property
hItemBinaryMemo4	Item type: Binary memo (4 bytes)	Type property
hItemTextMemo	Item type: Text Memo	Type property
hItemUnicodeMemo	Item type: Unicode Text Memo	Type property
hItemCurrency	Item type: Currency	Type property
Versions 27 and later hItemSecurePassword New in version 27 hItemSecurePassword hItemSecurePassword	Item type: Password	Type property
hItemNumRec	Item type: Record number	Type property
hItemNumeric	Item type: High-precision numeric	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
hItemUnicodeText	Item type: Unicode text	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
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
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 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 20 and later NoWait New in version 20 NoWait NoWait	The refresh of materialized view is not a locking operation: it is performed in background task. <Connection>.InfoView returns the information of the materialized view after being refreshed.	Versions 20 and later <Cnt>.RefreshView New in version 20 <Cnt>.RefreshView <Cnt>.RefreshView
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
hNoIndex	The file index is not copied	<Cnt>.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
hNoRefresh	The table or query content will not be refreshed	<Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.First
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
hSaveItems	Saves the values of items in memory when using HSavePosition. These values will be restored next time <Source>.RestorePosition is called.	<HFSQL file>.SavePosition
hBoundSeparator	Used to separate the values of lower and upper bounds for the components of composite key	<Source>.FilterIncludedBetween
hSubErrLast	Type of error returned: Number of the last sub-error	HError
hSubErrPrevious	Type of error returned: Number of the previous sub-error	HError
hSubErrFirst	Type of error returned: Number of the first sub-error	HError
hSubErrNext	Type of error returned: Number of the previous sub-error	HError
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
hStructure	Configure the file management: New empty file created from the file description	<Cnt>.RegenerateFile
hNoError	No error occurred	HError
hDeleteLog	Deletes the log file	<Cnt>.DeleteFile, <Cnt>.DeleteDatabase
hBackupCanceled	Status of backup: Backup canceled	<Cnt>.InfoBackup
Versions 15 and later hBackupFull New in version 15 hBackupFull hBackupFull	Type of backup: Full backup	<Cnt>.InfoBackup
Versions 15 and later hBackupDifferential New in version 15 hBackupDifferential hBackupDifferential	Type of backup: Differential backup	<Cnt>.InfoBackup
hBackupInProgress	Status of backup: Backup in progress	<Cnt>.InfoBackup
hBackupError	Status of backup: Error during backup	<Cnt>.InfoBackup
hBackupCompleted	Status of backup: Backup completed	<Cnt>.InfoBackup
Versions 15 and later hBackgroundTask New in version 15 hBackgroundTask hBackgroundTask	Execute process in the background, without locking the data file (available for data files in Client/Server mode).	<Source>.StatCalculate, <Source>.Index
Versions 19 and later hWindowsDiskCacheSize New in version 19 hWindowsDiskCacheSize hWindowsDiskCacheSize	Mode for managing the size of Windows disk cache.	<Cnt>.SetServer
hNdxCacheSize	Maximum size in megabytes (MB) of index cache	<Cnt>.SetServer
hFtxSize	Size of full-text index file in bytes (".Ftx" file)	<Source>.InfoFile
hFicSize	Size of data file in bytes (".Fic" file)	<Source>.InfoFile
hMaxLogSize	Maximum size in megabytes (MB) of log files	<Cnt>.SetServer
hMaxActivityStatisticsSize	Maximum size in megabytes (MB) of files for activity statistics	<Cnt>.SetServer
hMmoSize	Size of memo file in bytes (".Mmo" file)	<Source>.InfoFile
hNdxSize	Size of index file in bytes (".Ndx" file)	<Source>.InfoFile
hInternetPageSize	Size of page for using the RPC via Internet.	Remote access (RPC on HFSQL)
hIntranetPageSize	Size of page for using the RPC via Intranet.	Remote access (RPC on HFSQL)
hPageSize	Size of a block of caches. This block of caches will be used when looping through a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption.	HSetCache
hTotalSize	Total file size in bytes (added size of data file, memo file and index file).	<Source>.InfoFile
Versions 22 and later hTelemetryEnable New in version 22 hTelemetryEnable hTelemetryEnable	Configure the sending of data via the telemetry for the HFSQL server.	<Cnt>.SetServer
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 19 and later hSecondaryThread New in version 19 hSecondaryThread hSecondaryThread	Option for running the procedure: the procedure is run in a secondary thread.	HOnServerCall
hActiveSyncFrame	The size of the frame is optimized to be used with Mobile devices.	HCS.FrameSize
hDefaultFrame	The standard size will be used by default.	HCS.FrameSize
hGPRSFrame	The frame size is optimized for a use via GPRS	HCS.FrameSize
hInternetFrame	The frame size is optimized for a use via Internet	HCS.FrameSize
hIntranetFrame	The frame size is optimized for a use via Intranet	HCS.FrameSize
hWifiFrame	The frame size is optimized for a use via Wifi	HCS.FrameSize
hTriggerBefore	Indicates the type of trigger: The procedure is run before the HFSQL function	HActivateTrigger, HDeactivateTrigger, <Source>.DeleteTrigger, <Source>.DescribeTrigger
hTriggerAfter	Indicates the type of trigger: The procedure is run after the HFSQL function	HActivateTrigger, HDeactivateTrigger, <Source>.DeleteTrigger, <Source>.DescribeTrigger
Versions 21 and later htsNone New in version 21 htsNone htsNone	Type ot timestamp for the item: the item is not a timestamp item.	TimestampType property
Versions 21 and later htsCreation New in version 21 htsCreation htsCreation	Type ot timestamp for the item: the item will store the creation date of record.	TimestampType property
Versions 21 and later htsLastModification New in version 21 htsLastModification htsLastModification	Type ot timestamp for the item: the item will store the date of last modification performed on the record.	TimestampType property
hUnicode	Used to retrieve the record value in Unicode format.	<Source>.RetrieveRecord
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
hMaxVal	Defines an upper bound for a filter	<Source>.BuildKeyValue, <Source>.Filter, <Source>.FilterStartsWith, <Source>.FilterIncludedBetween
hMinVal	Defines a lower bound for a filter	<Source>.BuildKeyValue, <Source>.Filter, <Source>.FilterStartsWith, <Source>.FilterIncludedBetween
hCheckDuplicates	Checks for duplicates for this operation, even if the duplicate check is disabled (<Source>.SetDuplicates)	<Source>.Add, <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.Modify
hCheckIntegrity	Checks the integrity of operation even if the automatic integrity check is disabled (<Cnt>.SetIntegrity)	<Source>.Add, <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery, <Source>.Modify, <HFSQL file>.Cross, <Source>.Delete
hCheckMemo	Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos)	<Source>.Index
hViewAdd	Create a view with addition: Stores the content of the view next time <Source>.ExecuteView is called	<Source>.CreateView, <Source>.MergeView
hViewLocking	Lock records read in the file and included in the view	<Source>.CreateView, <Source>.MergeView
hViewDefault	Default creation of view	<Source>.CreateView, <Source>.MergeView
hViewPostponed	The view is created but it will be run later by <Source>.ExecuteView	<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
hViewBreakable	Interrupt view creation by pressing the ESC key	<Source>.CreateView
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
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
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
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 line of code: IF NOT <HFSQL function> THEN EndProgram()	<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 line of code: IF NOT <HFSQL function> THEN SetFocusAndReturnToUserInput()	<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
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

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

Constant	Description	Functions/Properties

eltSetOfProcedures	The listed element is a set of procedures	<Cnt>.ListStoredElement
eltProcedure	The listed element is a stored procedure	<Cnt>.ListStoredElement
eltQuery	The listed element is a query.	<Cnt>.ListStoredElement
Versions 15 and later h3G New in version 15 h3G h3G	Type of network to simulate: 3G	<Cnt>.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, <Cnt>.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, <Cnt>.OpenConnection, Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property
hAccessJDBCMySQL	Access to a MySQL database via a JDBC driver	HDescribeConnection, <Cnt>.OpenConnection
hAccessJDBCSQLServer	Access to an SQL Server database via a JDBC driver	HDescribeConnection, <Cnt>.OpenConnection
hNativeAccessAS400	Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.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, <Cnt>.OpenConnection, Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property
hNativeAccessXML	Provider that will be used for the connection: Native XML Connector (included with WINDEV/WEBDEV)	HConnect, <Source>.DeclareExternal, HDescribeConnection, HListFile, <Cnt>.OpenConnection, Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property
Versions 23 and later hActiveDirectory New in version 23 hActiveDirectory hActiveDirectory	Enable the authentication via Active Directory.	<Cnt>.SetServer
Versions 15 and later hADSL New in version 15 hADSL hADSL	Type of network to simulate: ADSL	<Cnt>.SimulateNetwork
hAffectBrowse	Addition affecting the current browse	<Source>.Add, <Source>.Modify
hApplication	Property of a database found on an HFSQL server: Name of the application from which the database was created.	HInfoDatabaseProperty, HInfoFileProperty
hStopped	Server stopped	HServerStatus
Versions 15 and later hNone New in version 15 hNone hNone	Used to disable the simulation of a specific network.	<Cnt>.SimulateNetwork
hAllowed	The relevant rights are granted to the user or group.	HModifyDatabaseRights, HModifyFileRights, HModifyServerRights
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 looping through 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 looping through 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
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
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
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
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.	<Cnt>.SetServer
Versions 18 and later hAutoStatisticalCalc New in version 18 hAutoStatisticalCalc hAutoStatisticalCalc	Enable the automatic calculation of statistics for the data files (optimization of indexes).	<Cnt>.SetServer
hCardinality	Integrity constraints: Check the link cardinalities.	<Cnt>.SetIntegrity
hInfiniteCardinality	Maximum cardinality ("N")	MaxLinkedCardinality property, MaxSourceCardinality property
hChangeCharset	The character set defined by ChangeCharset will be taken into account in the new data file. Sorts, searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.	<Source>.Creation, <Source>.CreationIfNotFound, <Source>.Index
hDatabasePath	Path of directory containing all databases	<Cnt>.SetServer
hJNLPath	Path of the directory containing all the logs of the different HFSQL Client/Server applications	<Cnt>.SetServer
hJNLBackupPath	Path of the directory containing the backups of the logs	<Cnt>.SetServer
hLogPath	Path of the directory containing the log files	<Cnt>.SetServer
hActivityStatisticsPath	Path of the directory containing the activity statistics	<Cnt>.SetServer
hDuplicateKey	Characteristics of an item: Key with duplicates	KeyType property
hUniqueKey	Characteristics of an item: Unique key	KeyType property
Versions 20 and later hSQLCode New in version 20 hSQLCode hSQLCode	Requested information: SQL code of the materialized view	Versions 20 and later <Cnt>.InfoView New in version 20 <Cnt>.InfoView <Cnt>.InfoView
hCompatible	The structures of the data files (defined in the analysis and found in the physical file) must be compatible.	<Source>.CheckStructure
hPackNo	Compression mode: No compression	MmoPackMethod property
hPackZLW	Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation.	MmoPackMethod property
hKeepTRS	Stores the transaction files during the deletion	<Cnt>.DeleteDatabase, <Cnt>.DeleteFile
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
hCopyIndex	Copies the index of the data file	<Cnt>.CopyFile
hCopyIfNotFound	Copies the data file only if it does not exist at the specified location on the destination computer.	<Cnt>.CopyFile
hCorrespondence	Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions	HInfoLog
hCreator	Property of a database found on an HFSQL server: Name of database owner.	<Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty
hCreateIndex	The index of the data file is not copied. It is automatically recreated at the destination by reindexing.	<Cnt>.CopyFile
hIncreasing	Sort performed in ascending order	SortType property
Versions 24 and later hCryptAES128 New in version 24 hCryptAES128 hCryptAES128	File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
Versions 19 and later hEncryptionAuto New in version 19 hEncryptionAuto hEncryptionAuto	File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionNO	No file encryption.	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionRC5_12	The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionRC5_16	The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits).	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hEncryptionStandard	The memo file is encrypted according to an optimized encryption algorithm on 128 bits.	FicCryptMethod property, MmoCryptMethod property, NdxCryptMethod property
hClientCursor	Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor	HDescribeConnection, <Cnt>.OpenConnection
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, <Cnt>.OpenConnection
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, <Cnt>.OpenConnection
hReadOnlyCursor	The set of records cannot be modified.	HDescribeConnection, <Cnt>.OpenConnection
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, <Cnt>.OpenConnection
hOptimisticCursor	The record is locked when it is updated	HDescribeConnection, <Cnt>.OpenConnection
hPessimisticCursor	The record is locked as soon as it goes into edit mode to be modified.	HDescribeConnection, <Cnt>.OpenConnection
hServerCursor	Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.	HDescribeConnection, <Cnt>.OpenConnection
hStaticCursor	Makes a copy of all query records in memory (high memory usage). All types of moves are allowed.	HDescribeConnection, <Cnt>.OpenConnection
hDaemonUser	Username that will be used by the server (Linux only)	<Cnt>.SetServer
hDate	Property of a database found on an HFSQL server: Creation date of the database.	<Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty
Versions 20 and later hDateLastRefresh New in version 20 hDateLastRefresh hDateLastRefresh	Requested information: Date of the last successful refresh for the materialized view.	Versions 20 and later <Cnt>.InfoView New in version 20 <Cnt>.InfoView <Cnt>.InfoView
hDBASCII	Sort according to ASCII order	HDBSortType
hDisconnection	Configures the disconnection message	HOnServerCall
hDBLexicographic	Sort according to the lexicographic order	HDBSortType
hDecreasing	Sort performed in descending order	SortType property
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).	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hStarted	Server started	HServerStatus
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.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hDestroyLink	Deletes all links related to the deleted data file.	<Cnt>.DeleteFile
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: Only one record is read if duplicates are found when looping through a key item	<Source>.Forward, <Source>.ReadPrevious, <Source>.ReadNext, <Source>.Previous, <Source>.Backward, <Source>.Next
hData	Configure the file management: All the operations stored in the log file are applied to the existing file	<Cnt>.RegenerateFile
hRightsInsert	Rights to add new records into a data file.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsStopServer	Rights to stop a server (<Connection>.StopServer)	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsLock	Rights to lock the data files or the records of a data file.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsChangeRights	Rights to change rights.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights, <Cnt>.ModifyServerRights
hRightsChangeLink	Rights to modify the integrity rules on a data file.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsChangePassword	Rights to change the password of a user on the server (the user can change his own password and the administrator can change the password of each user).	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsChangeOwner	Rights to modify the owner of an element	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsConnection	Rights to connect to a server (encrypted or unencrypted connection)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsEncryptedConnection	Rights to connect to a server (encrypted connection only)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsCreateDB	Rights to create a database	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsCreateFile	Rights to create a data file (with <Source>.Creation)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
Versions 20 and later hRightsCreateView New in version 20 hRightsCreateView hRightsCreateView	Rights to create a SQL view or a materialized view.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsDebug	Rights to debug the stored procedures.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsDisconnectClient	Rights to disconnect the client computers.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsSendMessageToClient	Rights to send messages to the client computers.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsRunProcedure	Rights to run the stored procedures.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageDuplicate	Rights to enable and disable the management of duplicates.	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsManageIntegrity	Rights to enable and disable the management of integrity.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageTask	Rights to manage the scheduled tasks.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsManageProcedure	Rights to add, modify and delete the stored procedures.	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageServer	Rights to use <Cnt>.SetServer	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsManageTrigger	Rights to manage the server triggers (addition, activation, deletion)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsManageUser	Rights to delete and add users or groups	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsNoDatabaseAccess	Rights to prevent access to a database (<Cnt>.NoDatabaseAccess and <Cnt>.EndNoDatabaseAccess)	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsRead	Rights to read the records of a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsReadLogStat	Rights to see the activity statistics and the server logs.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsMaintenance	Rights to start a re-index operation or to perform statistical calculations on a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsAutoModif	Rights to perform the automatic modification of the data files on a file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsUpdate	Rights to modify the records of a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsPriority	Rights to modify the priority of a client application	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
Versions 18 and later hRightsServerReplication New in version 18 hRightsServerReplication hRightsServerReplication	Rights to define and perform a replication between two HFSQL servers.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hRightsBackup	Rights to save the data files	<Cnt>.InfoDatabaseRights, <Cnt>.InfoServerRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyServerRights
hRightsDelete	Rights to delete the records from a data file	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
hRightsDeleteDB	Rights to delete a database	<Cnt>.InfoDatabaseRights, <Cnt>.ModifyDatabaseRights
hRightsDeleteFile	Rights to delete a data file (<Cnt>.DeleteFile)	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights
Versions 20 and later hRightsDeleteView New in version 20 hRightsDeleteView hRightsDeleteView	Rights to delete a SQL view or a materialized view.	Versions 20 and later <Cnt>.InfoViewRights, <Cnt>.ModifyViewRights New in version 20 <Cnt>.InfoViewRights, <Cnt>.ModifyViewRights <Cnt>.InfoViewRights, <Cnt>.ModifyViewRights
hRightsAll	List of all the rights	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hRightsSeeUser	Rights to view the characteristics of a group or user.	<Cnt>.InfoServerRights, <Cnt>.ModifyServerRights
hlbDiskAccess	Value modifying the coefficient applied to the counter for the number of disk accesses.	<Cnt>.SetServer
hlbActive	Enable or disable the load balancing	<Cnt>.SetServer
hlbClientCalls	Value modifying the coefficient applied to the counter for client calls	<Cnt>.SetServer
hlbMaxTimeout	Value modifying the maximum timeout for a server request	<Cnt>.SetServer
hlbDisk	Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server	<Cnt>.SetServer
hlbSent	Value modifying the coefficient applied to the counter for the bytes sent by the server	<Cnt>.SetServer
hlbReceived	Value modifying the coefficient applied to the counter for the bytes received by the server	<Cnt>.SetServer
hWriteDefault	Addition not affecting the current browse/Identifier re-used or calculated for the record	<Source>.Add, <Source>.Write, <Source>.Modify
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).	<Cnt>.InfoDatabaseRights, <Cnt>.InfoFileRights, <Cnt>.InfoServerRights
hOnUpdate	Integrity rule applied during a modification	<Cnt>.SetIntegrity
hRecFile	Record to read: Value of the item currently saved in the data file	<Source>.ErrorModification, <Source>.ErrorStatusModification
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
hOnDelete	Integrity rule applied during a deletion	<Cnt>.SetIntegrity
hErrDatabaseAccess	Configure the access errors to an HFSQL Client/Server database.	<Source>.OnError
hErrADO	Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant.	HErrorInfo
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
hErrLock	Customize lock errors	<Source>.OnError
hErrSystemCode	Type of information about the error to return: Number of the associated system 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 via the "Copy" button in the WLanguage error window.	HErrorInfo
hErrDuplicates	Customize duplicate errors	<Source>.OnError
hErrCurrent	Type of information about the error to return: Number of the current error	HError
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>.InfoView New in version 20 <Connection>.InfoView <Connection>.InfoView
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
hErrLockInfo	Type of information about the error to return: Information about the lock	HErrorInfo
hErrClientInfo	Information about the client layer used by the Native Connector that returned the error.	HErrorInfo
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
hErrServerInfo	Information about the server used by the Native Connector that returned the error.	HErrorInfo
hErrIntegrity	Customize integrity errors	<Source>.OnError
hErrLink	Type of information about the error to return: Name of the link associated with the error	HErrorInfo
hErrMessage	Type of information about the error to return: Message associated with the error	HErrorInfo
hErrADOMessage	Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO)	HErrorInfo
hErrBaseMessage	Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase)	HErrorInfo
hErrNativeMessage	Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector.	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
hErrSystemMessage	Type of information about the error to return: Message of associated system 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
hErrPassword	Customize password errors	<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
hErrNDX	Type of information about the error to return: Full name of the index file associated with the error	HErrorInfo
hErrRecNum	Type of information about the error to return: Number of the record associated with the error	HErrorInfo
hErrOLEDB	Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection.	HErrorInfo
hErrConnectionLoss	Customize the errors caused by a loss of connection with the server.	<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
hErrMain	Type of information about the error to return: Number of the main error	HError
hErrIndex	Customize reindexing errors (reindexing in progress when accessing the data file)	<Source>.OnError
hErrItem	Type of information about the error to return: Name of the item 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
hErrAll	Customize all errors	<Source>.OnError
hErrNeedValue	Customize errors caused by a required value that has not been specified (OLE DB only).	<Source>.OnError
hErrWDD	Type of information about the error to return: Full name of the analysis file associated with the error	HErrorInfo
hStateActive	Status of the record/Type of record taken into account: Active record	<Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification
hStateInvalid	Record status not found (error)	<Source>.State, <Source>.ErrorStatusModification
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
hStateAll	Type of record: Total number of records in the data file	<Source>.NbRec
hExisting	Type of search: Only the assignments for which a file actually exists	HListREP
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
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
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
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
hExpWithoutXSL	The style sheet (".XSL" file) is not created	<Source>.ExportXML
hFileAS400	Type of file: AS400 file	Type property
hFileOther	Type of file: Other type of 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
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
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
hANSIFormat	Data format: Ansi format (used by Windows)	Format property
hUNICODEFormat	Data format: UNICODE format	Format property
Versions 17 and later hForwardOnly New in version 17 hForwardOnly hForwardOnly	Native Connectors only: Optimizes simple iterations that do 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. For example, this constant can be used when looping through records to populate a Table control programmatically.	<Source>.ReadLast, <Source>.ReadFirst, <Source>.ReadSeekFirst, <Source>.ReadSeekLast
Versions 20 and later hftPunctuationSimple New in version 20 hftPunctuationSimple hftPunctuationSimple	Full-text Index item described programmatically: Taking into account the simple punctuation characters (non Unicode).	Option property of variables of type FullTextIndex Description.
Versions 20 and later hftPunctuationUnicode New in version 20 hftPunctuationUnicode hftPunctuationUnicode	Full-text Index item described programmatically: Taking into account the Unicode punctuation characters.	Option property of variables of type FullTextIndex Description.
hFTX	Reindexing full-text indexes	<Source>.Index
HGeneric	Type of search: Generic search	<Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.SeekLast, <Source>.SeekFirst
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
hInherit	The user will inherit from the value of the rights granted to the group to which he belongs	<Cnt>.ModifyDatabaseRights, <Cnt>.ModifyFileRights, <Cnt>.ModifyServerRights
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	Does not check for duplicates for this action, even if the automatic duplicate check is enabled (<Source>.SetDuplicates)	<Source>.Add
hIgnoreIntegrity	Ignores the integrity check for this operation, even if the automatic integrity check is enabled (<Cnt>.SetIntegrity)	<Source>.Add, <Source>.Modify, <Source>.Delete, <HFSQL file>.Cross
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
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
Versions 20 and later hImpIgnoreFirstLine<