<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p></p>
<div>Hello guys, I want to update a value in a shape file using dbmanager and virtual layers</div>
<div><br>
</div>
<div>I have a the virtual layer mydata with the column myfield</div>
<div><br>
</div>
<div>but when a run;</div>
<div><br>
</div>
<div><b>update mydata</b></div>
<div><b>set myfield = 1</b></div>
<div><br>
</div>
<div>dbmanager threw me this error:</div>
<div><br>
</div>
<div><b>An error occurred when executing a query:</b></div>
<div><b>Query execution error on CREATE TEMP VIEW _tview AS update mydata </b></div>
<div><b>set myfield = 1; : 1 - near "update": syntax error</b></div>
<div><br>
</div>
<div><span style="font-family: Calibri, Arial, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">I know that is much easier make this with field calculator
but I need update the data with sql</span><span style="font-family: Calibri, Arial, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;"> for other scenarios
with certain types of conditions and several virtual layers involved.</span></div>
<br>
<p></p>
<p>Thanks before hand to everyone.</p>
</div>
</body>
</html>