|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The controls can be copied from the window editor...... |
|
|
|
|
|
|
|
| Returns the list of triggers applied to one or more HFSQL tables. |
|
|
|
|
|
|
|
| Returns the number of the last error triggered by the HFSQL engine. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Modifies the current connection. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| Moves several records forward from the current position in the data file, according to a specified item. |
|
|
|
|
|
|
|
| Customizes the management of HFSQL errors. |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| If a transaction is in progress, rolls back all operations performed on tables in transactions since the start of the transaction. |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Used to lock:
The entire data table, in read and write mode. Its data cannot be accessed by other computers.
The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.... |
|
|
|
|
|
|
|
| The use of bar codes to identify and manage products has become essential...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|