|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The OLE DB provider on HFSQL is used to access an HFSQL database (Classic or Client/Server) from an external software that manages the accesses by OLE DB... |
|
|
|
|
|
|
|
| To handle a database via OLE DB, the following elements must be installed on the development computer and on the deployment computer... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.... |
|
|
|
|
|
|
|
| When defining the connections in the data model editor or when defining the connections programmatically, you have the ability to specifier the optional connection information... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer. |
|
|
|
|
|
|
|
| Adds:
the record found in memory into the data file (query or view).
the record found in a Record variable into the data file (query or view).... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Positions on the first row of the query result. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| The management mode of data files may have to be adapted when using an HFSQL Client/Server application...... |
|
|
|
|
|
|
|
| Moves backward several records from the current position in the data file, according to a specified item. |
|
|
|
|
|
|
|
| The automatic assisted replication is used to easily implement a replication on an existing application...... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Returns the characteristics of all the columns (or items):
for a given table.
for a given query.... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server Connector...... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code...... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... |
|
|
|
|
|
|
|
| Before you start using WDConver, you must have...... |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| The analysis is used to define the structure of data files used by the project...... |
|
|
|
|
|
|
|
| The following tools are provided with WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| Associates an OLE control with an OLE object by invoking a specific OLE server. |
|
|
|
|
|
|
|
| Initializes an OLE control with an OLE object. |
|
|
|
|
|
|
|
| Using WDConver in command line mode consists in running a conversion description created and saved with WDConver ("...... |
|
|
|
|
|
|
|
| The Name property is used to get:
the name of the font associated with a Font variable.
the name of a control, report or report block.
the name of a control, group of controls or window.
the name of a control, group of controls or page.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|