Page History
- 2007-Jan-11 23:35 anonymous
- 2006-Dec-13 08:31 anonymous
- 2006-Dec-13 07:51 anonymous
- 2006-Dec-11 19:55 anonymous
- 2006-Aug-22 21:02 anonymous
- 2006-Aug-15 13:57 anonymous
- 2006-Aug-13 14:42 anonymous
- 2006-Jul-11 11:02 anonymous
- 2006-Apr-24 07:03 anonymous
- 2006-Jan-16 07:07 anonymous
- 2005-Mar-02 18:40 anonymous
- 2004-Aug-11 22:57 anonymous
- 2004-Aug-09 07:33 anonymous
- 2003-Oct-26 03:03 anonymous
- 2003-May-29 16:47 anonymous
- 2003-May-29 16:47 anonymous
Download
Download and unzip the file sqlite_source.zip. Do not use the .tar.gz files because they have not been pre-processed for use with Windows.
Create a starter DLL project
1. File > New > Project
2. Under Project Types, select Visual C++ Projects and then Win32.
3. Choose the project template "Win32 Project".
4. Give the project a name and click OK.
5. When the "Win32 Application Wizard" appears, choose Application Settings. set the Application Type to DLL and check the box that says "Empty project". Click Finish. You now have a blank DLL project.
Add the SQLite files to the project
7. Project > Add Existing Item
8. Add all the .c and .h files that you unzipped, except for: tclsqlite.c and shell.c.
Make a .DEF file
9. Create a new file called sqlite.def in the project directory. The contents of sqlite.def should be:
EXPORTS sqlite_open sqlite_close sqlite_exec sqlite_last_insert_rowid sqlite_error_string sqlite_interrupt sqlite_complete sqlite_busy_handler sqlite_busy_timeout sqlite_get_table sqlite_free_table sqlite_mprintf sqlite_vmprintf sqlite_exec_printf sqlite_exec_vprintf sqlite_get_table_printf sqlite_get_table_vprintf sqlite_freemem sqlite_libversion sqlite_libencoding sqlite_changes sqlite_create_function sqlite_create_aggregate sqlite_function_type sqlite_user_data sqlite_aggregate_context sqlite_aggregate_count sqlite_set_result_string sqlite_set_result_int sqlite_set_result_double sqlite_set_result_error sqliteMalloc sqliteFree sqliteRealloc sqlite_set_authorizer sqlite_trace sqlite_compile sqlite_step sqlite_finalize sqlite_progress_handler sqlite_reset sqlite_last_statement_changes
10. Add the sqlite.def file to the project.
11. Under Project > Properties navigate to the Linker folder and choose "Input". In the field that says "Module Definition File" type sqlite.def. NOTE: You have to do this twice, once for the Debug configuration and once for the Release configuration.
12. Compile!
How to make the SQLITE.EXE command-line utility
There are some slight changes if you wanted to build the sqlite.exe command-line utility, instead of the DLL. To do that, when you're creating the project and you get to the "Win32 Application Wizard", choose "Console Application" instead of "DLL". Then, when you are adding files to the project, also add shell.c. Finally, don't include the .DEF file.