| |
| FileToPage | Automatically updates the controls of a page with:- the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
- the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
|
| FileToScreen | Actualiza automáticamente los controles de una ventana o página con:- los valores de los elementos vinculados en el registro actual (cargado en memoria) del archivo de datos descrito en el editor de modelo de datos.
- los valores de las variables WLanguage vinculadas.
Esta operación se realiza independientemente del estado de los controles (en gris, inactivos o invisibles). |
| HActivateFilter | Activa el filtro que se creó previamente para el archivo de datos (vista o consulta) especificado. |
| 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).
|
| 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.). |
| HCancelDeclaration | Allows you to: |
| HCancelSeek | Cancels the current search criterion. |
| HChangeConnection | Dynamically changes the connection associated with a data file. |
| 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. |
| HCloseConnection | Cierra la conexión a una base de datos. |
| 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.
|
| HDeactivateFilter | Temporarily disables the filter on a data file (view or query). |
| HDelete | Deletes a record from a data file (query or view). |
| HDescribeConnection | Describes a new connection to an external database. |
| 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. |
| HExecuteQuery | Declares a query created in the query editor to the HFSQL engine and runs this query. |
| HExecuteSQLQuery | Initializes a query written in SQL language and declares this query to the HFSQL engine. |
| HExtractMemo | Extrae el contenido de un elemento memo binario de un archivo de datos HFSQL, de una consulta o de una vista HFSQL a un archivo físico (en disco). |
| HFilter | Defines and enables a filter on a data file, view or query. |
| HFilterIdentical | Defines and enables a filter used to find the exact value of a string item. |
| HFilterStartsWith | Defines and enables a "Start with" filter on a file, view or query. |
| 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. |
| HFreePosition | Deletes a position saved by HSavePosition. |
| HGetCurrentPosition | Returns the approximate position of current record in the data file. |
| 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. |
| 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).
|
| HListDatabase | Lists the Client/Server databases associated with a connection. |
| HModify | Modifies the specified record or the record found in memory in the data file (query or view). |
| HNbRec | Returns the number of records in an HFSQL file, query or view: active records, deleted records, etc. |
| HOpen | Opens a data file. |
| HOpenConnection | Opens a connection to a specific database. |
| 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. |
| 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). |
| 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. |
| HSavePosition | Stores the current file context (current record, filter, pointers). |
| ScreenToFile | Automatically updates:- the values of a data file's items in memory with the values from the controls in the window.
- the value of the WLanguage variables with the value of the window controls.
This function is also available for WEBDEV pages. |