| |
| Convert | Convierte un valor numérico en una cadena binaria para realizar una búsqueda en una clave numérica. |
| HAccelerateSpeed | Reorganizes the internal structure of the indexes to optimize the speed for accessing the data. |
| HActivateAutoFilter | Activa un filtro automático en los archivos relacionados al navegar por un archivo XML. |
| HActivateFilter | Activa el filtro que se creó previamente para el archivo de datos (vista o consulta) especificado. |
| HActivateTrigger | Vuelve a activar un disparador que fue desactivado por HDeactivateTrigger. |
| HAdd | Adds: - the record found in memory into the data file (query or view).
- the record found in a Record variable into the data file (query or view).
|
| HAlias | Creates a logical alias of a data file (or query) or cancels all existing aliases. |
| HBackward | Moves backward several records from the current position in the data file, according to a specified item. |
| HBuildKeyValue | Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.). |
| HBuildKeyValueANSI | Regardless of the platform used, the data stored in the HFSQL files is in ANSI format. |
| HCancelAlias | Cancela un alias declarado previamente con la función HAlias. |
| HCancelDeclaration | Allows you to: |
| HCancelSeek | Cancels the current search criterion. |
| HChangeConnection | Dynamically changes the connection associated with a data file. |
| HChangeDir | Cambia la ruta de acceso a un archivo de datos (es decir, el directorio en el que se manipulará el archivo). |
| HChangeKey | Changes the browse item. |
| HChangeLocation | Modifica el modo de búsqueda de los archivos de datos físicos (.FIC, .NDX, etc.). |
| HChangeLogDir | Modifies the location of log files corresponding to an HFSQL data file. |
| HChangeName | Modifies the physical name of a data file. |
| HChangeRplDir | Changes the location of the subscriber replica description ("*.rpl" file). |
| HCheckInalterado | Comprueba si uno o todos los registros de un archivo de datos inalterable no han sido modificados (con un editor hexadecimal, por ejemplo). |
| HCheckIndex | Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file). |
| HCheckMemo | Checks the structural integrity of memos in an HFSQL data file. |
| HCheckStructure | Defines the mode for comparing data files. |
| HClose | Closes either a data file or all data files opened by the current user: all corresponding physical data files are closed for the current user. |
| HCloseAnalysis | Closes the current analysis (or all current analyses in the case of a project with multiple analyses). |
| HCloseConnection | Cierra la conexión a una base de datos. |
| HCompareItem | Compara dos valores ordenándolos según el elemento de índice HFSQL especificado: todas las opciones de orden especificadas para el elemento se tienen en cuenta (distinguir mayúsculas y minúsculas, puntuación, dirección del orden, lenguaje Unicode, etc.). |
| HComputer | Almacena un número o identificador único de equipo para usar registros y transacciones en la red. |
| HConnect | Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. |
| HConvertX | Convierte un valor numérico en una cadena binaria para realizar una búsqueda en una clave numérica. |
| HCopyRecord | Copies: - the content of the current record (loaded in memory) to the current data file record.
- the content of the Record variable to the current data file record.
|
| HCreateMasterReplica | Creates the description file of a Master Replica (logged replication or universal replication). |
| HCreateMovableReplica | Creates a movable replication. |
| HCreateSubscriberReplica | Creates the description file of a subscriber replica. |
| HCreateView | Crea una vista HFSQL.
Esta función utiliza el anterior mecanismo de vistas. |
| HCreation | Creates an empty data file (file extension ".FIC") with index file, full-text index file and memo file if required. |
| HCreationIfNotFound | Performs the following operations: - If the data file doesn't exist, create an empty data file (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary.. The function is equivalent to HCreation.
- If the data file exists, opens the data file.
|
| HCross | Crosses a record in a data file. |
| HDataSourceKnown | Permite saber si se ha inicializado una fuente de datos. |
| HDBCreation | Finaliza la descripción de la estructura de un archivo de datos xBase mediante programación. |
| HDBDescribeField | Describes through programming each item found in the structure of an xBase file described by HDBDescribeFile. |
| HDBDescribeFile | Describes a file in dBase3 format (most common format) programmatically. |
| HDBDescribeIndex | Describes through programming the different index files that will be created. |
| HDBIndex | Opens an xBase index file. |
| HDBOpen | Opens the xBase data file and the "memo" file if it exists. |
| HDBOpenNoLock | In single-user mode, opens an xBase data file without locking it. |
| HDBSortType | Returns or modifies the sequence of text items in the xBase files. |
| HDeactivateAutoFilter | Desactiva un filtro automático en archivos relacionados al navegar por un archivo XML. |
| HDeactivateFilter | Temporarily disables the filter on a data file (view or query). |
| HDeactivateTrigger | Deshabilita un disparador. |
| HDeclare | Declara una descripción del archivo de datos (que esta en el análisis) en el proyecto actual. |
| HDeclareExternal | Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
| HDelete | Deletes a record from a data file (query or view). |
| HDeleteAll | Deletes all records from a data file, an HFSQL view or a query. |
| HDeleteTrigger | Elimina un desencadenador. |
| HDeleteView | Deletes a previously created view. This function uses the former view mechanism. |
| HDescribeConnection | Describes a new connection to an external database. |
| HDescribeFile | Describes a data file programmatically. |
| HDescribeFullTextIndex | Describes a full-text index of data file created programmatically. |
| HDescribeItem | Describes a file item programmatically. |
| HDescribeLink | Describes a link between two data files programmatically. |
| HDescribeTrigger | Adds or modifies a trigger on an HFSQL data file. |
| HDuplicateRecord | Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
| HEndNoModif | Unlocks a file that was locked by the same program with HNoModif. |
| HError | Devuelve el número del último error provocado por el motor HFSQL. |
| HErrorDuplicates | Permite verificar si se produjo un error duplicados. |
| HErrorInfo | Devuelve información detallada sobre el último error originado por el motor HFSQL. |
| HErrorIntegrity | Permite saber si se produjo un error de integridad. |
| HErrorLock | Used to check whether a lock error occurred. |
| HErrorModification | Allows you to: - return the value of a record item if a modification conflict occurs.
- check if a modification conflict occurred.
|
| HErrorPassword | Tras la ejecución de una función de lectura o escritura en un archivo de datos, se utiliza para averiguar si se ha producido un error causado por una contraseña incorrecta en este archivo de datos.. |
| HErrorStatusModification | Devuelve el estado de un registro durante un conflicto de modificación. |
| HExecuteQuery | Declares a query created in the query editor to the HFSQL engine and runs this query. |
| HExecuteQueryAsynchronous | Executes a SELECT query asynchronously. |
| HExecuteSQLQuery | Initializes a query written in SQL language and declares this query to the HFSQL engine. |
| HExecuteSQLQueryAsynchronous | Executes an SQL query asynchronously. |
| HExecuteView | Ejecuta una vista que fue creada de antemano (se puede utilizar para refrescar los datos de la vista, por ejemplo). Esta función utiliza el anterior mecanismo de vistas. |
| HExportCSV | Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
| HExportJSON | Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
| HExportJSONString | Exporta los registros de un archivo de datos (HFSQL u OLE DB), vista o consulta a una cadena JSON. |
| HExportXLS | Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
| HExportXML | Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
| HExtractMemo | Extrae el contenido de un campo de tipo memo binario de un archivo de datos, consulta o vista HFSQL a un archivo físico (en el disco). |
| HFileExist | Determines:- whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
- whether a view or a query was defined.
|
| HFilter | Defines and enables a filter on a data file, view or query. |
| HFilterContains | Defines and enables a "Contains" filter on a data file, view or query. |
| HFilterIdentical | Defines and enables a filter used to find the exact value of a string item. |
| HFilterIncludedBetween | Defines and enables an "Included between" filter on a file, view or query. |
| HFilterStartsWith | Defines and enables a "Start with" filter on a file, view or query. |
| HFirst | Sets the position on the first record of a data file according to the specified browse item. |
| HFlush | Forces the operating system of the computer where the data files are found to write data onto the disk. |
| HForward | Moves several records forward from the current position in the data file, according to a specified item. |
| HFound | Checks whether the current record corresponds to the current filter or search. |
| HFree | Transforms the crossed records (HCross) into deleted records. |
| HFreePosition | Borra una posición guardada por HSavePosition. |
| HFreeQuery | Releases query resources (following use of HExecuteQuery or HExecuteSQLQuery functions). |
| HFTListWord | Devuelve una lista de las palabras del registro actual que tendrá en cuenta el índice de texto completo. |
| HGetCurrentPosition | Returns the approximate position of current record in the data file. |
| HHistoryModification | Returns the modifications performed on one or more items of a given record. The result can be displayed in a list box or in a table to allow the user to view the modifications made to the specified file. |
| Importa un archivo CSV en un archivo de datos HFSQL Classic o Client/Server. Este archivo de datos debe haberse definido en el editor de análisis, o declarado con las funciones HDeclare, HDeclareExternal o HDescribeFile). |
| HImportHF55 | Imports a Hyper File 5.5 file into an HFSQL Classic file. |
| HImportJSON | Imports a JSON file into an HFSQL Classic data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
| HImportText | Imports a Text file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
| HImportXLS | Importa un archivo XLS a un archivo de datos en formato HFSQL Classic o Client/Server (archivo de datos descrito en el editor de análisis, o declarado por las funciones HDeclare, HDeclareExternal o HDescribeFile). |
| HImportXML | Imports an XML file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
| HIndex | Rebuilds the file index (".NDX" file). |
| HIndexingInProgress | Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed. |
| HInfoAnalysis | Returns information about an analysis (WDD file). |
| HInfoFile | Returns the characteristics of an HFSQL Classic or Client/Server data file. |
| HInfoMemo | Returns the characteristics of binary and text memos. |
| HInfoReplica | Returns information about the specified replica. |
| HInitHF55 | Used to access specific functions for managing xBase (or dBase) data if Native xBase Access provided with WINDEV or WEBDEV 14 is not available. |
| HInitSubscriber | Initializes the range of automatic identifiers for the description file of subscriber replica (".rpl" extension). |
| HJSONToRecord | Importa datos JSON al registro actual. |
| HLast | Sets the position on the last record of a data file according to a browse item. |
| HLinkMemo | Permite asociar un archivo a un campo de tipo memo binario o cancelar la asociación existente entre un archivo y un campo binario. |
| HListAnalysis | Returns the list of WINDEV or WEBDEV analyses (in HFSQL Classic format) available in a given directory. |
| HListConnection | Returns the list of connections currently described in the application: - connections described in the data model editor (for the main analysis and additional analyses if required).
- connections described by programming (with functions HDescribeConnection or HOpenConnection).
|
| HListCustomFolder | Returns a list of defined Custom-Folders (also called groups): - in the current analysis,
- in ongoing analyses (case of projects with multiple analyses).
- in the specified analysis.
|
| HListFile | Returns the list of files:- analysis in progress.
- of analyses in progress (case of projects with multiple analyses).
- specific analysis recognized by the HFSQL engine.
- available on a connection via a Native Connector or an OLE DB driver.
- for a group of files defined in the data model editor.
|
| HListFullTextIndex | Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
| HListItem | Devuelve la lista de artículos:- encontrada en un fichero de datos ( una consulta o una vista) conocido por el motor HFSQL. Los archivos de datos definidos por las funciones HDeclare, HDeclareExternal y HDescribeFile se tienen en cuenta.
- encontrado en una variable Record.
|
| HListKey | Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
| HListLink | Returns the list of data file bindings (Merise type) present:- in the current analysis,
- in ongoing analyses (projects with multiple analyses).
- in a specific analysis.
|
| HListProvider | Devuelve la lista de proveedores OLE DB y/o Native Connectors instalados en el equipo actual. |
| HListQueryParameter | Devuelve la lista de parámetros de una consulta creada en el editor de consultas. |
| HListREP | Returns the list of assignments for the data files handled by the current application, which means the list of physical files corresponding to the files described in the analysis. |
| HListSpatialKeys | Devuelve las claves espaciales de un archivo de datos (de una consulta o vista) reconocidas por el motor HFSQL. |
| HListStopWord | Returns the list of stop words used by a full-text index. |
| HListSynonym | Devuelve la lista de sinónimos utilizados por un índice de texto completo. |
| HListTrigger | Returns the list of triggers applied to one or more HFSQL data files. |
| HLockFile | Bloquea un archivo de datos e impide que los demás sitios o aplicaciones accedan a él. |
| HLockRecNum | Locks a record and restricts the access to this record for all the other applications. |
| HLogInfo | Agrega comentarios al registro al guardar la operación. |
| HLogRecreate | Used to recreate an empty log. |
| HLogRestart | Reinicia el registro del archivo. |
| HLogStop | Detiene el registro del archivo. |
| HMergeView | Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
| HMigrateLinkedCompositeKey | Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
| HMode | Changes the mode and the method for locking data files. |
| HModify | Modifica el registro especificado o el que esta en la memoria en el archivo de datos (consulta o vista). |
| HModifyStructure | Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization). |
| HNbRec | Returns the number of records in an HFSQL file, query or view: active records, deleted records, etc. |
| HNext | Establece la posición en el siguiente registro del archivo de datos según un campo de navegación. |
| HNoModif | Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
| HOnError | Customizes the management of HFSQL errors. |
| HOpen | Opens a data file. |
| HOpenAnalysis | Opens an analysis in HFSQL Classic format. |
| HOpenComplementaryAnalysis | Abre un nuevo análisis, pero conserva el análisis principal de la aplicación. |
| HOpenConnection | Opens a connection to a specific database. |
| HOptimize | Permite utilizar los períodos de inactividad de un software (período sin procesos) para optimizar las consultas y navegaciones que se ejecutarán más adelante. |
| HOptimizeQuery | Optimiza las consultas de selección mediante el uso de tiempos de inactividad al gestionar una aplicación (período sin procesos). |
| HOut | Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |
| HPass | Defines the password used to create or open a data file. |
| HPrepareQuery | Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
| HPrepareSQLQuery | Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
| HPrevious | Sets the position on the previous record of the data file according to a browse item. |
| HQueryExecuted | Determina si se ha ejecutado una consulta. |
| HRead | Reads a record in a file according to a given record number. |
| HReadFirst | Positions on the first file record according to a browse item. |
| HReadLast | Sets the position on the last record of a data file according to a browse item. |
| HReadNext | Sets the position on the next data file record according to a browse item. |
| HReadPrevious | Sets the position on the previous record of a file according to a browse item. |
| HReadSeek | Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
| HReadSeekFirst | Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
| HReadSeekLast | Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). |
| HRecNum | Returns:- the number of the current record in the HFSQL data file.
- the number of the current record in the HFSQL view.
|
| HRecordDate | Devuelve la fecha y hora en que se modificó por última vez un registro HFSQL (Clásico o Cliente/Servidor). |
| HRecordToJSON | Retrieves the structure and value of the current record and exports them into a string in JASON format. |
| HRecordToString | Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). |
| HRecordToXML | Retrieves the structure and the value of the current record and exports them into a character string in XML format. |
| HRecreateSubscriberReplica | Recreates the subscriber replica description file (universal replication only) based on the information of the master replica (.rpm and .syn files). |
| HRefreshView | Asks to recalculate the content of a materialized view. |
| HRegenerateFile | Vuelve a generar un archivo de datos a partir de su registro. |
| HReset | Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
| HRestorePosition | Restores the previously saved context of a file (function HSavePosition): recording in progress, filter, playback pointers. |
| HRetrieveItem | Returns the content of an item found in the current record (in the data file, view, query, ...). |
| HRetrieveRecord | Returns the content of the current record (in a file, a view or a query, ...). |
| HRplDeclareLink | Declares a (1, 1) (0, n) link between two tables. |
| HRplManageFile | Define las opciones utilizadas para la replicación universal de un archivo: - la dirección de replicación.
- el modo de gestión de los conflictos.
|
| HRplManageItem | Especifica las opciones de replicación de un elemento: el elemento puede replicarse o no. |
| HRplPass | Establece las contraseñas que protegen los archivos de la replicación universal. |
| HSave | Modifica el registro actual si existe, si no existe, agrega un nuevo registro. |
| HSavePosition | Stores the current file context (current record, filter, pointers). |
| HSecurity | Activa o desactiva el mecanismo de seguridad automática en uno o más archivos de datos. |
| HSeek | Positions on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default). |
| HSeekFirst | Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
| HSeekLast | Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
| HSetDuplicates | Enables or disables the management of duplicates on a unique key. |
| HSetIntegrity | Enables or disables the management of an integrity constraint on a file link. |
| HSetLog | Enables or disables log management on a file. |
| HSetMemo | Used to modify the management mode of memo items. |
| HSetPosition | Sets the position on a record, based on the approximate position of one of its items. |
| HSetREP | Enables or disables the management of .REP files. |
| HSetReplication | Temporarily disables (or re-enables) the replication. |
| HSetTransaction | Enables or disables the management of transactions for one or more files. |
| HSetTrigger | Enables or disables the management of triggers. |
| HSortView | Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
| HStatCalculate | Performs various statistical calculations on the file keys. |
| HStatDate | Returns the date of the last update for the index statistics. |
| HState | Permite conocer el estado de un registro. |
| HStatNbDuplicates | Returns the number of duplicates for a given key item. |
| HStatNbRec | Devuelve el número de entradas para un elemento clave determinado. |
| HStatNbRecRange | Devuelve una estimación del número de entradas para un elemento clave en un intervalo de valores determinado. |
| HStatTime | Returns the time of the last update for the index statistics. |
| HSubstDir | Associates the data directory specified in the analysis with a directory found on disk. |
| HSynchronizeReplica | Synchronizes master and subscriber replicas: operations performed on one replica are transferred to the other. |
| HToFile | Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected. |
| HToItem | Assigns the specified value to an item of the current record. |
| HTransacción | Inicia una transacción en los archivos de datos (HFSQL o accedido a través de una Conector Nativo) y crea el archivo de transacción. |
| HTransactionCancel | If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction. |
| HTransactionEnd | Validates the current transaction: - the modifications performed on the data file since the start of transaction (HTransactionStart) are validated.
- the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
- the records locked in read-only by the transaction are unlocked.
|
| HTransactionFree | Transforms all "in transaction" records into "normal" records if they do not belong to a transaction currently in progress. |
| HTransactionInProgress | Used to find out whether a transaction is in progress. |
| HTransactionInterrupted | Permite saber si se interrumpió una transacción (la transacción no se validó, ni se canceló). |
| HTransactionStart | Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
| HTriggerRecordBefore | Recupera el valor de la Record actual antes de que se ejecuten los disparadores. |
| HUnlockFile | Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
| HUnlockRecNum | Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
| HVersion | Used to find out:- whether the content of a file was modified.
- whether the content of a file used by a query was modified.
|
| HViewToFile | Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding data file. This function uses the former view mechanism. |
| HWrite | Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
| WithSpace | Adds or deletes the spaces found on the right of a text item when reading it. |