[QGIS-Developer] Execute SQL

[Luigi Pirelli]

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>
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
> 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/20181108/1010ef87/attachment.html>