|
|
|
|
|
|
|
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Usage example of the HOpenConnection function |
|
|
|
|
|
|
|
| Returns a list of keys to add to tables to improve query performance. |
|
|
|
|
|
|
|
| The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| Usage example of the HChangeConnection function |
|
|
|
|
|
|
|
| Once the connection to the database is established, WDSQL allows you to create different types of SQL queries...... |
|
|
|
|
|
|
|
| Usage example of the HDescribeConnection function |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Data masking is a process that transforms the data in an item that will be displayed to the user...... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| The Source property can be used on:
Chart control field field: in this case, the Source property indicates the source of the series: table column, list of values, etc, ...
a connection: in this case, the Source property is used to identify or define the source of a connection (HFSQL Client/Server, OLE DB, etc.)..... |
|
|
|
|
|
|
|
| Starting with version 21, you can manage transactions in SQL code...... |
|
|
|
|
|
|
|
| Drag and Drop is used to transfer data between several controls with the mouse. This data can be moved between several controls found in the same application or in different applications.... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|