|
|
|
|
|
|
|
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.... |
|
|
|
|
|
|
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.... |
|
|
|
|
|
|
For the Android applications, the available databases are HFSQL (Classic and Client/Server) and SQLite.... |
|
|
|
|
|
|
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.... |
|
|
|
|
|
|
The following paragraphs present the main aspects and specific features of the Native SQLite Connector. |
|
|
|
|
|
|
The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis.... |
|
|
|
|
|
|
An application that works with the User Groupware can be used with a database handled by a Native Connector...... |
|
|
|
|
|
|
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
WINDEV and WEBDEV propose a Native Connector to MariaDB (also called Native Access)...... |
|
|
|
|
|
|
When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError...... |
|
|
|
|
|
|
WINDEV and WEBDEV propose a Native Connector to PostgreSQL...... |
|
|
|
|
|
|
WINDEV and WEBDEV propose an optional Native Connector to Progress ...... |
|
|
|
|
|
|
WINDEV and WEBDEV propose a Native Connector for MySQL...... |
|
|
|
|
|
|
WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... |
|
|
|
|
|
|
This type of Native Connector allows access to ACCESS databases for better interoperability purposes...... |
|
|
|
|
|
|
WINDEV and WEBDEV propose an optional Native Connector to DB2...... |
|
|
|
|
|
|
WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server Access)...... |
|
|
|
|
|
|
The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database...... |
|
|
|
|
|
|
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.... |
|
|
|
|
|
|
Used to access specific functions for managing xBase (or dBase) data if Native xBase Access provided with WINDEV or WEBDEV 14 is not available. |
|
|
|
|
|
|
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)...... |
|
|
|
|
|
|
The native access to HFSQL Classic and Client/Server is available for the WINDEV applications running in Linux ("console" applications) and for the WEBDEV sites hosted in Linux...... |
|
|
|
|
|
|
WINDEV and WEBDEV propose an optional Native Connector to Sybase (also called Native Access to Sybase...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|