[Qgis-user] SQL language in DB Manager

Antonio Valanzano anvalanz at gmail.com
Wed Mar 1 06:21:24 PST 2023


Thanks for the info.

So we have a mix of SQLite and SpatiaLite functions  and QGIS expressions.

The problem I see is that QGIS expressions can be used only when a virtual
layer is created starting from shapefiles,
because, as I have already shown in my previous mail, when working with
virtual layers based on tables of a Spatialite database such expressions
are not recognized and the system generates an error message.

There is no uniformity between the different virtual layers and this could
confuse users.


Antonio Valanzano
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230301/8072e542/attachment.htm>


More information about the QGIS-User mailing list