|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming. |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| ODBCUserName is used to:
Identify the username used to connect to a database via an ODBC driver or a Native Connector.
Specify the username used to connect to a database via an ODBC driver or a Native Connector.... |
|
|
|
|
|
|
|
| Executes an XPATH query in an xmlDocument variable. |
|
|
|
|
|
|
|
| Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
|
| Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
|
| Returns the result of a calculation XPath query. |
|
|
|
|
|
|
|
| Used to lock:
The entire data table, in read and write mode. Its data cannot be accessed by other computers.
The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.... |
|
|
|
|
|
|
|
| Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL or Oracle) or via an OLE DB access on a specific table or set of tables. |
|
|
|
|
|
|
|
| Free the resources of a query (after the call to HExecuteQuery or HExecuteSQLQuery). |
|
|
|
|
|
|
|
| Free the resources of a query (after the call to HExecuteQuery or HExecuteSQLQuery). |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| The result of a select query can be used in...... |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|