VB SQLite Library (COM-Wrapper)

[xiaoyao]

Good point.

It's because you only have Visual Studio 6.0 installed without C++.
The VB6 compiler resorts by "KERNEL32.LIB" to some files in /vc98/lib.
You can get it to work to copy paste that folder from another installation. So it's not really needed to have C++ 6.0 installed if you can get the folder somewhere else.


Why? It's a COM Wrapper so not need to fiddle with sqlite API's for the developer. Also sqlite_get_table is not used because it's deprecated and there are more efficient API functions to get the same result internally.

i think gettable is the quick method,you can test:
put all select result to :dim data(rows,cols),how much time need?
1,sqlite3-get_table
2,com object,
3,ado drivers

We need a quick way to read all the data。
also need a way to export csv format,or import csv file.