Display constants used by prefixed syntaxes only The following constants are used to manage HFSQL data files: | | | | Constant | Affects | Used by the functions or properties | | eltProcedure | The listed element is a stored procedure | HListStoredElement | | eltQuery | The listed element is a query. | HListStoredElement | | eltSetOfProcedures | The listed element is a set of procedures | HListStoredElement |  Versions 15 and laterh3G New in version 15h3G | Type of network to simulate: 3G | HSimulateNetwork | | hAcceptOpenedFile | Allows you to read the source file that will be added to the memo if this source file is opened in write mode somewhere else. | HLinkMemo | | hAccessHF7 | Pseudo-connection to HFSQL Classic database. | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hAccessHFClientServer | Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hAccessJDBCMySQL | Access to a MySQL database via a JDBC driver | HDescribeConnection,
HOpenConnection | | hAccessJDBCSQLServer | Access to a SQL Server database via a JDBC driver | HDescribeConnection,
HOpenConnection | Versions 23 and laterhActiveDirectory New in version 23hActiveDirectory hActiveDirectory | Enable the authentication via Active Directory. | HSetServer | | hActiveSyncFrame | The size of the frame is optimized to be used with Mobile devices. | HCS.FrameSize | | hActivityStatisticsPath | Path of the directory containing the activity statistics | HSetServer | | hActivityStatisticsPeriod | Indicates the period (in second) between each backup of values for the different activity counters. | HSetServer | Versions 15 and laterhADSL New in version 15hADSL hADSL | Type of network to simulate: ADSL | HSimulateNetwork | | hAffectBrowse | Addition affecting the current browse | HAdd, HModify | | hAllowed | The relevant rights are granted to the user or group. | HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights | | hANSIFormat | Data format: Ansi format (used by Windows) | ..Format | | hApplication | Property of a database found on an HFSQL server: Name of the application from which the database was created. | HInfoDatabaseProperty, HInfoFileProperty | Versions 18 and laterhAutoStatisticalCalc New in version 18hAutoStatisticalCalc hAutoStatisticalCalc | Enable the automatic calculation of statistics for the data files (optimization of indexes). | HSetServer | Versions 15 and laterhBackgroundTask New in version 15hBackgroundTask hBackgroundTask | Perform the process in background task without locking the data file (available for the data files in Client/Server mode). | HStatCalculate,
HIndex | | hBackupCanceled | Status of backup: Backup canceled | HInfoBackup | | hBackupCompleted | Status of backup: Backup completed | HInfoBackup | Versions 15 and laterhBackupDifferential New in version 15hBackupDifferential hBackupDifferential | Type of backup: Differential backup | HInfoBackup | | hBackupError | Status of backup: Error during backup | HInfoBackup | Versions 15 and laterhBackupFull New in version 15hBackupFull hBackupFull | Type of backup: Full backup | HInfoBackup | | hBackupInProgress | Status of backup: Backup in progress | HInfoBackup | | hBoundSeparator | Used to separate the values of lower and upper bounds for the components of composite key | HFilterIncludedBetween | Versions 24 and laterhBrowsableNonBlocking New in version 24hBrowsableNonBlocking hBrowsableNonBlocking | Number of records in the view or query that can currently be browsed (no record locking). | HNbRec | Versions 21 and laterhCacheNbUnusedFiles New in version 21hCacheNbUnusedFiles hCacheNbUnusedFiles | Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server. | HSetServer | | hCardinality | Integrity constraints: Check the link cardinalities. | HSetIntegrity | | hChangeCharset | The character set defined by ChangeCharset will be taken into account in the new data file. The sorts, the searches, ... on string keys (strings, characters, date and time) will be performed according to this character set. | HCreation,
HCreationIfNotFound,
HIndex | | hCheckDuplicates | Checks for duplicates for this action, 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 | | hClientCursor | Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor | HDescribeConnection,
HOpenConnection | | hCompatible | The structures of the data files (defined in the analysis and found in the physical file) must be compatible. | HCheckStructure | | hComputer | Property of a database found on an HFSQL server: Name of the computer from which the element was created. | HInfoDatabaseProperty, HInfoFileProperty | | hCopyAutoId | Copies the automatic identifier while keeping its value | HCopyRecord, HImportHF55,
HImportText,
HImportXLS | | hCopyIfNotFound | Copies the data file only if it does not exist at the specified location on the destination computer. | HCopyFile | | hCopyIndex | Copies the index of the data file | HCopyFile | | hCorrespondence | Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions | HInfoLog | | hCreateIndex | The index of the data file is not copied. It is automatically re-created on the destination by re-indexing. | HCopyFile | | hCreator | Property of a database found on an HFSQL server: Name of database owner. | HInfoDatabaseProperty, HInfoFileProperty | Versions 24 and laterhCryptAES128 New in version 24hCryptAES128 hCryptAES128 | File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | Versions 19 and laterhCryptAuto New in version 19hCryptAuto hCryptAuto | File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptNo | No file encryption. | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptRC5_12 | The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptRC5_16 | The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptStandard | The memo file is encrypted according to an optimized encryption algorithm on 128 bits. | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCurrentRecNum | Number of the current record. | HFSQL functions | | hDaemonUser | User name that will be used by the server (Linux only) | HSetServer | | hData | Configure the file management: All the operations stored in the log file are applied to the existing file | HRegenerateFile | | hDatabasePath | Path of directory containing all databases | HSetServer | | hDate | Property of a database found on an HFSQL server: Creation date of the database. | HInfoDatabaseProperty, HInfoFileProperty | Versions 20 and laterhDateLastRefresh New in version 20hDateLastRefresh hDateLastRefresh | Requested information: Date of the last successful refresh for the materialized view. | HInfoView | | hDBASCII | Sort according to ASCII order | HDBSortType | | hDBLexicographic | Sort according to the lexicographic order | HDBSortType | | hDebuggingPort | Port used to debug the stored procedures and the server triggers. | HSetServer | | hDecreasing | Sort performed in descending order | ..SortType | | hDefault | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the values of the requested rights (in the same order). | HInfoDatabaseRights,
HInfoFileRights,
HInfoServerRights | | hDefaultFrame | The standard size will be used by default. | HCS.FrameSize | | hDefaultVal | The items of destination record that are not affected by the copy are initialized with their default value.
For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value. | HCopyRecord,
HImportHF55,
HImportText,
| | hDelayedOpening | Optimize the opening of existing files: If the file already exists, it will be opened during the first access to the file. The file is created if it does not exist. | HCreationIfNotFound | | hDeleteLog | Deletes the log file | HDeleteFile,
HDeleteDatabase | | hDestroyLink | Deletes all links related to the deleted data file. | HDeleteFile | | hDetails | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the rights and there value. | HInfoDatabaseRights,
HInfoFileRights,
HInfoServerRights | | hDisconnection | Configures the disconnection message | HOnServerCall | | hDisk | Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case | HChangeLocation,
HDeclare | | hDistinct | Management of duplicates during the browse: If duplicates are found when a browse is performed on a key item, a single record is browsed | HForward, HReadPrevious,
HReadNext, HPrevious,
HBackward, HNext | | hDuplicateKey | Characteristics of an item: Key with duplicates | ..KeyType | | hDynamicCursor | Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users. | HDescribeConnection,
HOpenConnection | | hEffective | The rights returned correspond to the rights that will be actually granted to the user or to the group on the database. The inherited rights are taken into account (rights granted to the groups to which the user belongs for example). | HInfoDatabaseRights,
HInfoFileRights,
HInfoServerRights | | hErrADO | Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant. | HErrorInfo | | hErrADOMessage | Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO) | HErrorInfo | | hErrAll | Customize all the errors | HOnError | | hErrBase | Type of information about the error to return: Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant | HErrorInfo | | hErrBaseMessage | Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase) | HErrorInfo | | hErrClientInfo | Information about the client layer used by the Native Connector that returned the error. | HErrorInfo | | hErrConnectionLoss | Customize the errors caused by a loss of connection with the server. | HOnError | | hErrCurrent | Type of information about the error to return: Number of the current error | HError | | hErrDatabaseAccess | Configure the access errors to an HFSQL Client/Server database. | HOnError | | hErrDebugInfo | Type of information about the error to return: Specific information for debugging the problem that occurred. This information should only be displayed and communicated on express demand from PC SOFT.
When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database. | HErrorInfo | | hErrDuplicates | Customize duplicate errors | HOnError | | hErrFIC | Type of information about the error to return: Full name of the data file associated with the error | HErrorInfo | | hErrFile | Type of information about the error to return: Logical name of data file associated with the error | HErrorInfo | | hErrFullDetails | Type of information about the error to return: Full error details (error line, current process, etc.)
Remark: Returns the same information as the one retrieved when clicking the "Copy" button in the error window of WLanguage. | HErrorInfo | | hErrIndex | Customize the reindexing errors (reindexing operation in progress during the access to the data file) | HOnError | | hErrIntegrity | Customize integrity errors | HOnError | | hErrItem | Type of information about the error to return: Name of item associated with the error | HErrorInfo | | hErrLink | Type of information about the error to return: Name of link associated with the error | HErrorInfo | | hErrLock | Customize lock errors | HOnError | | hErrLockInfo | Type of information about the error to return: Information about the lock | HErrorInfo | | hErrMain | Type of information about the error to return: Number of the main error | HError | | hErrMessage | Type of information about the error to return: Message associated with the error | HErrorInfo | | hErrMMO | Type of information about the error to return: Full name of the memo file associated with the error | HErrorInfo | | hErrModify | Customize a modification conflict | HOnError | | hErrNative | Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used | HErrorInfo | | hErrNativeMessage | Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector. | HErrorInfo | | hErrNDX | Type of information about the error to return: Full name of the index file associated with the error | HErrorInfo | | hErrNeedValue | Customize the errors caused by a mandatory input with no data (OLE DB only). | HOnError | | hErrOLEDB | Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection. | HErrorInfo | | hErrOLEDBMessage | Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB) | HErrorInfo | Versions 20 and laterhErrorLastRefresh New in version 20hErrorLastRefresh hErrorLastRefresh | Requested information: Last error while refreshing the materialized view. | HInfoView | | hErrPassword | Customize password errors | HOnError | Versions 20 and laterhErrPositionSQLError New in version 20hErrPositionSQLError hErrPositionSQLError | Type of information about the error to return: Position of the SQL error in the SQL code of the query run by HExecuteSQLQuery. | HErrorInfo | | hErrRecNum | Type of information about the error to return: Number of the record associated with the error | HErrorInfo | | hErrServer | Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error | HErrorInfo | | hErrServerInfo | Information about the server used by the Native Connector that returned the error. | HErrorInfo | | hErrSystemCode | Type of information about the error to return: Number of the associated system error | HErrorInfo | | hErrSystemMessage | Type of information about the error to return: Message of associated system error | HErrorInfo | | hErrWDD | Type of information about the error to return: Full name of the analysis file associated with the error | HErrorInfo | | hExisting | Type of search: Only the assignments for which a file actually exists | HListREP | | hExpBreakable | Mode for creating the export file: The export can be interrupted by pressing Esc.
If the export is interrupted, the export file is valid and it only contains the records exported before the interruption. | HExportXML
HExportJSON
HExportCSV
HExportXLS | | hExpCreation | Mode for creating the export file: The file is overwritten if it already exists. | HExportXML
HExportJSON
HExportCSV
HExportXLS | Versions 24 and laterhExpNoLineItemName New in version 24hExpNoLineItemName 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 | | hExpNormal | Mode for creating the export file: Standard operating mode | HExportXML
HExportJSON
HExportCSV
HExportXLS | | hExpWithoutXSL | The style sheet (".XSL" file) is not created | HExportXML | Versions 24 and laterhFalsifyTimestamp New in version 24hFalsifyTimestamp hFalsifyTimestamp | Management of Timestamp items: By default, a Timestamp item contains the date and time the record was created/modified. This constant is used to force the value of the Timestamp item with the value assigned to it (and not with the value calculated automatically). | HAdd, HModify | | hFicSize | Size of data file in bytes (".Fic" file) | HInfoFile | | hFileAS400 | Type of file: AS400 file | ..Type | | hFileClientServer | Type of file: HFSQL Client/Server file | ..Type | | hFileHF5 | Type of file: Hyper File 5 file | ..Type | | hFileMySQL | Type of file: MySQL file | ..Type | | hFileNormal | Type of file: Standard file (HFSQL Classic) | ..Type | | hFileOLEDB | Type of file: OLEDB file | ..Type | | hFileOracle | Type of file: ORACLE file | ..Type | | hFileOracleLite | Type of file: ORACLE Lite file | ..Type | | hFileOther | Type of file: Other type of file | ..Type | Versions 15 and laterhFilePostgreSQL New in version 15hFilePostgreSQL hFilePostgreSQL | Type of file: PostgreSQL file | ..Type | | hFileProgress | Type of file: Progress file | ..Type | | hFileQuery | Type of file: Query | ..Type | | hFileQueryAS400 | Type of file: Query on an AS/400 database | ..Type | | hFileQueryClientServer | Type of file: Query on an HFSQL Client/Server database | ..Type | | hFileQueryMySQL | Type of file: Query on a MySQL database | ..Type | | hFileQueryOLEDB | Type of file: Query on a database accessed via an OLE DB provider | ..Type | | hFileQueryOracle | Type of file: Query on an Oracle database | ..Type | | hFileQueryOracleLite | Type of file: Query on an Oracle Lite database | ..Type | Versions 15 and laterhFileQueryPostgreSQL New in version 15hFileQueryPostgreSQL hFileQueryPostgreSQL | Type of file: Query on a PostgreSQL database | ..Type | | hFileQueryProgress | Type of file: Query on a Progress database | ..Type | Versions 16 and laterhFileQuerySQLAzure New in version 16hFileQuerySQLAzure hFileQuerySQLAzure | Type of file: Query on an SQL Azure database | ..Type | | hFileQuerySQLServer | Type of file: Query on an SQL Server database | ..Type | | hFileQuerySQLServerMobile | Type of file: Query on an SQL Server Mobile database | ..Type | | hFileQuerySybase | Type of file: Query on a Sybase database | ..Type | | hFileQueryXML | Type of file: Query on an XML database | ..Type | | hFileSQL | Type of file: SQL file | ..Type | Versions 16 and laterhFileSQLAzure New in version 16hFileSQLAzure hFileSQLAzure | Type of file: SQL Azure file | ..Type | Versions 16 and laterhFileSQLite New in version 16hFileSQLite hFileSQLite | Type of file: SQLite file | ..Type | | hFileSQLServer | Type of file: SQL Server file | ..Type | | hFileSQLServerMobile | Type of file: SQL Server Mobile file | ..Type | | hFileSybase | Type of file: Sybase file | ..Type | | hFileTemporary | Type of file: Temporary file | ..Type | | hFileView | Type of file: HFSQL view | ..Type | | hFileXBase | Type of file: xBase file | ..Type | | hFileXML | Type of file: XML file | ..Type | Versions 22 and laterhFindKey New in version 22hFindKey hFindKey | Enable the search for keys on the HFSQL server. | HSetServer | | hForbidden | The relevant rights are not granted to the user or group | HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights | Versions 17 and laterhForwardOnly New in version 17hForwardOnly hForwardOnly | Native Connectors only: Used to speed up the browse of data during a simple browse that does not use the following features: - Reading the previous record.
- Modifying a record.
- Saving position.
If one of these features is used, the result may differ from the expected one.This constant can be used for example during a browse used to fill a memory Table control. | HReadLast,
HReadFirst,
HReadSeekFirst,
HReadSeekLast | | hForwardOnlyCursor | Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible. | HDescribeConnection,
HOpenConnection | Versions 20 and laterhftPunctuationSimple New in version 20hftPunctuationSimple hftPunctuationSimple | Full-text Index item described by programming: Taking into account the simple punctuation characters (non Unicode). | ..Option property of FullTextIndex description variables. | Versions 20 and laterhftPunctuationUnicode New in version 20hftPunctuationUnicode hftPunctuationUnicode | Full-text Index item described by programming: Taking into account the Unicode punctuation characters. | ..Option property of FullTextIndex description variables. | | hFTX | Reindexing full-text indexes | HIndex | | hFtxSize | Size of full-text index file in bytes (".Ftx" file) | HInfoFile | | HGeneric | Type of search: Generic search | HReadSeekLast,
HReadSeekFirst,
HSeekLast,
HSeekFirst | | hGPRSFrame | The frame size is optimized for a use via GPRS | HCS.FrameSize | | hHCreationIfNotFound | Type of test to run to check the connection: Checks the connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only. | HConnect | | hHOpen | Type of test to run to check the connection: Checks the connection by opening a file. This value is used by default when accessing to an hORead database. | HConnect | | hIdentical | The structures of files (read in the analysis and in the physical file) must be strictly identical. | HReadSeek, HSeek, HCheckStructure | | hIgnoreDuplicates | Ignores the duplicate check for this operation, 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 | | hImpBreakable | The import can be interrupted by pressing ESC. | HImportHF55,
HImportText,
HImportXLS,
HImportXML
HImportJSON | | hImpConversion | Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated. | HImportHF55 | | hImpCreation | Type of import: If the (HFSQL Classic) import file exists, it is overwritten. | HImportHF55,
HImportText,
HImportXLS,
HImportXML
HImportJSON | | hImpIgnoreEmptyItem | If one or more items are not filled in the text file, the corresponding lines are still imported.
The missing items contain:- the default value of items if the hDefaultVal constant is specified.
- the value of items in the current record before the call to HImportText.
| HImportText,
HImportXLS | Versions 20 and laterhImpIgnoreFirstLine New in version 20hImpIgnoreFirstLine hImpIgnoreFirstLine | Type of import: The first row of the imported file is ignored. | HImportText,
HImportXLS | | hImpIgnoreInvalidLine | Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing. | HImportText,
HImportXLS | | hImpIgnoreItem | Type of import: - The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value.
- The items of imported file (Hyper File 5.5) with no match in the import file are ignored.
| HImportHF55 | | hImpNoDelimiter | Type of import: The string separators (if they exist) are part of the item | HImportText | | hImpNormal | Type of import: The import is not performed and an error occurs in the following cases:- items found in the Hyper File 5.5 file with no match in the HFSQL Classic file.
- associated items in the two files but with a different size and/or format.
If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created.
No management of integrity and no management of duplicates.
The non-imported items take the value of the current record.
The automatic identifiers are recalculated. | HImportHF55,
HImportText,
HImportXLS,
HImportXML
HImportJSON | | hImpNoSpace | Type of import: The space characters found at the end of string are automatically deleted during the import | HImportHF55 | | hImpOEM2ANSI | Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility. | HImportText | | hImpTestDuplicates | Type of import: Checks the duplicates during the import | HImportHF55,
HImportText,
HImportXLS | | hImpTestIntegrity | Type of import: Checks the integrity during the import | HImportHF55,
HImportText,
| | hInaccessible | Undefined server status | HServerStatus | | hIncreasing | Sort performed in ascending order | ..SortType | | hInfiniteCardinality | Maximum cardinality ("N") | ..MaxLinkedCardinality, ..MaxSourceCardinality | | hInfoAll | Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate).
The different values are separated by CR characters (Carriage Return). | HInfoServer | Versions 15 and laterhInfoCluster New in version 15hInfoCluster hInfoCluster | Information about the HFSQL cluster. | HInfoServer | | hInfoDate | Date and time of server on 8 bytes in UTC format (universal time) | HInfoServer | Versions 22 and laterhInfoFreeDiskSpace New in version 22hInfoFreeDiskSpace hInfoFreeDiskSpace | Available space on the server disk, expressed in MB. | HInfoServer | | hInfoHardware | Information about the hardware used:- Type of processor (for example: Intel Pentium)
- Size of server RAM (for example: 630 MB)
This information is returned in the following format:
<Type of CPU> = TAB + <Size of server RAM> | HInfoServer | | hInfoLogicalName | Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center. | HInfoServer | | hInfoName | Name of server (DNS) | HInfoServer | | hInfoPlatform | Information about the server platform:- Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX
- System version: corresponds to Service Pack in Windows or empty string if no Service Pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example).
This information is returned in the following format:
<System name> + TAB + <Version> | HInfoServer | Versions 19 and laterhInfoSizeCacheNdxUsed New in version 19hInfoSizeCacheNdxUsed hInfoSizeCacheNdxUsed | Size of index cache that is actually used on the server, expressed in MB. | HInfoServer | Versions 22 and laterhInfoTotalDiskSpace New in version 22hInfoTotalDiskSpace hInfoTotalDiskSpace | Total capacity of server disk, expressed in MB. | HInfoServer | | hInfoVersion | Information about the version of programs required for the server to operate:- Version of Manta.exe or Manta in Linux
- Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | HInfoServer | | hInfoVersionDetails | Detailed information about the version of the programs required to operate the server:
<Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date>
The listed elements are as follows:- Manta.exe or Manta in Linux
- HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
- Management of logs (HFLogger.exe)
- MantaManager
- the framework required to operate the server.
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | HInfoServer | | hInfoVI | Version number of Manta.exe or Manta in Linux | HInfoServer | | hInherit | The user will inherit from the value of the rights granted to the group to which he belongs | HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights | | hIntegrityCascade | Modification/Deletion rule: Cascading modification/deletion | ..ModificationRule, ..DeletionRule | | hIntegrityDefaultValue | Modification/Deletion rule: Default modification/deletion | ..ModificationRule, ..DeletionRule | | hIntegrityForbidden | Modification/Deletion rule: Modification/Deletion not allowed | ..ModificationRule, ..DeletionRule | | hIntegrityNone | Modification/Deletion rule: No integrity management | ..ModificationRule, ..DeletionRule | | hInternetFrame | The frame size is optimized for a use via Internet | HCS.FrameSize | | hInternetPageSize | Size of page for using the RPC via Internet. | Remote access (RPC on HFSQL) | | hIntranetFrame | The frame size is optimized for a use via Intranet | HCS.FrameSize | | hIntranetPageSize | Size of page for using the RPC via Intranet. | Remote access (RPC on HFSQL) | | hInvalidRecNum | Constant returned if there is no current record or if the specified file corresponds to a multi-file query. | HRecNum | | hItemBinary | Item type: Binary | ..Type | | hItemBinaryMemo | Item type: Binary Memo | ..Type | | hItemBinaryMemo4 | Item type: Binary memo (4 bytes) | ..Type | | hItemBoolean | Item type: Boolean | ..Type | | hItemCharacter | Item type: Character | ..Type | Versions 20 and laterhItemCombination New in version 20hItemCombination hItemCombination | Item type: Combination | ..Type | | hItemCurrency | Item type: Currency | ..Type | | hItemDate6 | Item type: Date | ..Type | | hItemDate8 | Item type: Date | ..Type | | hItemDateTime | Item type: Date/Time | ..Type | Versions 20 and laterhItemEnumeration New in version 20hItemEnumeration hItemEnumeration | Item type: Enumeration | ..Type | | hItemHour | Item type: Hour | ..Type | | hItemIdAuto | Item type: Automatic identifier (8 bytes) | ..Type | | hItemIdAuto4 | Item type: Automatic identifier (4 bytes) | ..Type | | hItemInteger1 | Item type: 1-byte integer | ..Type | | hItemInteger2 | Item type: 2-byte integer | ..Type | | hItemInteger4 | Item type: 4-byte integer | ..Type | | hItemInteger8 | Item type: 8-byte integer | ..Type | | hItemInvalid | Invalid type of item | ..Type | Versions 24 and laterhItemJSON New in version 24hItemJSON hItemJSON | Item type: JSON | ..Type | | hItemNumeric | Item type: High-precision numeric | ..Type | | hItemNumRec | Item type: Record number | ..Type | | hItemPicture | Item type: Image | ..Type | | hItemReal4 | Item type: 4-byte real | ..Type | | hItemReal8 | Item type: 8-byte real | ..Type | | hItemRealTurbo | Item type: Turbo real | ..Type | | hItemText | Item type: Text | ..Type | | hItemTextMemo | Item type: Text Memo | ..Type | | hItemTimeLength | Item type: Duration | ..Type | | hItemUnicodeMemo | Item type: Unicode Text Memo | ..Type | | hItemUnicodeText | Item type: Unicode text | ..Type | | hItemUnsignedInteger1 | Item type: Unsigned 1-byte integer | ..Type | | hItemUnsignedInteger2 | Item type: Unsigned 2-byte integer | ..Type | | hItemUnsignedInteger4 | Item type: Unsigned 4-byte integer | ..Type | | hItemUnsignedInteger8 | Item type: Unsigned 4-byte integer | ..Type | Versions 24 and laterhItemUUID128 New in version 24hItemUUID128 hItemUUID128 | Item type: UUID 128 | ..Type | Versions 24 and laterhItemUUID128Auto New in version 24hItemUUID128Auto hItemUUID128Auto | Item type: UUID 128 automatic identifier | ..Type | Versions 24 and laterhItemUUID256 New in version 24hItemUUID256 hItemUUID256 | Item type: UUID 256 | ..Type | Versions 24 and laterhItemUUID256Auto New in version 24hItemUUID256Auto hItemUUID256Auto | Item type: UUID 256 automatic identifier | ..Type | | hJNLBackupPath | Path of the directory containing the backups of the logs | HSetServer | | hJNLPath | Path of the directory containing all the logs of the different HFSQL Client/Server applications | HSetServer | Versions 23 and laterhkaInterval New in version 23hkaInterval hkaInterval | Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client. | HSetServer | Versions 23 and laterhkaTimeout New in version 23hkaTimeout hkaTimeout | Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected. | HSetServer | | hKeepFilter | The 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 | | hKeepTRS | Stores the transaction files during the deletion | HDeleteDatabase,
HDeleteFile | Versions 17 and laterhLanguageBinarySort New in version 17hLanguageBinarySort 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, ..LanguageDescribed, H.LanguageCreationUnicode | | hLanguageCreation | Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation". | ..Language, ..LanguageDescribed | Versions 17 and laterhLanguageFastSort New in version 17hLanguageFastSort hLanguageFastSort | The sort will be performed by comparing the characters one by one according to a generic sort. | ..Language, ..LanguageDescribed, H.LanguageCreationUnicode | | hlbActive | Enable or disable the load balancing | HSetServer | | hlbClientCalls | Value modifying the coefficient applied to the counter for client calls | HSetServer | | hlbDisk | Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server | HSetServer | | hlbDiskAccess | Value modifying the coefficient applied to the counter for the number of disk accesses. | HSetServer | | hlbMaxTimeout | Value modifying the maximum time-out for a server request | HSetServer | | hlbReceived | Value modifying the coefficient applied to the counter for the bytes received by the server | HSetServer | | hlbSent | Value modifying the coefficient applied to the counter for the bytes sent by the server | HSetServer | | hLimitParsing | Limits the file browse: The browse will stop as soon as the last sought value is found. The current record will correspond to this last record found.
HFound will be set to False and HOut will be set to True.
This constant is used to optimize the search speed in client/server mode. | HReadSeek, HReadSeekLast, HReadSeekFirst, HSeek, HSeekLast, HSeekFirst | | hLockNo | Type of lock: No lock | HAdd, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, HModify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLockReadWrite | Type of lock: Lock in read/write | HAdd, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, HModify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLockWrite | Type of lock: Lock in write mode | HAdd, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, HModify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLogIdentification | Configures the file to re-create: Re-creates the "JournalIdentification.fic" file. | HLogRecreate | | hLogJNLFile | Configures the file to re-create: Only <File name>JNL.FIC is recreated. | HLogRecreate | | hLogLevel | Defines the elements that must be found in the log file | HSetServer | | hLogNo | Format of log process: No log | Log | | hLogOperation | Configures the file to re-create: Re-creates the "JournalOperation.fic" file. | HLogRecreate | | hLogPath | Path of the directory containing the log files | HSetServer | | hLogReadingWriting | Format of log process: Log the read and write operations performed in the file | ..LogMethod | | hLogUser | Configures the file to re-create: Re-creates the log of users ("UserLog.fic").
This file exists in HFSQL Client/Server only. This file contains the information (login, computer, ...) about the users who perform the logged actions. | HLogRecreate | | hLogWriting | Format of log process: Log the write operations performed in the file | ..LogMethod | Versions 20 and laterhlpBackup New in version 20hlpBackup hlpBackup | Type of scheduling to list: Scheduling of backups. | | Versions 22 and laterhlpCalcStat New in version 22hlpCalcStat hlpCalcStat | Type of operation performed on the server: statistical calculation. | Type hServerOperation | Versions 22 and laterhlpKeyDetection New in version 22hlpKeyDetection hlpKeyDetection | Type of operation performed on the server: detection of keys. | Type hServerOperation | Versions 20 and laterhlpMaterializedView New in version 20hlpMaterializedView hlpMaterializedView | Type of scheduling to list: Tasks for refreshing the materialized views. | | Versions 20 and laterhlpOptimization New in version 20hlpOptimization hlpOptimization | Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation). | | Versions 22 and laterhlpReplication New in version 22hlpReplication hlpReplication | Type of operation performed on the server: server replication. | Type hServerOperation | Versions 20 and laterhlpTask New in version 20hlpTask hlpTask | Type of scheduling to list: Scheduled tasks that run a stored procedure. | | | hLstAll | Lists all the keys, all the files, all the items or all the connections | HListKey, HListFile, HListItem, HListConnection,
HListStoredElement | | hLstCompositeKey | Lists the composite key items only | HListKey, HListItem | Versions 22 and laterhLstDatabaseSize New in version 22hLstDatabaseSize hLstDatabaseSize | List of connection databases as well as their size. | HListDatabase | | hLstDetail | Lists the detailed information | HListKey, HListFile,
HListLink, HListItem, HListConnection,
HListStoredElement | | hLstDetailPlus | For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part. | HListKey, HListItem | | hLstFile | Lists the databases and their files for the server defined by the connection | HListDatabase | | hLstItem | Lists the non-key and non-memo items | HListItem | | hLstKey | Lists the key items | HListKey, HListItem | | hLstLogicalOrder | Lists the items or the keys according to the logical order of items | HListKey, HListItem | Versions 20 and laterhLstMaterializedView New in version 20hLstMaterializedView hLstMaterializedView | Lists the materialized views found on an HFSQL server. | HListFile | | hLstMemo | Lists the memo items | HListItem | | hLstNormal | Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically. | HListKey, HListFile, HListItem, HListConnection | | hLstOpened | Stores the opened connections only | HListConnection | | hLstOriginalItem | Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file. | HListKey, HListItem | | hLstQuery | - Lists the queries found on a server
Versions 19 and laterLists the queries that have been run. New in version 19Lists the queries that have been run. Lists the queries that have been run.
| | | hLstSet | Lists the sets of procedures found on a server | HListStoredElement | | hLstSorted | Sorts the list of keys, files, items or connection in ascending order | HListKey, HListFile, HListItem, HListConnection | | hLstStoredProcedure | Lists the stored procedures of a connection via Native Connectors or OLE DB | HListFile,
HListStoredElement | | hLstSystemTable | List of system tables for a connection via Native Connectors or OLE DB | HListFile | | hLstTable | List of user tables for a connection via Native Connectors or OLE DB | HListFile | | hLstView | - List the views of a connection via Native Connectors or OLE DB.
Versions 20 and laterList the SQL views on an HFSQL server. New in version 20List the SQL views on an HFSQL server. List the SQL views on an HFSQL server.
| HListFile | | hMasterReplica | Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica) | ..Replication | | hMaxActivityStatisticsSize | Maximum size in megabytes (MB) of files for activity statistics | HSetServer | | hMaxLogSize | Maximum size in megabytes (MB) of log files | HSetServer | Versions 24 and laterhMaxNumberConnection New in version 24hMaxNumberConnection hMaxNumberConnection | Maximum number of connections allowed per application. | HSetServer | | hMaxVal | Defines an upper bound for a filter | HBuildKeyValue,
HFilter,
HFilterStartsWith,
HFilterIncludedBetween | | hMemoAuto | The memos are read during the access to the item | HSetMemo | | hMemoBin | Type of file used for the memo: Any binary file | HLinkMemo | | hMemoImg | Type of file used for the memo: Image file | HLinkMemo | | hMemoNo | No management of memos | HSetMemo | | hMemoOle | Type of file used for the memo: OLE file | HLinkMemo | | hMemoWav | Type of file used for the memo: sound file | HLinkMemo | | hMemoYes | The text memos are read whenever the record is read.
Read the binary memos when accessing the item. | HSetMemo | | hMessage | Configure the information message | HOnServerCall | | hMinVal | Defines a lower bound for a filter | HBuildKeyValue,
HFilter,
HFilterStartsWith,
HFilterIncludedBetween | Versions 20 and laterhMmoCompact New in version 20hMmoCompact hMmoCompact | Compression and defragmentation of "Mmo" files. | HIndex | | hMmoSize | Size of memo file in bytes (".Mmo" file) | HInfoFile | | hMode2GB | Indicates whether the system files support more than 2 GB | HSetServer | | hModeDirect | Priority implementation of locks | HMode | | hModeMono | Single-user lock mode | HMode | | hModeMulti | Multi-user lock mode | HMode | | hModeReservation | Non-priority implementation of locks | HMode | | hModifyFile | When modifying the query result, these modifications will be applied to the files belonging to the query.
If this option is not specified, only the query result is modified. | HExecuteQuery, HExecuteSQLQuery | Versions 17 and laterhmsBackgroundTask New in version 17hmsBackgroundTask hmsBackgroundTask | A hot automatic modification is performed (available for the HFSQL Client/Server data files only). | HModifyStructure | Versions 17 and laterhmsNoCheck New in version 17hmsNoCheck hmsNoCheck | The automatic data modification is performed even if the file description is more recent than the analysis description. | HModifyStructure | Versions 17 and laterhmsNormal New in version 17hmsNormal hmsNormal | Standard operating mode of the automatic data modification. | HModifyStructure | | hNativeAccessAS400 | Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessDB2 | OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessInformix | OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 20 and laterhNativeAccessMariaDB New in version 20hNativeAccessMariaDB 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, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessMySQL | OLE DB provider that will be used for the connection: Native MySQL Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessOracle | OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessOracleLite | Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessPostgreSQL | OLE DB provider that will be used for the connection: Native PostgreSQL Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessProgress | OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 16 and laterhNativeAccessSQLAzure New in version 16hNativeAccessSQLAzure hNativeAccessSQLAzure | OLE DB provider that will be used for the connection: Native SQL Azure Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 15 and laterhNativeAccessSQLite New in version 15hNativeAccessSQLite hNativeAccessSQLite | OLE DB provider that will be used for the connection: Native Connector to an SQLite database | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | 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, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | 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, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessSybase | OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessXBase | OLE DB provider that will be used for the connection: Native xBase Connector | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessXML | Provider that will be used for the connection: Native XML Connector (supplied with WINDEV/WEBDEV) | HConnect, HDeclareExternal,
HDescribeConnection, HListFile,
HOpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNdxCacheSize | Maximum size in megabytes (MB) of index cache | HSetServer | | hNdxCompact | Re-index operation with compression | HIndex | | hNdxDelete | Reindex and delete damaged records | HIndex | | hNdxMinimal | Re-index operation while ignoring the corrupted keys | HIndex | | hNdxNormal | Standard re-index operation | HIndex | | hNdxNoStat | Reindex without statistical calculation | HIndex | | hNdxSilent | Configure the re-index operation: No display while re-indexing | HIndex | | hNdxSize | Size of index file in bytes (".Ndx" file) | HInfoFile | | hNoBind | Run a query without enabling the bind | HExecuteQuery, HExecuteSQLQuery,
HPrepareSQLQuery | | hNoCheck | No check is performed, the analysis description may differ from the description of physical file. | HCheckStructure | | hNoError | No error occurred | HError | Versions 21 and laterhNoHourglass New in version 21hNoHourglass hNoHourglass | When reading the query result, this read operation may be locked and a hourglass appears by default. This constant is used not to display the hourglass in this case. | HExecuteQuery, HExecuteSQLQuery | | hNoIndex | The file index is not copied | HCopyFile | | hNoLink | Management of integrity: The links are not updated on the server (creation, modification or deletion).
Reminder: by default, the links are updated on the server when creating a file. | HCreation, HCreationIfNotFound | Versions 15 and laterhNone New in version 15hNone hNone | Used to disable the simulation of a specific network. | HSimulateNetwork | | hNoRefresh | The table or query content will not be refreshed | HLast, HReadLast, HReadFirst, HFirst | | hNotAKey | Characteristics of an item: Non-key item | ..KeyType | | hNotes | Property of a database found on an HFSQL server: Database description or any other information associated with the database by HModifyDatabaseProperty. | HInfoDatabaseProperty, HInfoFileProperty, HInfoServerProperty, HModifyDatabaseProperty, HModifyFileProperty, HModifyServerProperty | Versions 18 and laterhNotifCCClassic New in version 18hNotifCCClassic hNotifCCClassic | The notifications are sent by the Control Centers in HFSQL Classic mode. | HNotifConfigure | Versions 18 and laterhNotifCCCS New in version 18hNotifCCCS hNotifCCCS | The notifications are sent by the Control Centers in Client/Server mode. | HNotifConfigure | Versions 18 and laterhNotifCritical New in version 18hNotifCritical hNotifCritical | The notifications will be sent from the critical level (for the critical and error problems). | HNotifAddCCRecipient, HNotifAddEmailRecipient | Versions 18 and laterhNotifEmail New in version 18hNotifEmail hNotifEmail | The notifications are sent by email. | HNotifConfigure | Versions 18 and laterhNotifError New in version 18hNotifError hNotifError | The notifications will be sent for the error problems only. | HNotifAddCCRecipient, HNotifAddEmailRecipient | Versions 22 and laterhNotifInformation New in version 22hNotifInformation hNotifInformation | The notifications will be sent from the information level (for the information, warning, critical and error problems) | HNotifAddCCRecipient, HNotifAddEmailRecipient | Versions 18 and laterhNotifWarning New in version 18hNotifWarning hNotifWarning | The notifications will be sent from the warning level (for the warning, critical and error problems). | HNotifAddCCRecipient, HNotifAddEmailRecipient | | hNotLocking | Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To find out whether the execution of the view or query is completed, use ..ExecutionCompleted.
This constant is available for the views and queries in HFSQL Classic or Client/Server.
This constant has no effect for the data files and for the Native Connectors | hNbRec | | 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 | | hNotSorted | Sort direction: Item not sorted | ..SortType | | hODBC | OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Used to access an ODBC source declared in the ODBC data sources of Windows | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbAccess2000 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2000 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbAccess2007 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2007 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | Versions 19 and laterhOledbAccess2010 New in version 19hOledbAccess2010 hOledbAccess2010 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2010 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbAccess97 | OLE DB provider that will be used for the connection: OLE DB provider for Access 97 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbDBase5 | OLE DB provider that will be used for the connection: OLE DB provider for dBase 5 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbExcel2000 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbExcel2007 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbExcel97 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 97 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbLotus4 | OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbOracle | OLE DB provider that will be used for the connection: OLE DB provider for Oracle | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOledbSQLServer | OLE DB provider that will be used for the connection: OLE DB provider for SQL Server | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, HDeclareExternal, HListFile, HOpenConnection, SQLConnect | | hOnDelete | Integrity rule applied during a deletion | HSetIntegrity | | hOnUpdate | Integrity rule applied during a modification | HSetIntegrity | | hOpenKeysetCursor | Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions). | HDescribeConnection,
HOpenConnection | | hOptimisticCursor | The record is locked when it is updated | HDescribeConnection,
HOpenConnection | Versions 15 and laterhOptIndex New in version 15hOptIndex hOptIndex | Optimization options: Provokes the re-indexing operation on the data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes. | hFileParameter variable | Versions 15 and laterhOptStat New in version 15hOptStat hOptStat | Optimization options: Provokes the recalculation of statistics on the data files. | hFileParameter variable | | hORead | File accessible in read-only | ..CtAccess, ..CtDescribedAccess,
HConnect, HOpen | | hOReadWrite | File accessible in read/write | ..CtAccess, ..CtDescribedAccess,
HConnect, HOpen | | hOwner | Property of a database found on an HFSQL server: Owner of database. | HInfoDatabaseProperty, HInfoFileProperty, HModifyDatabaseProperty, HModifyFileProperty | | hPackNo | Compression mode: No compression | ..MmoPackMethod | | hPackZLW | Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation. | ..MmoPackMethod | | hPageSize | Size of a block of caches. This block of caches will be used when browsing a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption. | HSetCache | | hPessimisticCursor | The record is locked as soon as it becomes in edit to be modified. | HDescribeConnection,
HOpenConnection | | hPrecisionHigh | Position with high precision | HGetCurrentPosition, HSetPosition | | hPrecisionLow | Position with low precision | HGetCurrentPosition, HSetPosition | | hPrecisionMedium | Position with medium precision | HGetCurrentPosition, HSetPosition | | hQueryBreakable | The query initialization can be interrupted with the ESC key | HExecuteQuery, HExecuteSQLQuery | | hQueryDefault | The query is initialized without interruption | HExecuteQuery, HExecuteSQLQuery | | hQueryWithoutCorrection | Native Connector or OLE DB only:
No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.) | HExecuteQuery, HExecuteSQLQuery | | hQueryWithoutHFCorrection | HFSQL only
The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters. | HExecuteQuery, HExecuteSQLQuery | Versions 19 and laterhReadCommitted New in version 19hReadCommitted hReadCommitted | Isolation level of transaction: only the finalized transactions are visible by the other users. | HTransactionIsolation | | hReadOnlyCursor | The set of records cannot be modified. | HDescribeConnection,
HOpenConnection | Versions 19 and laterhReadUncommitted New in version 19hReadUncommitted hReadUncommitted | Isolation level of transaction: the non-finalized transactions are visible by the other users. | HTransactionIsolation | | hRecalculateIdAuto | Mode for calculating the automatic identifier: Automatic identifier re-calculated during the write operation | HWrite, HModify | | hRecFile | Record to read: Value of the item currently saved in the data file | HErrorModification, HErrorStatusModification | Versions 22 and laterhRecNumAll New in version 22hRecNumAll hRecNumAll | - Used to track all records found in a data file.
Versions 23 and laterUsed to check all unaltered records New in version 23Used to check all unaltered records Used to check all unaltered records
| | | hRecRead | Record to read: Value of the item for the source record | HErrorModification, HErrorStatusModification | | hRecUser | Record to read: Value of the item for the current record when performing the modification | HErrorModification, HErrorStatusModification | Versions 20 and laterhRefreshInProgress New in version 20hRefreshInProgress hRefreshInProgress | Requested information: Is the materialized view currently refreshed? | HInfoView | Versions 19 and laterhRepeatableRead New in version 19hRepeatableRead hRepeatableRead | Isolation level of transaction: the application in transaction sees a snapshot of the database when the transaction starts. | HTransactionIsolation | | hReplicated | Replication mode: The data file is configured to be replicated. | ..Replication | | hRightsAll | List of all the rights | HInfoDatabaseRights,
HInfoFileRights,
HInfoServerRights | | hRightsAutoModif | Rights to perform the automatic modification of the data files on a file | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsBackup | Rights to save the data files | HInfoDatabaseRights,
HInfoServerRights,
HModifyDatabaseRights,
HModifyServerRights | | hRightsChangeLink | Rights to modify the integrity rules on a data file. | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsChangeOwner | Rights to modify the owner of an element | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsChangePassword | Rights to change the password of a user on the server (the user can change his own password and the administrator can change the password of each user). | HInfoServerRights,
HModifyServerRights | | hRightsChangeRights | Rights to change rights. | HInfoDatabaseRights,
HInfoFileRights,
HInfoServerRights,
HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights | | hRightsConnection | Rights to connect to a server (encrypted or unencrypted connection) | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsCreateDB | Rights to create a database | HInfoServerRights,
HModifyServerRights | | hRightsCreateFile | Rights to create a data file (with HCreation) | HInfoDatabaseRights,
HModifyDatabaseRights | Versions 20 and laterhRightsCreateView New in version 20hRightsCreateView hRightsCreateView | Rights to create a SQL view or a materialized view. | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsDebug | Rights to debug the stored procedures. | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsDelete | Rights to delete the records from a data file | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsDeleteDB | Rights to delete a database | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsDeleteFile | Rights to delete a data file (HDeleteFile) | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | Versions 20 and laterhRightsDeleteView New in version 20hRightsDeleteView hRightsDeleteView | Rights to delete a SQL view or a materialized view. | HInfoViewRights, HModifyViewRights | | hRightsDisconnectClient | Rights to disconnect the client computers. | HInfoServerRights,
HModifyServerRights | | hRightsEncryptedConnection | Rights to connect to a server (encrypted connection only) | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsInsert | Rights to add new records into a data file. | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsLock | Rights to lock the data files or the records of a data file. | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsMaintenance | Rights to start a re-index operation or to perform statistical calculations on a data file | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsManageDuplicate | Rights to enable and disable the management of duplicates. | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsManageIntegrity | Rights to enable and disable the management of integrity. | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsManageProcedure | Rights to add, modify and delete the stored procedures. | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsManageServer | Rights to use HSetServer | HInfoServerRights,
HModifyServerRights | | hRightsManageTask | Rights to manage the scheduled tasks. | HInfoServerRights,
HModifyServerRights | | hRightsManageTrigger | Rights to manage the server triggers (addition, activation, deletion) | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsManageUser | Rights to delete and add users or groups | HInfoServerRights,
HModifyServerRights | | hRightsNoDatabaseAccess | Rights to prevent (or not) access to a database (HNoDatabaseAccess and HEndNoDatabaseAccess) | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsPriority | Rights to modify the priority of a client application | HInfoServerRights,
HModifyServerRights | | hRightsRead | Rights to read the records of a data file | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRightsReadLogStat | Rights to see the activity statistics and the logs of the server. | HInfoServerRights,
HModifyServerRights | | hRightsRunProcedure | Rights to run the stored procedures. | HInfoDatabaseRights,
HModifyDatabaseRights | | hRightsSeeUser | Rights to view the characteristics of a group or user. | HInfoServerRights,
HModifyServerRights | | hRightsSendMessageToClient | Rights to send messages to the client computers. | HInfoServerRights,
HModifyServerRights | Versions 18 and laterhRightsServerReplication New in version 18hRightsServerReplication hRightsServerReplication | Rights to define and perform a replication between two HFSQL servers. | HInfoServerRights,
HModifyServerRights | | hRightsStopServer | Rights to stop a server (HStopServer) | HInfoServerRights,
HModifyServerRights | | hRightsUpdate | Rights to modify the records of a data file | HInfoDatabaseRights,
HInfoFileRights,
HModifyDatabaseRights,
HModifyFileRights | | hRPDefault | Configure the restore operation: Position freed. The stored position is restored | HRestorePosition | | hRPFilter | Configure the restore operation: 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 | | hRPKeep | Configure the restore operation: Position not freed | HRestorePosition | Versions 22 and laterhrsCopy New in version 22hrsCopy hrsCopy | Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is locking. | HRSAddConfig | Versions 22 and laterhrsCopyBackgroundTask New in version 22hrsCopyBackgroundTask hrsCopyBackgroundTask | Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is performed in background task and it is not locking. | HRSAddConfig | Versions 22 and laterhrsNoCopy New in version 22hrsNoCopy hrsNoCopy | Configure the replication between servers: No copy is performed. | HRSAddConfig | Versions 22 and laterhsAdd New in version 22hsAdd hsAdd | Monitors the operations for adding records. | HTrack | | hSaveItems | Saves the values of items in memory when using HSavePosition. These values will be restored next time HRestorePosition is called. | HSavePosition | Versions 22 and laterhsCross New in version 22hsCross hsCross | Monitors the operations for crossing records. | HTrack | Versions 22 and laterhsDeletion New in version 22hsDeletion hsDeletion | Monitors the operations for deleting records. | HTrack | Versions 19 and laterhSecondaryThread New in version 19hSecondaryThread hSecondaryThread | Option for running the procedure: the procedure is run in a secondary thread. | HOnServerCall | | hServerCursor | Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data. | HDescribeConnection,
HOpenConnection | | hServerPort | Network port used | HSetServer | | hSetIdAuto | Mode for calculating the automatic identifier: Identifier value equals to the one stored during the 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 | Versions 22 and laterhsModification New in version 22hsModification hsModification | Monitors the operations for modifying records. | HTrack | Versions 20 and laterhSQLCode New in version 20hSQLCode hSQLCode | Requested information: SQL code of the materialized view | HInfoView | | hSQLUnicode | Used to specify that the query text must be sent in Unicode format to the server.
This constant is available in WINDEV Mobile only. | HExecuteSQLQuery | | hStarted | Server started | HServerStatus | | hStateActive | Status of the record/Type of record taken into account: Active record | HState, hNbRec, HErrorStatusModification | | hStateAll | Type of record: Total number of records in the data file | hNbRec | | hStateCrossed | Status of the record/Type of record taken into account: Crossed record | HState, hNbRec, HErrorStatusModification | | hStateDel | Status of the record/Type of record taken into account: Deleted record | HState, hNbRec, HErrorStatusModification | | hStateInvalid | Record status not found (error) | HState, HErrorStatusModification | | hStaticCursor | Makes a copy of all query records in memory (consumes a lot of memory). All types of moves are allowed. | HDescribeConnection,
HOpenConnection | | hStopped | Server stopped | HServerStatus | | hStructure | Configure the file management: New empty file created from the file description | HRegenerateFile | | hSubErrFirst | Type of error returned: Number of the first sub-error | HError | | hSubErrLast | Type of error returned: Number of the last sub-error | HError | | hSubErrNext | Type of error returned: Number of the previous sub-error | HError | | hSubErrPrevious | Type of error returned: Number of the previous sub-error | HError | | hSubscriberReplica | Replication mode: The data file is a subscriber replica (HCreateSubscriberReplica was used to create the subscriber replica) | ..Replication | Versions 22 and laterhTelemetryEnable New in version 22hTelemetryEnable hTelemetryEnable | Configure the sending of data via the telemetry for the HFSQL server. | HSetServer | Versions 17 and laterhTempDirectory New in version 17hTempDirectory hTempDirectory | Path of temporary directory. This directory is used to create the temporary files if necessary (temporary files created when re-indexing large data files for example). | HSetServer | | hTotalSize | Total file size in bytes (added size of data file, memo file and index file). | HInfoFile | | hTriggerAfter | Indicates the type of trigger: The procedure is run after the HFSQL function | HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger | | hTriggerBefore | Indicates the type of trigger: The procedure is run before the HFSQL function | HActivateTrigger, HDeactivateTrigger, HDeleteTrigger, HDescribeTrigger | Versions 21 and laterhtsCreation New in version 21htsCreation htsCreation | Type ot timestamp for the item: the item will store the creation date of record. | ..TimestampType | Versions 21 and laterhtsLastModification New in version 21htsLastModification htsLastModification | Type ot timestamp for the item: the item will store the date of last modification performed on the record. | ..TimestampType | Versions 21 and laterhtsNone New in version 21htsNone htsNone | Type ot timestamp for the item: the item is not a timestamp item. | ..TimestampType | | hUnicode | Used to retrieve the record value in Unicode format. | HRetrieveRecord | | hUNICODEFormat | Data format: UNICODE format | ..Format | | hUniqueKey | Characteristics of an item: Unique key | ..KeyType | | hViewAdd | Create a view with addition: Stores the view content next time HExecuteView is called | HCreateView, HMergeView | | hViewBreakable | The view creation can be interrupted by pressing the ESC key | HCreateView | | hViewDefault | Default creation of view | HCreateView, HMergeView | | hViewDistinct | The view is created without duplicates according to the sort key | HCreateView, HMergeView | | hViewExclusive | Optimizes the creation time of view by locking the entire source file | HCreateView, HMergeView | | hViewIntersection | Merge views with intersection: Common rows between the two specified views | HMergeView | | hViewJoin | Join between the first view and the second view. | HMergeView | | hViewLocking | The records read in the file and included in the view are locked | HCreateView, HMergeView | | hViewPostponed | The view is created but it will be run later by HExecuteView | HCreateView, HMergeView | | hViewSubtraction | Merge views with subtraction: Row of the first view without the common rows of the second view | HMergeView | | hViewUnion | Merging views: Merge the rows of the two specified views | HMergeView | | hViewUnionEx | Exclusive merge of views: Merge the non-common rows of the two specified views | HMergeView | | hWDL | The files are sought:- In the main WDL.
- In the WDL according to their load order, then on disk or in the specified WDL, then on disk.
- In the main WDL of the component.
- In the secondary WDLs of the component according to the load order.
| HChangeLocation,
HDeclare | | hWifiFrame | The frame size is optimized for a use via Wifi | HCS.FrameSize | Versions 19 and laterhWindowsDiskCacheSize New in version 19hWindowsDiskCacheSize hWindowsDiskCacheSize | Mode for managing the size of Windows disk cache. | HSetServer | | hWithFilter | If this parameter is specified: - the query result corresponds to a selection of filter records if the HFSQL engine allows it. Otherwise, the query result corresponds to an HFSQL view
- the following operations are not allowed: search on the query result, query on query, view on query, query on view.
- the browse items specified when browsing the result are ignored.
- the magnifier is not available for the tables linked to a query.
- hNbRec cannot be used on the queries.
If this parameter is not specified (by default): - the query result corresponds to an HFSQL view
- the following operations can be performed on the queries: search on the query result, query on query, view on query, query on view.
- the browse items specified when browsing the result are taken into account.
- the magnifier is available on tables linked to a query.
- hNbRec can be used on the queries.
| HExecuteQuery, HExecuteSQLQuery | | hWithTransaction | The query is run in a transaction. A transaction is started, the records are locked in read/write during the execution of the query and they are unlocked at the end of its execution, regardless of the result (failure or success).
If the query cannot end properly (locked records, power failure, etc.), the transaction is canceled and the data files are restored to their previous status (before the query execution).
Remark: The query execution may be slowed down. | HExecuteQuery, HExecuteSQLQuery | | hWriteDefault | Addition not affecting the current browse/Identifier re-used or calculated for the record | HAdd, HWrite, HModify | | hYield | For the UPDATE and DELETE queries performed on an important number of records, this constant is used to give control back to the other applications that use the files. | HExecuteQuery, HExecuteSQLQuery | Versions 20 and laterNoWait New in version 20NoWait NoWait | The refresh of materialized view is not a locking operation: it is performed in background task. HInfoView is used to find out the result of refresh performed on the materialized view. | HRefreshView | | opCancel | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the code continues to run. | HOnError | | opEndProcess | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the current process stops. Equivalent to the following code line:
IF NOT <HFSQL function> THEN ReturnToCapture() | HOnError | | opEndProgram | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the program stops. Equivalent to the following code line:
IF NOT <HFSQL function> THEN EndProgram() | HOnError | | opRelaunchProgram | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The program stops and the application is automatically restarted. | HOnError | | opRetry | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
In this case, the function that triggered the error is re-run. | HOnError |
Versions 23 and laterThe following constants are used to manage HFSQL data files (prefixed syntax): | | | | Constant | Affects | Used by the functions or properties | | eltProcedure | The listed element is a stored procedure | <Connection variable>.ListStoredElement | | eltQuery | The listed element is a query. | <Connection variable>.ListStoredElement | | eltSetOfProcedures | The listed element is a set of procedures | <Connection variable>.ListStoredElement | Versions 15 and laterh3G New in version 15h3G h3G | Type of network to simulate: 3G | <Connection variable>.SimulateNetwork | | hAcceptOpenedFile | Allows you to read the source file that will be added to the memo if this source file is opened in write mode somewhere else. | <Source>.LinkMemo | | hAccessHF7 | Pseudo-connection to HFSQL Classic database. | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hAccessHFClientServer | Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hAccessJDBCMySQL | Access to a MySQL database via a JDBC driver | HDescribeConnection,
<Connection variable>.OpenConnection | | hAccessJDBCSQLServer | Access to a SQL Server database via a JDBC driver | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 23 and laterhActiveDirectory New in version 23hActiveDirectory hActiveDirectory | Enable the authentication via Active Directory. | <Connection variable>.SetServer | | hActiveSyncFrame | The size of the frame is optimized to be used with Mobile devices. | HCS.FrameSize | | hActivityStatisticsPath | Path of the directory containing the activity statistics | <Connection variable>.SetServer | | hActivityStatisticsPeriod | Indicates the period (in second) between each backup of values for the different activity counters. | <Connection variable>.SetServer | Versions 15 and laterhADSL New in version 15hADSL hADSL | Type of network to simulate: ADSL | <Connection variable>.SimulateNetwork | | hAffectBrowse | Addition affecting the current browse | <Source>.Add, <Source>.Modify | | hAllowed | The relevant rights are granted to the user or group. | HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights | | hANSIFormat | Data format: Ansi format (used by Windows) | ..Format | | hApplication | Property of a database found on an HFSQL server: Name of the application from which the database was created. | HInfoDatabaseProperty, HInfoFileProperty | Versions 18 and laterhAutoStatisticalCalc New in version 18hAutoStatisticalCalc hAutoStatisticalCalc | Enable the automatic calculation of statistics for the data files (optimization of indexes). | <Connection variable>.SetServer | Versions 15 and laterhBackgroundTask New in version 15hBackgroundTask hBackgroundTask | Perform the process in background task without locking the data file (available for the data files in Client/Server mode). | <Source>.StatCalculate,
<Source>.Index | | hBackupCanceled | Status of backup: Backup canceled | <Connection variable>.InfoBackup | | hBackupCompleted | Status of backup: Backup completed | <Connection variable>.InfoBackup | Versions 15 and laterhBackupDifferential New in version 15hBackupDifferential hBackupDifferential | Type of backup: Differential backup | <Connection variable>.InfoBackup | | hBackupError | Status of backup: Error during backup | <Connection variable>.InfoBackup | Versions 15 and laterhBackupFull New in version 15hBackupFull hBackupFull | Type of backup: Full backup | <Connection variable>.InfoBackup | | hBackupInProgress | Status of backup: Backup in progress | <Connection variable>.InfoBackup | | hBoundSeparator | Used to separate the values of lower and upper bounds for the components of composite key | <Source>.FilterIncludedBetween | Versions 21 and laterhCacheNbUnusedFiles New in version 21hCacheNbUnusedFiles hCacheNbUnusedFiles | Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server. | <Connection variable>.SetServer | | hCardinality | Integrity constraints: Check the link cardinalities. | <Connection variable>.SetIntegrity | | hChangeCharset | The character set defined by ChangeCharset will be taken into account in the new data file. The sorts, the searches, ... on string keys (strings, characters, date and time) will be performed according to this character set. | <Source>.Creation,
<Source>.CreationIfNotFound,
<Source>.Index | | hCheckDuplicates | Checks for duplicates for this action, 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 (<Connection variable>.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 | | hClientCursor | Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor | HDescribeConnection,
<Connection variable>.OpenConnection | | hCompatible | The structures of the data files (defined in the analysis and found in the physical file) must be compatible. | <Source>.CheckStructure | | hComputer | Property of a database found on an HFSQL server: Name of the computer from which the element was created. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty | | hCopyAutoId | Copies the automatic identifier while keeping its value | <Source>.CopyRecord,
<Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS | | hCopyIfNotFound | Copies the data file only if it does not exist at the specified location on the destination computer. | <Connection variable>.CopyFile | | hCopyIndex | Copies the index of the data file | <Connection variable>.CopyFile | | hCorrespondence | Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions | HInfoLog | | hCreateIndex | The index of the data file is not copied. It is automatically recreated at the destination by reindexing. | <Connection variable>.CopyFile | | hCreator | Property of a database found on an HFSQL server: Name of database owner. | <Connection variable>.InfoDatabaseProperty,
<Connection variable>.InfoFileProperty | Versions 24 and laterhCryptAES128 New in version 24hCryptAES128 hCryptAES128 | File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | Versions 19 and laterhCryptAuto New in version 19hCryptAuto hCryptAuto | File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptNo | No file encryption. | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptRC5_12 | The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptRC5_16 | The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptStandard | The memo file is encrypted according to an optimized encryption algorithm on 128 bits. | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCurrentRecNum | Number of the current record. | HFSQL functions | | hDaemonUser | User name that will be used by the server (Linux only) | <Connection variable>.SetServer | | hData | Configure the file management: All the operations stored in the log file are applied to the existing file | <Connection variable>.RegenerateFile | | hDatabasePath | Path of directory containing all databases | <Connection variable>.SetServer | | hDate | Property of a database found on an HFSQL server: Creation date of the database. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty | Versions 20 and laterhDateLastRefresh New in version 20hDateLastRefresh hDateLastRefresh | Requested information: Date of the last successful refresh for the materialized view. | <Connection variable>.InfoView | | hDBASCII | Sort according to ASCII order | HDBSortType | | hDBLexicographic | Sort according to the lexicographic order | HDBSortType | | hDebuggingPort | Port used to debug the stored procedures and the server triggers. | <Connection variable>.SetServer | | hDecreasing | Sort performed in descending order | ..SortType | | hDefault | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the values of the requested rights (in the same order). | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights | | hDefaultFrame | The standard size will be used by default. | HCS.FrameSize | | hDefaultVal | The items of destination record that are not affected by the copy are initialized with their default value.
For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value. | <Source>.CopyRecord,
<Source>.ImportHF55,
<Source>.ImportText,
| | hDelayedOpening | Optimize the opening of existing files: If the file already exists, it will be opened during the first access to the file. The file is created if it does not exist. | <Source>.CreationIfNotFound | | hDeleteLog | Deletes the log file | <Connection variable>.DeleteFile,
<Connection variable>.DeleteDatabase | | hDestroyLink | Deletes all links related to the deleted data file. | <Connection variable>.DeleteFile | | hDetails | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the rights and there value. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights | | hDisconnection | Configures the disconnection message | HOnServerCall | | hDisk | Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case | <Source>.ChangeLocation,
<Source>.Declare | | hDistinct | Management of duplicates during the browse: If duplicates are found when a browse is performed on a key item, a single record is browsed | <Source>.Forward, <Source>.ReadPrevious,
<Source>.ReadNext, <Source>.Previous,
<Source>.Backward, <Source>.Next | | hDuplicateKey | Characteristics of an item: Key with duplicates | ..KeyType | | hDynamicCursor | Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users. | HDescribeConnection,
<Connection variable>.OpenConnection | | hEffective | The rights returned correspond to the rights that will be actually granted to the user or to the group on the database. The inherited rights are taken into account (rights granted to the groups to which the user belongs for example). | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights | | hErrADO | Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant. | HErrorInfo | | hErrADOMessage | Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO) | HErrorInfo | | hErrAll | Customize all the errors | <Source>.OnError | | hErrBase | Type of information about the error to return: Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant | HErrorInfo | | hErrBaseMessage | Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase) | HErrorInfo | | hErrClientInfo | Information about the client layer used by the Native Connector that returned the error. | HErrorInfo | | hErrConnectionLoss | Customize the errors caused by a loss of connection with the server. | <Source>.OnError | | hErrCurrent | Type of information about the error to return: Number of the current error | HError | | hErrDatabaseAccess | Configure the access errors to an HFSQL Client/Server database. | <Source>.OnError | | hErrDebugInfo | Type of information about the error to return: Specific information for debugging the problem that occurred. This information should only be displayed and communicated on express demand from PC SOFT.
When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database. | HErrorInfo | | hErrDuplicates | Customize duplicate errors | <Source>.OnError | | hErrFIC | Type of information about the error to return: Full name of the data file associated with the error | HErrorInfo | | hErrFile | Type of information about the error to return: Logical name of data file associated with the error | HErrorInfo | | hErrFullDetails | Type of information about the error to return: Full error details (error line, current process, etc.)
Remark: Returns the same information as the one retrieved when clicking the "Copy" button in the error window of WLanguage. | HErrorInfo | | hErrIndex | Customize the reindexing errors (reindexing operation in progress during the access to the data file) | <Source>.OnError | | hErrIntegrity | Customize integrity errors | <Source>.OnError | | hErrItem | Type of information about the error to return: Name of item associated with the error | HErrorInfo | | hErrLink | Type of information about the error to return: Name of link associated with the error | HErrorInfo | | hErrLock | Customize lock errors | <Source>.OnError | | hErrLockInfo | Type of information about the error to return: Information about the lock | HErrorInfo | | hErrMain | Type of information about the error to return: Number of the main error | HError | | hErrMessage | Type of information about the error to return: Message associated with the error | HErrorInfo | | hErrMMO | Type of information about the error to return: Full name of the memo file associated with the error | HErrorInfo | | hErrModify | Customize a modification conflict | <Source>.OnError | | hErrNative | Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used | HErrorInfo | | hErrNativeMessage | Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector. | HErrorInfo | | hErrNDX | Type of information about the error to return: Full name of the index file associated with the error | HErrorInfo | | hErrNeedValue | Customize the errors caused by a mandatory input with no data (OLE DB only). | <Source>.OnError | | hErrOLEDB | Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection. | HErrorInfo | | hErrOLEDBMessage | Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB) | HErrorInfo | Versions 20 and laterhErrorLastRefresh New in version 20hErrorLastRefresh hErrorLastRefresh | Requested information: Last error while refreshing the materialized view. | <Connection variable>.InfoView | | hErrPassword | Customize password errors | <Source>.OnError | Versions 20 and laterhErrPositionSQLError New in version 20hErrPositionSQLError hErrPositionSQLError | Type of information about the error to return: Position of the SQL error in the SQL code of the query run by <HFSQL file>.ExecuteSQLQuery. | HErrorInfo | | hErrRecNum | Type of information about the error to return: Number of the record associated with the error | HErrorInfo | | hErrServer | Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error | HErrorInfo | | hErrServerInfo | Information about the server used by the Native Connector that returned the error. | HErrorInfo | | hErrSystemCode | Type of information about the error to return: Number of the associated system error | HErrorInfo | | hErrSystemMessage | Type of information about the error to return: Message of associated system error | HErrorInfo | | hErrWDD | Type of information about the error to return: Full name of the analysis file associated with the error | HErrorInfo | | hExisting | Type of search: Only the assignments for which a file actually exists | HListREP | | hExpBreakable | Mode for creating the export file: The export can be interrupted by pressing Esc.
If the export is interrupted, the export file is valid and it only contains the records exported before the interruption. | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | | hExpCreation | Mode for creating the export file: The file is overwritten if it already exists. | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | Versions 24 and laterhExpNoLineItemName New in version 24hExpNoLineItemName 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 | | hExpNormal | Mode for creating the export file: Standard operating mode | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | | hExpWithoutXSL | The style sheet (".XSL" file) is not created | <Source>.ExportXML | | hFicSize | Size of data file in bytes (".Fic" file) | <Source>.InfoFile | | hFileAS400 | Type of file: AS400 file | ..Type | | hFileClientServer | Type of file: HFSQL Client/Server file | ..Type | | hFileHF5 | Type of file: Hyper File 5 file | ..Type | | hFileMySQL | Type of file: MySQL file | ..Type | | hFileNormal | Type of file: Standard file (HFSQL Classic) | ..Type | | hFileOLEDB | Type of file: OLEDB file | ..Type | | hFileOracle | Type of file: ORACLE file | ..Type | | hFileOracleLite | Type of file: ORACLE Lite file | ..Type | | hFileOther | Type of file: Other type of file | ..Type | Versions 15 and laterhFilePostgreSQL New in version 15hFilePostgreSQL hFilePostgreSQL | Type of file: PostgreSQL file | ..Type | | hFileProgress | Type of file: Progress file | ..Type | | hFileQuery | Type of file: Query | ..Type | | hFileQueryAS400 | Type of file: Query on an AS/400 database | ..Type | | hFileQueryClientServer | Type of file: Query on an HFSQL Client/Server database | ..Type | | hFileQueryMySQL | Type of file: Query on a MySQL database | ..Type | | hFileQueryOLEDB | Type of file: Query on a database accessed via an OLE DB provider | ..Type | | hFileQueryOracle | Type of file: Query on an Oracle database | ..Type | | hFileQueryOracleLite | Type of file: Query on an Oracle Lite database | ..Type | Versions 15 and laterhFileQueryPostgreSQL New in version 15hFileQueryPostgreSQL hFileQueryPostgreSQL | Type of file: Query on a PostgreSQL database | ..Type | | hFileQueryProgress | Type of file: Query on a Progress database | ..Type | Versions 16 and laterhFileQuerySQLAzure New in version 16hFileQuerySQLAzure hFileQuerySQLAzure | Type of file: Query on an SQL Azure database | ..Type | | hFileQuerySQLServer | Type of file: Query on an SQL Server database | ..Type | | hFileQuerySQLServerMobile | Type of file: Query on an SQL Server Mobile database | ..Type | | hFileQuerySybase | Type of file: Query on a Sybase database | ..Type | | hFileQueryXML | Type of file: Query on an XML database | ..Type | | hFileSQL | Type of file: SQL file | ..Type | Versions 16 and laterhFileSQLAzure New in version 16hFileSQLAzure hFileSQLAzure | Type of file: SQL Azure file | ..Type | Versions 16 and laterhFileSQLite New in version 16hFileSQLite hFileSQLite | Type of file: SQLite file | ..Type | | hFileSQLServer | Type of file: SQL Server file | ..Type | | hFileSQLServerMobile | Type of file: SQL Server Mobile file | ..Type | | hFileSybase | Type of file: Sybase file | ..Type | | hFileTemporary | Type of file: Temporary file | ..Type | | hFileView | Type of file: HFSQL view | ..Type | | hFileXBase | Type of file: xBase file | ..Type | | hFileXML | Type of file: XML file | ..Type | Versions 22 and laterhFindKey New in version 22hFindKey hFindKey | Enable the search for keys on the HFSQL server. | <Connection variable>.SetServer | | hForbidden | The relevant rights are not granted to the user or group | <Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights,
<Connection variable>.ModifyServerRights | Versions 17 and laterhForwardOnly New in version 17hForwardOnly hForwardOnly | Native Connectors only: Used to speed up the browse of data during a simple browse that does not use the following features: - Reading the previous record.
- Modifying a record.
- Saving position.
If one of these features is used, the result may differ from the expected one.This constant can be used for example during a browse used to fill a memory Table control. | <Source>.ReadLast,
<Source>.ReadFirst,
<Source>.ReadSeekFirst,
<Source>.ReadSeekLast | | hForwardOnlyCursor | Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible. | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 20 and laterhftPunctuationSimple New in version 20hftPunctuationSimple hftPunctuationSimple | Full-text Index item described by programming: Taking into account the simple punctuation characters (non Unicode). | ..Option property of FullTextIndex description variables. | Versions 20 and laterhftPunctuationUnicode New in version 20hftPunctuationUnicode hftPunctuationUnicode | Full-text Index item described by programming: Taking into account the Unicode punctuation characters. | ..Option property of FullTextIndex description variables. | | hFTX | Reindexing full-text indexes | <Source>.Index | | hFtxSize | Size of full-text index file in bytes (".Ftx" file) | <Source>.InfoFile | | HGeneric | Type of search: Generic search | <Source>.ReadSeekLast,
<Source>.ReadSeekFirst,
<Source>.SeekLast,
<Source>.SeekFirst | | hGPRSFrame | The frame size is optimized for a use via GPRS | HCS.FrameSize | | hHCreationIfNotFound | Type of test to run to check the connection: Checks the connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only. | HConnect | | hHOpen | Type of test to run to check the connection: Checks the connection by opening a file. This value is used by default when accessing to an hORead database. | HConnect | | hIdentical | The structures of files (read in the analysis and in the physical file) must be strictly identical. | <Source>.ReadSeek, <Source>.Seek, <Source>.CheckStructure | | hIgnoreDuplicates | Ignores the duplicate check for this operation, 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 (<Connection variable>.SetIntegrity) | <Source>.Add, <Source>.Modify, <Source>.Delete, <HFSQL file>.Cross | | hImpBreakable | The import can be interrupted by pressing ESC. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpConversion | Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated. | <Source>.ImportHF55 | | hImpCreation | Type of import: If the (HFSQL Classic) import file exists, it is overwritten. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpIgnoreEmptyItem | If one or more items are not filled in the text file, the corresponding lines are still imported.
The missing items contain:- the default value of items if the hDefaultVal constant is specified.
- the value of items in the current record before the call to <Source>.ImportText.
| <Source>.ImportText,
<Source>.ImportXLS | Versions 20 and laterhImpIgnoreFirstLine New in version 20hImpIgnoreFirstLine hImpIgnoreFirstLine | Type of import: The first row of the imported file is ignored. | <Source>.ImportText,
<Source>.ImportXLS | | hImpIgnoreInvalidLine | Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing. | <Source>.ImportText,
<Source>.ImportXLS | | hImpIgnoreItem | Type of import: - The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value.
- The items of imported file (Hyper File 5.5) with no match in the import file are ignored.
| <Source>.ImportHF55 | | hImpNoDelimiter | Type of import: The string separators (if they exist) are part of the item | <Source>.ImportText | | hImpNormal | Type of import: The import is not performed and an error occurs in the following cases:- items found in the Hyper File 5.5 file with no match in the HFSQL Classic file.
- associated items in the two files but with a different size and/or format.
If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created.
No management of integrity and no management of duplicates.
The non-imported items take the value of the current record.
The automatic identifiers are recalculated. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpNoSpace | Type of import: The space characters found at the end of string are automatically deleted during the import | <Source>.ImportHF55 | | hImpOEM2ANSI | Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility. | <Source>.ImportText | | hImpTestDuplicates | Type of import: Checks the duplicates during the import | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS | | hImpTestIntegrity | Type of import: Checks the integrity during the import | <Source>.ImportHF55,
<Source>.ImportText,
| | hInaccessible | Undefined server status | HServerStatus | | hIncreasing | Sort performed in ascending order | ..SortType | | hInfiniteCardinality | Maximum cardinality ("N") | ..MaxLinkedCardinality, ..MaxSourceCardinality | | hInfoAll | Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate).
The different values are separated by CR characters (Carriage Return). | <Connection variable>.InfoServer | Versions 15 and laterhInfoCluster New in version 15hInfoCluster hInfoCluster | Information about the HFSQL cluster. | <Connection variable>.InfoServer | | hInfoDate | Date and time of server on 8 bytes in UTC format (universal time) | <Connection variable>.InfoServer | Versions 22 and laterhInfoFreeDiskSpace New in version 22hInfoFreeDiskSpace hInfoFreeDiskSpace | Available space on the server disk, expressed in MB. | <Connection variable>.InfoServer | | hInfoHardware | Information about the hardware used:- Type of processor (for example: Intel Pentium)
- Size of server RAM (for example: 630 MB)
This information is returned in the following format:
<Type of CPU> = TAB + <Size of server RAM> | <Connection variable>.InfoServer | | hInfoLogicalName | Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center. | <Connection variable>.InfoServer | | hInfoName | Name of server (DNS) | <Connection variable>.InfoServer | | hInfoPlatform | Information about the server platform:- Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX
- System version: corresponds to Service Pack in Windows or empty string if no Service Pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example).
This information is returned in the following format:
<System name> + TAB + <Version> | <Connection variable>.InfoServer | Versions 19 and laterhInfoSizeCacheNdxUsed New in version 19hInfoSizeCacheNdxUsed hInfoSizeCacheNdxUsed | Size of index cache that is actually used on the server, expressed in MB. | <Connection variable>.InfoServer | Versions 22 and laterhInfoTotalDiskSpace New in version 22hInfoTotalDiskSpace hInfoTotalDiskSpace | Total capacity of server disk, expressed in MB. | <Connection variable>.InfoServer | | hInfoVersion | Information about the version of programs required for the server to operate:- Version of Manta.exe or Manta in Linux
- Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | <Connection variable>.InfoServer | | hInfoVersionDetails | Detailed information about the version of the programs required to operate the server:
<Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date>
The listed elements are as follows:- Manta.exe or Manta in Linux
- HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
- Management of logs (HFLogger.exe)
- MantaManager
- the framework required to operate the server.
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | <Connection variable>.InfoServer | | hInfoVI | Version number of Manta.exe or Manta in Linux | <Connection variable>.InfoServer | | hInherit | The user will inherit from the value of the rights granted to the group to which he belongs | <Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights,
<Connection variable>.ModifyServerRights | | hIntegrityCascade | Modification/Deletion rule: Cascading modification/deletion | ..ModificationRule, ..DeletionRule | | hIntegrityDefaultValue | Modification/Deletion rule: Default modification/deletion | ..ModificationRule, ..DeletionRule | | hIntegrityForbidden | Modification/Deletion rule: Modification/Deletion not allowed | ..ModificationRule, ..DeletionRule | | hIntegrityNone | Modification/Deletion rule: No integrity management | ..ModificationRule, ..DeletionRule | | hInternetFrame | The frame size is optimized for a use via Internet | HCS.FrameSize | | hInternetPageSize | Size of page for using the RPC via Internet. | Remote access (RPC on HFSQL) | | hIntranetFrame | The frame size is optimized for a use via Intranet | HCS.FrameSize | | hIntranetPageSize | Size of page for using the RPC via Intranet. | Remote access (RPC on HFSQL) | | hInvalidRecNum | Constant returned if there is no current record or if the specified file corresponds to a multi-file query. | <Source>.RecNum | | hItemBinary | Item type: Binary | ..Type | | hItemBinaryMemo | Item type: Binary Memo | ..Type | | hItemBinaryMemo4 | Item type: Binary memo (4 bytes) | ..Type | | hItemBoolean | Item type: Boolean | ..Type | | hItemCharacter | Item type: Character | ..Type | Versions 20 and laterhItemCombination New in version 20hItemCombination hItemCombination | Item type: Combination | ..Type | | hItemCurrency | Item type: Currency | ..Type | | hItemDate6 | Item type: Date | ..Type | | hItemDate8 | Item type: Date | ..Type | | hItemDateTime | Item type: Date/Time | ..Type | Versions 20 and laterhItemEnumeration New in version 20hItemEnumeration hItemEnumeration | Item type: Enumeration | ..Type | | hItemHour | Item type: Hour | ..Type | | hItemIdAuto | Item type: Automatic identifier (8 bytes) | ..Type | | hItemIdAuto4 | Item type: Automatic identifier (4 bytes) | ..Type | | hItemInteger1 | Item type: 1-byte integer | ..Type | | hItemInteger2 | Item type: 2-byte integer | ..Type | | hItemInteger4 | Item type: 4-byte integer | ..Type | | hItemInteger8 | Item type: 8-byte integer | ..Type | | hItemInvalid | Invalid type of item | ..Type | Versions 24 and laterhItemJSON New in version 24hItemJSON hItemJSON | Item type: JSON | ..Type | | hItemNumeric | Item type: High-precision numeric | ..Type | | hItemNumRec | Item type: Record number | ..Type | | hItemPicture | Item type: Image | ..Type | | hItemReal4 | Item type: 4-byte real | ..Type | | hItemReal8 | Item type: 8-byte real | ..Type | | hItemRealTurbo | Item type: Turbo real | ..Type | | hItemText | Item type: Text | ..Type | | hItemTextMemo | Item type: Text Memo | ..Type | | hItemTimeLength | Item type: Duration | ..Type | | hItemUnicodeMemo | Item type: Unicode Text Memo | ..Type | | hItemUnicodeText | Item type: Unicode text | ..Type | | hItemUnsignedInteger1 | Item type: Unsigned 1-byte integer | ..Type | | hItemUnsignedInteger2 | Item type: Unsigned 2-byte integer | ..Type | | hItemUnsignedInteger4 | Item type: Unsigned 4-byte integer | ..Type | | hItemUnsignedInteger8 | Item type: Unsigned 4-byte integer | ..Type | Versions 24 and laterhItemUUID128 New in version 24hItemUUID128 hItemUUID128 | Item type: UUID 128 | ..Type | Versions 24 and laterhItemUUID128Auto New in version 24hItemUUID128Auto hItemUUID128Auto | Item type: UUID 128 automatic identifier | ..Type | Versions 24 and laterhItemUUID256 New in version 24hItemUUID256 hItemUUID256 | Item type: UUID 256 | ..Type | Versions 24 and laterhItemUUID256Auto New in version 24hItemUUID256Auto hItemUUID256Auto | Item type: UUID 256 automatic identifier | ..Type | | hJNLBackupPath | Path of the directory containing the backups of the logs | <Connection variable>.SetServer | | hJNLPath | Path of the directory containing all the logs of the different HFSQL Client/Server applications | <Connection variable>.SetServer | Versions 23 and laterhkaInterval New in version 23hkaInterval hkaInterval | Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client. | <Connection variable>.SetServer | Versions 23 and laterhkaTimeout New in version 23hkaTimeout hkaTimeout | Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected. | <Connection variable>.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 | | hKeepTRS | Stores the transaction files during the deletion | <Connection variable>.DeleteDatabase,
<Connection variable>.DeleteFile | Versions 17 and laterhLanguageBinarySort New in version 17hLanguageBinarySort 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, ..LanguageDescribed, H.LanguageCreationUnicode | | hLanguageCreation | Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation". | ..Language, ..LanguageDescribed | Versions 17 and laterhLanguageFastSort New in version 17hLanguageFastSort hLanguageFastSort | The sort will be performed by comparing the characters one by one according to a generic sort. | ..Language, ..LanguageDescribed, H.LanguageCreationUnicode | | hlbActive | Enable or disable the load balancing | <Connection variable>.SetServer | | hlbClientCalls | Value modifying the coefficient applied to the counter for client calls | <Connection variable>.SetServer | | hlbDisk | Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server | <Connection variable>.SetServer | | hlbDiskAccess | Value modifying the coefficient applied to the counter for the number of disk accesses. | <Connection variable>.SetServer | | hlbMaxTimeout | Value modifying the maximum time-out for a server request | <Connection variable>.SetServer | | hlbReceived | Value modifying the coefficient applied to the counter for the bytes received by the server | <Connection variable>.SetServer | | hlbSent | Value modifying the coefficient applied to the counter for the bytes sent by the server | <Connection variable>.SetServer | | hLimitParsing | Limits the file browse: The browse will stop as soon as the last sought value is found. The current record will correspond to this last record found.
<Source>.Found will be set to False and <Source>.Out will be set to True.
This constant is used to optimize the search speed in client/server mode. | <Source>.ReadSeek, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst | | hLockNo | Type of lock: No lock | <Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLockReadWrite | Type of lock: Lock in read/write | <Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLockWrite | Type of lock: Lock in write mode | <Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLogIdentification | Configures the file to re-create: Re-creates the "JournalIdentification.fic" file. | <Source>.LogRecreate | | hLogJNLFile | Configures the file to re-create: Only <File name>JNL.FIC is recreated. | <Source>.LogRecreate | | hLogLevel | Defines the elements that must be found in the log file | <Connection variable>.SetServer | | hLogNo | Format of log process: No log | ..LogMethod | | hLogOperation | Configures the file to re-create: Re-creates the "JournalOperation.fic" file. | <Source>.LogRecreate | | hLogPath | Path of the directory containing the log files | <Connection variable>.SetServer | | hLogReadingWriting | Format of log process: Log the read and write operations performed in the file | ..LogMethod | | hLogUser | Configures the file to re-create: Re-creates the log of users ("UserLog.fic").
This file exists in HFSQL Client/Server only. This file contains the information (login, computer, ...) about the users who perform the logged actions. | <Source>.LogRecreate | | hLogWriting | Format of log process: Log the write operations performed in the file | ..LogMethod | Versions 20 and laterhlpBackup New in version 20hlpBackup hlpBackup | Type of scheduling to list: Scheduling of backups. | | Versions 22 and laterhlpCalcStat New in version 22hlpCalcStat hlpCalcStat | Type of operation performed on the server: statistical calculation. | Type hServerOperation | Versions 22 and laterhlpKeyDetection New in version 22hlpKeyDetection hlpKeyDetection | Type of operation performed on the server: detection of keys. | Type hServerOperation | Versions 20 and laterhlpMaterializedView New in version 20hlpMaterializedView hlpMaterializedView | Type of scheduling to list: Tasks for refreshing the materialized views. | | Versions 20 and laterhlpOptimization New in version 20hlpOptimization hlpOptimization | Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation). | | Versions 22 and laterhlpReplication New in version 22hlpReplication hlpReplication | Type of operation performed on the server: server replication. | Type hServerOperation | Versions 20 and laterhlpTask New in version 20hlpTask hlpTask | Type of scheduling to list: Scheduled tasks that run a stored procedure. | | | hLstAll | Lists all the keys, all the files, all the items or all the connections | <Source>.ListKey, HListFile, <Source>.ListItem, HListConnection,
<Connection variable>.ListStoredElement | | hLstCompositeKey | Lists the composite key items only | <Source>.ListKey, <Source>.ListItem | Versions 22 and laterhLstDatabaseSize New in version 22hLstDatabaseSize hLstDatabaseSize | List of connection databases as well as their size. | <Connection variable>.ListDatabase | | hLstDetail | Lists the detailed information | <Source>.ListKey, HListFile,
<Source>.ListLink, <Source>.ListItem, HListConnection,
<Connection variable>.ListStoredElement | | hLstDetailPlus | For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part. | <Source>.ListKey, <Source>.ListItem | | hLstFile | Lists the databases and their files for the server defined by the connection | <Connection variable>.ListDatabase | | hLstItem | Lists the non-key and non-memo items | <Source>.ListItem | | hLstKey | Lists the key items | <Source>.ListKey, <Source>.ListItem | | hLstLogicalOrder | Lists the items or the keys according to the logical order of items | <Source>.ListKey, <Source>.ListItem | Versions 20 and laterhLstMaterializedView New in version 20hLstMaterializedView hLstMaterializedView | Lists the materialized views found on an HFSQL server. | HListFile | | hLstMemo | Lists the memo items | <Source>.ListItem | | hLstNormal | Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically. | <Source>.ListKey, HListFile, <Source>.ListItem, HListConnection | | hLstOpened | Stores the opened connections only | HListConnection | | hLstOriginalItem | Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file. | <Source>.ListKey, <Source>.ListItem | | hLstQuery | - Lists the queries found on a server
Versions 19 and laterLists the queries that have been run. New in version 19Lists the queries that have been run. Lists the queries that have been run.
| | | hLstSet | Lists the sets of procedures found on a server | <Connection variable>.ListStoredElement | | hLstSorted | Sorts the list of keys, files, items or connection in ascending order | <Source>.ListKey, HListFile, <Source>.ListItem, HListConnection | | hLstStoredProcedure | Lists the stored procedures of a connection via Native Connectors or OLE DB | HListFile,
<Connection variable>.ListStoredElement | | hLstSystemTable | List of system tables for a connection via Native Connectors or OLE DB | HListFile | | hLstTable | List of user tables for a connection via Native Connectors or OLE DB | HListFile | | hLstView | - List the views of a connection via Native Connectors or OLE DB.
Versions 20 and laterList the SQL views on an HFSQL server. New in version 20List the SQL views on an HFSQL server. List the SQL views on an HFSQL server.
| HListFile | | hMasterReplica | Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica) | ..Replication | | hMaxActivityStatisticsSize | Maximum size in megabytes (MB) of files for activity statistics | <Connection variable>.SetServer | | hMaxLogSize | Maximum size in megabytes (MB) of log files | <Connection variable>.SetServer | Versions 24 and laterhMaxNumberConnection New in version 24hMaxNumberConnection hMaxNumberConnection | Maximum number of connections allowed per application. | <Connection variable>.SetServer | | hMaxVal | Defines an upper bound for a filter | <Source>.BuildKeyValue,
<Source>.Filter,
<Source>.FilterStartsWith,
<Source>.FilterIncludedBetween | | hMemoAuto | The memos are read during the access to the item | <Source>.SetMemo | | hMemoBin | Type of file used for the memo: Any binary file | <Source>.LinkMemo | | hMemoImg | Type of file used for the memo: Image file | <Source>.LinkMemo | | hMemoNo | No management of memos | <Source>.SetMemo | | hMemoOle | Type of file used for the memo: OLE file | <Source>.LinkMemo | | hMemoWav | Type of file used for the memo: sound file | <Source>.LinkMemo | | hMemoYes | The text memos are read whenever the record is read.
Read the binary memos when accessing the item. | <Source>.SetMemo | | hMessage | Configure the information message | HOnServerCall | | hMinVal | Defines a lower bound for a filter | <Source>.BuildKeyValue,
<Source>.Filter,
<Source>.FilterStartsWith,
<Source>.FilterIncludedBetween | Versions 20 and laterhMmoCompact New in version 20hMmoCompact hMmoCompact | Compression and defragmentation of "Mmo" files. | <Source>.Index | | hMmoSize | Size of memo file in bytes (".Mmo" file) | <Source>.InfoFile | | hMode2GB | Indicates whether the system files support more than 2 GB | <Connection variable>.SetServer | | hModeDirect | Priority implementation of locks | <Source>.Mode | | hModeMono | Single-user lock mode | <Source>.Mode | | hModeMulti | Multi-user lock mode | <Source>.Mode | | hModeReservation | Non-priority implementation of locks | <Source>.Mode | | hModifyFile | When modifying the query result, these modifications will be applied to the files belonging to the query.
If this option is not specified, only the query result is modified. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | Versions 17 and laterhmsBackgroundTask New in version 17hmsBackgroundTask hmsBackgroundTask | A hot automatic modification is performed (available for the HFSQL Client/Server data files only). | <Source>.ModifyStructure | Versions 17 and laterhmsNoCheck New in version 17hmsNoCheck hmsNoCheck | The automatic data modification is performed even if the file description is more recent than the analysis description. | <Source>.ModifyStructure | Versions 17 and laterhmsNormal New in version 17hmsNormal hmsNormal | Standard operating mode of the automatic data modification. | <Source>.ModifyStructure | | hNativeAccessAS400 | Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessDB2 | OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessInformix | OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 20 and laterhNativeAccessMariaDB New in version 20hNativeAccessMariaDB hNativeAccessMariaDB | OLE DB provider that will be used for the connection: Native MariaDB Connector (optional module of WINDEV/WEBDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessMySQL | OLE DB provider that will be used for the connection: Native MySQL Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessOracle | OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessOracleLite | Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessPostgreSQL | OLE DB provider that will be used for the connection: Native PostgreSQL Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessProgress | OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 16 and laterhNativeAccessSQLAzure New in version 16hNativeAccessSQLAzure hNativeAccessSQLAzure | OLE DB provider that will be used for the connection: Native SQL Azure Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 15 and laterhNativeAccessSQLite New in version 15hNativeAccessSQLite hNativeAccessSQLite | OLE DB provider that will be used for the connection: Native Connector to an SQLite database | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessSQLServer | OLE DB provider that will be used for the connection: Native SQL Server Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessSQLServerMobile | Provider that will be used for the connection: Native SQL Server Mobile Connector (optional module of WINDEV Mobile) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessSybase | OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessXBase | OLE DB provider that will be used for the connection: Native xBase Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessXML | Provider that will be used for the connection: Native XML Connector (supplied with WINDEV/WEBDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNdxCacheSize | Maximum size in megabytes (MB) of index cache | <Connection variable>.SetServer | | hNdxCompact | Re-index operation with compression | <Source>.Index | | hNdxDelete | Reindex and delete damaged records | <Source>.Index | | hNdxMinimal | Re-index operation while ignoring the corrupted keys | <Source>.Index | | hNdxNormal | Standard re-index operation | <Source>.Index | | hNdxNoStat | Reindex without statistical calculation | <Source>.Index | | hNdxSilent | Configure the re-index operation: No display while re-indexing | <Source>.Index | | hNdxSize | Size of index file in bytes (".Ndx" file) | <Source>.InfoFile | | hNoBind | Run a query without enabling the bind | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery,
<Source>.PrepareSQLQuery | | hNoCheck | No check is performed, the analysis description may differ from the description of physical file. | <Source>.CheckStructure | | hNoError | No error occurred | HError | Versions 21 and laterhNoHourglass New in version 21hNoHourglass hNoHourglass | When reading the query result, this read operation may be locked and a hourglass appears by default. This constant is used not to display the hourglass in this case. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hNoIndex | The file index is not copied | <Connection variable>.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 | Versions 15 and laterhNone New in version 15hNone hNone | Used to disable the simulation of a specific network. | <Connection variable>.SimulateNetwork | | hNoRefresh | The table or query content will not be refreshed | <Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.First | | hNotAKey | Characteristics of an item: Non-key item | ..KeyType | | hNotes | Property of a database found on an HFSQL server: Database description or any other information associated with the database by <Connection variable>.ModifyDatabaseProperty. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.InfoServerProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty, <Connection variable>.ModifyServerProperty | Versions 18 and laterhNotifCCClassic New in version 18hNotifCCClassic hNotifCCClassic | The notifications are sent by the Control Centers in HFSQL Classic mode. | <Connection variable>.NotifConfigure | Versions 18 and laterhNotifCCCS New in version 18hNotifCCCS hNotifCCCS | The notifications are sent by the Control Centers in Client/Server mode. | <Connection variable>.NotifConfigure | Versions 18 and laterhNotifCritical New in version 18hNotifCritical hNotifCritical | The notifications will be sent from the critical level (for the critical and error problems). | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | Versions 18 and laterhNotifEmail New in version 18hNotifEmail hNotifEmail | The notifications are sent by email. | <Connection variable>.NotifConfigure | Versions 18 and laterhNotifError New in version 18hNotifError hNotifError | The notifications will be sent for the error problems only. | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | Versions 22 and laterhNotifInformation New in version 22hNotifInformation hNotifInformation | The notifications will be sent from the information level (for the information, warning, critical and error problems) | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | Versions 18 and laterhNotifWarning New in version 18hNotifWarning hNotifWarning | The notifications will be sent from the warning level (for the warning, critical and error problems). | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | | hNotLocking | Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To find out whether the execution of the view or query is completed, use ..ExecutionCompleted.
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 | | 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 | | hNotSorted | Sort direction: Item not sorted | ..SortType | | hODBC | OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Used to access an ODBC source declared in the ODBC data sources of Windows | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbAccess2000 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2000 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbAccess2007 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2007 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | Versions 19 and laterhOledbAccess2010 New in version 19hOledbAccess2010 hOledbAccess2010 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2010 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbAccess97 | OLE DB provider that will be used for the connection: OLE DB provider for Access 97 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbDBase5 | OLE DB provider that will be used for the connection: OLE DB provider for dBase 5 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbExcel2000 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbExcel2007 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbExcel97 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 97 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbLotus4 | OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbOracle | OLE DB provider that will be used for the connection: OLE DB provider for Oracle | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbSQLServer | OLE DB provider that will be used for the connection: OLE DB provider for SQL Server | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOnDelete | Integrity rule applied during a deletion | <Connection variable>.SetIntegrity | | hOnUpdate | Integrity rule applied during a modification | <Connection variable>.SetIntegrity | | hOpenKeysetCursor | Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions). | HDescribeConnection,
<Connection variable>.OpenConnection | | hOptimisticCursor | The record is locked when it is updated | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 15 and laterhOptIndex New in version 15hOptIndex hOptIndex | Optimization options: Provokes the re-indexing operation on the data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes. | hFileParameter variable | Versions 15 and laterhOptStat New in version 15hOptStat hOptStat | Optimization options: Provokes the recalculation of statistics on the data files. | hFileParameter variable | | hORead | File accessible in read-only | ..CtAccess, ..CtDescribedAccess,
HConnect, <Source>.Open | | hOReadWrite | File accessible in read/write | ..CtAccess, ..CtDescribedAccess,
HConnect, <Source>.Open | | hOwner | Property of a database found on an HFSQL server: Owner of database. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty | | hPackNo | Compression mode: No compression | ..MmoPackMethod | | hPackZLW | Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation. | ..MmoPackMethod | | hPageSize | Size of a block of caches. This block of caches will be used when browsing a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption. | HSetCache | | hPessimisticCursor | The record is locked as soon as it becomes in edit to be modified. | HDescribeConnection,
<Connection variable>.OpenConnection | | hPrecisionHigh | Position with high precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hPrecisionLow | Position with low precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hPrecisionMedium | Position with medium precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hQueryBreakable | The query initialization can be interrupted with the ESC key | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryDefault | The query is initialized without interruption | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryWithoutCorrection | Native Connector or OLE DB only:
No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.) | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryWithoutHFCorrection | HFSQL only
The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | Versions 19 and laterhReadCommitted New in version 19hReadCommitted hReadCommitted | Isolation level of transaction: only the finalized transactions are visible by the other users. | <Connection variable>.TransactionIsolation | | hReadOnlyCursor | The set of records cannot be modified. | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 19 and laterhReadUncommitted New in version 19hReadUncommitted hReadUncommitted | Isolation level of transaction: the non-finalized transactions are visible by the other users. | <Connection variable>.TransactionIsolation | | hRecalculateIdAuto | Mode for calculating the automatic identifier: Automatic identifier re-calculated during the write operation | <Source>.Write, <Source>.Modify | | hRecFile | Record to read: Value of the item currently saved in the data file | <Source>.ErrorModification, <Source>.ErrorStatusModification | Versions 22 and laterhRecNumAll New in version 22hRecNumAll hRecNumAll | - Used to track all records found in a data file.
Versions 23 and laterUsed to check all unaltered records New in version 23Used to check all unaltered records Used to check all unaltered records
| | | hRecRead | Record to read: Value of the item for the source record | <Source>.ErrorModification, <Source>.ErrorStatusModification | | hRecUser | Record to read: Value of the item for the current record when performing the modification | <Source>.ErrorModification, <Source>.ErrorStatusModification | Versions 20 and laterhRefreshInProgress New in version 20hRefreshInProgress hRefreshInProgress | Requested information: Is the materialized view currently refreshed? | <Connection variable>.InfoView | Versions 19 and laterhRepeatableRead New in version 19hRepeatableRead hRepeatableRead | Isolation level of transaction: the application in transaction sees a snapshot of the database when the transaction starts. | <Connection variable>.TransactionIsolation | | hReplicated | Replication mode: The data file is configured to be replicated. | ..Replication | | hRightsAll | List of all the rights | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights | | hRightsAutoModif | Rights to perform the automatic modification of the data files on a file | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsBackup | Rights to save the data files | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoServerRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyServerRights | | hRightsChangeLink | Rights to modify the integrity rules on a data file. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsChangeOwner | Rights to modify the owner of an element | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.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). | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsChangeRights | Rights to change rights. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights,
<Connection variable>.ModifyServerRights | | hRightsConnection | Rights to connect to a server (encrypted or unencrypted connection) | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsCreateDB | Rights to create a database | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsCreateFile | Rights to create a data file (with <Source>.Creation) | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | Versions 20 and laterhRightsCreateView New in version 20hRightsCreateView hRightsCreateView | Rights to create a SQL view or a materialized view. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsDebug | Rights to debug the stored procedures. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsDelete | Rights to delete the records from a data file | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsDeleteDB | Rights to delete a database | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsDeleteFile | Rights to delete a data file (<Connection variable>.DeleteFile) | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | Versions 20 and laterhRightsDeleteView New in version 20hRightsDeleteView hRightsDeleteView | Rights to delete a SQL view or a materialized view. | <Connection variable>.InfoViewRights, <Connection variable>.ModifyViewRights | | hRightsDisconnectClient | Rights to disconnect the client computers. | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsEncryptedConnection | Rights to connect to a server (encrypted connection only) | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsInsert | Rights to add new records into a data file. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsLock | Rights to lock the data files or the records of a data file. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsMaintenance | Rights to start a re-index operation or to perform statistical calculations on a data file | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsManageDuplicate | Rights to enable and disable the management of duplicates. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsManageIntegrity | Rights to enable and disable the management of integrity. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsManageProcedure | Rights to add, modify and delete the stored procedures. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsManageServer | Rights to use <Connection variable>.SetServer | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsManageTask | Rights to manage the scheduled tasks. | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsManageTrigger | Rights to manage the server triggers (addition, activation, deletion) | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsManageUser | Rights to delete and add users or groups | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsNoDatabaseAccess | Rights to prevent (or not) access to a database (<Connection variable>.NoDatabaseAccess and <Connection variable>.EndNoDatabaseAccess) | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsPriority | Rights to modify the priority of a client application | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsRead | Rights to read the records of a data file | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | hRightsReadLogStat | Rights to see the activity statistics and the logs of the server. | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsRunProcedure | Rights to run the stored procedures. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.ModifyDatabaseRights | | hRightsSeeUser | Rights to view the characteristics of a group or user. | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsSendMessageToClient | Rights to send messages to the client computers. | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | Versions 18 and laterhRightsServerReplication New in version 18hRightsServerReplication hRightsServerReplication | Rights to define and perform a replication between two HFSQL servers. | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsStopServer | Rights to stop a server (<Connection variable>.StopServer) | <Connection variable>.InfoServerRights,
<Connection variable>.ModifyServerRights | | hRightsUpdate | Rights to modify the records of a data file | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights | | 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 | | hRPKeep | Configure the restore operation: Position not freed | <Source>.RestorePosition | Versions 22 and laterhrsCopy New in version 22hrsCopy hrsCopy | Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is locking. | <Connection variable>.RSAddConfig | Versions 22 and laterhrsCopyBackgroundTask New in version 22hrsCopyBackgroundTask hrsCopyBackgroundTask | Configure the replication between servers: Enables the initial copy of replicated elements from the connection server (master server) to the other server (subscriber server, defined in the hRSConfig variable). This copy is performed in background task and it is not locking. | <Connection variable>.RSAddConfig | Versions 22 and laterhrsNoCopy New in version 22hrsNoCopy hrsNoCopy | Configure the replication between servers: No copy is performed. | <Connection variable>.RSAddConfig | Versions 22 and laterhsAdd New in version 22hsAdd hsAdd | Monitors the operations for adding records. | <Source>.Track | | 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 | Versions 22 and laterhsCross New in version 22hsCross hsCross | Monitors the operations for crossing records. | <Source>.Track | Versions 22 and laterhsDeletion New in version 22hsDeletion hsDeletion | Monitors the operations for deleting records. | <Source>.Track | Versions 19 and laterhSecondaryThread New in version 19hSecondaryThread hSecondaryThread | Option for running the procedure: the procedure is run in a secondary thread. | HOnServerCall | | hServerCursor | Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data. | HDescribeConnection,
<Connection variable>.OpenConnection | | hServerPort | Network port used | <Connection variable>.SetServer | | hSetIdAuto | Mode for calculating the automatic identifier: Identifier value equals to the one stored during the addition | <Source>.Add, <Source>.Write, <Source>.Modify | | hSetIdAuto | Mode for calculating the automatic identifier: Identifier value equals to the one stored during the write operation | <Source>.Add, <Source>.Write, <Source>.Modify | Versions 22 and laterhsModification New in version 22hsModification hsModification | Monitors the operations for modifying records. | <Source>.Track | Versions 20 and laterhSQLCode New in version 20hSQLCode hSQLCode | Requested information: SQL code of the materialized view | <Connection variable>.InfoView | | hSQLUnicode | Used to specify that the query text must be sent in Unicode format to the server.
This constant is available in WINDEV Mobile only. | <HFSQL file>.ExecuteSQLQuery | | hStarted | Server started | HServerStatus | | hStateActive | Status of the record/Type of record taken into account: Active record | <Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification | | hStateAll | Type of record: Total number of records in the data file | <Source>.NbRec | | hStateCrossed | Status of the record/Type of record taken into account: Crossed record | <Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification | | hStateDel | Status of the record/Type of record taken into account: Deleted record | <Source>.State, <Source>.NbRec, <Source>.ErrorStatusModification | | hStateInvalid | Record status not found (error) | <Source>.State, <Source>.ErrorStatusModification | | hStaticCursor | Makes a copy of all query records in memory (consumes a lot of memory). All types of moves are allowed. | HDescribeConnection,
<Connection variable>.OpenConnection | | hStopped | Server stopped | HServerStatus | | hStructure | Configure the file management: New empty file created from the file description | <Connection variable>.RegenerateFile | | hSubErrFirst | Type of error returned: Number of the first sub-error | HError | | hSubErrLast | Type of error returned: Number of the last sub-error | HError | | hSubErrNext | Type of error returned: Number of the previous sub-error | HError | | hSubErrPrevious | Type of error returned: Number of the previous sub-error | HError | | hSubscriberReplica | Replication mode: The data file is a subscriber replica (HCreateSubscriberReplica was used to create the subscriber replica) | ..Replication | Versions 22 and laterhTelemetryEnable New in version 22hTelemetryEnable hTelemetryEnable | Configure the sending of data via the telemetry for the HFSQL server. | <Connection variable>.SetServer | Versions 17 and laterhTempDirectory New in version 17hTempDirectory hTempDirectory | Path of temporary directory. This directory is used to create the temporary files if necessary (temporary files created when re-indexing large data files for example). | <Connection variable>.SetServer | | hTotalSize | Total file size in bytes (added size of data file, memo file and index file). | <Source>.InfoFile | | hTriggerAfter | Indicates the type of trigger: The procedure is run after the HFSQL function | HActivateTrigger, HDeactivateTrigger, <Source>.DeleteTrigger, <Source>.DescribeTrigger | | hTriggerBefore | Indicates the type of trigger: The procedure is run before the HFSQL function | HActivateTrigger, HDeactivateTrigger, <Source>.DeleteTrigger, <Source>.DescribeTrigger | Versions 21 and laterhtsCreation New in version 21htsCreation htsCreation | Type ot timestamp for the item: the item will store the creation date of record. | ..TimestampType | Versions 21 and laterhtsLastModification New in version 21htsLastModification htsLastModification | Type ot timestamp for the item: the item will store the date of last modification performed on the record. | ..TimestampType | Versions 21 and laterhtsNone New in version 21htsNone htsNone | Type ot timestamp for the item: the item is not a timestamp item. | ..TimestampType | | hUnicode | Used to retrieve the record value in Unicode format. | <Source>.RetrieveRecord | | hUNICODEFormat | Data format: UNICODE format | ..Format | | hUniqueKey | Characteristics of an item: Unique key | ..KeyType | | hViewAdd | Create a view with addition: Stores the view content next time <Source>.ExecuteView is called | <Source>.CreateView, <Source>.MergeView | | hViewBreakable | The view creation can be interrupted by pressing the ESC key | <Source>.CreateView | | hViewDefault | Default creation of view | <Source>.CreateView, <Source>.MergeView | | hViewDistinct | The view is created without duplicates according to the sort key | <Source>.CreateView, <Source>.MergeView | | hViewExclusive | Optimizes the creation time of view by locking the entire source file | <Source>.CreateView, <Source>.MergeView | | hViewIntersection | Merge views with intersection: Common rows between the two specified views | <Source>.MergeView | | hViewJoin | Join between the first view and the second view. | <Source>.MergeView | | hViewLocking | The records read in the file and included in the view are locked | <Source>.CreateView, <Source>.MergeView | | hViewPostponed | The view is created but it will be run later by <Source>.ExecuteView | <Source>.CreateView, <Source>.MergeView | | hViewSubtraction | Merge views with subtraction: Row of the first view without the common rows of the second view | <Source>.MergeView | | hViewUnion | Merging views: Merge the rows of the two specified views | <Source>.MergeView | | hViewUnionEx | Exclusive merge of views: Merge the non-common rows of the two specified views | <Source>.MergeView | | hWDL | The files are sought:- In the main WDL.
- In the WDL according to their load order, then on disk or in the specified WDL, then on disk.
- In the main WDL of the component.
- In the secondary WDLs of the component according to the load order.
| <Source>.ChangeLocation,
<Source>.Declare | | hWifiFrame | The frame size is optimized for a use via Wifi | HCS.FrameSize | Versions 19 and laterhWindowsDiskCacheSize New in version 19hWindowsDiskCacheSize hWindowsDiskCacheSize | Mode for managing the size of Windows disk cache. | <Connection variable>.SetServer | | hWithFilter | If this parameter is specified: - the query result corresponds to a selection of filter records if the HFSQL engine allows it. Otherwise, the query result corresponds to an HFSQL view
- the following operations are not allowed: search on the query result, query on query, view on query, query on view.
- the browse items specified when browsing the result are ignored.
- the magnifier is not available for the tables linked to a query.
- hNbRec cannot be used on the queries.
If this parameter is not specified (by default): - the query result corresponds to an HFSQL view
- the following operations can be performed on the queries: search on the query result, query on query, view on query, query on view.
- the browse items specified when browsing the result are taken into account.
- the magnifier is available on tables linked to a query.
- hNbRec can be used on the queries.
| HExecuteQuery, HExecuteSQLQuery | | hWithTransaction | The query is run in a transaction. A transaction is started, the records are locked in read/write during the execution of the query and they are unlocked at the end of its execution, regardless of the result (failure or success).
If the query cannot end properly (locked records, power failure, etc.), the transaction is canceled and the data files are restored to their previous status (before the query execution).
Remark: The query execution may be slowed down. | HExecuteQuery, HExecuteSQLQuery | | hWriteDefault | Addition not affecting the current browse/Identifier re-used or calculated for the record | <Source>.Add, <Source>.Write, <Source>.Modify | | hYield | For the UPDATE and DELETE queries performed on an important number of records, this constant is used to give control back to the other applications that use the files. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | Versions 20 and laterNoWait New in version 20NoWait NoWait | The refresh of materialized view is not a locking operation: it is performed in background task. <Connection variable>.InfoView is used to find out the result of refresh performed on the materialized view. | <Connection variable>.RefreshView | | opCancel | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the code continues to run. | <Source>.OnError | | opEndProcess | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the current process stops. Equivalent to the following code line:
IF NOT <HFSQL function> THEN ReturnToCapture() | <Source>.OnError | | opEndProgram | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The function that triggered the error returns an error and the program stops. Equivalent to the following code line:
IF NOT <HFSQL function> THEN EndProgram() | <Source>.OnError | | opRelaunchProgram | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
The program stops and the application is automatically restarted. | <Source>.OnError | | opRetry | This constant must be returned by the procedure or window used to customize the process of HFSQL errors.
In this case, the function that triggered the error is re-run. | <Source>.OnError |
New in version 23The following constants are used to manage HFSQL data files (prefixed syntax): | | | | Constant | Affects | Used by the functions or properties | | eltProcedure | The listed element is a stored procedure | <Connection variable>.ListStoredElement | | eltQuery | The listed element is a query. | <Connection variable>.ListStoredElement | | eltSetOfProcedures | The listed element is a set of procedures | <Connection variable>.ListStoredElement | Versions 15 and laterh3G New in version 15h3G h3G | Type of network to simulate: 3G | <Connection variable>.SimulateNetwork | | hAcceptOpenedFile | Allows you to read the source file that will be added to the memo if this source file is opened in write mode somewhere else. | <Source>.LinkMemo | | hAccessHF7 | Pseudo-connection to HFSQL Classic database. | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hAccessHFClientServer | Provider that will be used for the connection: Native Connector to an HFSQL Client/Server database | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hAccessJDBCMySQL | Access to a MySQL database via a JDBC driver | HDescribeConnection,
<Connection variable>.OpenConnection | | hAccessJDBCSQLServer | Access to a SQL Server database via a JDBC driver | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 23 and laterhActiveDirectory New in version 23hActiveDirectory hActiveDirectory | Enable the authentication via Active Directory. | <Connection variable>.SetServer | | hActiveSyncFrame | The size of the frame is optimized to be used with Mobile devices. | HCS.FrameSize | | hActivityStatisticsPath | Path of the directory containing the activity statistics | <Connection variable>.SetServer | | hActivityStatisticsPeriod | Indicates the period (in second) between each backup of values for the different activity counters. | <Connection variable>.SetServer | Versions 15 and laterhADSL New in version 15hADSL hADSL | Type of network to simulate: ADSL | <Connection variable>.SimulateNetwork | | hAffectBrowse | Addition affecting the current browse | <Source>.Add, <Source>.Modify | | hAllowed | The relevant rights are granted to the user or group. | HModifyDatabaseRights,
HModifyFileRights,
HModifyServerRights | | hANSIFormat | Data format: Ansi format (used by Windows) | ..Format | | hApplication | Property of a database found on an HFSQL server: Name of the application from which the database was created. | HInfoDatabaseProperty, HInfoFileProperty | Versions 18 and laterhAutoStatisticalCalc New in version 18hAutoStatisticalCalc hAutoStatisticalCalc | Enable the automatic calculation of statistics for the data files (optimization of indexes). | <Connection variable>.SetServer | Versions 15 and laterhBackgroundTask New in version 15hBackgroundTask hBackgroundTask | Perform the process in background task without locking the data file (available for the data files in Client/Server mode). | <Source>.StatCalculate,
<Source>.Index | | hBackupCanceled | Status of backup: Backup canceled | <Connection variable>.InfoBackup | | hBackupCompleted | Status of backup: Backup completed | <Connection variable>.InfoBackup | Versions 15 and laterhBackupDifferential New in version 15hBackupDifferential hBackupDifferential | Type of backup: Differential backup | <Connection variable>.InfoBackup | | hBackupError | Status of backup: Error during backup | <Connection variable>.InfoBackup | Versions 15 and laterhBackupFull New in version 15hBackupFull hBackupFull | Type of backup: Full backup | <Connection variable>.InfoBackup | | hBackupInProgress | Status of backup: Backup in progress | <Connection variable>.InfoBackup | | hBoundSeparator | Used to separate the values of lower and upper bounds for the components of composite key | <Source>.FilterIncludedBetween | Versions 21 and laterhCacheNbUnusedFiles New in version 21hCacheNbUnusedFiles hCacheNbUnusedFiles | Maximum number of unused HFSQL tables that are stored in cache (which means opened) on the server. | <Connection variable>.SetServer | | hCardinality | Integrity constraints: Check the link cardinalities. | <Connection variable>.SetIntegrity | | hChangeCharset | The character set defined by ChangeCharset will be taken into account in the new data file. The sorts, the searches, ... on string keys (strings, characters, date and time) will be performed according to this character set. | <Source>.Creation,
<Source>.CreationIfNotFound,
<Source>.Index | | hCheckDuplicates | Checks for duplicates for this action, 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 (<Connection variable>.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 | | hClientCursor | Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor | HDescribeConnection,
<Connection variable>.OpenConnection | | hCompatible | The structures of the data files (defined in the analysis and found in the physical file) must be compatible. | <Source>.CheckStructure | | hComputer | Property of a database found on an HFSQL server: Name of the computer from which the element was created. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty | | hCopyAutoId | Copies the automatic identifier while keeping its value | <Source>.CopyRecord,
<Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS | | hCopyIfNotFound | Copies the data file only if it does not exist at the specified location on the destination computer. | <Connection variable>.CopyFile | | hCopyIndex | Copies the index of the data file | <Connection variable>.CopyFile | | hCorrespondence | Gives the correspondence between the numbers of the log functions and the names of the WLanguage functions | HInfoLog | | hCreateIndex | The index of the data file is not copied. It is automatically recreated at the destination by reindexing. | <Connection variable>.CopyFile | | hCreator | Property of a database found on an HFSQL server: Name of database owner. | <Connection variable>.InfoDatabaseProperty,
<Connection variable>.InfoFileProperty | Versions 24 and laterhCryptAES128 New in version 24hCryptAES128 hCryptAES128 | File encryption performed only if a password is defined for the file. In this case, the file is encrypted using a 128-bit AES algorithm with Output feedback (OFB). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | Versions 19 and laterhCryptAuto New in version 19hCryptAuto hCryptAuto | File encryption performed only if a password is defined for the file. In this case, the data file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptNo | No file encryption. | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptRC5_12 | The file is encrypted according to an optimized encryption algorithm (RC5 12 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptRC5_16 | The file is encrypted according to an optimized encryption algorithm (RC5 16 rounds on 128 bits). | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCryptStandard | The memo file is encrypted according to an optimized encryption algorithm on 128 bits. | ..FicCryptMethod, ..MmoCryptMethod, ..NdxCryptMethod | | hCurrentRecNum | Number of the current record. | HFSQL functions | | hDaemonUser | User name that will be used by the server (Linux only) | <Connection variable>.SetServer | | hData | Configure the file management: All the operations stored in the log file are applied to the existing file | <Connection variable>.RegenerateFile | | hDatabasePath | Path of directory containing all databases | <Connection variable>.SetServer | | hDate | Property of a database found on an HFSQL server: Creation date of the database. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty | Versions 20 and laterhDateLastRefresh New in version 20hDateLastRefresh hDateLastRefresh | Requested information: Date of the last successful refresh for the materialized view. | <Connection variable>.InfoView | | hDBASCII | Sort according to ASCII order | HDBSortType | | hDBLexicographic | Sort according to the lexicographic order | HDBSortType | | hDebuggingPort | Port used to debug the stored procedures and the server triggers. | <Connection variable>.SetServer | | hDecreasing | Sort performed in descending order | ..SortType | | hDefault | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the values of the requested rights (in the same order). | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights | | hDefaultFrame | The standard size will be used by default. | HCS.FrameSize | | hDefaultVal | The items of destination record that are not affected by the copy are initialized with their default value.
For the non-imported items, the values of current record (HFSQL Classic) are reinitialized with their default value. | <Source>.CopyRecord,
<Source>.ImportHF55,
<Source>.ImportText,
| | hDelayedOpening | Optimize the opening of existing files: If the file already exists, it will be opened during the first access to the file. The file is created if it does not exist. | <Source>.CreationIfNotFound | | hDeleteLog | Deletes the log file | <Connection variable>.DeleteFile,
<Connection variable>.DeleteDatabase | | hDestroyLink | Deletes all links related to the deleted data file. | <Connection variable>.DeleteFile | | hDetails | The rights returned do not take the inherited rights into account (rights granted to the groups to which the user belongs).
If no rights were defined, the value will be set to hInherit.
<Result> contains the rights and there value. | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights | | hDisconnection | Configures the disconnection message | HOnServerCall | | hDisk | Search mode for the data files or the analyses: The files are sought on the disk only. This is the most common case | <Source>.ChangeLocation,
<Source>.Declare | | hDistinct | Management of duplicates during the browse: If duplicates are found when a browse is performed on a key item, a single record is browsed | <Source>.Forward, <Source>.ReadPrevious,
<Source>.ReadNext, <Source>.Previous,
<Source>.Backward, <Source>.Next | | hDuplicateKey | Characteristics of an item: Key with duplicates | ..KeyType | | hDynamicCursor | Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users. | HDescribeConnection,
<Connection variable>.OpenConnection | | hEffective | The rights returned correspond to the rights that will be actually granted to the user or to the group on the database. The inherited rights are taken into account (rights granted to the groups to which the user belongs for example). | <Connection variable>.InfoDatabaseRights,
<Connection variable>.InfoFileRights,
<Connection variable>.InfoServerRights | | hErrADO | Type of information about the error to return: Error code returned by ADO. The corresponding message is returned by the hErrADOMessage constant. | HErrorInfo | | hErrADOMessage | Type of information about the error to return: Message corresponding to the error returned by ADO (hErrADO) | HErrorInfo | | hErrAll | Customize all the errors | <Source>.OnError | | hErrBase | Type of information about the error to return: Error code returned by the database. The corresponding message is returned by the hErrBaseMessage constant | HErrorInfo | | hErrBaseMessage | Type of information about the error to return: Message corresponding to the error returned by the database (hErrBase) | HErrorInfo | | hErrClientInfo | Information about the client layer used by the Native Connector that returned the error. | HErrorInfo | | hErrConnectionLoss | Customize the errors caused by a loss of connection with the server. | <Source>.OnError | | hErrCurrent | Type of information about the error to return: Number of the current error | HError | | hErrDatabaseAccess | Configure the access errors to an HFSQL Client/Server database. | <Source>.OnError | | hErrDebugInfo | Type of information about the error to return: Specific information for debugging the problem that occurred. This information should only be displayed and communicated on express demand from PC SOFT.
When running a query via OLE DB, this option allows you to retrieve the code of the SQL query currently run on the database. | HErrorInfo | | hErrDuplicates | Customize duplicate errors | <Source>.OnError | | hErrFIC | Type of information about the error to return: Full name of the data file associated with the error | HErrorInfo | | hErrFile | Type of information about the error to return: Logical name of data file associated with the error | HErrorInfo | | hErrFullDetails | Type of information about the error to return: Full error details (error line, current process, etc.)
Remark: Returns the same information as the one retrieved when clicking the "Copy" button in the error window of WLanguage. | HErrorInfo | | hErrIndex | Customize the reindexing errors (reindexing operation in progress during the access to the data file) | <Source>.OnError | | hErrIntegrity | Customize integrity errors | <Source>.OnError | | hErrItem | Type of information about the error to return: Name of item associated with the error | HErrorInfo | | hErrLink | Type of information about the error to return: Name of link associated with the error | HErrorInfo | | hErrLock | Customize lock errors | <Source>.OnError | | hErrLockInfo | Type of information about the error to return: Information about the lock | HErrorInfo | | hErrMain | Type of information about the error to return: Number of the main error | HError | | hErrMessage | Type of information about the error to return: Message associated with the error | HErrorInfo | | hErrMMO | Type of information about the error to return: Full name of the memo file associated with the error | HErrorInfo | | hErrModify | Customize a modification conflict | <Source>.OnError | | hErrNative | Type of information about the error to return: Error code returned by the Native Connector or the OLE DB provider used | HErrorInfo | | hErrNativeMessage | Type of information about the error to return: Message corresponding to the error returned by the provider of the Native Connector. | HErrorInfo | | hErrNDX | Type of information about the error to return: Full name of the index file associated with the error | HErrorInfo | | hErrNeedValue | Customize the errors caused by a mandatory input with no data (OLE DB only). | <Source>.OnError | | hErrOLEDB | Type of information about the error to return: Error code returned by the system during an access via an OLE DB connection. | HErrorInfo | | hErrOLEDBMessage | Type of information about the error to return: Message corresponding to the error returned by the system during an OLE DB connection (hErrOLEDB) | HErrorInfo | Versions 20 and laterhErrorLastRefresh New in version 20hErrorLastRefresh hErrorLastRefresh | Requested information: Last error while refreshing the materialized view. | <Connection variable>.InfoView | | hErrPassword | Customize password errors | <Source>.OnError | Versions 20 and laterhErrPositionSQLError New in version 20hErrPositionSQLError hErrPositionSQLError | Type of information about the error to return: Position of the SQL error in the SQL code of the query run by <HFSQL file>.ExecuteSQLQuery. | HErrorInfo | | hErrRecNum | Type of information about the error to return: Number of the record associated with the error | HErrorInfo | | hErrServer | Type of information about the error to return: Name of the HFSQL Client/Server server that triggers the error | HErrorInfo | | hErrServerInfo | Information about the server used by the Native Connector that returned the error. | HErrorInfo | | hErrSystemCode | Type of information about the error to return: Number of the associated system error | HErrorInfo | | hErrSystemMessage | Type of information about the error to return: Message of associated system error | HErrorInfo | | hErrWDD | Type of information about the error to return: Full name of the analysis file associated with the error | HErrorInfo | | hExisting | Type of search: Only the assignments for which a file actually exists | HListREP | | hExpBreakable | Mode for creating the export file: The export can be interrupted by pressing Esc.
If the export is interrupted, the export file is valid and it only contains the records exported before the interruption. | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | | hExpCreation | Mode for creating the export file: The file is overwritten if it already exists. | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | Versions 24 and laterhExpNoLineItemName New in version 24hExpNoLineItemName 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 | | hExpNormal | Mode for creating the export file: Standard operating mode | <Source>.ExportXML
<Source>.ExportJSON
<Source>.ExportCSV
<Source>.ExportXLS | | hExpWithoutXSL | The style sheet (".XSL" file) is not created | <Source>.ExportXML | | hFicSize | Size of data file in bytes (".Fic" file) | <Source>.InfoFile | | hFileAS400 | Type of file: AS400 file | ..Type | | hFileClientServer | Type of file: HFSQL Client/Server file | ..Type | | hFileHF5 | Type of file: Hyper File 5 file | ..Type | | hFileMySQL | Type of file: MySQL file | ..Type | | hFileNormal | Type of file: Standard file (HFSQL Classic) | ..Type | | hFileOLEDB | Type of file: OLEDB file | ..Type | | hFileOracle | Type of file: ORACLE file | ..Type | | hFileOracleLite | Type of file: ORACLE Lite file | ..Type | | hFileOther | Type of file: Other type of file | ..Type | Versions 15 and laterhFilePostgreSQL New in version 15hFilePostgreSQL hFilePostgreSQL | Type of file: PostgreSQL file | ..Type | | hFileProgress | Type of file: Progress file | ..Type | | hFileQuery | Type of file: Query | ..Type | | hFileQueryAS400 | Type of file: Query on an AS/400 database | ..Type | | hFileQueryClientServer | Type of file: Query on an HFSQL Client/Server database | ..Type | | hFileQueryMySQL | Type of file: Query on a MySQL database | ..Type | | hFileQueryOLEDB | Type of file: Query on a database accessed via an OLE DB provider | ..Type | | hFileQueryOracle | Type of file: Query on an Oracle database | ..Type | | hFileQueryOracleLite | Type of file: Query on an Oracle Lite database | ..Type | Versions 15 and laterhFileQueryPostgreSQL New in version 15hFileQueryPostgreSQL hFileQueryPostgreSQL | Type of file: Query on a PostgreSQL database | ..Type | | hFileQueryProgress | Type of file: Query on a Progress database | ..Type | Versions 16 and laterhFileQuerySQLAzure New in version 16hFileQuerySQLAzure hFileQuerySQLAzure | Type of file: Query on an SQL Azure database | ..Type | | hFileQuerySQLServer | Type of file: Query on an SQL Server database | ..Type | | hFileQuerySQLServerMobile | Type of file: Query on an SQL Server Mobile database | ..Type | | hFileQuerySybase | Type of file: Query on a Sybase database | ..Type | | hFileQueryXML | Type of file: Query on an XML database | ..Type | | hFileSQL | Type of file: SQL file | ..Type | Versions 16 and laterhFileSQLAzure New in version 16hFileSQLAzure hFileSQLAzure | Type of file: SQL Azure file | ..Type | Versions 16 and laterhFileSQLite New in version 16hFileSQLite hFileSQLite | Type of file: SQLite file | ..Type | | hFileSQLServer | Type of file: SQL Server file | ..Type | | hFileSQLServerMobile | Type of file: SQL Server Mobile file | ..Type | | hFileSybase | Type of file: Sybase file | ..Type | | hFileTemporary | Type of file: Temporary file | ..Type | | hFileView | Type of file: HFSQL view | ..Type | | hFileXBase | Type of file: xBase file | ..Type | | hFileXML | Type of file: XML file | ..Type | Versions 22 and laterhFindKey New in version 22hFindKey hFindKey | Enable the search for keys on the HFSQL server. | <Connection variable>.SetServer | | hForbidden | The relevant rights are not granted to the user or group | <Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights,
<Connection variable>.ModifyServerRights | Versions 17 and laterhForwardOnly New in version 17hForwardOnly hForwardOnly | Native Connectors only: Used to speed up the browse of data during a simple browse that does not use the following features: - Reading the previous record.
- Modifying a record.
- Saving position.
If one of these features is used, the result may differ from the expected one.This constant can be used for example during a browse used to fill a memory Table control. | <Source>.ReadLast,
<Source>.ReadFirst,
<Source>.ReadSeekFirst,
<Source>.ReadSeekLast | | hForwardOnlyCursor | Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible. | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 20 and laterhftPunctuationSimple New in version 20hftPunctuationSimple hftPunctuationSimple | Full-text Index item described by programming: Taking into account the simple punctuation characters (non Unicode). | ..Option property of FullTextIndex description variables. | Versions 20 and laterhftPunctuationUnicode New in version 20hftPunctuationUnicode hftPunctuationUnicode | Full-text Index item described by programming: Taking into account the Unicode punctuation characters. | ..Option property of FullTextIndex description variables. | | hFTX | Reindexing full-text indexes | <Source>.Index | | hFtxSize | Size of full-text index file in bytes (".Ftx" file) | <Source>.InfoFile | | HGeneric | Type of search: Generic search | <Source>.ReadSeekLast,
<Source>.ReadSeekFirst,
<Source>.SeekLast,
<Source>.SeekFirst | | hGPRSFrame | The frame size is optimized for a use via GPRS | HCS.FrameSize | | hHCreationIfNotFound | Type of test to run to check the connection: Checks the connection by opening or creating a file (if the file does not exist). This operation can be performed in hOReadWrite mode only. | HConnect | | hHOpen | Type of test to run to check the connection: Checks the connection by opening a file. This value is used by default when accessing to an hORead database. | HConnect | | hIdentical | The structures of files (read in the analysis and in the physical file) must be strictly identical. | <Source>.ReadSeek, <Source>.Seek, <Source>.CheckStructure | | hIgnoreDuplicates | Ignores the duplicate check for this operation, 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 (<Connection variable>.SetIntegrity) | <Source>.Add, <Source>.Modify, <Source>.Delete, <HFSQL file>.Cross | | hImpBreakable | The import can be interrupted by pressing ESC. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpConversion | Type of import: The associated items do not have the same type or the same size: the data checked out from the imported file is automatically converted or truncated. | <Source>.ImportHF55 | | hImpCreation | Type of import: If the (HFSQL Classic) import file exists, it is overwritten. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpIgnoreEmptyItem | If one or more items are not filled in the text file, the corresponding lines are still imported.
The missing items contain:- the default value of items if the hDefaultVal constant is specified.
- the value of items in the current record before the call to <Source>.ImportText.
| <Source>.ImportText,
<Source>.ImportXLS | Versions 20 and laterhImpIgnoreFirstLine New in version 20hImpIgnoreFirstLine hImpIgnoreFirstLine | Type of import: The first row of the imported file is ignored. | <Source>.ImportText,
<Source>.ImportXLS | | hImpIgnoreInvalidLine | Type of import: The lines whose structure are invalid are not imported: the import continues on the following lines. The structure is invalid if data is missing for one or more items, or if string separators are missing. | <Source>.ImportText,
<Source>.ImportXLS | | hImpIgnoreItem | Type of import: - The items found in the import file (HFSQL Classic) without associated items in the imported file (Hyper File 5.5) are filled with their default value.
- The items of imported file (Hyper File 5.5) with no match in the import file are ignored.
| <Source>.ImportHF55 | | hImpNoDelimiter | Type of import: The string separators (if they exist) are part of the item | <Source>.ImportText | | hImpNormal | Type of import: The import is not performed and an error occurs in the following cases:- items found in the Hyper File 5.5 file with no match in the HFSQL Classic file.
- associated items in the two files but with a different size and/or format.
If the (HFSQL Classic) import file already exists, it is filled with the imported data; otherwise, the file is created.
No management of integrity and no management of duplicates.
The non-imported items take the value of the current record.
The automatic identifiers are recalculated. | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS,
<Source>.ImportXML
<Source>.ImportJSON | | hImpNoSpace | Type of import: The space characters found at the end of string are automatically deleted during the import | <Source>.ImportHF55 | | hImpOEM2ANSI | Type of import: Convert the imported strings from OEM to ANSI. This constant is available for backward compatibility. | <Source>.ImportText | | hImpTestDuplicates | Type of import: Checks the duplicates during the import | <Source>.ImportHF55,
<Source>.ImportText,
<Source>.ImportXLS | | hImpTestIntegrity | Type of import: Checks the integrity during the import | <Source>.ImportHF55,
<Source>.ImportText,
| | hInaccessible | Undefined server status | HServerStatus | | hIncreasing | Sort performed in ascending order | ..SortType | | hInfiniteCardinality | Maximum cardinality ("N") | ..MaxLinkedCardinality, ..MaxSourceCardinality | | hInfoAll | Full information about the server (corresponds to hInfoVi + hInfoVersion + hInfoPlatform + hInfoHardware + hInfoName + hInfoLogicalName + hInfoDate).
The different values are separated by CR characters (Carriage Return). | <Connection variable>.InfoServer | Versions 15 and laterhInfoCluster New in version 15hInfoCluster hInfoCluster | Information about the HFSQL cluster. | <Connection variable>.InfoServer | | hInfoDate | Date and time of server on 8 bytes in UTC format (universal time) | <Connection variable>.InfoServer | Versions 22 and laterhInfoFreeDiskSpace New in version 22hInfoFreeDiskSpace hInfoFreeDiskSpace | Available space on the server disk, expressed in MB. | <Connection variable>.InfoServer | | hInfoHardware | Information about the hardware used:- Type of processor (for example: Intel Pentium)
- Size of server RAM (for example: 630 MB)
This information is returned in the following format:
<Type of CPU> = TAB + <Size of server RAM> | <Connection variable>.InfoServer | | hInfoLogicalName | Name of server given in HFConf.ini or specified during the setup. This name appears in the HFSQL Control Center. | <Connection variable>.InfoServer | | hInfoName | Name of server (DNS) | <Connection variable>.InfoServer | | hInfoPlatform | Information about the server platform:- Name of operating system: Windows NT 4.0, Windows XP, Windows 2000, Windows 2003, LINUX
- System version: corresponds to Service Pack in Windows or empty string if no Service Pack is installed. In Linux, corresponds to the version of Linux kernel (2.4.20-8 for example).
This information is returned in the following format:
<System name> + TAB + <Version> | <Connection variable>.InfoServer | Versions 19 and laterhInfoSizeCacheNdxUsed New in version 19hInfoSizeCacheNdxUsed hInfoSizeCacheNdxUsed | Size of index cache that is actually used on the server, expressed in MB. | <Connection variable>.InfoServer | Versions 22 and laterhInfoTotalDiskSpace New in version 22hInfoTotalDiskSpace hInfoTotalDiskSpace | Total capacity of server disk, expressed in MB. | <Connection variable>.InfoServer | | hInfoVersion | Information about the version of programs required for the server to operate:- Version of Manta.exe or Manta in Linux
- Version of HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- Version of SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | <Connection variable>.InfoServer | | hInfoVersionDetails | Detailed information about the version of the programs required to operate the server:
<Program name> + TAB + <Version number> + TAB + <Internal version number> + TAB + <File date>
The listed elements are as follows:- Manta.exe or Manta in Linux
- HFSQL engine (WDHFsrv.dll or WDHFsrv.so in Linux)
- SQL engine (WDSQLsrv.dll or WDSQLsrv.so in Linux)
- Management of logs (HFLogger.exe)
- MantaManager
- the framework required to operate the server.
This information is returned in the following format:
<Manta version> + TAB + <HFSQL version> +TAB + <SQL version< | <Connection variable>.InfoServer | | hInfoVI | Version number of Manta.exe or Manta in Linux | <Connection variable>.InfoServer | | hInherit | The user will inherit from the value of the rights granted to the group to which he belongs | <Connection variable>.ModifyDatabaseRights,
<Connection variable>.ModifyFileRights,
<Connection variable>.ModifyServerRights | | hIntegrityCascade | Modification/Deletion rule: Cascading modification/deletion | ..ModificationRule, ..DeletionRule | | hIntegrityDefaultValue | Modification/Deletion rule: Default modification/deletion | ..ModificationRule, ..DeletionRule | | hIntegrityForbidden | Modification/Deletion rule: Modification/Deletion not allowed | ..ModificationRule, ..DeletionRule | | hIntegrityNone | Modification/Deletion rule: No integrity management | ..ModificationRule, ..DeletionRule | | hInternetFrame | The frame size is optimized for a use via Internet | HCS.FrameSize | | hInternetPageSize | Size of page for using the RPC via Internet. | Remote access (RPC on HFSQL) | | hIntranetFrame | The frame size is optimized for a use via Intranet | HCS.FrameSize | | hIntranetPageSize | Size of page for using the RPC via Intranet. | Remote access (RPC on HFSQL) | | hInvalidRecNum | Constant returned if there is no current record or if the specified file corresponds to a multi-file query. | <Source>.RecNum | | hItemBinary | Item type: Binary | ..Type | | hItemBinaryMemo | Item type: Binary Memo | ..Type | | hItemBinaryMemo4 | Item type: Binary memo (4 bytes) | ..Type | | hItemBoolean | Item type: Boolean | ..Type | | hItemCharacter | Item type: Character | ..Type | Versions 20 and laterhItemCombination New in version 20hItemCombination hItemCombination | Item type: Combination | ..Type | | hItemCurrency | Item type: Currency | ..Type | | hItemDate6 | Item type: Date | ..Type | | hItemDate8 | Item type: Date | ..Type | | hItemDateTime | Item type: Date/Time | ..Type | Versions 20 and laterhItemEnumeration New in version 20hItemEnumeration hItemEnumeration | Item type: Enumeration | ..Type | | hItemHour | Item type: Hour | ..Type | | hItemIdAuto | Item type: Automatic identifier (8 bytes) | ..Type | | hItemIdAuto4 | Item type: Automatic identifier (4 bytes) | ..Type | | hItemInteger1 | Item type: 1-byte integer | ..Type | | hItemInteger2 | Item type: 2-byte integer | ..Type | | hItemInteger4 | Item type: 4-byte integer | ..Type | | hItemInteger8 | Item type: 8-byte integer | ..Type | | hItemInvalid | Invalid type of item | ..Type | Versions 24 and laterhItemJSON New in version 24hItemJSON hItemJSON | Item type: JSON | ..Type | | hItemNumeric | Item type: High-precision numeric | ..Type | | hItemNumRec | Item type: Record number | ..Type | | hItemPicture | Item type: Image | ..Type | | hItemReal4 | Item type: 4-byte real | ..Type | | hItemReal8 | Item type: 8-byte real | ..Type | | hItemRealTurbo | Item type: Turbo real | ..Type | | hItemText | Item type: Text | ..Type | | hItemTextMemo | Item type: Text Memo | ..Type | | hItemTimeLength | Item type: Duration | ..Type | | hItemUnicodeMemo | Item type: Unicode Text Memo | ..Type | | hItemUnicodeText | Item type: Unicode text | ..Type | | hItemUnsignedInteger1 | Item type: Unsigned 1-byte integer | ..Type | | hItemUnsignedInteger2 | Item type: Unsigned 2-byte integer | ..Type | | hItemUnsignedInteger4 | Item type: Unsigned 4-byte integer | ..Type | | hItemUnsignedInteger8 | Item type: Unsigned 4-byte integer | ..Type | Versions 24 and laterhItemUUID128 New in version 24hItemUUID128 hItemUUID128 | Item type: UUID 128 | ..Type | Versions 24 and laterhItemUUID128Auto New in version 24hItemUUID128Auto hItemUUID128Auto | Item type: UUID 128 automatic identifier | ..Type | Versions 24 and laterhItemUUID256 New in version 24hItemUUID256 hItemUUID256 | Item type: UUID 256 | ..Type | Versions 24 and laterhItemUUID256Auto New in version 24hItemUUID256Auto hItemUUID256Auto | Item type: UUID 256 automatic identifier | ..Type | | hJNLBackupPath | Path of the directory containing the backups of the logs | <Connection variable>.SetServer | | hJNLPath | Path of the directory containing all the logs of the different HFSQL Client/Server applications | <Connection variable>.SetServer | Versions 23 and laterhkaInterval New in version 23hkaInterval hkaInterval | Maximum time (in seconds) after which, if no communication is established between the server and the client, the server will check the presence of client. | <Connection variable>.SetServer | Versions 23 and laterhkaTimeout New in version 23hkaTimeout hkaTimeout | Maximum time-out (in seconds) for the server when checking the presence of client. If the client is not found at the end of this time-out, the client is automatically disconnected. | <Connection variable>.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 | | hKeepTRS | Stores the transaction files during the deletion | <Connection variable>.DeleteDatabase,
<Connection variable>.DeleteFile | Versions 17 and laterhLanguageBinarySort New in version 17hLanguageBinarySort 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, ..LanguageDescribed, H.LanguageCreationUnicode | | hLanguageCreation | Used to find out whether the language used to perform the comparisons and the sort corresponds to "Defined at creation". | ..Language, ..LanguageDescribed | Versions 17 and laterhLanguageFastSort New in version 17hLanguageFastSort hLanguageFastSort | The sort will be performed by comparing the characters one by one according to a generic sort. | ..Language, ..LanguageDescribed, H.LanguageCreationUnicode | | hlbActive | Enable or disable the load balancing | <Connection variable>.SetServer | | hlbClientCalls | Value modifying the coefficient applied to the counter for client calls | <Connection variable>.SetServer | | hlbDisk | Value modifying the coefficient applied to the counter for the bytes read or written on disk by the server | <Connection variable>.SetServer | | hlbDiskAccess | Value modifying the coefficient applied to the counter for the number of disk accesses. | <Connection variable>.SetServer | | hlbMaxTimeout | Value modifying the maximum time-out for a server request | <Connection variable>.SetServer | | hlbReceived | Value modifying the coefficient applied to the counter for the bytes received by the server | <Connection variable>.SetServer | | hlbSent | Value modifying the coefficient applied to the counter for the bytes sent by the server | <Connection variable>.SetServer | | hLimitParsing | Limits the file browse: The browse will stop as soon as the last sought value is found. The current record will correspond to this last record found.
<Source>.Found will be set to False and <Source>.Out will be set to True.
This constant is used to optimize the search speed in client/server mode. | <Source>.ReadSeek, <Source>.ReadSeekLast, <Source>.ReadSeekFirst, <Source>.Seek, <Source>.SeekLast, <Source>.SeekFirst | | hLockNo | Type of lock: No lock | <Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLockReadWrite | Type of lock: Lock in read/write | <Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLockWrite | Type of lock: Lock in write mode | <Source>.Add, HForward, HLockFile, HLockRecNum, HLast, HWrite, HRead, HReadLast, HReadPrevious, HReadFirst, HReadSeekLast, HReadSeekFirst, HReadNext, <Source>.Modify, HPrevious, HFirst, HCross, HSeek, HSeekLast, HSeekFirst, HBackward, HNext | | hLogIdentification | Configures the file to re-create: Re-creates the "JournalIdentification.fic" file. | <Source>.LogRecreate | | hLogJNLFile | Configures the file to re-create: Only <File name>JNL.FIC is recreated. | <Source>.LogRecreate | | hLogLevel | Defines the elements that must be found in the log file | <Connection variable>.SetServer | | hLogNo | Format of log process: No log | ..LogMethod | | hLogOperation | Configures the file to re-create: Re-creates the "JournalOperation.fic" file. | <Source>.LogRecreate | | hLogPath | Path of the directory containing the log files | <Connection variable>.SetServer | | hLogReadingWriting | Format of log process: Log the read and write operations performed in the file | ..LogMethod | | hLogUser | Configures the file to re-create: Re-creates the log of users ("UserLog.fic").
This file exists in HFSQL Client/Server only. This file contains the information (login, computer, ...) about the users who perform the logged actions. | <Source>.LogRecreate | | hLogWriting | Format of log process: Log the write operations performed in the file | ..LogMethod | Versions 20 and laterhlpBackup New in version 20hlpBackup hlpBackup | Type of scheduling to list: Scheduling of backups. | | Versions 22 and laterhlpCalcStat New in version 22hlpCalcStat hlpCalcStat | Type of operation performed on the server: statistical calculation. | Type hServerOperation | Versions 22 and laterhlpKeyDetection New in version 22hlpKeyDetection hlpKeyDetection | Type of operation performed on the server: detection of keys. | Type hServerOperation | Versions 20 and laterhlpMaterializedView New in version 20hlpMaterializedView hlpMaterializedView | Type of scheduling to list: Tasks for refreshing the materialized views. | | Versions 20 and laterhlpOptimization New in version 20hlpOptimization hlpOptimization | Type of scheduling to list: Tasks for optimizing files (re-indexing, statistical calculation). | | Versions 22 and laterhlpReplication New in version 22hlpReplication hlpReplication | Type of operation performed on the server: server replication. | Type hServerOperation | Versions 20 and laterhlpTask New in version 20hlpTask hlpTask | Type of scheduling to list: Scheduled tasks that run a stored procedure. | | | hLstAll | Lists all the keys, all the files, all the items or all the connections | <Source>.ListKey, HListFile, <Source>.ListItem, HListConnection,
<Connection variable>.ListStoredElement | | hLstCompositeKey | Lists the composite key items only | <Source>.ListKey, <Source>.ListItem | Versions 22 and laterhLstDatabaseSize New in version 22hLstDatabaseSize hLstDatabaseSize | List of connection databases as well as their size. | <Connection variable>.ListDatabase | | hLstDetail | Lists the detailed information | <Source>.ListKey, HListFile,
<Source>.ListLink, <Source>.ListItem, HListConnection,
<Connection variable>.ListStoredElement | | hLstDetailPlus | For the numeric items or keys, adds to the detailed information the number of digits found in the integer part and in the decimal part. | <Source>.ListKey, <Source>.ListItem | | hLstFile | Lists the databases and their files for the server defined by the connection | <Connection variable>.ListDatabase | | hLstItem | Lists the non-key and non-memo items | <Source>.ListItem | | hLstKey | Lists the key items | <Source>.ListKey, <Source>.ListItem | | hLstLogicalOrder | Lists the items or the keys according to the logical order of items | <Source>.ListKey, <Source>.ListItem | Versions 20 and laterhLstMaterializedView New in version 20hLstMaterializedView hLstMaterializedView | Lists the materialized views found on an HFSQL server. | HListFile | | hLstMemo | Lists the memo items | <Source>.ListItem | | hLstNormal | Lists all keys/List not sorted, not detailed, without the files described dynamically/List of links/Lists the items (except for composite key items)/List of connections, not sorted, not detailed, without the connections described dynamically. | <Source>.ListKey, HListFile, <Source>.ListItem, HListConnection | | hLstOpened | Stores the opened connections only | HListConnection | | hLstOriginalItem | Used on a log file (xxxJNL.fic), lists the items of the source file (that was logged). For example, on CustomerLOG.Fic, lists the items of CUSTOMER file. | <Source>.ListKey, <Source>.ListItem | | hLstQuery | - Lists the queries found on a server
Versions 19 and laterLists the queries that have been run. New in version 19Lists the queries that have been run. Lists the queries that have been run.
| | | hLstSet | Lists the sets of procedures found on a server | <Connection variable>.ListStoredElement | | hLstSorted | Sorts the list of keys, files, items or connection in ascending order | <Source>.ListKey, HListFile, <Source>.ListItem, HListConnection | | hLstStoredProcedure | Lists the stored procedures of a connection via Native Connectors or OLE DB | HListFile,
<Connection variable>.ListStoredElement | | hLstSystemTable | List of system tables for a connection via Native Connectors or OLE DB | HListFile | | hLstTable | List of user tables for a connection via Native Connectors or OLE DB | HListFile | | hLstView | - List the views of a connection via Native Connectors or OLE DB.
Versions 20 and laterList the SQL views on an HFSQL server. New in version 20List the SQL views on an HFSQL server. List the SQL views on an HFSQL server.
| HListFile | | hMasterReplica | Replication mode: The data file is a master replica (HCreateMasterReplica was used to create the master replica) | ..Replication | | hMaxActivityStatisticsSize | Maximum size in megabytes (MB) of files for activity statistics | <Connection variable>.SetServer | | hMaxLogSize | Maximum size in megabytes (MB) of log files | <Connection variable>.SetServer | Versions 24 and laterhMaxNumberConnection New in version 24hMaxNumberConnection hMaxNumberConnection | Maximum number of connections allowed per application. | <Connection variable>.SetServer | | hMaxVal | Defines an upper bound for a filter | <Source>.BuildKeyValue,
<Source>.Filter,
<Source>.FilterStartsWith,
<Source>.FilterIncludedBetween | | hMemoAuto | The memos are read during the access to the item | <Source>.SetMemo | | hMemoBin | Type of file used for the memo: Any binary file | <Source>.LinkMemo | | hMemoImg | Type of file used for the memo: Image file | <Source>.LinkMemo | | hMemoNo | No management of memos | <Source>.SetMemo | | hMemoOle | Type of file used for the memo: OLE file | <Source>.LinkMemo | | hMemoWav | Type of file used for the memo: sound file | <Source>.LinkMemo | | hMemoYes | The text memos are read whenever the record is read.
Read the binary memos when accessing the item. | <Source>.SetMemo | | hMessage | Configure the information message | HOnServerCall | | hMinVal | Defines a lower bound for a filter | <Source>.BuildKeyValue,
<Source>.Filter,
<Source>.FilterStartsWith,
<Source>.FilterIncludedBetween | Versions 20 and laterhMmoCompact New in version 20hMmoCompact hMmoCompact | Compression and defragmentation of "Mmo" files. | <Source>.Index | | hMmoSize | Size of memo file in bytes (".Mmo" file) | <Source>.InfoFile | | hMode2GB | Indicates whether the system files support more than 2 GB | <Connection variable>.SetServer | | hModeDirect | Priority implementation of locks | <Source>.Mode | | hModeMono | Single-user lock mode | <Source>.Mode | | hModeMulti | Multi-user lock mode | <Source>.Mode | | hModeReservation | Non-priority implementation of locks | <Source>.Mode | | hModifyFile | When modifying the query result, these modifications will be applied to the files belonging to the query.
If this option is not specified, only the query result is modified. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | Versions 17 and laterhmsBackgroundTask New in version 17hmsBackgroundTask hmsBackgroundTask | A hot automatic modification is performed (available for the HFSQL Client/Server data files only). | <Source>.ModifyStructure | Versions 17 and laterhmsNoCheck New in version 17hmsNoCheck hmsNoCheck | The automatic data modification is performed even if the file description is more recent than the analysis description. | <Source>.ModifyStructure | Versions 17 and laterhmsNormal New in version 17hmsNormal hmsNormal | Standard operating mode of the automatic data modification. | <Source>.ModifyStructure | | hNativeAccessAS400 | Provider that will be used for the connection: Native AS/400 Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessDB2 | OLE DB provider that will be used for the connection: Native DB2 Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessInformix | OLE DB provider that will be used for the connection: Native Informix Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 20 and laterhNativeAccessMariaDB New in version 20hNativeAccessMariaDB hNativeAccessMariaDB | OLE DB provider that will be used for the connection: Native MariaDB Connector (optional module of WINDEV/WEBDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessMySQL | OLE DB provider that will be used for the connection: Native MySQL Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessOracle | OLE DB provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessOracleLite | Provider that will be used for the connection: Native Oracle Connector (optional module of WINDEV Mobile) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessPostgreSQL | OLE DB provider that will be used for the connection: Native PostgreSQL Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessProgress | OLE DB provider that will be used for the connection: Native Progress Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 16 and laterhNativeAccessSQLAzure New in version 16hNativeAccessSQLAzure hNativeAccessSQLAzure | OLE DB provider that will be used for the connection: Native SQL Azure Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | Versions 15 and laterhNativeAccessSQLite New in version 15hNativeAccessSQLite hNativeAccessSQLite | OLE DB provider that will be used for the connection: Native Connector to an SQLite database | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessSQLServer | OLE DB provider that will be used for the connection: Native SQL Server Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessSQLServerMobile | Provider that will be used for the connection: Native SQL Server Mobile Connector (optional module of WINDEV Mobile) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessSybase | OLE DB provider that will be used for the connection: Native Sybase Connector (optional module of WINDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessXBase | OLE DB provider that will be used for the connection: Native xBase Connector | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNativeAccessXML | Provider that will be used for the connection: Native XML Connector (supplied with WINDEV/WEBDEV) | HConnect, <Source>.DeclareExternal,
HDescribeConnection, HListFile,
<Connection variable>.OpenConnection,
..Provider, ..CtOLEDBProvider, ..CtDescribedOLEDBProvider | | hNdxCacheSize | Maximum size in megabytes (MB) of index cache | <Connection variable>.SetServer | | hNdxCompact | Re-index operation with compression | <Source>.Index | | hNdxDelete | Reindex and delete damaged records | <Source>.Index | | hNdxMinimal | Re-index operation while ignoring the corrupted keys | <Source>.Index | | hNdxNormal | Standard re-index operation | <Source>.Index | | hNdxNoStat | Reindex without statistical calculation | <Source>.Index | | hNdxSilent | Configure the re-index operation: No display while re-indexing | <Source>.Index | | hNdxSize | Size of index file in bytes (".Ndx" file) | <Source>.InfoFile | | hNoBind | Run a query without enabling the bind | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery,
<Source>.PrepareSQLQuery | | hNoCheck | No check is performed, the analysis description may differ from the description of physical file. | <Source>.CheckStructure | | hNoError | No error occurred | HError | Versions 21 and laterhNoHourglass New in version 21hNoHourglass hNoHourglass | When reading the query result, this read operation may be locked and a hourglass appears by default. This constant is used not to display the hourglass in this case. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hNoIndex | The file index is not copied | <Connection variable>.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 | Versions 15 and laterhNone New in version 15hNone hNone | Used to disable the simulation of a specific network. | <Connection variable>.SimulateNetwork | | hNoRefresh | The table or query content will not be refreshed | <Source>.Last, <Source>.ReadLast, <Source>.ReadFirst, <Source>.First | | hNotAKey | Characteristics of an item: Non-key item | ..KeyType | | hNotes | Property of a database found on an HFSQL server: Database description or any other information associated with the database by <Connection variable>.ModifyDatabaseProperty. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.InfoServerProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty, <Connection variable>.ModifyServerProperty | Versions 18 and laterhNotifCCClassic New in version 18hNotifCCClassic hNotifCCClassic | The notifications are sent by the Control Centers in HFSQL Classic mode. | <Connection variable>.NotifConfigure | Versions 18 and laterhNotifCCCS New in version 18hNotifCCCS hNotifCCCS | The notifications are sent by the Control Centers in Client/Server mode. | <Connection variable>.NotifConfigure | Versions 18 and laterhNotifCritical New in version 18hNotifCritical hNotifCritical | The notifications will be sent from the critical level (for the critical and error problems). | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | Versions 18 and laterhNotifEmail New in version 18hNotifEmail hNotifEmail | The notifications are sent by email. | <Connection variable>.NotifConfigure | Versions 18 and laterhNotifError New in version 18hNotifError hNotifError | The notifications will be sent for the error problems only. | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | Versions 22 and laterhNotifInformation New in version 22hNotifInformation hNotifInformation | The notifications will be sent from the information level (for the information, warning, critical and error problems) | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | Versions 18 and laterhNotifWarning New in version 18hNotifWarning hNotifWarning | The notifications will be sent from the warning level (for the warning, critical and error problems). | <Connection variable>.NotifAddCCRecipient, <Connection variable>.NotifAddEmailRecipient | | hNotLocking | Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To find out whether the execution of the view or query is completed, use ..ExecutionCompleted.
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 | | 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 | | hNotSorted | Sort direction: Item not sorted | ..SortType | | hODBC | OLE DB provider that will be used for the connection: OLE DB provider for ODBC. Used to access an ODBC source declared in the ODBC data sources of Windows | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbAccess2000 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2000 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbAccess2007 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2007 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | Versions 19 and laterhOledbAccess2010 New in version 19hOledbAccess2010 hOledbAccess2010 | OLE DB provider that will be used for the connection: OLE DB provider for Access 2010 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbAccess97 | OLE DB provider that will be used for the connection: OLE DB provider for Access 97 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbDBase5 | OLE DB provider that will be used for the connection: OLE DB provider for dBase 5 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbExcel2000 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2000 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbExcel2007 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 2007 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbExcel97 | OLE DB provider that will be used for the connection: OLE DB provider for Excel 97 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbLotus4 | OLE DB provider that will be used for the connection: OLE DB provider for Lotus 4 | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbOracle | OLE DB provider that will be used for the connection: OLE DB provider for Oracle | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOledbSQLServer | OLE DB provider that will be used for the connection: OLE DB provider for SQL Server | ..CtOLEDBProvider, ..CtDescribedOLEDBProvider,
HConnect, <Source>.DeclareExternal, HListFile, <Connection variable>.OpenConnection, SQLConnect | | hOnDelete | Integrity rule applied during a deletion | <Connection variable>.SetIntegrity | | hOnUpdate | Integrity rule applied during a modification | <Connection variable>.SetIntegrity | | hOpenKeysetCursor | Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions). | HDescribeConnection,
<Connection variable>.OpenConnection | | hOptimisticCursor | The record is locked when it is updated | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 15 and laterhOptIndex New in version 15hOptIndex hOptIndex | Optimization options: Provokes the re-indexing operation on the data files. A hot re-indexing operation is performed on the indexes and on the full-text indexes. | hFileParameter variable | Versions 15 and laterhOptStat New in version 15hOptStat hOptStat | Optimization options: Provokes the recalculation of statistics on the data files. | hFileParameter variable | | hORead | File accessible in read-only | ..CtAccess, ..CtDescribedAccess,
HConnect, <Source>.Open | | hOReadWrite | File accessible in read/write | ..CtAccess, ..CtDescribedAccess,
HConnect, <Source>.Open | | hOwner | Property of a database found on an HFSQL server: Owner of database. | <Connection variable>.InfoDatabaseProperty, <Connection variable>.InfoFileProperty, <Connection variable>.ModifyDatabaseProperty, <Connection variable>.ModifyFileProperty | | hPackNo | Compression mode: No compression | ..MmoPackMethod | | hPackZLW | Compression mode: Compression based on the Ziw-Lempel algorithm, Welch implementation. | ..MmoPackMethod | | hPageSize | Size of a block of caches. This block of caches will be used when browsing a file. A large block of caches improves the browse and increases the transfers via network and the memory consumption. | HSetCache | | hPessimisticCursor | The record is locked as soon as it becomes in edit to be modified. | HDescribeConnection,
<Connection variable>.OpenConnection | | hPrecisionHigh | Position with high precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hPrecisionLow | Position with low precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hPrecisionMedium | Position with medium precision | <Source>.GetCurrentPosition, <Source>.SetPosition | | hQueryBreakable | The query initialization can be interrupted with the ESC key | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryDefault | The query is initialized without interruption | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryWithoutCorrection | Native Connector or OLE DB only:
No check is performed by the HFSQL engine. This option must be used if the query contains commands specific to a connection type (Oracle, SQL Server, etc.) | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | | hQueryWithoutHFCorrection | HFSQL only
The file format (filled with space characters or not) is not checked by the HFSQL engine. To be used if the query handles both HFSQL files in a format that fills items with space characters and HFSQL files in a format that does not fill items with space characters. | <HFSQL file>.ExecuteQuery, <HFSQL file>.ExecuteSQLQuery | Versions 19 and laterhReadCommitted New in version 19hReadCommitted hReadCommitted | Isolation level of transaction: only the finalized transactions are visible by the other users. | <Connection variable>.TransactionIsolation | | hReadOnlyCursor | The set of records cannot be modified. | HDescribeConnection,
<Connection variable>.OpenConnection | Versions 19 and laterhReadUncommitted |
|
|
| | |
|