Poco::Data::Session Can't create table?

[hahaha]

I use this class as below:

Code: Select all

SQLite::Connector::registerConnector();
Session ses("SQLite", "partition_1.db");
std::string varcharStr="varchar(50)";
std::string colname="coll";
ses << "create table topic(:col,:varchar)",use(colname),use(varcharStr),now;

it does't work and throw a Poco::Data::SQLite::InvalidSQLStatementException: SQL Statement invalid or database missing exception!

may be session does't support create data table SQL?

[alex]

it does't work and throw a Poco::Data::SQLite::InvalidSQLStatementException: SQL Statement invalid or database missing exception!

Can't do binding like that with DDL SQL statements, you are seeing compile error from SQLite API. But even if you could, you still have a syntax error - there is no comma between column name and type.