|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A Table control can be used to display the content of a data file or query... |
|
|
|
|
|
|
|
| Two types of directories can be configured when creating the executable... |
|
|
|
|
|
|
|
| When you design a quick prototype, you often create windows (or pages) without defining any data files... |
|
|
|
|
|
|
|
| A Looper control can be used to display the content of a data file or query... |
|
|
|
|
|
|
|
| The analysis allows you to define the structure of data files used by the project... |
|
|
|
|
|
|
|
| Describes a link between two data files programmatically. |
|
|
|
|
|
|
|
| Returns the list of data files watched by HWatch. |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Returns the list of data files watched by HWatch. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection... |
|
|
|
|
|
|
|
| Allows you to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Stops watching a data file on an HFSQL server. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| This feature is used to signal that a data file cannot be modified after writing... |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Used to check whether an integrity error occurred. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL data files specified by the user when installing the application. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Cancels an alias that was declared beforehand by HAlias. |
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Stops watching a data file on an HFSQL server. |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file.
|
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Sets the position on the previous record of the data file according to a browse item. |
|
|
|
|
|
|
|
| Describes a full-text index of data file created programmatically. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
|
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Used to check whether a lock error occurred. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Ends the description of the structure of an xBase data file programmatically. |
|
|
|
|
|
|
|
| Sets the position on the previous record of the data file according to a browse item. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| 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), view or query to a JSON file. |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |
|
|
|
|
|
|
|
| Stores the current context of a data file: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile support NULL values in items of HFSQL data files and for all other types of access (Native, OLE DB... |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Defines a semantic index of a data file created programmatically. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file.
|
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| During the life of an application, items live and die... |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| The analysis proposes two types of Unicode items ... |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| Describes a file item programmatically. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
|
|
|
|
|
|
|
| The Continent type is used to find out the characteristics of a continent. |
|
|
|
|
|
|
|
| The Country type is used to find out the characteristics of a country. |
|
|
|
|
|
|
|
| Used to find out the properties of a database on an HFSQL server. |
|
|
|
|
|
|
|
| The constants are language elements whose value is fixed once and for all... |
|
|
|
|
|
|
|
| Used to find out whether the number called is busy. |
|
|
|
|
|
|
|
| Used to find out whether an answer was given to the call. |
|
|
|
|
|
|
|
| Returns the error of the last SOAP procedure that failed. |
|
|
|
|
|
|
|
| Returns the error for the last .Net procedure that failed. |
|
|
|
|
|
|
|
| Used to find out the properties of a database on an HFSQL server. |
|
|
|
|
|
|
|
| The FaxCompleteStatus structure is automatically filled during the call to FaxStatus...... |
|
|
|
|
|
|
|
| Used to find out and modify the properties of the current burner. |
|
|
|
|
|
|
|
| Free the resources of a query (after the call to HExecuteQuery or HExecuteSQLQuery). |
|
|
|
|
|
|
|
| Enables (or disables) the remote control for the current multi-user WINDEV application. This is an advanced function. |
|
|
|
|
|
|
|
| The sfSeekDeletedResult type is used to find out the characteristics of a deleted record that was retrieved by SFSeekDeleted... |
|
|
|
|
|
|
|
| The nfcTag type is used to define the advanced characteristics of an NFC tag (Near Field Communication). |
|
|
|
|
|
|
|
| List of HFSQL properties associated with the queries and views... |
|
|
|
|
|
|
|
| The diagPath type is used to define all the advanced characteristics of a Path shape (equivalent to a polygon that can include rounded lines). |
|
|
|
|
|
|
|
| Checks the existence of a directory. |
|
|
|
|
|
|
|
| Modifies the period (which means the number of days) displayed in a Gantt Chart column found in a Table (or TreeView Table) control. |
|
|
|
|
|
|
|
| List of standard FTP functions... |
|
|
|
|
|
|
|
| Links help users navigate the help system...... |
|
|
|
|
|
|
|
| Allows you to find out whether an update is available for the specified application. |
|
|
|
|
|
|
|
| The sfSaveResult type is used to find out the result of SFAdd and SFModify... |
|
|
|
|
|
|
|
| The sfExecuteQueryResult type is used to find out the result of SFForwardQuery and SFExecuteQuery... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|