[Qgis-user] Update value in shape file using dbmanager and virtual layers

[Luis Fernando Duque Quintero]

Hello guys, I want to update a value in a shape file using dbmanager and virtual layers

I have a the virtual layer mydata with the column myfield

but when a run;

update mydata
set myfield = 1

dbmanager threw me this error:

An error occurred when executing a query:
Query execution error on CREATE TEMP VIEW _tview AS update mydata
set myfield = 1; : 1 - near "update": syntax error

I know that is much easier make this with field calculator but I need update the data with sql for other scenarios with certain types of conditions and several virtual layers involved.


Thanks before hand to everyone.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170530/37deed43/attachment.html>