|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| The database can be accessed via a web service...... |
|
|
|
|
|
|
|
| Returns the list of items in a data file (query or view) recognized by the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. |
|
|
|
|
|
|
|
| The RecordSize property is used to get the size (in bytes) of a record in:
a file described in the data model editor,
a file described through programming,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| WINDEV Tutorial - Reports and Queries Distribute Reports and Queries with your applications - 10 min |
|
|
|
|
|
|
|
| Reports & Queries is used to...... |
|
|
|
|
|
|
|
| A List Box or Combo Box control can be used to display the content of a data file or query, to allow a user to select a record, for example...... |
|
|
|
|
|
|
|
| Deletes all elements:
from a one-dimensional or two-dimensional WLanguage array.
from an associative array.
from the advanced array property (array of gglCalendar events, ...).
from a WLanguage queue.
from a WLanguage stack.
from a WLanguage list.... |
|
|
|
|
|
|
|
| The NbMemoItem property is used to get the total number of memo items in a record of:
a file described in the data model editor,
a file described through programming,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| 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 Type property is used to get:
the type of element (data file or item) defined programmatically or in the data model editor, view or query.
the type of object.
the type of data held in a Variant.... |
|
|
|
|
|
|
|
| Deletes all the 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.... |
|
|
|
|
|
|
|
| When a WINDEV, WEBDEV or WINDEV Mobile element (analysis, query, ...... |
|
|
|
|
|
|
|
| Modbus is a "field" (industrial and/or restricted environments) communication protocol created in 1979...... |
|
|
|
|
|
|
|
| Runs a JavaScript method of the jQuery library on a page element. |
|
|
|
|
|
|
|
| A query with parameters can be used...... |
|
|
|
|
|
|
|
| The native access to HFSQL Classic and Client/Server is available for the WINDEV applications running in Linux ("console" applications) and for the WEBDEV sites hosted in Linux...... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display...... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| An OLE control can be bound to an item in a data file, query, etc.... |
|
|
|
|
|
|
|
| Used to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the data file is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Allows you to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the data file is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|