|
|
|
|
|
|
|
|
|
|
|
|
| Resultados de la búsqueda |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Two types of directories can be configured when creating the executable... |
|
|
|
|
|
|
|
| A Looper control can be used to display the content of a data file or query... |
|
|
|
|
|
|
|
| When you design a quick prototype, you often create windows (or pages) without defining any data files... |
|
|
|
|
|
|
|
| The analysis allows you to define the structure of data files used by the project... |
|
|
|
|
|
|
|
| Un control Línea de tiempo se puede...... |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Trigger monitoring of write actions (add, modify or delete) performed on a data file present on an HFSQL server. In case of modification, a specific procedure can be triggered. |
|
|
|
|
|
|
|
| Exporta los registros de un archivo de datos (HFSQL u OLE DB), vista o consulta a una cadena JSON. |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Describe un archivo de datos mediante programación. |
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL data files specified by the user when installing the application. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| Exporta los registros de un archivo de datos (HFSQL u OLE DB), vista o consulta a un archivo JSON. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file.
|
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
Returns the list of items:- found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
- found in a Record variable.
|
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| This feature is used to signal that a data file cannot be modified after writing... |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
Returns the list of files:- current analysis.
- analyses in progress (projects with multiple analyses).
- a 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.
|
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of the HFSQL data files and for all the other types of accesses (Native, OLE DB, ... |
|
|
|
|
|
|
|
| Describes a link between two data files programmatically. |
|
|
|
|
|
|
|
| Used to check whether a lock error occurred. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| After the execution of a read or write function in a data file, used to find out whether an error caused by a wrong password occurred on this data file.
|
|
|
|
|
|
|
|
| Stores the current context of a data file: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
| Exporta los registros de un archivo de datos (HFSQL u OLE DB), vista o consulta a una cadena JSON. |
|
|
|
|
|
|
|
| Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Describes a full-text index of data file created programmatically. |
|
|
|
|
|
|
|
| Sets the position on the previous record of the data file according to a browse item. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |
|
|
|
|
|
|
|
| Sets the position on the previous record of the data file according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of links (Merise) in the current analysis or in a specific analysis. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| During the life of an application, items live and die... |
|
|
|
|
|
|
|
| Describes a file item programmatically. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a data file. |
|
|
|
|
|
|
|
Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
|
|
|
|
|
|
|
|
| The analysis proposes two types of Unicode items... |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Trigger monitoring of write actions (add, modify or delete) performed on a data file present on an HFSQL server. In case of modification, a specific procedure can be triggered. |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Cuando una función HFSQL falla (devuelve False, por ejemplo), se puede conocer mediante programación el número del error correspondiente con la función HError...... |
|
|
|
|
|
|
|
| Permite:
Borrar una declaración realizada de antemano por HDeclare, HDeclareExternal, HDescriveFile.. Después de esta operación, el archivo de datos motor HFSQL deja de reconocerlo..
Liberar los recursos de una consulta (después de la llamada a HExecuteQuery o HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| Usage example of the SQLTransaction function |
|
|
|
|
|
|
|
| Usage example of the HDescribeItem function |
|
|
|
|
|
|
|
| Usage example of the Type property |
|
|
|
|
|
|
|
| Llena una array de clases o estructuras con el contenido de un archivo de datos o consulta HFSQL. |
|
|
|
|
|
|
|
| Usage example of the Size property |
|
|
|
|
|
|
|
| Usage example of the HCopyRecord function |
|
|
|
|
|
|
|
| Usage example of the HDeclareExternal function |
|
|
|
|
|
|
|
| Usage example of the HLinkMemo function |
|
|
|
|
|
|
|
| Este tipo de control Looper utiliza los datos de un archivo de datos o consulta...... |
|
|
|
|
|
|
|
| Usage example of the HIndex function |
|
|
|
|
|
|
|
| Usage example of the HDescribeFullTextIndex function |
|
|
|
|
|
|
|
| Usage example of the HViewToFile function |
|
|
|
|
|
|
|
| Devuelve los diferentes elementos de una ruta: disco, directorios, nombre y extensión del archivo. |
|
|
|
|
|
|
|
| Usage example of the BuildBrowsingTable function |
|
|
|
|
|
|
|
| Usage example of the HCreation function |
|
|
|
|
|
|
|
| Usage example of the HFileExist function |
|
|
|
|
|
|
|
| Usage example of the HState function |
|
|
|
|
|
|
|
| Usage example of the HCancelDeclaration function |
|
|
|
|
|
|
|
| Usage example of the fDate function |
|
|
|
|
|
|
|
| El siguiente mecanismo permite a los desarrolladores escribir código WLanguage más fácilmente en el editor de código ...... |
|
|
|
|
|
|
|
| Usage example of the fDateTime function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|