ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Native Connectors/Native Accesses / Native SQLite Connector
  • Overview
  • Programming
  • 1. Opening the connection
  • 2. Running queries
  • 3. Retrieving the result
  • 4. Closing the connection
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Native SQLite Connector: Programming with SQL functions
Native Connectors (Native Accesses)Available only with this kind of connection
Overview
The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis. However, the data must be handled by queries only. The content of SQLite files cannot be read directly.
Remark: Don't forget to read the limitations regarding the use of Native SQLite Connector
Programming

1. Opening the connection

SQLConnect opens a connection to an SQLite database via the Native Connector. The type of database used (SQLITE in this case) must be passed as parameter to SQLConnect.
The database name corresponds to the name of the database file
ConnectionNum = SQLConnect("SQLiteDatabase", "sa", "", "", "SQLITE")

2. Running queries

The queries are run by SQLExec. SQLExec expects the text of the SQL query as parameter, as well as the name that will be given to this query.
SQLExec("SELECT NOM, PRENOM, POSTE, PHOTO FROM CLIENT", "REQ1")

3. Retrieving the result

Several methods can be used to retrieve the result:
  • SQLFirst: Retrieves the result and starts an SQLFirst/SQLCol browse.
  • SQLTable: Retrieves the result of the query in a Table control populated programmatically in the WINDEV application or WEBDEV site. The result of the query can be retrieved by partial Fetch.
  • SQLFetch: Used to browse the different lines of the query result. The browse performed in the query result is an SQLFetch/SQLGetCol browse.
SQLLock is used to lock the table records or the records selected by the query.

4. Closing the connection

SQLClose is used to close the connection to the database once all the necessary queries have been run.
Minimum version required
  • Version 16
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help