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 <herbert_lincon_...@hotmail.com> 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 > QGIS-Developer@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer