|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| The database can be accessed via a web service...... |
|
|
|
|
|
|
|
| WDMap is used to view the records found in a data file...... |
|
|
|
|
|
|
|
| Usage example of the HSubstDir function |
|
|
|
|
|
|
|
| Positions on the previous file record according to a browse item. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| The ActiveX control is used to easily manage the ActiveX technology...... |
|
|
|
|
|
|
|
| Performs the following operations:
If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation.
If the file exists, opens the file.... |
|
|
|
|
|
|
|
| Defines the password used to create or open a data file. |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Several types of controls can be used in a window, ...... |
|
|
|
|
|
|
|
| Sets the position on the next data file record according to a browse item. |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions.... |
|
|
|
|
|
|
|
| Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows). |
|
|
|
|
|
|
|
| The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc.... |
|
|
|
|
|
|
|
| Modifies the current connection. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis...... |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| WINDEV Tutorial - External database Using data from an external database - 40 min |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| The use of bar codes to identify and manage products has become essential...... |
|
|
|
|
|
|
|
| The controls can be copied from the window editor...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|