Display only constants used by prefix syntaxesThe following constants are used to manipulate HFSQL data files: | | | | Constant | Description | Functions/Properties |
|---|
| eltSetOfProcedures | The listed element is a set of procedures | HListStoredElement | | eltProcedure | The listed element is a stored procedure | HListStoredElement | | eltQuery | The listed element is a query. | HListStoredElement | | h3G | Type of network to simulate: 3G | HSimulateNetwork | | h4G | Type of network to simulate: 4G | HSimulateNetwork | | h5G | 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 (provided 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 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, 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 | | hBackupPath | Path of the directory containing the backups. | HSetServer | | hActivityStatisticsPath | Path of the directory containing the activity statistics | HSetServer | | hDuplicateKey | Characteristics of an item: Key with duplicates | KeyType property | | hPrimaryKey | Characteristics of an item: Primary key | KeyType property | | hUniqueKey | Characteristics of an item: Unique key | KeyType property | | hCloud | 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 recreated 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 algorithm with a 128-bit key. | FicEncryption property, MmoEncryption property, NdxEncryption property | | hEncryptionRC5_16 | The file or connection is encrypted using an optimized 16-round RC5 algorithm with a 128-bit key. | Encryption property
FicEncryption property,
MmoEncryption property,
NdxEncryption property | | hEncryptionStandard | The file or connection is encrypted using an optimized 128-bit 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 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 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 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 | | 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 run automatic data modification 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. 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 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 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 | Reindex 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 the right granted to the group to which they belong | 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 | | 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 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 reindex operation: No display during the reindex 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 | Item type: Binary | Type property | | hItemBoolean | Item type: Boolean | Type property | | hItemCharacter | Item type: Character | Type property | | hItemCombination | Item type: Combination | Type property | | hItemDate6 | Item type: Date | Type property | | hItemDate8 | Item type: Date | Type property | | hItemDateTime | Item type: Date/Time | Type property | | hItemTimeLength | Item type: Duration | Type property | | hItemInteger1 | Item type: 1-byte integer | Type property | | hItemInteger2 | Item type: 2-byte integer | Type property | | hItemInteger4 | Item type: 4-byte integer | Type property | | hItemInteger8 | Item type: 8-byte integer | Type property | | hItemUnsignedInteger1 | Item type: Unsigned 1-byte integer | Type property | | hItemUnsignedInteger2 | Item type: Unsigned 2-byte integer | Type property | | hItemUnsignedInteger4 | Item type: Unsigned 4-byte integer | Type property | | hItemUnsignedInteger8 | Item type: Unsigned 4-byte integer | Type property | | hItemEnumeration | Item type: Enumeration | Type property | | hItemHour | Item type: Time | Type property | | hItemIDAuto | Item type: Automatic identifier (8 bytes) | Type property | | hItemIDAuto4 | Item type: Automatic identifier (4 bytes) | Type property | | hItemPicture | Item type: Image | Type property | | hItemInvalid | Invalid type of item | Type property | | hItemJSON | Item type: JSON | Type property | | hItemBinaryMemo | Item type: Binary memo | Type property | | hItemBinaryMemo4 | Item type: Binary memo (4 bytes) | Type property | | hItemTextMemo | Item type: Text memo | Type property | | hItemUnicodeMemo | Item type: Unicode text memo | Type property | | hItemCurrency | Item type: Currency | Type property | | hItemSecurePassword | Item type: Password | Type property | | hItemNumRec | Item type: Record number | Type property | | hItemNumeric | Item type: High-precision numeric | Type property | | hItemReal4 | Item type: 4-byte real | Type property | | hItemReal8 | Item type: 8-byte real | Type property | | hItemRealTurbo | Item type: Turbo real | Type property | | hItemText | Item type: Text | Type property | | hItemUnicodeText | Item type: Unicode text | Type property | | hItemUUID128 | Item type: UUID 128 | Type property | | hItemUUID128Auto | Item type: UUID 128 automatic identifier | Type property | | hItemUUID256 | Item type: UUID 256 | Type property | | hItemUUID256Auto | Item type: UUID 256 automatic identifier | Type property | | hsAdd | Monitors the operations for adding records. | HWatch | | hsModification | Monitors the operations for modifying records. | HWatch | | hsCross | Monitors the operations for crossing records. | HWatch | | hsDeletion | Monitors the operations for deleting records. | HWatch | | 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 | | 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 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 | Full-text index file (".Ftx") size in bytes | HInfoFile | | hFicSize | Data file (".Fic") size in bytes | HInfoFile | | 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 | Option for running the procedure: the procedure is run 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 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,
HImportXLS | | hMaxVal | Defines an upper bound for a filter | HBuildKeyValue,
HFilter,
HFilterStartsWith,
HFilterIncludedBetween | | hMinVal | Defines a lower bound for a filter | HBuildKeyValue,
HFilter,
HFilterStartsWith,
HFilterIncludedBetween | | hCheckDuplicates | Checks for duplicates for this operation, even if the duplicate check is disabled (HSetDuplicates) | HAdd, HExecuteQuery, HExecuteSQLQuery, HModify | | hCheckIntegrity | Checks the integrity of operation even if the automatic integrity check is disabled (HSetIntegrity) | HAdd, HExecuteQuery, HExecuteSQLQuery, HModify, HCross, HDelete | | hCheckMemo | Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos) | HIndex | | hViewAdd | Create a view with addition: Stores the content of the view next time HExecuteView is called | HCreateView, HMergeView | | hViewLocking | Lock records read in the file and included in the view | HCreateView, HMergeView | | hViewDefault | Default creation of view | HCreateView, HMergeView | | hViewPostponed | The view is created but it will be run later by HExecuteView | HCreateView, HMergeView | | hViewDistinct | Create view without duplicates with respect to the sort key | HCreateView, HMergeView | | hViewExclusive | Lock the entire source file to reduce the view creation time | HCreateView, HMergeView | | hViewBreakable | Interrupt view creation by pressing the ESC key | HCreateView | | hViewIntersection | Merge views with intersection: Common rows between the two specified views | HMergeView | | hViewJoin | Join between the first view and the second view. | HMergeView | | hViewSubtraction | Merge views with subtraction: Row of the first view without the common rows of the second view | HMergeView | | hViewUnion | Merging views: Merge the rows of the two specified views | HMergeView | | hViewUnionEx | Exclusive merge of views: Merge the non-common rows of the two specified views | HMergeView | | hWDL | The files are sought:- In the main WDL.
- In the WDL according to their load order, then on disk or in the specified WDL, then on disk.
- In the main WDL of the component.
- In the secondary WDLs of the component according to the load order.
| HChangeLocation,
HDeclare | | opCancel | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the code continues to run. | HOnError | | 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 |
The following constants are used to manipulate HFSQL data files, using prefix syntax: | | | | Constant | Description | Functions/Properties |
|---|
| eltSetOfProcedures | The listed element is a set of procedures | <Cnt>.ListStoredElement | | eltProcedure | The listed element is a stored procedure | <Cnt>.ListStoredElement | | eltQuery | The listed element is a query. | <Cnt>.ListStoredElement | | h3G | Type of network to simulate: 3G | <Cnt>.SimulateNetwork | | h4G | Type of network to simulate: 4G | <Cnt>.SimulateNetwork | | h5G | Type of network to simulate: 5G | <Cnt>.SimulateNetwork | | hAcceptOpenedFile | Allows you to read the source file that will be added to the memo if this source file is opened in write mode somewhere else. | <Source>.LinkMemo | | hAccessHF7 | Pseudo-connection to HFSQL Classic database. | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hAccessHFClientServer | Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hAccessJDBCMySQL | Access to a MySQL database via a JDBC driver | HDescribeConnection,
<Cnt>.OpenConnection | | hAccessJDBCSQLServer | Access to an SQL Server database via a JDBC driver | HDescribeConnection,
<Cnt>.OpenConnection | | hNativeAccessAS400 | Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessDB2 | OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessInformix | OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessMariaDB | OLE DB provider that will be used for the connection: Native MariaDB Connector (optional module of WINDEV/WEBDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessMySQL | OLE DB provider that will be used for the connection: Native MySQL Connector | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessOracle | OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessOracleLite | Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessPostgreSQL | OLE DB provider that will be used for the connection: Native PostgreSQL Connector | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessProgress | OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessSQLAzure | OLE DB provider that will be used for the connection: Native SQL Azure Connector | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessSQLite | OLE DB provider that will be used for the connection: Native Connector to an SQLite database | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessSQLServer | OLE DB provider that will be used for the connection: Native SQL Server Connector (optional module of WINDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessSQLServerMobile | Provider that will be used for the connection: Native SQL Server Mobile Connector (optional module of WINDEV Mobile) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessSybase | OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessXBase | OLE DB provider that will be used for the connection: Native xBase Connector | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hNativeAccessXML | Provider that will be used for the connection: Native XML Connector (provided with WINDEV/WEBDEV) | HConnect,
<Source>.DeclareExternal,
HDescribeConnection,
HListFile,
<Cnt>.OpenConnection,
Provider property,
CtOLEDBProvider property,
CtDescribedOLEDBProvider property | | hActiveDirectory | Enable the authentication via Active Directory. | <Cnt>.SetServer | | hADSL | Type of network to simulate: ADSL | <Cnt>.SimulateNetwork | | hAffectBrowse | Addition affecting the current browse | <Source>.Add,
<Source>.Modify | | hApplication | Property of a database found on an HFSQL server: Name of the application from which the database was created. | HInfoDatabaseProperty,
HInfoFileProperty | | hStopped | Server stopped | HServerStatus | | hNone | Used to disable the simulation of a specific network. | <Cnt>.SimulateNetwork | | hAllowed | The relevant rights are granted to the user or group. | HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights | | hWithFilter | If this parameter is specified: - the query result corresponds to a selection of filter records if the HFSQL engine allows it. Otherwise, the query result corresponds to an HFSQL view
- the following operations are not allowed: search on the query result, query on query, view on query, query on view.
- the browse items specified when looping through the result are ignored.
- the magnifier is not available for the tables linked to a query.
- hNbRec cannot be used on the queries.
If this parameter is not specified (by default): - the query result corresponds to an HFSQL view
- the following operations can be performed on the queries: search on the query result, query on query, view on query, query on view.
- the browse items specified when looping through the result are taken into account.
- the magnifier is available on tables linked to a query.
- hNbRec can be used on the queries.
| HExecuteQuery,
HExecuteSQLQuery | | hWithTransaction | The query is run in a transaction. A transaction is started, the records are locked in read/write during the execution of the query and they are unlocked at the end of its execution, regardless of the result (failure or success).
If the query cannot end properly (locked records, power failure, etc.), the transaction is canceled and the data files are restored to their previous status (before the query execution).
Remark: The query execution may be slowed down. | HExecuteQuery,
HExecuteSQLQuery | | hLockWrite | Type of lock: Lock in write mode | <Source>.Add,
HForward,
HLockFile,
HLockRecNum,
HLast,
HWrite,
HRead,
HReadLast,
HReadPrevious,
HReadFirst,
HReadSeekLast,
HReadSeekFirst,
HReadNext,
<Source>.Modify,
HPrevious,
HFirst,
HCross,
HSeek,
HSeekLast,
HSeekFirst,
HBackward,
HNext | | hLockReadWrite | Type of lock: Lock in read/write mode | <Source>.Add,
HForward,
HLockFile,
HLockRecNum,
HLast,
HWrite,
HRead,
HReadLast,
HReadPrevious,
HReadFirst,
HReadSeekLast,
HReadSeekFirst,
HReadNext,
<Source>.Modify,
HPrevious,
HFirst,
HCross,
HSeek,
HSeekLast,
HSeekFirst,
HBackward,
HNext | | hLockNo | Type of lock: No lock | <Source>.Add,
HForward,
HLockFile,
HLockRecNum,
HLast,
HWrite,
HRead,
HReadLast,
HReadPrevious,
HReadFirst,
HReadSeekLast,
HReadSeekFirst,
HReadNext,
<Source>.Modify,
HPrevious,
HFirst,
HCross,
HSeek,
HSeekLast,
HSeekFirst,
HBackward,
HNext | | hCacheNbUnusedFiles | Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server. | <Cnt>.SetServer | | hAutoStatisticalCalc | Enable the automatic calculation of statistics for the data files (optimization of indexes). | <Cnt>.SetServer | | hCardinality | Integrity constraints: Check the link cardinalities. | <Cnt>.SetIntegrity | | hInfiniteCardinality | Maximum cardinality ("N") | MaxLinkedCardinality property,
MaxSourceCardinality property | | hChangeCharset | The character set defined by ChangeCharset will be taken into account in the new data file. Sorts, searches, ... on string keys (strings, characters, date and time) will be performed according to this character set. | <Source>.Creation,
<Source>.CreationIfNotFound,
<Source>.Index | | hDatabasePath | Path of directory containing all databases | <Cnt>.SetServer | | hJNLPath | Path of the directory containing all the logs of the different HFSQL Client/Server applications | <Cnt>.SetServer | | hJNLBackupPath | Path of the directory containing the backups of the logs | <Cnt>.SetServer | | hLogPath | Path of the directory containing the log files | <Cnt>.SetServer | | hActivityStatisticsPath | Path of the directory containing the activity statistics | <Cnt>.SetServer | | hDuplicateKey | Characteristics of an item: Key with duplicates | KeyType property | | hUniqueKey | Characteristics of an item: Unique key | KeyType property | | hCloud | Type of network to simulate: Cloud | <Cnt>.SimulateNetwork | | hSQLCode | Requested information: SQL code of the materialized view | <Cnt>.InfoView | | hCompatible | The structures of the data files (defined in the analysis and found in the physical file) must be compatible. | <Source>.CheckStructure | | hPackNo | Compression mode: No compression | MmoPackMethod property | | hPackZLW | Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation. | MmoPackMethod property | | hKeepTRS | Stores the transaction files during the deletion | <Cnt>.DeleteDatabase,
<Cnt>.DeleteFile | | hCopyAutoID | Copies the automatic identifier while keeping its value | <Source>.CopyRecord,
<Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS | | hCopyIndex | Copies the index of the data file | <Cnt>.CopyFile | | hCopyIfNotFound | Copies the data file only if it does not exist at the specified location on the destination computer. | <Cnt>.CopyFile | | hCorrespondence | Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions | HInfoLog | | hCreator | Property of a database found on an HFSQL server: Name of database owner. | <Cnt>.InfoDatabaseProperty,
<Cnt>.InfoFileProperty | | hCreateIndex | The index of the data file is not copied. It is automatically recreated at the destination by reindexing. | <Cnt>.CopyFile | | hIncreasing | Sort performed in ascending order | SortType property | | hEncryptionAES128 | The file is encrypted only if it is password-protected. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB). | 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 | No file encryption. | FicEncryption property,
MmoEncryption property,
NdxEncryption property | | hEncryptionRC5_12 | The file is encrypted using an optimized 12-round RC5 algorithm with a 128-bit key. | FicEncryption property,
MmoEncryption property,
NdxEncryption property | | hEncryptionRC5_16 | The file is encrypted using an optimized 16-round RC5 algorithm (128 bits). | FicEncryption property,
MmoEncryption property,
NdxEncryption property | | hEncryptionStandard | The file is encrypted using an optimized 128-bit algorithm. | 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,
<Cnt>.OpenConnection | | 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,
<Cnt>.OpenConnection | | 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,
<Cnt>.OpenConnection | | hReadOnlyCursor | The record set manipulated cannot be modified. | HDescribeConnection,
<Cnt>.OpenConnection | | 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,
<Cnt>.OpenConnection | | hOptimisticCursor | The record is locked when it is updated | HDescribeConnection,
<Cnt>.OpenConnection | | hPessimisticCursor | The record is locked as soon as it is edited. | HDescribeConnection,
<Cnt>.OpenConnection | | hServerCursor | Cursor managed by the database. This cursor can easily reflect changes made to data by other users. | HDescribeConnection,
<Cnt>.OpenConnection | | hStaticCursor | Makes a copy of all query records in memory (high memory consumption). All types of scrolling are supported. | HDescribeConnection,
<Cnt>.OpenConnection | | hDaemonUser | Username that will be used by the server (Linux only) | <Cnt>.SetServer | | hDate | Property of a database found on an HFSQL server: Creation date of the database. | <Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty | | hDateLastRefresh | Requested information: Date of the last successful refresh for the materialized view. | <Cnt>.InfoView | | hDBASCII | Sort according to ASCII order | HDBSortType | | hDisconnection | Configures the disconnection message | HOnServerCall | | hDBLexicographic | Sort according to the lexicographic order | HDBSortType | | hDecreasing | Sort performed in descending order | SortType property | | hDefault | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the values of the requested rights (in the same order). | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.InfoServerRights | | hStarted | Server started | HServerStatus | | hDetails | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the rights and there value. | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.InfoServerRights | | hDestroyLink | Deletes all links related to the deleted data file. | <Cnt>.DeleteFile | | hDisk | Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case | <Source>.ChangeLocation,
<Source>.Declare | | hDistinct | Manages duplicates during the iteration: Only one record is read if duplicates are found when looping through a key item | <Source>.Forward,
<Source>.ReadPrevious,
<Source>.ReadNext,
<Source>.Previous,
<Source>.Backward,
<Source>.Next | | hData | Configure the file management: All the operations stored in the log file are applied to the existing file | <Cnt>.RegenerateFile | | hRightsInsert | Rights to add new records into a data file. | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsStopServer | Rights to stop a server (<Connection>.StopServer) | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsLock | Rights to lock the data files or the records of a data file. | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsChangeRights | Rights to change rights. | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.InfoServerRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights,
<Cnt>.ModifyServerRights | | hRightsChangeLink | Rights to modify the integrity rules on a data file. | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsChangePassword | Rights to change the password of a user on the server (the user can change his own password and the administrator can change the password of each user). | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsChangeOwner | Rights to change the owner of an element | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsConnection | Rights to connect to a server (encrypted or unencrypted connection) | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsEncryptedConnection | Rights to connect to a server (encrypted connection only) | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsCreateDB | Rights to create a database | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsCreateFile | Rights to create a data file (with <Source>.Creation) | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsCreateView | Rights to create a SQL view or a materialized view. | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsDebug | Rights to debug the stored procedures. | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsDisconnectClient | Rights to disconnect the client computers. | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsSendMessageToClient | Rights to send messages to the client computers. | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsRunProcedure | Rights to run the stored procedures. | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsManageDuplicate | Rights to enable and disable the management of duplicates. | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsManageIntegrity | Rights to enable and disable the management of integrity. | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsManageTask | Rights to manage the scheduled tasks. | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsManageProcedure | Rights to add, modify and delete the stored procedures. | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsManageServer | Rights to use <Cnt>.SetServer | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsManageTrigger | Rights to manage the server triggers (addition, activation, deletion) | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsManageUser | Rights to delete and add users or groups | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsNoDatabaseAccess | Rights to prevent access to a database (<Cnt>.NoDatabaseAccess and <Cnt>.EndNoDatabaseAccess) | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsRead | Rights to read the records of a data file | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsReadLogStat | Rights to see the activity statistics and the server logs. | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsMaintenance | Rights to start a re-index operation or to perform statistical calculations on a data file | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsAutoModif | Rights to run automatic data modification on a file | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsUpdate | Rights to modify the records of a data file | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsPriority | Rights to modify the priority of a client application | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsServerReplication | Rights to define and perform a replication between two HFSQL servers. | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hRightsBackup | Rights to save the data files | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoServerRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyServerRights | | hRightsDelete | Rights to delete the records from a data file | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsDeleteDB | Rights to delete a database | <Cnt>.InfoDatabaseRights,
<Cnt>.ModifyDatabaseRights | | hRightsDeleteFile | Rights to delete a data file (<Cnt>.DeleteFile) | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights | | hRightsDeleteView | Rights to delete a SQL view or a materialized view. | <Cnt>.InfoViewRights, <Cnt>.ModifyViewRights | | hRightsAll | List of all the rights | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.InfoServerRights | | hRightsSeeUser | Rights to view the characteristics of a group or user. | <Cnt>.InfoServerRights,
<Cnt>.ModifyServerRights | | hlbDiskAccess | Value modifying the coefficient applied to the counter for the number of disk accesses. | <Cnt>.SetServer | | hlbActive | Enable or disable the load balancing | <Cnt>.SetServer | | hlbClientCalls | Value modifying the coefficient applied to the counter for client calls | <Cnt>.SetServer | | hlbMaxTimeout | Value modifying the maximum timeout for a server request | <Cnt>.SetServer | | hlbDisk | Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server | <Cnt>.SetServer | | hlbSent | Value modifying the coefficient applied to the counter for the bytes sent by the server | <Cnt>.SetServer | | hlbReceived | Value modifying the coefficient applied to the counter for the bytes received by the server | <Cnt>.SetServer | | hWriteDefault | Addition not affecting the current browse/Identifier re-used or calculated for the record | <Source>.Add,
<Source>.Write,
<Source>.Modify | | hEffective | The rights returned correspond to the rights that will be actually granted to the user or to the group on the database. Inherited rights are taken into account (for example, rights granted to the groups to which the user belongs). | <Cnt>.InfoDatabaseRights,
<Cnt>.InfoFileRights,
<Cnt>.InfoServerRights | | hOnUpdate | Integrity rule applied during a modification | <Cnt>.SetIntegrity | | hRecFile | Record to read: Value of the item currently saved in the data file | <Source>.ErrorModification,
<Source>.ErrorStatusModification | | hRecRead | Record to read: Value of the item for the source record | <Source>.ErrorModification,
<Source>.ErrorStatusModification | | hRecUser | Record to read: Value of the item for the current record when performing the modification | <Source>.ErrorModification,
<Source>.ErrorStatusModification | | hOnDelete | Integrity rule applied during a deletion | <Cnt>.SetIntegrity | | hErrDatabaseAccess | Configure the access errors to an HFSQL Client/Server database. | <Source>.OnError | | hErrADO | Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant. | HErrorInfo | | hErrBase | Type of information about the error to return: Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant | HErrorInfo | | hErrLock | Defines how to handle lock errors | <Source>.OnError | | hErrSystemCode | Type of information about the error to return: Number of the associated system error | HErrorInfo | | hErrFullDetails | Type of information about the error to return: Full error details (error line, current process, etc.)
Remark: Returns the same information as the one retrieved via the "Copy" button in the WLanguage error window. | HErrorInfo | | hErrDuplicates | Defines how to handle duplicate errors | <Source>.OnError | | 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. | <Connection>.InfoView | | hErrFIC | Type of information about the error to return: Full name of the data file associated with the error | HErrorInfo | | hErrFile | Type of information about the error to return: Logical name of data file associated with the error | HErrorInfo | | hErrLockInfo | Type of information about the error to return: Information about the lock | HErrorInfo | | hErrClientInfo | Information about the client 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. This information should only be displayed and communicated on express demand from PC SOFT.
When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database. | HErrorInfo | | hErrServerInfo | Information about the server used by the Native Connector that returned the error. | HErrorInfo | | hErrIntegrity | Defines how to handle integrity errors | <Source>.OnError | | hErrLink | Type of information about the error to return: Name of the link associated with the error | HErrorInfo | | hErrMessage | Type of information about the error to return: Message associated with the error | HErrorInfo | | hErrADOMessage | Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO) | HErrorInfo | | hErrBaseMessage | Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase) | HErrorInfo | | hErrNativeMessage | Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector. | HErrorInfo | | hErrOLEDBMessage | Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB) | HErrorInfo | | hErrSystemMessage | Type of information about the error to return: Message of associated system error | HErrorInfo | | hErrMMO | Type of information about the error to return: Full name of the memo file associated with the error | HErrorInfo | | hErrModify | Defines how to handle modification conflicts | <Source>.OnError | | hErrPassword | Defines how to handle password errors | <Source>.OnError | | hErrNative | Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used | HErrorInfo | | hErrNDX | Type of information about the error to return: Full name of the index file associated with the error | HErrorInfo | | hErrRecNum | Type of information about the error to return: Number of the record associated with the error | HErrorInfo | | hErrOLEDB | Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection. | HErrorInfo | | hErrConnectionLoss | Defines how to handle errors caused by a loss of connection with the server. | <Source>.OnError | | hErrPositionSQLError | Type of information about the error to return: Position of the SQL error in the SQL code of the query run by <HFSQL file>.ExecuteSQLQuery. | HErrorInfo | | hErrMain | Type of information about the error to return: Number of the main error | HError | | hErrIndex | Defines how to handle reindexing errors (reindexing in progress when accessing the data file) | <Source>.OnError | | hErrItem | Type of information about the error to return: Name of the item associated with the error | HErrorInfo | | hErrServer | Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error | HErrorInfo | | hErrAll | Defines how to handle all errors | <Source>.OnError | | hErrNeedValue | Defines how to handle errors caused by a required value that has not been specified (OLE DB only). | <Source>.OnError | | hErrWDD | Type of information about the error to return: Full name of the analysis file associated with the error | HErrorInfo | | hStateActive | Status of the record/Type of record taken into account: Active record | <Source>.State,
<Source>.NbRec,
<Source>.ErrorStatusModification | | hStateInvalid | Record status not found (error) | <Source>.State,
<Source>.ErrorStatusModification | | hStateCrossed | Status of the record/Type of record taken into account: Crossed record | <Source>.State,
<Source>.NbRec,
<Source>.ErrorStatusModification | | hStateDel | Status of the record/Type of record taken into account: Deleted record | <Source>.State,
<Source>.NbRec,
<Source>.ErrorStatusModification | | hStateAll | Type of record: Total number of records in the data file | <Source>.NbRec | | hExisting | Type of search: Only the assignments for which a file actually exists | HListREP | | hExpCreation | Mode for creating the export file: The file is overwritten if it already exists. | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | | hExpBreakable | Mode for creating the export file: The export can be interrupted by pressing Esc.
If the export is interrupted, the export file is valid and it only contains the records exported before the interruption. | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | | hExpNormal | Mode for creating the export file: Standard operating mode | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | | hExpNoLineItemName | Mode for creating the CSV/XLSX file: The first line of the generated file will not contain the names of the items. | <Source>.ExportCSV
<Source>.ExportXLS | | hExpWithoutXSL | The style sheet (".XSL" file) is not created | <Source>.ExportXML | | hFileAS400 | Type of file: AS400 file | Type property | | hFileOther | Type of file: Other type of file | Type property | | hFileClientServer | Type of file: HFSQL Client/Server file | Type property | | hFileHF5 | Type of file: Hyper File 5 file | Type property | | hFileMySQL | Type of file: MySQL file | Type property | | hFileNormal | Type of file: Standard file (HFSQL Classic) | Type property | | hFileOLEDB | Type of file: OLEDB file | Type property | | hFileOracle | Type of file: ORACLE file | Type property | | hFileOracleLite | Type of file: ORACLE Lite file | Type property | | 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 | <Source>.Add,
<Source>.Write,
<Source>.Modify | | hSetIDAuto | Mode for calculating the automatic identifier: Identifier value equals to the one stored during the write operation | <Source>.Add,
<Source>.Write,
<Source>.Modify | | hANSIFormat | Data format: Ansi format (used by Windows) | Format property | | hUNICODEFormat | Data format: UNICODE format | Format property | | hForwardOnly | Native Connectors only: Optimizes simple iterations that do not use the following features: - Reading the previous record.
- Modifying a record.
- Saving position.
If one of these features is used, the result may differ from the expected one.For example, this constant can be used when looping through records to populate a Table control programmatically. | <Source>.ReadLast,
<Source>.ReadFirst,
<Source>.ReadSeekFirst,
<Source>.ReadSeekLast | | hftPunctuationSimple | Full-text Index item described programmatically: Taking into account the simple punctuation characters (non Unicode). | Option property of variables
of type FullTextIndex Description. | | hftPunctuationUnicode | Full-text Index item described programmatically: Taking into account the Unicode punctuation characters. | Option property of variables
of type FullTextIndex Description. | | hFTX | Reindex full-text indexes | <Source>.Index | | HGeneric | Type of search: Generic search | <Source>.ReadSeekLast,
<Source>.ReadSeekFirst,
<Source>.SeekLast,
<Source>.SeekFirst | | hHCreationIfNotFound | Type of test to run to check the connection: Checks the connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only. | HConnect | | hInherit | The user will inherit the right granted to the group to which they belong | <Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights,
<Cnt>.ModifyServerRights | | hHOpen | Type of test to run to check the connection: Checks the connection by opening a file. This value is used by default when accessing to an hORead database. | HConnect | | hIdentical | The structures of files (read in the analysis and in the physical file) must be strictly identical. | <Source>.ReadSeek,
<Source>.Seek,
<Source>.CheckStructure | | hIgnoreDuplicates | Does not check for duplicates for this action, even if the automatic duplicate check is enabled (<Source>.SetDuplicates) | <Source>.Add | | hIgnoreIntegrity | Ignores the integrity check for this operation, even if the automatic integrity check is enabled (<Cnt>.SetIntegrity) | <Source>.Add,
<Source>.Modify,
<Source>.Delete,
<HFSQL file>.Cross | | hImpConversion | Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated. | <Source>.ImportHF55 | | hImpCreation | Type of import: If the (HFSQL Classic) import file exists, it is overwritten. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpIgnoreInvalidLine | Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing. | <Source>.ImportText,
<Source>.ImportXLS | | hImpIgnoreFirstLine | Type of import: The first row of the imported file is ignored. | <Source>.ImportText,
<Source>.ImportXLS | | hImpIgnoreItem | Type of import: - The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value.
- The items of imported file (Hyper File 5.5) with no match in the import file are ignored.
| <Source>.ImportHF55 | | hImpIgnoreEmptyItem | If one or more items are not filled in the text file, the corresponding lines are still imported.
The missing items contain:- the default value of items if the hDefaultVal constant is specified.
- the value of items in the current record before the call to <Source>.ImportText.
| <Source>.ImportText,
<Source>.ImportXLS | | hImpBreakable | The import can be interrupted by pressing ESC. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpNormal | Type of import: The import is not performed and an error occurs in the following cases:- items found in the Hyper File 5.5 file with no match in the HFSQL Classic file.
- associated items in the two files but with a different size and/or format.
If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created.
No management of integrity and no management of duplicates.
The non-imported items take the value of the current record.
The automatic identifiers are recalculated. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpOEM2ANSI | Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility. | <Source>.ImportText | | hImpNoDelimiter | Type of import: The string separators (if they exist) are part of the item | <Source>.ImportText | | hImpNoSpace | Type of import: The space characters found at the end of string are automatically deleted during the import | <Source>.ImportHF55 | | hImpTestDuplicates | Type of import: Checks the duplicates during the import | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS | | hImpTestIntegrity | Type of import: Checks the integrity during the import | <Source>.ImportHF55,
<Source>.ImportText,
| | hInaccessible | Undefined server status | HServerStatus | | hInfoCluster | Information about the HFSQL cluster. | <Cnt>.InfoServer | | hInfoDate | Date and time of server on 8 bytes in UTC format (universal time) | <Cnt>.InfoServer | | hInfoFreeDiskSpace | Available space on the server disk, expressed in MB. | <Cnt>.InfoServer | | hInfoTotalDiskSpace | Total capacity of server disk, expressed in MB. | <Cnt>.InfoServer | | hInfoHardware | Information about the hardware used:- Type of processor (for example: Intel Pentium)
- Size of server RAM (for example: 630 MB)
This information is returned in the following format:
<Type of CPU> = TAB + <Size of server RAM> | <Cnt>.InfoServer | | hInfoName | Name of server (DNS) | <Cnt>.InfoServer | | hInfoLogicalName | Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center. | <Cnt>.InfoServer | | hInfoPlatform | Information about the server platform:- Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX
- System version: corresponds to Service Pack in Windows or empty string if no Service Pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example).
This information is returned in the following format:
<System name> + TAB + <Version> | <Cnt>.InfoServer | | hInfoSizeCacheNdxUsed | Size of index cache that is actually used on the server, expressed in MB. | <Cnt>.InfoServer | | hInfoAll | Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate).
The different values are separated by CR characters (Carriage Return). | <Cnt>.InfoServer | | hInfoVersion | Information about the version of programs required for the server to operate:- Version of Manta.exe or Manta in Linux
- Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | <Cnt>.InfoServer | | hInfoVersionDetails | Detailed information about the version of the programs required to operate the server:
<Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date>
The listed elements are as follows:- Manta.exe or Manta in Linux
- HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
- Management of logs (HFLogger.exe)
- MantaManager
- the framework required to operate the server.
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | <Cnt>.InfoServer | | hInfoVI | Version number of Manta.exe or Manta in Linux | <Cnt>.InfoServer | | hIntegrityNone | Modification/Deletion rule: No integrity management | ModificationRule property,
DeletionRule property | | hIntegrityCascade | Modification/Deletion rule: Cascading modification/deletion | ModificationRule property,
DeletionRule property | | hIntegrityForbidden | Modification/Deletion rule: Modification/Deletion not allowed | ModificationRule property,
DeletionRule property | | hIntegrityDefaultValue | Modification/Deletion rule: Default modification/deletion | ModificationRule property,
DeletionRule property | | hForbidden | The relevant rights are not granted to the user or group | <Cnt>.ModifyDatabaseRights,
<Cnt>.ModifyFileRights,
<Cnt>.ModifyServerRights | | hLogJNLFile | Configures the file to recreate: Only <File name>JNL.FIC is recreated. | <Source>.LogRecreate | | hLogIdentification | Configures the file to recreate: Re-creates the "JournalIdentification.fic" file. | <Source>.LogRecreate | | hLogWriting | Format of log process: Log the write operations performed in the file | LogMethod property | | hLogReadingWriting | Format of log process: Log the read and write operations performed in the file | LogMethod property | | hLogNo | Format of log process: No log | LogMethod property | | hLogOperation | Configures the file to recreate: Re-creates the "JournalOperation.fic" file. | <Source>.LogRecreate | | hLogUser | Configures the file to recreate: Recreates the log of users ("UserLog.fic").
This file exists in HFSQL Client/Server only. This file contains the information (login, computer, ...) about the users who perform the logged actions. | <Source>.LogRecreate | | hkaInterval | Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client. | <Cnt>.SetServer | | hkaTimeout | Maximum timeout (in seconds) for the server when checking the presence of client. If the client is not found at the end of this timeout, the client is automatically disconnected. | <Cnt>.SetServer | | hLanguageCreation | Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation". | Language property,
LanguageDescribed property | | hLanguageBinarySort | The sort will be performed by comparing the binary value of the bytes. This type of sort is very fast. It should be used to perform an exact-match search for example. | Language property,
LanguageDescribed property, H.LanguageCreationUnicode | | hLanguageFastSort | The sort will be performed by comparing the characters one by one according to a generic sort. | Language property,
LanguageDescribed property, H.LanguageCreationUnicode | | hLimitParsing | Limits the file browse: The iteration will stop when the last searched value is found. The current record will correspond to this last record found.
<Source>.Found will be set to False and <Source>.Out will be set to True.
This constant is used to optimize the search speed in client/server mode. | <Source>.ReadSeek, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst | | 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 | <Source>.ListKey,
<Source>.ListItem | | hLstCompositeKey | Lists the composite key items only | <Source>.ListKey,
<Source>.ListItem | | hLstSet | Lists the sets of procedures found on a server | <Cnt>.ListStoredElement | | hLstDetail | Lists the detailed information | <Source>.ListKey,
HListFile,
<Source>.ListLink,
<Source>.ListItem,
HListConnection,
<Cnt>.ListStoredElement | | hLstDetailPlus | For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part. | <Source>.ListKey,
<Source>.ListItem | | hLstFile | Lists the databases and their files for the server defined by the connection | <Cnt>.ListDatabase | | hLstMemo | Lists the memo items | <Source>.ListItem | | hLstNormal | Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically. | <Source>.ListKey,
HListFile,
<Source>.ListItem,
HListConnection | | hLstLogicalOrder | Lists the items or the keys according to the logical order of items | <Source>.ListKey,
<Source>.ListItem | | hLstOpened | Stores the opened connections only | HListConnection | | hLstStoredProcedure | Lists the stored procedures of a connection via Native Connectors or OLE DB | HListFile,
<Cnt>.ListStoredElement | | hLstQuery | - Lists the queries found on a server
- Lists the queries that have been run.
| | | hLstItem | Lists the non-key and non-memo items | <Source>.ListItem | | hLstOriginalItem | Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file. | <Source>.ListKey, <Source>.ListItem | | hLstTable | List of user tables for a connection via Native Connectors or OLE DB | HListFile | | hLstSystemTable | List of system tables for a connection via Native Connectors or OLE DB | HListFile | | hLstDatabaseSize | List of connection databases as well as their size. | <Cnt>.ListDatabase | | hLstAll | Lists all the keys, all the files, all the items or all the connections | <Source>.ListKey,
HListFile,
<Source>.ListItem,
HListConnection,
<Cnt>.ListStoredElement | | hLstSorted | Sorts the list of keys, files, items or connection in ascending order | <Source>.ListKey,
HListFile,
<Source>.ListItem,
HListConnection | | hLstView | - List the views of a connection via Native Connectors or OLE DB.
- 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. | <Cnt>.InfoDatabaseProperty,
<Cnt>.InfoFileProperty | | hMemoAuto | The memos are read during the access to the item | <Source>.SetMemo | | hMemoBin | Type of file used for the memo: Any binary file | <Source>.LinkMemo | | hMemoImg | Type of file used for the memo: Image file | <Source>.LinkMemo | | hMemoNo | No management of memos | <Source>.SetMemo | | hMemoOle | Type of file used for the memo: OLE file | <Source>.LinkMemo | | hMemoYes | The text memos are read whenever the record is read.
Read the binary memos when accessing the item. | <Source>.SetMemo | | hMemoWav | Type of file used for the memo: sound file | <Source>.LinkMemo | | hMessage | Configures the information message | HOnServerCall | | hMode2GB | Indicates whether system files support more than 2 GB | <Cnt>.SetServer | | hMmoCompact | Compression and defragmentation of "Mmo" files. | <Source>.Index | | hModeDirect | Priority implementation of locks | <Source>.Mode | | hModeMono | Single-user lock mode | <Source>.Mode | | hModeMulti | Multi-user lock mode | <Source>.Mode | | hModeReservation | Non-priority implementation of locks | <Source>.Mode | | hModifyFile | When modifying the query result, these modifications will be applied to the files belonging to the query.
If this option is not specified, only the query result is modified. | <HFSQL file>.ExecuteQuery,
<HFSQL file>.ExecuteSQLQuery | | hmsNormal | Standard operating mode of the automatic data modification. | <Source>.ModifyStructure | | hmsNoCheck | The automatic data modification is performed even if the file description is more recent than the analysis description. | <Source>.ModifyStructure | | hmsBackgroundTask | A hot automatic modification is performed (available for the HFSQL Client/Server data files only). | <Source>.ModifyStructure | | hNdxCompact | Reindexing with compression | <Source>.Index | | hNdxMinimal | Reindex and ignore corrupted keys | <Source>.Index | | hNdxSilent | Configures the reindex operation: No display during the reindex operation | <Source>.Index | | hNdxNormal | Standard reindexing | <Source>.Index | | hNdxNoStat | Reindex without calculating statistics | <Source>.Index | | hNdxDelete | Reindex and delete damaged records | <Source>.Index | | hLogLevel | Defines the elements that must be in the log file | <Cnt>.SetServer | | hMaxNumberConnection | Maximum number of connections allowed per application. | <Cnt>.SetServer | | hNonBlocking | Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To knwo if the execution of the view or query is completed, use the ExecutionCompleted property property.
This constant is available for the views and queries in HFSQL Classic or Client/Server.
This constant has no effect for the data files and for the Native Connectors | <Source>.NbRec | | hNotAKey | Characteristics of an item: Non-key item | KeyType property | | hNotReplicated | Replication mode: The data file is not configured for replication. To implement the replication, check "Replication" in the characteristics of the file in the data model editor. | Replication property | | hNotSorted | Sort direction: Item not sorted | SortType property | | hNotes | Property of a database found on an HFSQL server: Database description or any other information associated with the database by <Cnt>.ModifyDatabaseProperty. | <Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty, <Cnt>.InfoServerProperty, <Cnt>.ModifyDatabaseProperty, <Cnt>.ModifyFileProperty, <Cnt>.ModifyServerProperty | | hNotifWarning | The notifications will be sent from the warning level (for the warning, critical and error problems). | <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient | | hNotifCCClassic | The notifications are sent by the Control Centers in HFSQL Classic mode. | <Cnt>.NotifConfigure | | hNotifCCCS | The notifications are sent by the Control Centers in Client/Server mode. | <Cnt>.NotifConfigure | | hNotifCritical | The notifications will be sent from the critical level (for the critical and error problems). | <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient | | hNotifEmail | The notifications are sent by email. | <Cnt>.NotifConfigure | | hNotifError | The notifications will be sent for the error problems only. | <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient | | hNotifInformation | The notifications will be sent from the information level (for the information, warning, critical and error problems) | <Cnt>.NotifAddCCRecipient, <Cnt>.NotifAddEmailRecipient | | hCurrentRecNum | Number of the current record. | HFSQL functions | | hInvalidRecNum | Constant returned if there is no current record or if the specified file corresponds to a multi-file query. | <Source>.RecNum | | 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,
<Source>.DeclareExternal,
HListFile,
<Cnt>.OpenConnection,
SQLConnect | | hORead | File accessible in read-only | CtAccess property,
CtDescribedAccess property,
HConnect,
<Source>.Open | | hOReadWrite | File accessible in read/write | CtAccess property,
CtDescribedAccess property,
HConnect, <Source>.Open | | hOledbAccess97 | OLE DB provider that will be used for the connection: OLE DB provider for Access 97 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbAccess2000 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2000 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbAccess2007 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2007 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbAccess2010 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2010 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbDBase5 | OLE DB provider that will be used for the connection: OLE DB provider for dBase 5 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbExcel2000 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbExcel2007 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbExcel97 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 97 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbLotus4 | OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4 | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbOracle | OLE DB provider that will be used for the connection: OLE DB provider for Oracle | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | hOledbSQLServer | OLE DB provider that will be used for the connection: OLE DB provider for SQL Server | CtOLEDBProvider property,
CtDescribedOLEDBProvider property,
HConnect, <Source>.DeclareExternal, HListFile, <Cnt>.OpenConnection, SQLConnect | | 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. | <Source>.CreationIfNotFound | | hActivityStatisticsPeriod | Indicates the period (in second) between each backup of values for the different activity counters. | <Cnt>.SetServer | | hDebuggingPort | Port used to debug the stored procedures and the server triggers. | <Cnt>.SetServer | | hServerPort | Network port used | <Cnt>.SetServer | | hPrecisionHigh | Position with high precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hPrecisionLow | Position with low precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hPrecisionMedium | Position with medium precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hOwner | Property of a database found on an HFSQL server: Owner of database. | <Cnt>.InfoDatabaseProperty, <Cnt>.InfoFileProperty, <Cnt>.ModifyDatabaseProperty, <Cnt>.ModifyFileProperty | | hRefreshInProgress | Requested information: Is the materialized view currently refreshed? | <Cnt>.InfoView | | hReadCommitted | Isolation level of transaction: other users can only view completed transactions. | <Cnt>.TransactionIsolation | | hReadUncommitted | Isolation level of transaction: other users can view incomplete transactions. | <Cnt>.TransactionIsolation | | hRecalculateIDAuto | Mode for calculating the automatic identifier: Automatic identifier re-calculated during the write operation | <Source>.Write,
<Source>.Modify | | hFindKey | Enable the search for keys on the HFSQL server. | <Cnt>.SetServer | | hRepeatableRead | Isolation level of transaction: the application in transaction sees a snapshot of the database when the transaction starts. | <Cnt>.TransactionIsolation | | hSubscriberReplica | Replication mode: The data file is a subscriber replica (HCreateSubscriberReplica was used to create the subscriber replica) | Replication property | | hMasterReplica | Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica) | Replication property | | hReplicated | Replication mode: The data file is configured to be replicated. | Replication property | | hQueryDefault | The query is initialized without interruption | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryBreakable | The query initialization can be interrupted with the ESC key | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryWithoutCorrection | Native Connector or OLE DB only:
No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.) | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryWithoutHFCorrection | HFSQL only
The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hTempDirectory | Path of temporary directory. This directory is used to create the temporary files if necessary (temporary files created when re-indexing large data files for example). | <Cnt>.SetServer | | hKeepFilter | The filter set by HFilter will be taken into account, even if the search key is not optimized for the filter.
Reminder: HFilter returns the search key optimized for the filter.
Caution: in this case, performance problems may occur on large files. | <Source>.ChangeKey,
<Source>.Last,
<Source>.ReadLast,
<Source>.ReadFirst,
<Source>.ReadSeekLast,
<Source>.ReadSeekFirst,
<Source>.ReadSeek,
HFirst,
<Source>.Seek,
<Source>.SeekLast,
<Source>.SeekFirst | | hRPKeep | Configure the restore operation: Position not freed | <Source>.RestorePosition | | hRPDefault | Configure the restore operation: Position freed. The stored position is restored | <Source>.RestorePosition | | hRPFilter | Configure the restore operation: Restore the filter set when <HFSQL file>.SavePosition is called | <Source>.RestorePosition | | hRPHF5 | Configure the restore operation: If the stored position was deleted or modified, this position is restored | <Source>.RestorePosition | | hrsCopy | Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is locking. | <Cnt>.RSAddConfig | | hrsCopyBackgroundTask | Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is performed in background task and it is not locking. | <Cnt>.RSAddConfig | | hrsNoCopy | Configure the replication between servers: No copy is performed. | <Cnt>.RSAddConfig | | hItemBinary | Item type: Binary | Type property | | hItemBoolean | Item type: Boolean | Type property | | hItemCharacter | Item type: Character | Type property | | hItemCombination | Item type: Combination | Type property | | hItemDate6 | Item type: Date | Type property | | hItemDate8 | Item type: Date | Type property | | hItemDateTime | Item type: Date/Time | Type property | | hItemTimeLength | Item type: Duration | Type property | | hItemInteger1 | Item type: 1-byte integer | Type property | | hItemInteger2 | Item type: 2-byte integer | Type property | | hItemInteger4 | Item type: 4-byte integer | Type property | | hItemInteger8 | Item type: 8-byte integer | Type property | | hItemUnsignedInteger1 | Item type: Unsigned 1-byte integer | Type property | | hItemUnsignedInteger2 | Item type: Unsigned 2-byte integer | Type property | | hItemUnsignedInteger4 | Item type: Unsigned 4-byte integer | Type property | | hItemUnsignedInteger8 | Item type: Unsigned 4-byte integer | Type property | | hItemEnumeration | Item type: Enumeration | Type property | | hItemGeometry | Item type: Geometry in 2D or geographic coordinates | Type property | | hItemHour | Item type: Time | Type property | | hItemIDAuto | Item type: Automatic identifier (8 bytes) | Type property | | hItemIDAuto4 | Item type: Automatic identifier (4 bytes) | Type property | | hItemPicture | Item type: Image | Type property | | hItemInvalid | Invalid type of item | Type property | | hItemJSON | Item type: JSON | Type property | | hItemBinaryMemo | Item type: Binary memo | Type property | | hItemBinaryMemo4 | Item type: Binary memo (4 bytes) | Type property | | hItemTextMemo | Item type: Text memo | Type property | | hItemUnicodeMemo | Item type: Unicode text memo | Type property | | hItemCurrency | Item type: Currency | Type property | | hItemSecurePassword | Item type: Password | Type property | | hItemMultiPoint2D | Item type: Multipoint in 2D coordinates | Type property | | hItemMultiPointGeo | Item type: Multipoint in geographic coordinates | Type property | | hItemMultiPolygon2D | Item type: Multipolygon in 2D coordinates | Type property | | hItemMultiPolygonGeo | Item type: Multipolygon in geographic coordinates | Type property | | hItemMultiLinestring2D | Item type: Multilinestring in 2D coordinates | Type property | | hItemMultiLinestringGeo | Item type: Multilinestring in geographic coordinates | Type property | | hItemNumRec | Item type: Record number | Type property | | hItemNumeric | Item type: High-precision numeric | Type property | | hItemPoint2D | Item type: Point in 2D coordinates | Type property | | hItemPointGeo | Item type: Point in geographic coordinates | Type property | | hItemPolygon2D | Item type: Polygon in 2D coordinates | Type property | | hItemPolygonGeo | Item type: Polygon in geographic coordinates | Type property | | hItemLinestring2D | Item type: Linestring in 2D coordinates | Type property | | hItemLinestringGeo | Item type: Linestring in geographic coordinates | Type property | | hItemReal4 | Item type: 4-byte real | Type property | | hItemReal8 | Item type: 8-byte real | Type property | | hItemRealTurbo | Item type: Turbo real | Type property | | hItemText | Item type: Text | Type property | | hItemUnicodeText | Item type: Unicode text | Type property | | hItemUUID128 | Item type: UUID 128 | Type property | | hItemUUID128Auto | Item type: UUID 128 automatic identifier | Type property | | hItemUUID256 | Item type: UUID 256 | Type property | | hItemUUID256Auto | Item type: UUID 256 automatic identifier | Type property | | hsAdd | Monitors the operations for adding records. | <Source>.Track | | hsModification | Monitors the operations for modifying records. | <Source>.Track | | hsCross | Monitors the operations for crossing records. | <Source>.Track | | hsDeletion | Monitors the operations for deleting records. | <Source>.Track | | NoWait | The refresh of materialized view is not a locking operation: it is performed in background task. <Connection>.InfoView returns the information of the materialized view after being refreshed. | <Cnt>.RefreshView | | hNoBind | Run a query without enabling the bind | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery,
<Source>.PrepareSQLQuery | | hNoCheck | No check is performed, the analysis description may differ from the description of physical file. | <Source>.CheckStructure | | hNoIndex | The file index is not copied | <Cnt>.CopyFile | | hNoLink | Management of integrity: The links are not updated on the server (creation, modification or deletion).
Reminder: by default, the links are updated on the server when creating a file. | <Source>.Creation, <Source>.CreationIfNotFound | | hNoRefresh | The table or query content will not be refreshed | <Source>.Last,
<Source>.ReadLast,
<Source>.ReadFirst,
<Source>.First | | hNoHourglass | When reading the query result, this read operation may be locked and an hourglass appears by default. This constant is used not to display the hourglass in this case. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hSaveItems | Saves the values of items in memory when using HSavePosition. These values will be restored next time <Source>.RestorePosition is called. | <HFSQL file>.SavePosition | | hBoundSeparator | Used to separate the values of lower and upper bounds for the components of composite key | <Source>.FilterIncludedBetween | | hSubErrLast | Type of error returned: Number of the last sub-error | HError | | hSubErrPrevious | Type of error returned: Number of the previous sub-error | HError | | hSubErrFirst | Type of error returned: Number of the first sub-error | HError | | hSubErrNext | Type of error returned: Number of the previous sub-error | HError | | hSQLUnicode | Used to specify that the query text must be sent in Unicode format to the server.
This constant is available in WINDEV Mobile only. | <HFSQL file>.ExecuteSQLQuery | | hStructure | Configure the file management: New empty file created from the file description | <Cnt>.RegenerateFile | | hNoError | No error occurred | HError | | hDeleteLog | Deletes the log file | <Cnt>.DeleteFile,
<Cnt>.DeleteDatabase | | hBackupCanceled | Status of backup: Backup canceled | <Cnt>.InfoBackup | | hBackupFull | Type of backup: Full backup | <Cnt>.InfoBackup | | hBackupDifferential | Type of backup: Differential backup | <Cnt>.InfoBackup | | hBackupInProgress | Status of backup: Backup in progress | <Cnt>.InfoBackup | | hBackupError | Status of backup: Error during backup | <Cnt>.InfoBackup | | hBackupCompleted | Status of backup: Backup completed | <Cnt>.InfoBackup | | hBackgroundTask | Execute process in the background, without locking the data file (available for data files in Client/Server mode). | <Source>.StatCalculate,
<Source>.Index | | hWindowsDiskCacheSize | Mode for managing the size of Windows disk cache. | <Cnt>.SetServer | | hNdxCacheSize | Maximum size in megabytes (MB) of index cache | <Cnt>.SetServer | | hFtxSize | Full-text index file (".Ftx") size in bytes | <Source>.InfoFile | | hFicSize | Data file (".Fic") size in bytes | <Source>.InfoFile | | hMaxLogSize | Maximum size in megabytes (MB) of log files | <Cnt>.SetServer | | hMaxActivityStatisticsSize | Maximum size in megabytes (MB) of files for activity statistics | <Cnt>.SetServer | | hMmoSize | Memo file (".mmo") size in bytes | <Source>.InfoFile | | hNdxSize | Index file (".Ndx") size in bytes | <Source>.InfoFile | | hPageSize | Size of a block of caches. This block of caches will be used when looping through a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption. | HSetCache | | hTotalSize | Total file size in bytes (added size of data file, memo file and index file). | <Source>.InfoFile | | hTelemetryEnable | Configure the sending of data via the telemetry for the HFSQL server. | <Cnt>.SetServer | | hYield | For the UPDATE and DELETE queries performed on an important number of records, this constant is used to give control back to the other applications that use the files. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hSecondaryThread | Option for running the procedure: the procedure is run in a secondary thread. | HOnServerCall, <Source>.Track | | hActiveSyncFrame | The size of the frame is optimized to be used with Mobile devices. | HCS.FrameSize | | hDefaultFrame | The standard size will be used by default. | HCS.FrameSize | | hGPRSFrame | The frame size is optimized for a use via GPRS | HCS.FrameSize | | hInternetFrame | The frame size is optimized for a use via Internet | HCS.FrameSize | | hIntranetFrame | The frame size is optimized for a use via Intranet | HCS.FrameSize | | hWifiFrame | The frame size is optimized for a use via Wifi | HCS.FrameSize | | hTriggerBefore | Indicates the type of trigger: The procedure is run before the HFSQL function | HActivateTrigger,
HDeactivateTrigger,
<Source>.DeleteTrigger,
<Source>.DescribeTrigger | | hTriggerAfter | Indicates the type of trigger: The procedure is run after the HFSQL function | HActivateTrigger,
HDeactivateTrigger,
<Source>.DeleteTrigger,
<Source>.DescribeTrigger | | 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. | <Source>.RetrieveRecord | | hDefaultVal | The items of destination record that are not affected by the copy are initialized with their default value.
For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value. | <Source>.CopyRecord,
<Source>.ImportHF55,
<Source>.ImportText,
| | hMaxVal | Defines an upper bound for a filter | <Source>.BuildKeyValue,
<Source>.Filter,
<Source>.FilterStartsWith,
<Source>.FilterIncludedBetween | | hMinVal | Defines a lower bound for a filter | <Source>.BuildKeyValue,
<Source>.Filter,
<Source>.FilterStartsWith,
<Source>.FilterIncludedBetween | | hCheckDuplicates | Checks for duplicates for this operation, even if the duplicate check is disabled (<Source>.SetDuplicates) | <Source>.Add,
<HFSQL file>.ExecuteQuery,
<HFSQL file>.ExecuteSQLQuery,
<Source>.Modify | | hCheckIntegrity | Checks the integrity of operation even if the automatic integrity check is disabled (<Cnt>.SetIntegrity) | <Source>.Add,
<HFSQL file>.ExecuteQuery,
<HFSQL file>.ExecuteSQLQuery,
<Source>.Modify,
<HFSQL file>.Cross,
<Source>.Delete | | hCheckMemo | Standard reindexing with memo check and correction if necessary (used to retrieve the damaged memos) | <Source>.Index | | hViewAdd | Create a view with addition: Stores the content of the view next time <Source>.ExecuteView is called | <Source>.CreateView, <Source>.MergeView | | hViewLocking | Lock records read in the file and included in the view | <Source>.CreateView, <Source>.MergeView | | hViewDefault | Default creation of view | <Source>.CreateView, <Source>.MergeView | | hViewPostponed | The view is created but it will be run later by <Source>.ExecuteView | <Source>.CreateView, <Source>.MergeView | | hViewDistinct | Create view without duplicates with respect to the sort key | <Source>.CreateView, <Source>.MergeView | | hViewExclusive | Lock the entire source file to reduce the view creation time | <Source>.CreateView, <Source>.MergeView | | hViewBreakable | Interrupt view creation by pressing the ESC key | <Source>.CreateView | | hViewIntersection | Merge views with intersection: Common rows between the two specified views | <Source>.MergeView | | hViewJoin | Join between the first view and the second view. | <Source>.MergeView | | hViewSubtraction | Merge views with subtraction: Row of the first view without the common rows of the second view | <Source>.MergeView | | hViewUnion | Merging views: Merge the rows of the two specified views | <Source>.MergeView | | hViewUnionEx | Exclusive merge of views: Merge the non-common rows of the two specified views | <Source>.MergeView | | hWDL | The files are sought:- In the main WDL.
- In the WDL according to their load order, then on disk or in the specified WDL, then on disk.
- In the main WDL of the component.
- In the secondary WDLs of the component according to the load order.
| <Source>.ChangeLocation,
<Source>.Declare | | opCancel | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the code continues to run. | <Source>.OnError | | opEndProgram | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the program stops. Equivalent to the following line of code:
IF NOT <HFSQL function> THEN EndProgram() | <Source>.OnError | | opEndProcess | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the current process stops. Equivalent to the following line of code:
IF NOT <HFSQL function> THEN SetFocusAndReturnToUserInput() | <Source>.OnError | | opRetry | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
In this case, the function that triggered the error is re-run. | <Source>.OnError | | opRelaunchProgram | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The program stops and the application is automatically restarted. | <Source>.OnError |
This page is also available for…
|
|
|