<div dir="ltr">may you check on latest 3.4 and master version please?<br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">Luigi Pirelli<br><br>**************************************************************************************************<br>* LinkedIn: <a href="https://www.linkedin.com/in/luigipirelli" target="_blank">https://www.linkedin.com/in/luigipirelli</a><br>* Stackexchange: <a href="http://gis.stackexchange.com/users/19667/luigi-pirelli" target="_blank">http://gis.stackexchange.com/users/19667/luigi-pirelli</a><br>* GitHub: <a href="https://github.com/luipir" target="_blank">https://github.com/luipir</a><br>* Mastering QGIS 2nd Edition:<br>* <a href="https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition" target="_blank">https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition</a><br>* Hire me: <a href="http://goo.gl/BYRQKg" target="_blank">http://goo.gl/BYRQKg</a><br>**************************************************************************************************</div></div><br></div><br><div class="gmail_quote"><div dir="ltr">On Thu, 8 Nov 2018 at 14:26, Herbert Lincon <<a href="mailto:herbert_lincon_jau@hotmail.com">herbert_lincon_jau@hotmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">




<div dir="ltr">
<div style="font-family:Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="color:black;font-family:Tahoma,sans-serif">Hello,</span><br>
</div>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
</div>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="color:black;font-family:Tahoma,sans-serif">in the user list, no-one could help me, can you?</span></div>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
sorry if I'm badly using this developer list</div>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div>
<div>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">In QGIS 2.18.23, I´m using the model "Execute SQL" from the Tollbox to run the statment:</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">"SELECT * FROM input1 ORDER BY TALHAO ASC;"</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">​where "TALHAO" is the name of a colum with integer values.</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">My issue is:</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">I made a Model with several steps, and I need to put this SQL statment in the middle of it,</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">but this process never accept a output as input.</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">For example: if the "Execute SQL" is the first step, it will execute normally,</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">but if it is not the first one, I got this error:</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:red">Error executing algorithm Execute SQL
</span><span style="font-family:"Tahoma","sans-serif";color:black"></span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif;margin-top:9.0pt;margin-right:0cm;margin-bottom:9.0pt;margin-left:0cm">
<b><span style="font-family:"Tahoma","sans-serif";color:red">virtual:</span></b><span style="font-family:"Tahoma","sans-serif";color:red"> Cannot find layer OUTPUTALGQGISDISSOLVE1_shp20181015165259558</span><span style="font-family:"Tahoma","sans-serif";color:black"></span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">Searching in the %temp% folder, this output file do exist!</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">I made another attempt,</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">with the SQL as first step,</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">if the input shape is named starting with letter, it will run</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">if the input name´s starts with number, a got this error:</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:red">Error executing algorithm Execute SQL
</span><span style="font-family:"Tahoma","sans-serif";color:black"></span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif;margin-top:9.0pt;margin-right:0cm;margin-bottom:9.0pt;margin-left:0cm">
<b><span style="font-family:"Tahoma","sans-serif";color:red">virtual:</span></b><span style="font-family:"Tahoma","sans-serif";color:red"> Query execution error on DROP TABLE IF EXISTS "input1"; CREATE VIRTUAL TABLE "input1" USING QgsVLayer(81121_463_DE20181015165152041);:
 1 - unrecognized token: "81121_463_DE20181015165152041"</span><span style="font-family:"Tahoma","sans-serif";color:black"></span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">I can´t understand why sometimes this algoritm run, and sometimes not</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">I would appreciate some help</span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black"> </span></p>
<p style="margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin-top:0px;margin-bottom:0px;margin:0cm 0cm 0.0001pt;font-family:"Times New Roman",serif">
<span style="font-family:"Tahoma","sans-serif";color:black">Thanks for the Attention</span></p>
<br>
</div>
<div style="font-family:Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<span style="font-family:Arial;color:rgb(0,0,0);font-size:12pt">______________________________________________</span><br>
</div>
<div id="m_2060764957840500038signature">
<div id="m_2060764957840500038divtagdefaultwrapper" dir="ltr">
<div><font face="Arial"><font style="background-color:rgb(255,255,255)"><span style="line-height:20px"><font face="Arial, Helvetica, sans-serif"><span style="font-size:12pt"><b></b></span></font>
<div style="color:rgb(0,0,0);font-family:Arial,Helvetica,sans-serif,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols;font-size:16px;font-weight:bold">
<font face="Arial"><font color="#0c0c0c" size="4"><b style="line-height:20px">Herbert Lincon R. A. dos Santos</b></font></font></div>
<div style="color:rgb(0,0,0);font-family:Arial,Helvetica,sans-serif,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols;font-size:16px;font-weight:bold">
<br>
</div>
</span></font></font></div>
<div style="color:rgb(0,0,0);font-family:Arial,Helvetica,sans-serif;font-size:12pt">
<font face="Arial"><font size="3"><font style="color:rgb(42,42,42);background-color:rgb(255,255,255)"></font><br>
</font></font></div>
</div>
</div>
</div>
</div>
</div>

_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote></div>