| | |
| 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 simulate: 3G | HSimulateNetwork |
 New in version 28h4G | Type of network to simulate: 4G | HSimulateNetwork |
New in version 28h5G | Type of network to simulate: 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 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 |
| 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 |
| 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 |
| 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 |
| hActiveDirectory | Enable the authentication via Active Directory. | HSetServer |
| 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 |
| 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 |
| hCacheNbUnusedFiles | Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server. | HSetServer |
| 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 |
New in version 28hPrimaryKey | Characteristics of an item: Primary key | KeyType property |
| hUniqueKey | Characteristics of an item: Unique key | KeyType property |
New in version 28hCloud | Type of network to simulate: Cloud | HSimulateNetwork |
| hSQLCode | Requested information: SQL code of the 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 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,
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 |
| hEncryptionAES128 | The file or connection is encrypted only if the file is password-protected. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB). | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionAES128 | The file or connection is encrypted only if the file is password-protected. In this case, the file is encrypted using a 192-bit AES algorithm with Output feedback (OFB). | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionAES256 | The file or connection is encrypted only if the file is password-protected. In this case, the file is encrypted using a 256-bit AES algorithm with Output feedback (OFB). | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionAuto | The file is encrypted only if it is password-protected. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits). | FicEncryption property, MmoEncryption property, NdxEncryption property |
| hEncryptionNO | The file or connection is not encrypted. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionRC5_12 | The file is encrypted using an optimized 12-round RC5 encryption algorithm (128 bits). | FicEncryption property, MmoEncryption property, NdxEncryption property |
| hEncryptionRC5_16 | The file or connection is encrypted using an optimized 16-round RC5 encryption algorithm (128 bits). | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property |
| hEncryptionStandard | The file or connection is encrypted using an optimized 128-bit encryption algorithm. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption 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 |
| hDateLastRefresh | Requested information: Date of the last successful refresh for the materialized view. | 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 | Manages duplicates during the iteration: 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 |
| 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 |
| 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 |
| hRightsDeleteView | Rights to delete a 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. 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 |
| 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. | HExecuteQueryAsynchronous
HExecuteSQLQueryAsynchronous |
| heqaError | Procedure for the end of the execution of the query: The query and/or the procedure called for each record encountered an error. | HExecuteQueryAsynchronous
HExecuteSQLQueryAsynchronous |
| heqaOK | Procedure for the end of the execution of the query: The query and the procedure were correctly executed for each record. | HExecuteQueryAsynchronous
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 | Defines how to handle lock errors | HOnError |
| 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 | Defines how to handle duplicate errors | HOnError |
| hErrCurrent | Type of information about the error to return: Number of the current error | HError |
| hErrorLastRefresh | Requested information: Last error while refreshing the materialized view. | 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 library 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 | Defines how to handle integrity errors | HOnError |
| hErrLink | Type of information about the error to return: Name of the link associated with the error | HErrorInfo |
| 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 | Defines how to handle modification conflicts | HOnError |
| hErrPassword | Defines how to handle 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 | Defines how to handle errors caused by a loss of connection with the server. | HOnError |
| 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 | Defines how to handle 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 | Defines how to handle all the 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 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
HExportJSON
HExportCSV
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
HExportJSON
HExportCSV
HExportXLS |
| hExpNormal | Mode for creating the export file: Standard operating mode | HExportXML
HExportJSON
HExportCSV
HExportXLS |
| hExpNoLineItemName | Mode for creating the CSV/XLSX file: The first line of the generated file will not contain the names of the items. | HExportCSV
HExportXLS |
| hExpWithoutXSL | The style sheet (".XSL" file) is not created | HExportXML |
| 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 |
| 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 |
| hFileQueryPostgreSQL | Type of file: Query on a PostgreSQL database | Type property |
| hFileQueryProgress | Type of file: Query on a Progress database | Type property |
| 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 |
| hFileSQLAzure | Type of file: SQL Azure file | Type property |
| 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 |
| hForwardOnly | Native Connectors only: Allows looping through records faster. | HReadLast,
HReadFirst,
HReadSeekFirst,
HReadSeekLast |
| hftPunctuationSimple | Full-text Index item described programmatically: Taking into account the simple punctuation characters (non Unicode). | Option property of FullTextIndex Description variables. |
| 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,
HImportXLS,
HImportXML
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,
HImportXLS |
| hImpIgnoreFirstLine | Type of import: The first row of the imported file is ignored. | HImportText,
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,
HImportXLS |
| hImpBreakable | The import can be interrupted by pressing ESC. | HImportHF55,
HImportText,
HImportXLS,
HImportXML
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,
HImportXLS,
HImportXML
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,
HImportXLS |
| hImpTestIntegrity | Type of import: Checks the integrity during the import | HImportHF55,
HImportText,
|
| hInaccessible | Undefined server status | HServerStatus |
| hInfoCluster | Information about the HFSQL cluster. | HInfoServer |
| hInfoDate | Date and time of server on 8 bytes in UTC format (universal time) | HInfoServer |
| hInfoFreeDiskSpace | Available space on the server disk, expressed in MB. | HInfoServer |
| 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 |
| 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 |
| 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 |
| 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 the file browse: The browse will stop as soon as the last sought value is found. | HReadSeek, HReadSeekLast, HReadSeekFirst, HSeek, HSeekLast, HSeekFirst |
| hlpCalcStat | Type of operation performed on the server: statistical calculation. | hServerOperation type |
| hlpKeyDetection | Type of operation performed on the server: detection of keys. | hServerOperation type |
| hlpOptimization | Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation). | |
| hlpReplication | Type of operation performed on the server: server replication. | hServerOperation type |
| hlpBackup | Type of scheduling to list: Scheduling of backups. | |
| hlpTask | Type of scheduling to list: Scheduled tasks that run a stored procedure. | |
| hlpMaterializedView | Type of scheduling to list: Tasks for refreshing the materialized views. | |
| 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
- 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 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 |
| 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 |
| hmsNormal | Standard operating mode of the automatic data modification. | 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 | Configures the reindexing operation: No display during the reindexing operation | 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 |
| 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 |
| 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 there is no current record 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 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| hRefreshInProgress | Requested information: Is the materialized view currently refreshed? | HInfoView |
| hReadCommitted | Isolation level of transaction: other users can only view completed transactions. | HTransactionIsolation |
| hReadUncommitted | Isolation level of transaction: other users can view incomplete transactions. | HTransactionIsolation |
| hRecalculateIDAuto | Mode for calculating the automatic identifier: Automatic identifier re-calculated during the write operation | HWrite, HModify, HSave |
| hFindKey | Enable the search for keys on the HFSQL server. | HSetServer |
| hRepeatableRead | Isolation level of transaction: the application in transaction sees a snapshot of the database when the transaction starts. | 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 |
| 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 |
| 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 |
| 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 |
| hrsNoCopy | Configure the replication between servers: No copy is performed. | HRSAddConfig |
| hItemBinary | Type of item: Binary | Type property |
| hItemBoolean | Type of item: Boolean | Type property |
| hItemCharacter | Type of item: 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 item: Date/Time | Type property |
| hItemTimeLength | Type of item: Duration | Type property |
| hItemInteger1 | Type of item: 1-byte integer | Type property |
| hItemInteger2 | Type of item: 2-byte integer | Type property |
| hItemInteger4 | Type of item: 4-byte integer | Type property |
| hItemInteger8 | Type of item: 8-byte integer | Type property |
| hItemUnsignedInteger1 | Type of item: Unsigned 1-byte integer | Type property |
| hItemUnsignedInteger2 | Type of item: Unsigned 2-byte integer | Type property |
| hItemUnsignedInteger4 | Type of item: Unsigned 4-byte integer | Type property |
| hItemUnsignedInteger8 | Type of item: Unsigned 4-byte integer | Type property |
| hItemEnumeration | Type of item: Enumeration | Type property |
| hItemHour | Type of item: Time | Type property |
| hItemIDAuto | Type of item: Automatic identifier (8 bytes) | Type property |
| hItemIDAuto4 | Type of item: Automatic identifier (4 bytes) | Type property |
| hItemPicture | Type of item: Image | Type property |
| hItemInvalid | Invalid type of item | Type property |
| hItemJSON | Type of item: JSON | Type property |
| hItemBinaryMemo | Type of item: Binary memo | Type property |
| hItemBinaryMemo4 | Type of item: Binary memo (4 bytes) | Type property |
| hItemTextMemo | Type of item: Text memo | Type property |
| hItemUnicodeMemo | Type of item: Unicode text memo | Type property |
| hItemCurrency | Type of item: Currency | Type property |
| hItemSecurePassword | Type of item: Password | Type property |
| hItemNumRec | Type of item: Record number | Type property |
| hItemNumeric | Type of item: High-precision numeric | Type property |
| hItemReal4 | Type of item: 4-byte real | Type property |
| hItemReal8 | Type of item: 8-byte real | Type property |
| hItemRealTurbo | Type of item: Turbo real | Type property |
| hItemText | Type of item: Text | Type property |
| hItemUnicodeText | Type of item: Unicode text | Type property |
| hItemUUID128 | Type of item: UUID 128 | Type property |
| hItemUUID128Auto | Type of item: UUID 128 automatic identifier | Type property |
| hItemUUID256 | Type of item: UUID 256 | Type property |
| hItemUUID256Auto | Type of item: UUID 256 automatic identifier | Type property |
| hsAdd | Monitors the operations for adding records. | HTrack |
| hsModification | Monitors the operations for modifying records. | HTrack |
| hsCross | Monitors the operations for crossing records. | HTrack |
| hsDeletion | Monitors the operations for deleting records. | HTrack |
| 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. | 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 |
| 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 |
New in version 28hSKSimplified | Configures the message returned by HSuggestKey. | HSuggestKey |
| 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 |
| hBackupFull | Type of backup: Full backup | HInfoBackup |
| 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 |
| 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 | 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 |
| 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 |
| 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 | Option for running the procedure: the procedure is run in a secondary thread. | HOnServerCall
HTrack |
| 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 |
| htsNone | Type ot timestamp for the item: the item is not a timestamp item. | TimestampType property |
| htsCreation | Type ot timestamp for the item: the item will store the creation date of record. | TimestampType property |
| 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,
|
| 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 |
| SP_PBKDF2 | Key derivation function used to hash an item of type "Password": Password-Based Key Derivation Function 2 (PBKDF2) is used. | spDerivation property |
| SP_SHA2_256 | Algorithm used for salting an item of type "Password": Secure Hash Algorithm 256 (SHA-256) is used. | spHash property |
| SP_SHA2_512 | Algorithm used for salting an item of type "Password": Secure Hash Algorithm 512 (SHA-512) is used. | spHash property |
| SP_SHA3_256 | Algorithm used for salting an item of type "Password": Secure Hash Algorithm 3-256 (SHA-3 256) is used. | spHash property |
| SP_SHA3_512 | Algorithm used for salting an item of type "Password": Secure Hash Algorithm 3-512 (SHA-3 512) 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 <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 |