|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The analysis allows you to define the structure of data files used by the project... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Two types of directories can be configured when creating the executable... |
|
|
|
|
|
|
|
| A Table control can be used to display the content of a data file or query... |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Used to check whether a lock error occurred. |
|
|
|
|
|
|
|
| Describes a full-text index of data file created programmatically. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file.
|
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Describes a file item programmatically. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Lists the words of the current record that will be taken into account by the full-text indexing. |
|
|
|
|
|
|
|
| Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
Unlocks a record locked by: - HLockRecNum,
- a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
|
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection... |
|
|
|
|
|
|
|
| Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| 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 last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the approximate position of current record in the data file.
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Stores the current context of a data file: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| 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 links (Merise) in the current analysis or in a specific analysis. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Cancels an alias that was declared beforehand by HAlias. |
|
|
|
|
|
|
|
| Returns the list of data files watched by HWatch. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| During the life of an application, items live and die... |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| This feature is used to signal that a data file cannot be modified after writing... |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Used to check whether an integrity error occurred. |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX). |
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL data files specified by the user when installing the application. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Returns the list of data files watched by HWatch. |
|
|
|
|
|
|
|
Creates an HFSQL view.
This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Exports the records from a data file (HFSQL or OLE DB), view or query to a JSON string. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the list of keys in a data file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
Initializes: - one or all variables of file items with their default values.
- one or all items of a Record variable with their default values.
|
|
|
|
|
|
|
|
| Adds or modifies a trigger on an HFSQL data file. |
|
|
|
|
|
|
|
| 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, ... |
|
|
|
|
|
|
|
| Sets the position on the previous record of the data file according to a browse item. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
| Checks whether the current record corresponds to the current filter or search. |
|
|
|
|
|
|
|
Unlocks the records of a data file:- locked by HLockFile.
- individually locked by a locking read function.
|
|
|
|
|
|
|
|
| Describes a link between two data files programmatically. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Sets the position on the previous record of a file according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Temporarily disables the 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). |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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).
|
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Returns the spatial keys of a data file (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| Automatically updates the controls of a page with:
the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
the values of the bound WLanguage variables.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
| A Table control (populated programmatically, based on a data file or based on a variable) can include Combo Box columns...... |
|
|
|
|
|
|
|
| The remote HFSQL administrator proposes a full management of the HFSQL Client/Server databases...... |
|
|
|
|
|
|
|
| The setup program creation wizard includes the setup of the database along with the application and suggests additional elements...... |
|
|
|
|
|
|
|
| Any program developed with WINDEV, WEBDEV or WINDEV Mobile can easily access...... |
|
|
|
|
|
|
|
| This help page presents the different data sources available for a control.... |
|
|
|
|
|
|
|
| The DateLastAccessed property gets the date the file was last accessed. |
|
|
|
|
|
|
|
| An application that uses the user groupware can be used with a HyperFileSQL database in Client/Server mode...... |
|
|
|
|
|
|
|
| Refreshes a Table or TeeeView Table control from a given position:
for a control linked to a file: changes made in the linked data file are reflected in the control.
for a control handled programmatically: the calculated columns are re-calculated.... |
|
|
|
|
|
|
|
| Refreshes a Table or TeeeView Table control from a given position:
for a control linked to a file: changes made in the linked data file are reflected in the control.
for a control handled programmatically: the calculated columns are re-calculated.... |
|
|
|
|
|
|
|
| The ExtendedInfo property is used to get additional information:
about a data file accessed by a Native Connector or HFSQL Client/Server.
about an item accessed by a Native Connector or HFSQL Client/Server.
about a connection. In this case, this property is equivalent to CtExtendedInfo.... |
|
|
|
|
|
|
|
| A Bar Code control can be bound to an item in a data file, query, etc.... |
|
|
|
|
|
|
|
| This page explains how to program Table controls based on a data file...... |
|
|
|
|
|
|
|
| The links are used to link the files found in an analysis between themselves...... |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError...... |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles data files...... |
|
|
|
|
|
|
|
| The MaxValue property is used to:
get and set the top value of a report based on a data file.
get the maximum value of the current filter.
get the maximum value of a data series in a chart.
get and set the maximum value for some types of controls.... |
|
|
|
|
|
|
|
| The MinValue property is used to:
get and set the bottom value of a report based on a data file.
get the minimum value of the current filter.
get the minimum value of a data series in a chart.
get and set the minimum value for some types of controls.... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ...... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|