<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="+1"><tt>I am using qgis 2.14.1 on fedora 21 Linux<br>
<br>
I've done this successfully in older versions of qgis but it's
not working now and I don't kjnow why.<br>
<br>
So I open a spatialite database in DB manager. I can add tables
with and without geometry just fine. The problem is when I try
to load a query nothing happens. I input the query execute it
to make sure it works. Then select Load as new layer. Select a
unique key and a geometry column (the geometry is a simple
linestring). Then press Load now! Nothing happens! So I added
messages to db manager code and everything looks OK but a valid
QgsVectorLayer isn't created?<br>
<br>
So I tried in the python console and
QgsVectorLayer("dbname=test.sqlite table=test (geometry)",
"test0", "spatialite") works but </tt></font><font size="+1"><tt>QgsVectorLayer("dbname=test.sqlite
table='select * from test' </tt></font><font size="+1"><tt>(geometry)",
"test0", "spatialite") Does NOT. Doing </tt></font><font
size="+1"><tt>QgsVectorLayer("dbname=test.sqlite table='select *
from test'</tt></font><font size="+1"><tt>", "test0",
"spatialite")creates a non geometry table correctly???<br>
<br>
Like I said this used to work in older versions of qgis. Anyone
know what to check next?<br>
</tt></font>
</body>
</html>