[QGIS-Developer] Execute SQL

[Herbert Lincon]

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 <luipir at gmail.com>
Enviado: quinta-feira, 8 de novembro de 2018 12:56
Para: herbert_lincon_jau at hotmail.com
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 <herbert_lincon_jau at hotmail.com<mailto:herbert_lincon_jau at 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 at lists.osgeo.org<mailto:QGIS-Developer at lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20181112/f8976e49/attachment-0001.html>