|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQLite Connector. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server Access)...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose an optional Native Connector to Sybase (also called Native Access to Sybase...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... |
|
|
|
|
|
|
|
| To use an SQLite database with Native Connector (also called Native Access), the structure of SQLite tables must be imported into the data model editor.... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native Connector to SQLite. This Native Connector allows you to access an SQLite database from a WLanguage program without using an external driver.... |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure.... |
|
|
|
|
|
|
|
| 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...... |
|
|
|
|
|
|
|
| The CursorOptions property is used to manage the type of cursor used for a connection (Native Connectors, OLE DB, etc.). |
|
|
|
|
|
|
|
| For backward compatibility with the earlier versions of Native Oracle Connector (also called Native Oracle Access), the connection can still be configured in WDORAINS (supplied with Native Oracle Connector)...... |
|
|
|
|
|
|
|
| For compatibility with the earlier versions of the Native SQL Server Connector (also called Native SQL Server Access), the connection can still be configured in WDSQSINS (supplied with the Native SQL Server Connector)...... |
|
|
|
|
|
|
|
| The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc.... |
|
|
|
|
|
|
|
| The CalculatedItemExpression property is used to:
Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or through programming.
Define the SQL expression returning the value of a calculated item (when describing the item through programming).... |
|
|
|
|
|
|
|
| Lists the users currently connected to one or more files handled by a Client/Server connection.... |
|
|
|
|
|
|
|
| The ExtendedInfo property is used to get additional information:
about a data file accessed by a Native Connector or HFSQL Client/Server.
about an item accessed by a Native Connector or HFSQL Client/Server.
about a connection. In this case, this property is equivalent to CtExtendedInfo.... |
|
|
|
|
|
|
|
| The diagConnectionPoint type is used to define all the advanced characteristics of a connection point (i.e. point around a shape that a connector snaps to) in a Diagram Editor control. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The Connection keyword can correspond to:
the Connection variable.
the Connection property used to get and change the connection currently associated with a data file.
For more details, see Connection.
the Connection property of a hbScanParameter variable.... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application that uses HFSQL Client/Server data files, WDInst allows you to...... |
|
|
|
|
|
|
|
| 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 ODBCConnectionName property is used to:
Identify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
Specify the name of the ODBC connection used when printing a report based on a "query performed on a connection".... |
|
|
|
|
|
|
|
| Closes the current connection and frees the memory used by the connection. |
|
|
|
|
|
|
|
| Returns information about the status of a connection as well as the statistics about this connection. |
|
|
|
|
|
|
|
| The first operation to perform in order to use WDSQL is to establish the connection to a database...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|