TSqlite

TSqlite

TSqlite is a sqlite3 database COM DLL encapsulated in ATL. It is simple and easy to use. If you are used to using ADO, it just meets your needs, as shown in the following example:

 Do While Not rs.EOF   
    For i = 0 To rs.ColumnCount - 1   
        Debug.Print rs.ColumnValue(rs.ColumnName(i))    
    Next   
    rs.MoveNext   
Loop   

The test results are as follows:

Compilation environment:
Windows 10
Visual Studio 2019
Note: Supports compilation of all versions of vs6-vs2019. If you want to support use on xp, please use TSqlite.dsw and upgrade if necessary.
The upgrade route is generally: upgrade vs6 to vs2005 for transition and then upgrade to a higher version of the vs compilation environment.

sqlite version: 3.30.1