[soci-users] sqlite3 rtree table creation fails...

[Witold E Wolski]

This is the create statement:
std::string creatstatements = "CREATE TABLE isofeatureboundingbox
USING rtree(id,minmzext, maxmzext,minrt, maxrt,minmz,maxmz);"

sql_.once << creatstatements;

And thats the exception I am catching

sqlite3_statement_backend::prepare: near "USING": syntax error



best
Witold

[Mateusz Loskot]

Post by Witold E Wolski
std::string creatstatements = "CREATE TABLE isofeatureboundingbox

-------------------------------------------------^^^^^^^^^^^^^^^^^^

AFAIK, it should read

CREATE VIRTUAL TABLE

Also, check you have R*Tree module built into your SQLite library.

Best regards,

[Witold E Wolski]

Hi,

Thanks you were right. The VIRTUAL was mssing.

regards

Post by Mateusz Loskot

Post by Witold E Wolski
std::string creatstatements = "CREATE TABLE isofeatureboundingbox

-------------------------------------------------^^^^^^^^^^^^^^^^^^
AFAIK, it should read
CREATE VIRTUAL TABLE
Also, check you have R*Tree module built into your SQLite library.
Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
soci-users mailing list
https://lists.sourceforge.net/lists/listinfo/soci-users