|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc.... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| Modifies the current connection. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a web service proxy (SOAP). |
|
|
|
|
|
|
|
Returns the list of connections currently described in the application: - connections described in the data model editor (for the main analysis and, if necessary, additional analyses).
- connections described by programming (with functions HDescribeConnection or HOpenConnection).
|
|
|
|
|
|
|
|
Returns the list of files:- current analysis.
- analyses in progress (projects with multiple analyses).
- a specific analysis recognized by the HFSQL engine.
- available on a connection via a Native Connector or an OLE DB driver.
- for a group of files defined in the data model editor.
|
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| Closes a connection to a database. |
|
|
|
|
|
|
|
| The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ...... |
|
|
|
|
|
|
|
| Any program developed with WINDEV, WEBDEV or WINDEV Mobile can easily access...... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile propose different methods for describing a connection...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc.... |
|
|
|
|
|
|
|
| The first operation to perform in order to use WDSQL is to establish the connection to a database...... |
|
|
|
|
|
|
|
| The database can be accessed via a web service...... |
|
|
|
|
|
|
|
| Denies all new connections to a database or to all databases. |
|
|
|
|
|
|
|
| Denies all new connections to a database or to all databases. |
|
|
|
|
|
|
|
| In order for the application to be able to handle the data files found on the HFSQL server, the connection that will be used by the application must be defined in the project...... |
|
|
|
|
|
|
|
| The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.).... |
|
|
|
|
|
|
|
| The CtCursorOptions property is used to get the type of cursor used when connecting to an external database. |
|
|
|
|
|
|
|
| WDSQL is used to find out the structure of the accessed database...... |
|
|
|
|
|
|
|
| Begins, commits or rolls back a transaction:
on the files of a database opened by SQLConnect,
on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection.... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose an optional Native Connector to Informix (also called Native Access...... |
|
|
|
|
|
|
|
| The Database property is used to get and modify the database associated with a connection. |
|
|
|
|
|
|
|
| Returns the connection to the common database or to the reference database of the SaaS site. |
|
|
|
|
|
|
|
| WINDEV Tutorial - External database Using data from an external database - 40 min |
|
|
|
|
|
|
|
| Closes a connection to a database. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... |
|
|
|
|
|
|
|
| A database is an organized collection of data for a particular purpose (e.g., manage orders)...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|