|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming. |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Returns a list of keys to add to tables to improve query performance. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| The Alias type is used to declare and handle a logical alias for a data file or query. |
|
|
|
|
|
|
|
| Modifies the specified record or the record found in memory in the data file (query or view). |
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| The InitialFile property is used to get the original name of the table associated to an item in a query. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a table, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| Populates a List Box or Combo Box control programmatically with the records from a table or query. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Returns the spatial keys of a table (used in a query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a table, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| User-friendly editors in practice... |
|
|
|
|
|
|
|
| To make the result of a query easier to read, the records can be sorted according to one or more items...... |
|
|
|
|
|
|
|
| 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, ...... |
|
|
|
|
|
|
|
| Transforms the following elements into a specific format:
a structure (and its subelements),
a class (and its subelements),
an array (including the associative arrays),
a queue,
a stack,
a list.... |
|
|
|
|
|
|
|
| Fills a calendar that was previously retrieved: the events corresponding to the calendar are retrieved via a custom query. |
|
|
|
|
|
|
|
| The FilterCondition property gets the selection condition set by HFilter on a table, HFSQL view, or query. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), a view or a query to a CSV file. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|