Latest SQLite

[giantdragon]

Fortunately I have successfully compiled latest SQLite version. It seems works!!!

1. Download latest SQLite sources, unpack them, copy to "C:\QtSDK\QtSources\4.7.3\src\3rdparty\sqlite"
2. Open file "C:\QtSDK\QtSources\4.7.3\src\sql\drivers\sqlite\q sql_sqlite.h" Replace "#include <QtSql/private/qsqlcachedresult_p.h>" to "#include <C:/QtSDK/QtSources/4.7.3/src/sql/kernel/qsqlcachedresult_p.h>"
3. cd "C:\QtSDK\QtSources\4.7.3\src\plugins\sqldrivers\s qlite"
4. qmake "INCLUDEPATH+=C:\QtSDK\QtSources\4.7.3\src\plugins \sqldrivers\" "LIBS+=C:\QtSDK\QtSources\4.7.3\src\plugins\sqldri vers\"
5. mingw32-make release

Spent whole day solving this problem. I think Nokia must write tutorial how to do this and update include path.

[ChrisW67]

I think Nokia must write tutorial how to do this and update include path.

There's a perfectly good option to build the Qt libraries using a system (external) Sqlite, rather than the bundled Sqlite. It is documented in the configure options referred to by the existing install docs (See Step 4), and also pointed out by Wysota above. Had you used that option this exercise would have been trivial.

configure --help
...
-system-sqlite ..... Use sqlite from the operating system.
...
-I <string> ........ Add an explicit include path.
-L <string> ........ Add an explicit library path.
...

• Download, unpack, build, and install the SQlite library.
• Unpack the Qt source or clean the configuration of an existing copy
• Configure the Qt source with the "-system-sqlite" option. You will probably also need the -I and -L options.
• Build Qt

After this updating the version of Sqlite used is as simple as replacing the shared library.