|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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 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. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Deletes all elements:
from a one-dimensional or two-dimensional WLanguage array.
from an associative array.
from an advanced array property (array of gglCalendar events, etc.).
from a WLanguage queue.
from a WLanguage stack.
from a WLanguage list.... |
|
|
|
|
|
|
|
| Deletes all elements:
from a one-dimensional or two-dimensional WLanguage array.
from an associative array.
from an advanced array property (array of gglCalendar events, etc.).
from a WLanguage queue.
from a WLanguage stack.
from a WLanguage list.... |
|
|
|
|
|
|
|
| The native access to HFSQL Classic and Client/Server is available for WINDEV applications running in Linux ("console" applications) and for the WEBDEV websites hosted in Linux...... |
|
|
|
|
|
|
|
| Modbus is a "field" (industrial and/or restricted environments) communication protocol created in 1979...... |
|
|
|
|
|
|
|
| Allows you to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the table is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| An OLE control can be bound to an item in a table, query, etc.... |
|
|
|
|
|
|
|
| WDMap is used to view the records found in a table...... |
|
|
|
|
|
|
|
| Allows you to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the table is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| A query with parameters can be used...... |
|
|
|
|
|
|
|
| When a WINDEV, WEBDEV or WINDEV Mobile element (analysis, query, ...... |
|
|
|
|
|
|
|
| The NbItem property is used to get the total number of items (including composite keys) in a record of:
a file described in the data model editor,
a file described programmatically,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display...... |
|
|
|
|
|
|
|
| A data-bound Table control linked to a table is a field whose columns are linked to fields in a table or query (data source)...... |
|
|
|
|
|
|
|
| The NbKeyItem property is used to get the total number of key items (including composite keys) in a record of:
a file described in the data model editor,
a file described through programming,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|