[Qgis-user] qgis - virtual layers

[David_James]

Jozef Riha wrote
> hello list,
> 
> not sure if this is a known problem but during virtual layers feature
> testing i discovered that this tool has issues when source used in query
> contains characters such as space, forward slash, dash and possibly others
> in column names. it would be nice if user would be presented with a
> meaningful error message rather than a cryptic message about syntax error.
> 
> to reproduce:
> - import test.geojson to qgis
> - add virtual layer - run select * from test
> - you'll get:
> 
> Query execution error on DROP TABLE IF EXISTS "test"; CREATE VIRTUAL TABLE
> "test" USING QgsVLayer(test20160305235656402);: 1 - near "1": syntax error
> 
> br, j

Replying to a message that is over a year old ...

Virtual layer creation also errors with a cryptic error message if a column
name is "Update" - I suspect it will fail if column names are any SQL
reserved words. 

This is probably obvious, but it has taken me a couple of hours to realise
what the problem was and I would probably have never realised if Google had
not found Jozef Riha's posting for me.

(QGIS 2.18.2 on Windows)





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/qgis-virtual-layers-tp5254623p5324368.html
Sent from the QGIS - User mailing list archive at Nabble.com.