|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| MySource is used to handle the current data source (file, view or query) associated with a report or with a table based on a data file... |
|
|
|
|
|
|
|
| Copies a data source (file, query, view, ...) to a physical HFSQL table with the same description. This table is neither encrypted nor password protected. |
|
|
|
|
|
|
|
| Returns the list of items in a table (query or view) recognized by the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. |
|
|
|
|
|
|
|
| WINDEV Tutorial - Reports and Queries Distribute Reports and Queries with your applications - 10 min |
|
|
|
|
|
|
|
| Closes an email management session depending on the selected mode (SMTP/POP3, IMAP, MS Exchange or Lotus Notes).... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Reports & Queries is used to...... |
|
|
|
|
|
|
|
| The Type property is used to get:
the type of element (table 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 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.... |
|
|
|
|
|
|
|
| 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...... |
|
|
|
|
|
|
|
| Returns the list of items:
found in a table (a query or a view) known to the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
found in a Record variable.... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Runs a JavaScript method of the jQuery library on a page element. |
|
|
|
|
|
|
|
| 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 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.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|