Forget my request. I went ahead with a native SQLite query (after including
the sqlite3 header) here is what I used to get to the data,
sqlite3 *db;
int rc = sqlite3_open( spliteDBName.toStdString().c_str(), &db);
if( rc ){
txtStream<< "Can't open database: \n"<< sqlite3_errmsg(db)
<<endl;
sqlite3_close(db);
return;
}
strQry = "select i, sum(v) as sumi, count(i) as counti from tbltps
group by
i;";
rc = sqlite3_exec(db, strQry.toUtf8().constData(),NULL , NULL,
&zErrMsg);
if( rc!=SQLITE_OK ){
txtStream<< "\tSQL error: "<<strQry.toStdString()<<
zErrMsg<<endl;
sqlite3_free(zErrMsg);
return;
}
and one can use other functions such as
// SQLite get table statement
rc = sqlite3_get_table( db, strQry.toUtf8().constData(), &results,
&rows,
&columns, &errMsg );
Thank you again for your help,
Maaza
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/Load-SQLite-table-into-QGIS-tp6876536p6910904.html
Sent from the qgis-developer mailing list archive at Nabble.com.
_______________________________________________
Qgis-developer mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-developer
