| | |
| 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 |
| h3G | Type of network to be simulated: 3G | HSimulateNetwork |
| h4G | Network type to be simulated: 4G | HSimulateNetwork |
| h5G | Network type to be simulated: 5G | 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 to 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 to be used for connection: AS/400 Native Connector (optional WINDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessDB2 | OLE DB provider to be used for connection: DB2 Native Connector (optional WINDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessInformix | OLE DB provider to be used for connection: Informix Native Connector (optional WINDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessMariaDB | OLE DB provider to be used for connection: MariaDB Native Connector (optional WINDEV/WEBDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessMySQL | OLE DB provider to be used for the connection: MySQL Native Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessOracle | OLE DB provider to be used for connection: Oracle Native Connector (optional WINDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessOracleLite | Provider to be used for connection: Oracle Native Connector (optional WINDEV Mobile module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessPostgreSQL | OLE DB provider to be used for the connection: PostgreSQL Native Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessProgress | OLE DB provider to be used for connection: Progress Native Connector (optional WINDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessSQLAzure | OLE DB provider to be used for the connection: SQL Azure Native Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessSQLite | OLE DB provider to be used for the connection: Native connector to a SQLite database | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessSQLServer | OLE DB provider to be used for connection: SQL Server Native Connector (optional WINDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessSQLServerMobile | Provider to be used for the connection: SQL Server Mobile Native Connector (optional WINDEV Mobile module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessSybase | OLE DB provider to be used for connection: Sybase Native Connector (optional WINDEV module) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessXBase | OLE DB provider to be used for connection: xBase Native Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hNativeAccessXML | Provider to be used for connection: Native XML connector (supplied as standard with WINDEV/WEBDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
Provider property, CtOLEDBProvider property, CtDescribedOLEDBProvider property |
| hActiveDirectory | Enable the authentication via Active Directory. | HSetServer |
| hADSL | Network type to be simulated: ADSL | HSimulateNetwork |
| hAffectBrowse | Addition affecting the current browse | HAdd, HModify |
| hApplication | Property of a database on an HFSQL server: Name of the application from which the database was created. | HInfoDatabaseProperty, HInfoFileProperty |
| hStopped | Server stopped | HServerStatus |
| 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 | Lock type: Lock in read/write mode | 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, HNext, HSeekLast, HSeekFirst, HBackward, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, HModify, HPrevious, HFirst, HCross, HSeek |
| hCacheNbUnusedFiles | Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server. | HSetServer |
| hCalculStatistiqueAuto | Enable the automatic calculation of statistics for the data files (optimization of indexes). | HSetServer |
| hCardinality | Integrity constraints: Test 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, etc. 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 |
| hBackupPath | Path of the directory containing the backups. | HSetServer |
| hActivityStatisticsPath | Path of the directory containing the activity statistics | HSetServer |
| hDuplicateKey | Characteristics of a heading: Key with duplicates | KeyType property |
| hPrimaryKey | Field characteristics: Primary key | KeyType property |
| hSpatialKey | Characteristics of a heading: Spatial key | KeyType property |
| hUniqueKey | Characteristics of an item: Unique key | KeyType property |
| hCloud | Type of network to be simulated: Cloud | HSimulateNetwork |
| hSQLCode | Required information: SQL code for materialized view | 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 according to the Ziw-Lempel algorithm, implemented by Welch. | MmoPackMethod property |
 New in SaaShConserveHistoryReindexing | Keeps history of optimizations/reindexations performed on HFSQL Client/SErveur data files (asynchronous mode). | HSetServer |
| hKeepTRS | Stores the transaction files during the deletion | HDeleteDatabase,
HDeleteFile |
| hCopyAutoID | Copies the automatic identifier while keeping its value | HCopyRecord, HImportHF55,
HImportText,
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 on an HFSQL server: Name of the database owner. | HInfoDatabaseProperty, HInfoFileProperty |
| hCreateIndex | The index of the data file is not copied. It is automatically recreated on the destination by re-indexing. | HCopyFile |
| hIncreasing | Sort performed in ascending order | SortType property |
| hEncryptionAES128 | Data file or connection encrypted only if a password is set on the data file. In this case, the data file is encrypted using a 128-bit AES algorithm with the Output Feedback (OFB) mode. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionAES128 | Data file or connection encrypted only if a password is set on the data file. In this case, the data file is encrypted using a 192-bit AES algorithm with the Output Feedback (OFB) mode. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hAES256 encryption | Data file or connection encrypted only if a password is set on the data file. In this case, the data file is encrypted using a 256-bit AES algorithm with the Output Feedback (OFB) mode. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionAuto | Data file encrypted only if a password is set on the data file. In this case, the data file is encrypted using an optimized 16-round RC5 algorithm with a 128-bit key. | FicEncryption property, MmoEncryption property, NdxEncryption property |
| hEncryptionNO | No encryption of data file or connection. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionRC5_12 | The data file is encrypted using an optimized 12-round RC5 algorithm with a 128-bit key. | FicEncryption property, MmoEncryption property, NdxEncryption property |
| hEncryptionRC5_16 | Encryption of the data file or connection using an optimized 128-bit, 16-loop RC5 encryption algorithm. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionStandard | Data file or connection encryption using an optimized 128-bit encryption algorithm. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hClientCursor | Cursor managed by MDAC. Generally, it offers more features than a server-side cursor. A client-side cursor is always static | HDescribeConnection,
HOpenConnection |
| hDynamicCursor | This cursor offers many features, but consumes a lot of memory. This cursor supports all types of scrolling. You can access all insert, update and delete operations made by other users. | HDescribeConnection,
HOpenConnection |
| hForwardOnlyCursor | This cursor is fast and consumes little memory. The cursor can only move forward and be scrolled from the first to the last record. Changes made by other users are not visible. | HDescribeConnection,
HOpenConnection |
| hReadOnlyCursor | The record set manipulated cannot be modified. | HDescribeConnection,
HOpenConnection |
| hOpenKeysetCursor | This cursor handles a fixed set of records. Only the key of each record is stored and not the actual record (consumes less memory). Deleted records cannot be accessed. Changes made by other users are visible (but added records are not). | HDescribeConnection,
HOpenConnection |
| hOptimisticCursor | The record is locked when it is updated | HDescribeConnection,
HOpenConnection |
| hPessimisticCursor | The record is locked as soon as it is edited. | HDescribeConnection,
HOpenConnection |
| hServerCursor | Cursor managed by the database. This cursor can easily reflect changes made to data by other users. | HDescribeConnection,
HOpenConnection |
| hStaticCursor | Makes a copy of all query records in memory (high memory consumption). All types of scrolling are supported. | HDescribeConnection,
HOpenConnection |
| hDaemonUser | Username that will be used by the server (Linux only) | HSetServer |
| hDate | Property of a database on an HFSQL server: Date of database creation. | HInfoDatabaseProperty, HInfoFileProperty |
| hDateLastRefresh | Requested information: Date of last successful refresh of materialized view. | HInfoView |
| hDBASCII | Sort according to ASCII order | HDBSortType |
| hDisconnection | Setting the logout 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 data files or analyses: Data files are searched only on disk. This is the most common case. | HChangeLocation,
HDeclare |
| hDistinct | Management of duplicates during browse: When browsing a key item, if there are duplicates, only one record is browsed | HForward, HReadPrevious,
HReadNext, HPrevious,
HBackward, HNext |
| hData | Data file management settings: All operations stored in the log file are applied to the existing file. | HRegenerateFile |
| hRightsInsert | Rights to add records to 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 change the integrity rules of 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 change 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 |
| hRightsCreateView | Rights to create an SQL view or a materialized view. | HInfoDatabaseRights,
HModifyDatabaseRights |
| hRightsDebug | Rights to debug stored procedures. | HInfoDatabaseRights,
HModifyDatabaseRights |
| hRightsDisconnectClient | Rights to disconnect client computers. | HInfoServerRights,
HModifyServerRights |
| hRightsUnmask | Rights to unmask a data file item. | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights,
HInfoItemRights
HModifyItemRights |
| 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 data file modification on a data 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 |
| hRightsServerReplication | Rights to set up and run 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 |
| hRightsDeleteView | Rights to delete an SQL view or a materialized view. | 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. Inherited rights are taken into account (for example, rights granted to the groups to which the user belongs). | HInfoDatabaseRights,
HInfoFileRights,
HInfoServerRights |
| hOnUpdate | Integrity rule applied during a modification | HSetIntegrity |
| hRecFile | Record to read: Value of the item currently stored in the data file | HErrorModification, HErrorStatusModification |
| hRecRead | Record to playback: Item value for original record | HErrorModification, HErrorStatusModification |
| hRecUser | Record to read: Value of the item for the current record at the time of modification | HErrorModification, HErrorStatusModification |
| hOnDelete | Integrity rule applied during a deletion | HSetIntegrity |
| heqaCanceled | Query completion procedure: The procedure executed for each record returned False. The query and the different procedures were canceled. | HExecuteQueryAsynchronous
HExecuteSQLQueryAsynchronous |
| heqaError | Query termination procedure: The query and/or the procedure called for each record have encountered an error. | HExecuteQueryAsynchronous
HExecuteSQLQueryAsynchronous |
| heqaOK | Query completion procedure: The query and the procedure executed for each record have been successfully completed. | HExecuteQueryAsynchronous
HExecuteSQLQueryAsynchronous |
| hErrDatabaseAccess | Configure the access errors to an HFSQL Client/Server database. | HOnError |
| hErrADO | Type of error information to be returned: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant. | HErrorInfo |
| hErrBase | Type of error information to be returned: Error code returned by database. The corresponding message is returned by the hErrBaseMessage constant | HErrorInfo |
| hErrLock | Customize blocking errors | HOnError |
| hErrCode | Type of error information to be returned: Number of the last error triggered by the HFSQL engine. | HErrorInfo |
| hErrSystemCode | Type of error information to be returned: Associated system error number | HErrorInfo |
| hErrFullDetails | Type of error information to be returned: All error information (error line, processing in progress, etc.)
Note: Returns the same information as that retrieved by clicking on the "Copy" button in the WLanguage error window. | HErrorInfo |
| hErrDuplicates | Customize duplicate errors | HOnError |
| hErrCurrent | Type of error information to be returned: Current error number | HError |
| hErrorLastRefresh | Requested information: Last error when refreshing materialized view. | HInfoView |
| hErrFIC | Type of error information to be returned: Full name of the data file associated with the error | HErrorInfo |
| hErrFile | Type of error information to be returned: Logical name of the data file associated with the error | HErrorInfo |
| hErrLockInfo | Type of error information to be returned: Blocking information | HErrorInfo |
| hErrClientInfo | Information about the client library used by the Native Connector that returned the error. | HErrorInfo |
| hErrDebugInfo | Type of error information to be returned: Information specific to debugging the problem encountered. | HErrorInfo |
| hErrServerInfo | Information about the server used by the Native Connector that returned the error. | HErrorInfo |
| hErrIntegrity | Integrity error customization | HOnError |
| hErrLink | Type of error information to be returned: Name of the link associated with the error | HErrorInfo |
| hErrFicList | Type of error information to be returned: List of HFSQL data files in error. | HErrorInfo |
| hErrMessage | Type of error information to be returned: Error message | HErrorInfo |
| hErrADOMessage | Type of error information to be returned: Message corresponding to the error returned by ADO (hErrADO) | HErrorInfo |
| hErrBaseMessage | Type of error information to be returned: Message corresponding to the error returned by the database (hErrBase) | HErrorInfo |
| hErrNativeMessage | Type of error information to be returned: Message corresponding to the error returned by the Native Connector provider. | HErrorInfo |
| hErrOLEDBMessage | Type of error information to be returned: Message corresponding to the error returned by the system during an OLEDB connection (hErrOLEDB) | HErrorInfo |
| hErrSystemMessage | Type of error information to be returned: Associated system error message | HErrorInfo |
| hErrMMO | Type of error information to be returned: 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 error information to be returned: Error code returned by the Native Connector or OLE DB provider used | HErrorInfo |
| hErrNDX | Type of error information to be returned: Full name of the index file associated with the error | HErrorInfo |
| hErrRecNum | Type of error information to be returned: Record number associated with the error | HErrorInfo |
| hErrOLEDB | Type of error information to be returned: Error code returned by the system when accessing an OLE DB connection. | HErrorInfo |
| hErrConnectionLoss | Defines how to handle errors caused by a loss of connection with the server. | HOnError |
| hErrPositionSQLError | Type of error information to be returned: Position of the SQL error in the SQL code of the query executed by the HExecuteSQLQuery function. | HErrorInfo |
| hErrMain | Type of error information to be returned: Main error number | HError |
| hErrIndex | Defines how to handle reindexing errors (reindexing in progress when accessing the data file) | HOnError |
| hErrItem | Type of error information to be returned: Name of item associated with the error | HErrorInfo |
| hErrServer | Type of error information to be returned: Name of the HFSQL Client/Server causing the error | HErrorInfo |
| hErrAll | Customize all errors | HOnError |
| hErrNeedValue | Defines how to handle errors caused by a required value that has not been specified (OLE DB only). | HOnError |
| hErrWDD | Type of error information to be returned: Full name of the analysis file associated with the error | HErrorInfo |
| hStateActive | Recording status/Type of recording taken into account: Active record | HState, hNbRec, HErrorStatusModification |
| hStateInvalid | Record status not found (error) | HState, HErrorStatusModification |
| hStateCrossed | Recording status/Type of recording taken into account: Scratched record | HState, hNbRec, HErrorStatusModification |
| hStateDel | Recording status/Type of recording taken into account: Record deleted | HState, hNbRec, HErrorStatusModification |
| hStateAll | Record type: total number of records in the data file | hNbRec |
New in version 2025hExecPlanningCancelled | Schedule execution status: Task execution has been cancelled. | |
New in version 2025hExecPlanningInProgress | Schedule execution status: Task execution in progress. | |
New in version 2025hExecPlanningError | Scheduler execution status: Task execution in error. | |
New in version 2025hExecPlanningTerminated | Schedule execution status: Task execution completed. | |
| hExisting | Search type: Only assignments for which a data file actually exists | HListREP |
| hExpCreation | Export file creation mode: If the export file exists, it is overwritten. | HExportXML
HExportJSON
HExportCSV
HExportXLS |
| hExpBreakable | Export file creation mode: Export can be aborted by pressing the Escape key on the keyboard.
If the export is interrupted, the export file is valid and it only contains the records exported before the interruption. | HExportXML
HExportJSON
HExportCSV
HExportXLS |
| hExpNormal | Export file creation mode: Normal operation | HExportXML
HExportJSON
HExportCSV
HExportXLS |
| hExpNoLineItemName | CSV/XLSX file creation mode: The first line of the generated file will not contain the field names. | HExportCSV
HExportXLS |
| hExpWithoutXSL | The style sheet (".XSL" file) is not created | HExportXML |
| hFalsifyTimestamp | Timestamp field management By default, a timestamp field contains the date and time of record creation/modification, calculated automatically.
This constant prevents the Timestamp field from being updated: the last value in the record will be retained. | HAdd, HModify |
| hFileAS400 | File type: AS 400 file | Type property |
| hFileOther | File type: Other file | Type property |
| hFileClientServer | File type: Client/Server HFSQL file | Type property |
| hFileHF5 | File type: Hyper File 5 file | Type property |
| hFileMySQL | File type: MySQL file | Type property |
| hFileNormal | File type: Normal file (HFSQL Classic) | Type property |
| hFileOLEDB | File type: OLEDB file | Type property |
| hFileOracle | File type: ORACLE file | Type property |
| hFileOracleLite | File type: ORACLE Lite file | Type property |
| hFilePostgreSQL | File type: PostgreSQL file | Type property |
| hFileProgress | File type: Progress file | Type property |
| hFileQuery | File type: Request | Type property |
| hFileQueryAS400 | File type: AS/400 database query | Type property |
| hFileQueryClientServer | File type: HFSQL Client/Server database query | Type property |
| hFileQueryMySQL | File type: MySQL database query | Type property |
| hFileQueryOLEDB | File type: Query on a database accessed by an OLE DB provider | Type property |
| hFileQueryOracle | File type: Oracle database query | Type property |
| hFileQueryOracleLite | File type: Oracle Lite database query | Type property |
| hFileQueryPostgreSQL | File type: PostgreSQL database query | Type property |
| hFileQueryProgress | File type: Progress database query | Type property |
| hFileQuerySQLAzure | File type: SQL Azure database query | Type property |
| hFileQuerySQLServer | File type: SQL Server database query | Type property |
| hFileQuerySQLServerMobile | File type: SQL Server Mobile database query | Type property |
| hFileQuerySybase | File type: Sybase database query | Type property |
| hFileQueryXML | File type: XML database query | Type property |
| hFileSQL | File type: SQL file | Type property |
| hFileSQLAzure | File type: Azure SQL file | Type property |
| hFileSQLite | File type: SQLite file | Type property |
| hFileSQLServer | File type: SQL Server file | Type property |
| hFileSQLServerMobile | File type: SQL Server Mobile file | Type property |
| hFileSybase | File type: Sybase file | Type property |
| hFileTemporary | File type: Temporary file | Type property |
| hFileView | File type: HFSQL view | Type property |
| hFileXBase | File type: xBase file | Type property |
| hFileXML | File type: XML file | Type property |
| hSetIDAuto | Automatic ID calculation mode: ID value equal to that memorized at the time of addition | HAdd, HWrite, HModify |
| hSetIDAuto | Automatic ID calculation mode: ID value equal to that stored at time of writing | HAdd, HWrite, HModify |
| hANSIFormat | Data format: Ansi format (used by Windows) | Format property |
| hUnicodeFormat | Data format: UNICODE format | Format property |
| hForwardOnly | Native Connectors only: Allows looping through records faster. | HReadLast,
HReadFirst,
HReadSeekFirst,
HReadSeekLast |
| hftPunctuationSimple | Full-text index section programmatically described: simple punctuation characters (non-Unicode) taken into account. | Option property of FullTextIndex Description variables. |
| hftPunctuationUnicode | Full-text index section programmatically described: Unicode punctuation characters taken into account. | Option property of FullTextIndex Description variables. |
| hFTX | Reindexing full-text indexes | |
| HGeneric | Search type: Generic search | HReadSeekLast,
HReadSeekFirst,
HSeekLast,
HSeekFirst |
| hHCreateIfNotFound | Type of test to be performed to verify connection: Verifies connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only. In previous versions, this constant was called hHCreationIfNotFound. | HConnect |
| hInherit | The user will inherit the right granted to the group to which they belong | HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights |
| hHOpen | Type of test to be performed to verify the connection: Verifies the connection by opening a file. This value is used by default when accessing a HOLecture 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 | Import type: associated fields do not have the same type or size: data extracted from the imported file is automatically converted or truncated. | HImportHF55 |
| hImpCreation | Import type: If the import file (HFSQL Classic) exists, it is overwritten. | HImportHF55,
HImportText,
HImportXLS,
HImportXML,
HImportJSON |
| hImpIgnoreInvalidLine | Import type: Lines with an invalid structure are not imported: import continues on subsequent lines. The structure is invalid if data is missing for one or more items, or if string separators are missing. | HImportText,
HImportXLS |
| hImpIgnoreFirstLine | Import type: The first line of the imported file is ignored. | HImportText,
HImportXLS |
| hImpIgnoreItem | Type of import:- Fields in the import file (HFSQL Classic) that have no associated fields 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 populated in the text file, the corresponding lines are still imported.
The missing items contain:- the default value of the items if the hDefaultVal constant is specified.
- the value of items in the current record before the call to HImportText.
| HImportText,
HImportXLS |
| hImpBreakable | The import can be interrupted by pressing ESC. | HImportHF55,
HImportText,
HImportXLS,
HImportXML,
HImportJSON |
| hImpNormal | Import type: Import is not performed and an error is generated in the following cases:- fields present in the Hyper File 5.5 file but not in the HFSQL Classic file.
- associated items in the two files but with a different size and/or format.
| HImportHF55,
HImportText,
HImportXLS,
HImportXML,
HImportJSON |
| hImpOEM2ANSI | Import type: OEM to ANSI conversion of imported strings. This constant is available for backward compatibility. | HImportText |
| hImpNoDelimiter | Import type: String separators, if any, are part of the | HImportText |
| hImpNoSpace | Import type: Spaces at the end of strings are automatically removed during import | HImportHF55 |
| hImpTestDuplicates | Import type: Checks for duplicates when importing | HImportHF55,
HImportText,
HImportXLS |
| hImpTestIntegrity | Import type: Tests import integrity | HImportHF55,
HImportText,
|
| hInaccessible | Undefined server status | HServerStatus |
New in SaaShIndexCorrupt | Index check detected that index was corrupted. | |
| hInfoCluster | Information about the HFSQL cluster. | HInfoServer |
| hInfoDate | Date and time of server on 8 bytes in UTC format (universal time) | HInfoServer |
| hInfoFreeSpaceDisk | Available space on the server disk, expressed in MB. | HInfoServer |
| hInfoSpaceTotalDisk | 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 |
| 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 prohibited | 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 | Set the file to be recreated: Only the file <Nom du fichier>JNL.FIC is recreated. | HLogRecreate |
| hLogIdentification | Set the file to be re-created: Recreates the "JournalIdentification.fic" file. | HLogRecreate |
| hLogWriting | Logging format: logging of write operations performed on the file | Logging property |
| hLogReadingWriting | Logging format: logging of read and write operations performed in the file. | Logging property |
| hLogNo | Logging format: No logging | Logging |
| hJournalOperation | Set the file to be re-created: Recreates the file "JournalOpération.fic". | HLogRecreate |
| hLogUser | Set the file to be re-created: Recreates the user log "JournalUtilisateur.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 |
| 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 |
| 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 |
| hServerLanguage | Language of the HFSQL server. | HSetServer |
| 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 |
| 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 file browsing: browsing will stop as soon as the last searched value is found. | HReadSeek, HReadSeekLast, HReadSeekFirst, HSeek, HSeekLast, HSeekFirst |
| hlpCalcStat | Type of operation performed on the server: calculation of statistics. | hServerOperation type |
| hlpKeyDetection | Type of operation performed on the server: key detection. | hServerOperation type |
| hlpOptimization | Scheduler type: File optimization tasks (reindexing, statistics calculation). | |
| hlpReplication | Type of operation performed on the server: server replication. | hServerOperation type |
| hlpBackup | Planning type: Backup planning. | |
New in version 2025hlpCompleteSave | Schedule type: Full backup schedule. | |
New in version 2025hlpDifferentialBackup | Schedule type: Scheduling of differential Backups. | |
| hlpTask | Scheduler type: Scheduled tasks executing a stored procedure. | |
| hlpMaterializedView | Scheduler type: Refresh tasks for materialized views. | |
| hLstKey | Lists the key items | HListKey, HListItem |
| hLstCompositeKey | Lists the composite key items only | HListKey, HListItem |
| hLstSet | Lists the sets of procedures located 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 located on a server
- Lists the queries that have been run.
| |
| 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 |
| 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.
- List the SQL views on an HFSQL server.
| HListFile |
| hLstMaterializedView | Lists the materialized views located on an HFSQL server. | HListFile |
| hComputer | Property of a database on an HFSQL server: Name of the workstation 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 memo: Any binary file | HLinkMemo |
New in SaaShMemoCorrupt | Memo check detected that the memo was corrupted. | |
| hMemoImg | Type of file used for memo: Image file | HLinkMemo |
| hMemoNo | No management of memos | HSetMemo |
| hMemoOle | Type of file used for 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 memo: sound file | HLinkMemo |
| hMessage | Information message settings | HOnServerCall |
| hMode2GB | Indicates whether system files support more than 2 GB | HSetServer |
| 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 the result of the query is modified, these modifications will be transferred to the files contributing to the query.
If this option is not specified, only the query result is modified. | HExecuteQuery, HExecuteSQLQuery |
| hmsNormal | Standard operating mode of the automatic data modification. | HModifyStructure |
New in version 2025hmsSavegardeJournal | Prior to automation, log files are saved and then deleted. | HModifyStructure |
| hmsNoCheck | The automatic data modification is performed even if the file description is more recent than the analysis description. | HModifyStructure |
| hmsBackgroundTask | A hot automatic modification is performed (available for the HFSQL Client/Server data files only). | HModifyStructure |
| hNdxCompact | Reindexing with compression | HIndex
|
| hNdxMinimal | Reindex and ignore corrupted keys | HIndex
|
| hNdxSilent | Re-indexing settings: No display during re-indexing | 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 |
| hNumberMaxConnexion | 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 a heading: Non-key heading | KeyType property |
| hNotReplicated | Replication mode: The data file is not designed for replication.. To implement the replication, check "Replication" in the characteristics of the file in the data model editor. | Replication property |
| hNotSorted | Sort direction: unsorted item | SortType property |
| hNotes | Property of a database on an HFSQL server: Description of the database or any other information associated with the database using the HModifyDatabaseProperty function. | HInfoDatabaseProperty, HInfoFileProperty, HInfoServerProperty, HModifyDatabaseProperty, HModifyFileProperty, HModifyServerProperty |
| hNotifWarning | The notifications will be sent from the warning level (for the warning, critical and error problems). | HNotifAddCCRecipient, HNotifAddEmailRecipient |
| hNotifCCClassic | The notifications are sent by the Control Centers in HFSQL Classic mode. | HNotifConfigure |
| hNotifCCCS | The notifications are sent by the Control Centers in Client/Server mode. | HNotifConfigure |
| hNotifCritical | The notifications will be sent from the critical level (for the critical and error problems). | HNotifAddCCRecipient, HNotifAddEmailRecipient |
| hNotifEmail | The notifications are sent by email. | HNotifConfigure |
| hNotifError | The notifications will be sent for the error problems only. | HNotifAddCCRecipient, HNotifAddEmailRecipient |
| 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 no logging is in progress or if the specified file corresponds to a multi-file query. | HRecNum |
| hRecNumAll | - Used to track all records found in a data file.
- Used to check all unaltered records
| |
| hODBC | OLE DB provider to 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 to be used for the connection: OLE DB provider for Access 97 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbAccess2000 | OLE DB provider to be used for the connection: OLE DB provider for Access 2000 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbAccess2007 | OLE DB provider to be used for the connection: OLE DB provider for Access 2007 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbAccess2010 | OLE DB provider to be used for the connection: OLE DB provider for Access 2010 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbDBase5 | OLE DB provider to be used for the connection: OLE DB provider for dBase 5 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbExcel2000 | OLE DB provider to be used for the connection: OLE DB provider for Excel 2000 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbExcel2007 | OLE DB provider to be used for the connection: OLE DB provider for Excel 2007 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbExcel97 | OLE DB provider to be used for the connection: OLE DB provider for Excel 97 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbLotus4 | OLE DB provider to be used for the connection: OLE DB provider for Lotus 4 | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbOracle | OLE DB provider to be used for the connection: OLE DB provider for Oracle | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOledbSQLServer | OLE DB provider to be used for the connection: OLE DB provider for SQL Server | CtOLEDBProvider property, CtDescribedOLEDBProvider property,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect |
| hOptIndex | - Optimization option: causes data files to be reindexed. A hot re-indexing operation is performed on the indexes and on the full-text indexes.
| hFileParameter variable
|
| hOptStat | - Optimization option: Recalculates data file statistics.
| hFileParameter variable
|
New in SaaShOptVerifyIndex | Type of optimization performed: Index verification. | |
New in SaaShOptVerifyMemo | Optimization option: Memo checking. | |
| hDelayedOpening | Optimized opening of existing files: If the file already exists, it will only be opened the first time the file is accessed. The file is created if it does not exist. | HCreationIfNotFound |
| 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 | Ownership of a database on an HFSQL server: Database owner. | HInfoDatabaseProperty, HInfoFileProperty, HModifyDatabaseProperty, HModifyFileProperty |
| hRefreshInProgress | Requested information: Is the materialized view being refreshed? | HInfoView |
| hReadCommitted | Transaction isolation level: only finalized transactions are visible to other users. | HTransactionIsolation |
| hReadUncommitted | Transaction isolation level: unfinalized transactions are visible to other users. | HTransactionIsolation |
| hRecalculateIDAuto | Automatic identifier calculation mode: Automatic identifier re-calculated on posting. | HWrite, HModify, HSave |
| hFindKey | Enable the search for keys on the HFSQL server. | HSetServer |
New in SaaShReindexingWaiting | Current optimization status: Optimization/reindexing has not yet begun. | |
New in SaaSHReindexingInProgress | Current optimization status: Optimization/reindexing in progress. | |
New in SaaShReindexingError | Current optimization status: Optimization/reindexing is in error. | |
New in SaaShFinished indexation | Current optimization status: Optimization/reindexing is complete. | |
| hRepeatableRead | Transaction isolation level: the application in transaction sees a snapshot of the database at the moment the transaction starts. | HTransactionIsolation |
| hSubscriberReplica | Replication mode: The data file is a subscriber replica (function HCreateSubscriberReplica was used to create the subscriber replica). | Replication property |
| hMasterReplica | Replication mode: The data file is a master replica (function HCreateMasterReplica was used to create the master replica). | Replication property |
| hReplicated | Replication mode: The data file is configured for replication. | 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 data files in a format that completes items with space characters and HFSQL data files in a format that does not complete items with space characters. | HExecuteQuery, HExecuteSQLQuery |
| 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 optimized search key for the filter.
Warning: in this case, on large files, performance problems may arise. | HChangeKey, HLast, HReadLast, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadSeek, HFirst, HSeek, HSeekLast, HSeekFirst |
| hRPKeep | Restoration settings: Position not released | HRestorePosition |
| hRPDefault | Restoration settings: Released position. The stored position is restored | HRestorePosition |
| hRPFilter | Restoration settings: Restore filter set at time of HSavePosition | HRestorePosition |
| hRPHF5 | Restore settings: If the saved position has been deleted or modified, this position is restored. | HRestorePosition |
| hrsCopy | Set replication between servers: enable initial copy of replicated items from the connection server (master server) to the other server (publisher server, defined in variable type hRSConfig). This copy is locking. | HRSAddConfig |
| hrsCopyBackgroundTask | Set replication between servers: enable initial copy of replicated items from the connection server (master server) to the other server (publisher server, defined in variable type hRSConfig). This copy is performed in background task and it is not locking. | HRSAddConfig |
| hrsNoCopy | Inter-server replication settings: No copies are made. | HRSAddConfig |
| hItemBinary | Type of heading: Binary | Type property |
| hItemBoolean | Type of field: Boolean | Type property |
| hItemCharacter | Type of field: Character | Type property |
| hItemCombination | Type of item: Combination | Type property |
| hItemDate6 | Type of item: Date | Type property |
| hItemDate8 | Type of item: Date | Type property |
| hItemDateTime | Type of field: Date/Time | Type property |
| hItemTimeLength | Type of item: Duration | Type property |
| hItemInteger1 | Field type: 1-byte integer | Type property |
| hItemInteger2 | Field type: 2-byte integer | Type property |
| hItemInteger4 | Field type: 4-byte integer | Type property |
| hItemInteger8 | Field type: 8-byte integer | Type property |
| hItemUnsignedInteger1 | Field type: 1-byte unsigned integer | Type property |
| hItemUnsignedInteger2 | Field type: 2-byte unsigned integer | Type property |
| hItemUnsignedInteger4 | Field type: 4-byte unsigned integer | Type property |
| hItemUnsignedInteger8 | Field type: 4-byte unsigned integer | Type property |
| hItemEnumeration | Type of heading: Enumeration | Type property |
| hItemHour | Type of heading: Time | Type property |
| hItemIDAuto | Field type: Automation identifier (8 bytes) | Type property |
| hItemIDAuto4 | Type of item: Automation identifier (4 bytes) | Type property |
| hItemPicture | Type of section: Image | Type property |
| hItemInvalid | Invalid type of item | Type property |
| hRubJSON | Type of field: JSON | Type property |
| hItemBinaryMemo | Type of item: Binary memo | Type property |
| hItemBinaryMemo4 | Type of item: Binary memo (4 bytes) | Type property |
| hItemTextMemo | Type of heading: Text memo | Type property |
| hItemUnicodeMemo | Topic type: Unicode text memo | Type property |
| hItemCurrency | Type of heading: Monetary | Type property |
| hRubSecurePassword | Type of field: Password | Type property |
| hItemNumRec | Type of item: Registration number | Type property |
| hItemNumeric | Type of item: High-precision digital | Type property |
| hItemReal4 | Type of item: Real 4 bytes | Type property |
| hItemReal8 | Type of item: Real 8 bytes | Type property |
| hItemRealTurbo | Type of item: Real turbo | Type property |
| hItemText | Type of heading: Text | Type property |
| hItemUnicodeText | Type of field: Unicode text | Type property |
| hItemUUID128 | Type of field: UUID 128 | Type property |
| hItemUUID128Auto | Type of field: Automatic identifier UUID 128 | Type property |
| hItemUUID256 | Type of field: UUID 256 | Type property |
| hItemUUID256Auto | Type of item: Automatic identifier UUID 256 | Type property |
| hwAdd | Monitors the operations for adding records. New in version 2025In previous versions, this constant corresponds to hsAdd. | HWatch |
| hwModify | Monitors the operations for modifying records. New in version 2025In previous versions, this constant corresponds to hsModification. | HWatch |
| hwCross | Monitors the operations for crossing records. New in version 2025In previous versions, this constant corresponds to hsCross. | HWatch |
| hwDelete | Monitors the operations for deleting records. New in version 2025In previous versions, this constant corresponds to hsDeletion. | HWatch |
| NoWait | Refreshing the materialized view is not blocking: it takes place in the background. The HInfoView function is used to find out the result of refreshing the materialized view. | 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 | Integrity management: links are not updated on the server (creation, modification, deletion as the case may be).
Remember: by default, when a file is created, links are updated on the server. | HCreation, HCreationIfNotFound |
| hNoRefresh | The table or query content will not be refreshed | HLast, HReadLast, HReadFirst, HFirst |
| 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 |
| hSKSimplified | Configures the message returned by HSuggestKey. | HSuggestKey |
| hSDX | Reindex spatial indexes | HIndex
|
| 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 last sub-error | HError |
| hSubErrPrevious | Type of error returned: Number of previous sub-error | HError |
| hSubErrFirst | Type of error returned: Number of first sub-error | HError |
| hSubErrNext | Type of error returned: Number of 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 | File management settings: New empty file created from file description | HRegenerateFile |
| hNoError | No error occurred | HError |
| hDeleteLog | Deletes the log file | HDeleteFile,
HDeleteDatabase |
| hBackupCanceled | Backup status: Backup canceled | HInfoBackup |
New in version 2025hSvgAnonymizedAboutRights | Backup data is anonymized according to the rights of the user performing the backup. | hBackupDescription variable |
New in version 2025hSvgNonAnonymized | The fields are not anonymized in the backup only if the administrator performs the backup. In all other cases, the backup fails. | hBackupDescription variable |
New in version 2025hSvgAllAnonymized | Whatever the rights of the user making the backup, anonymized fields remain anonymized in the backup. | hBackupDescription variable |
| hBackupFull | Backup type: Full backup | HInfoBackup |
| hBackupDifferential | Backup type: differential backup | HInfoBackup |
| hBackupInProgress | Backup status: Backup in progress | HInfoBackup |
| hBackupError | Backup status: Backup error | HInfoBackup |
| hBackupCompleted | Backup status: Backup complete | HInfoBackup |
| hBackgroundTask | Execute process in the background, without locking the data file (available for data files in Client/Server mode). | HStatCalculate,
HIndex
|
| hWindowsDiskCacheSize | Mode for managing the size of Windows disk cache. | HSetServer |
| hNdxCacheSize | Maximum size in megabytes (MB) of index cache | HSetServer |
| hFtxSize | Full-text index file (".Ftx") size in bytes | HInfoFile |
| hFicSize | Data file (".Fic") size in bytes | HInfoFile |
New in version 2025hMaxSizeHistoryPlanning | Maximum number of executions to be kept in the scheduled execution history. | HSetServer |
| hMaxLogSize | Maximum size in megabytes (MB) of log files | HSetServer |
| hMaxActivityStatisticsSize | Maximum size in megabytes (MB) of files for activity statistics | HSetServer |
| hMmoSize | Memo file (".Mmo") size in bytes | HInfoFile |
| hNdxSize | Index file (".Ndx") size in bytes | HInfoFile |
| 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 |
| hSdxSize | Spatial index file (".Sdx") size in bytes | HInfoFile |
| hTotalSize | Total file size in bytes (added size of data file, memo file and index file). | HInfoFile |
| 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 |
| hSecondaryThread | Procedure execution option: the procedure is executed in a secondary thread. | HOnServerCall
HWatch |
| 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 executed before the HFSQL function | HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger |
| hTriggerAfter | Indicates the type of trigger: The procedure is executed after the HFSQL function | HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger |
New in version 2025htrgHAjoute | The function that triggered the trigger is HAdd. | Variable H.FunctionTriggerNumber (see HDescribeTrigger and HDescribeServerTrigger). |
New in version 2025htrgHEcrit | The function that triggered the trigger is HWrite. | Variable H.FunctionTriggerNumber (see HDescribeTrigger and HDescribeServerTrigger). |
New in version 2025htrgHModifies | The function that triggered the trigger is HModify. | Variable H.FunctionTriggerNumber (see HDescribeTrigger and HDescribeServerTrigger). |
New in version 2025htrgHRaye | The function that triggered the trigger is HCross. | Variable H.FunctionTriggerNumber (see HDescribeTrigger and HDescribeServerTrigger). |
New in version 2025htrgHSuppresses | The function that triggered the trigger is HDelete. | Variable H.FunctionTriggerNumber (see HDescribeTrigger and HDescribeServerTrigger). |
| hTriggerAfter | Indicates the type of trigger: The procedure is executed after the HFSQL function | HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger |
| htsNone | Field timestamp type: the field is not a timestamp field. | TimestampType property |
| htsCreation | Field timestamp type: the field will store the record creation date. | TimestampType property |
| htsLastModification | Field timestamp type: the field will store the last modification date of 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,
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 | Creation of view with addition: Keeps the contents of the view the next time the HExecuteView function 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 lines between the two specified views | HMergeView |
| hViewJoin | Join between the first view and the second view. | HMergeView |
| hViewSubtraction | Merge views with subtraction: Line of 1st view without common lines of second view | HMergeView |
| hViewUnion | View union: union of lines from two specified views | HMergeView |
| hViewUnionEx | Exclusive union of views: Union of lines not shared by 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 |
| MDPS_PBKDF2 | Key derivation function used to hash a "Password" field: The PBKDF2 algorithm is used. | spDerivation property |
| MDPS_SHA2_256 | Algorithm used to salt a "Password" type field: The SHA 256 algorithm is used. | spHash property |
| MDPS_SHA2_512 | Algorithm used to salt a "Password" type field: The SHA 512 algorithm is used. | spHash property |
| MDPS_SHA3_256 | Algorithm used to salt a "Password" type field: The SHA-3 256 algorithm is used. | spHash property |
| MDPS_SHA3_512 | Algorithm used to salt a "Password" type field: The SHA-3 512 algorithm is used. | 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 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 |