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.
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
