Hello, unfortunately, the same error hapens in 3.4.1
for now, I´m not looking for this SQL issue to be solved, but for another solution to "Group by" the elements in a shape file. any ideas? ______________________________________________ Herbert Lincon R. A. dos Santos ________________________________ De: Luigi Pirelli <[email protected]> Enviado: quinta-feira, 8 de novembro de 2018 12:56 Para: [email protected] Cc: qgis-developer Assunto: Re: [QGIS-Developer] Execute SQL may you check on latest 3.4 and master version please? Luigi Pirelli ************************************************************************************************** * LinkedIn: https://www.linkedin.com/in/luigipirelli * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli * GitHub: https://github.com/luipir * Mastering QGIS 2nd Edition: * https://www.packtpub.com/big-data-and-business-intelligence/mastering-qgis-second-edition * Hire me: http://goo.gl/BYRQKg ************************************************************************************************** On Thu, 8 Nov 2018 at 14:26, Herbert Lincon <[email protected]<mailto:[email protected]>> wrote: Hello, in the user list, no-one could help me, can you? sorry if I'm badly using this developer list In QGIS 2.18.23, I´m using the model "Execute SQL" from the Tollbox to run the statment: "SELECT * FROM input1 ORDER BY TALHAO ASC;" where "TALHAO" is the name of a colum with integer values. My issue is: I made a Model with several steps, and I need to put this SQL statment in the middle of it, but this process never accept a output as input. For example: if the "Execute SQL" is the first step, it will execute normally, but if it is not the first one, I got this error: Error executing algorithm Execute SQL virtual: Cannot find layer OUTPUTALGQGISDISSOLVE1_shp20181015165259558 Searching in the %temp% folder, this output file do exist! I made another attempt, with the SQL as first step, if the input shape is named starting with letter, it will run if the input name´s starts with number, a got this error: Error executing algorithm Execute SQL virtual: Query execution error on DROP TABLE IF EXISTS "input1"; CREATE VIRTUAL TABLE "input1" USING QgsVLayer(81121_463_DE20181015165152041);: 1 - unrecognized token: "81121_463_DE20181015165152041" I can´t understand why sometimes this algoritm run, and sometimes not I would appreciate some help Thanks for the Attention ______________________________________________ Herbert Lincon R. A. dos Santos _______________________________________________ QGIS-Developer mailing list [email protected]<mailto:[email protected]> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
