SQLite Third Lesson source code compilation error and solve

1)Fts2 has a designflaw and have been deprecated

2)Fts1 has a designflaw and have been deprecated

solution:

parse: fts1 There are design flaws that are now obsolete and have been provided Fts3 Fts1 sqlite_core

VS 's basic settings: Properties "C + +" "preprocessor" preprocessor definition

3)cannot open includefile: ' unicode/utypes.h ': No such file or directory

Fts1 caused by disabling Fts1 smooth compilation passed.

fts1 There is a design flaw that causes a database error ( Databasecorruption highly recommend discarding the module instead of fts3 dsqlite_enable_ Broken_fts1=1 to compile options.

The FTS1 module will be compiled as an extension module (when Sqlite_core is not defined).

In addition, if Sqlite_enable_fts1 is defined,FTS1 is also compiled into the SQLite kernel.

4) Error:no Module:rtree

sqlite3.exe The console program is not carrying the rtree module, if you need to enable the module, you need to call the precompiled definition: Sqlite_enable_rtree, shell.c regenerate the program.

5) Console program

set up an empty console, and then import the SQLite source code, compile the following error:

Error LNK2019: unresolved external symbol [email protected], the symbol in function ___tmaincr ...

The first step: c++/ Pre-compilation, add:sqlite_enable_rtree parameter Support RTREE

Step two: If it is a console program:

1. Select Project->properties in the menu , pop up the property Pages window

2. Configurationproperties->c/c++->preprocessor, Preprocessordefinitions _ Windows,  add _console.

3. In the left column, select:configurationproperties->linker->system, then in the right column SubSystem the corresponding item to CONSOLE (/subsystem:console)

6)unexpected end offile while looking for precompiled header. Did you forget to add ' #include "stdafx.h" ' to your source?

SQLite Source code can not invoke pre-compilation processing, because sqlite source code is pure C language, can not get VC + + pre-compilation benefits.

FIX: Properties " C + +"Precompiled Headers" create, use precompiled headers (without precompiled headers)

SQLite Third Lesson source code compilation error and resolution