sqlitevb


SQLiteVB: public functions modified to attend VB standards of compatibility

The original SQLite source has been modified following the tutorial available on http://www.persistentrealities.com/index.php?p=18

The "inspiration" for this came after finding this implementation: http://tannertech.net/sqlite3vb/

However, the above mentioned one does not use the latest SQLite source, so I did this one myself using VC++ 2008 based on SQLite 3.6.10, which can be found here: http://sqlite.org/download.html

Please keep in mind it is not an official version of SQLite, and there is completely NO affiliation with any of the above mentioned parties. It probably has some bugs. Feel free to work on them. To be a member of this project, just go to the ProjectMembership page in the Wiki section and leave there the requested information.

Usage: Private Declare Sub sqlite3_open Lib "SQLiteVB.dll" (ByVal FileName As String, ByRef handle As Long) Private Declare Sub sqlite3_close Lib "SQLiteVB.dll" (ByVal DB_Handle As Long) Private Declare Function sqlite3_last_insert_rowid Lib "SQLiteVB.dll" (ByVal DB_Handle As Long) As Long Private Declare Function sqlite3_changes Lib "SQLiteVB.dll" (ByVal DB_Handle As Long) As Long Private Declare Function sqlite_get_table Lib "SQLiteVB.dll" (ByVal DB_Handle As Long, _ ByVal SQLString As String, ByRef ErrStr As String) As Variant()'Results to an array (x,y) Private Declare Function sqlite_libversion Lib "SQLiteVB.dll" () As String Private Declare Function number_of_rows_from_last_call Lib "SQLiteVB.dll" () As Long

Project Information

Labels:
SQLite __stdcall VB6 VisualBasic CPlusPlus open source VisualStudio2008