[Qgis-developer] Re: Load SQLite table into QGIS

[mmekuria]

Dear Martin:
I tried every way I can think of and I have not been able to use the
non-geometric table .

Here is the code I am using let me know if you think I am doing something
wrong,


	QString spliteDBName = "C:/db/sjs.db";
	QString tblName = "tztrips";
	QString dbProv = "spatialite";
	QString schema = "dbname=\'" + spliteDBName +"\'  table=\'" + tblName +
"\'";
	QgsVectorLayer* tztripLayer = new QgsVectorLayer(schema, tblName, dbProv);
	if (!tztripLayer->isValid())
	{
		txtStream<<"Spatialite Layer \t"<<tztripLayer->name().toStdString()<<"\t
is invalid!"<<endl;
		return;
	}

It will report that the layer is invalid. If I use the a geometry table it
still does the same. 

But I have the geometry file working using the Uri and I am content with
that. 

Any help is greatly appreciated,

Maaza



--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Load-SQLite-table-into-QGIS-tp6876536p6906613.html
Sent from the qgis-developer mailing list archive at Nabble.com.