Hi,
I'm getting the following error when importing a Postgis table:
1 estado de cursor perdido.
SQL: CLOSE qgisf3
Resulta: 7 (ERROR: current transaction is aborted, commands ignored until
end of transaction block
)
Does anyone know what it means and how to solve it?
thanks
-
Cumprimentos,
P
Hi
On Thu, Dec 29, 2011 at 11:33 AM, Nathan Woodrow wrote:
> It would be handy to add condition statements to QgsExpression so we can
> support this kind of thing, Martin would be the guy to talk to about adding
> this kind of thing. He knows the most about QgsExpression.
SQL recognizes CASE st
This is a "prayer" for the plugin programmers!
First of all thank you for your contributions!
Qgis in it self is able to read and save shapefiles with many different
encodings, but some plugins seems to be hardcoded saving files in a specific
encoding.
One example is the ShapeFileSplitter. Even
Martin wrote:
>I would suggest to implement the CASE statement
Yes that would be great!!
CASE also supports another syntax which is even more flexible:
CASE WHEN a=1 THEN 'one'
WHEN a=2 THEN 'two'
ELSE 'other'
END
instead of:
CASE a WHEN 1 THEN 'one'
Il 06/01/2012 14:17, magerlin ha scritto:
This is a "prayer" for the plugin programmers!
Please open a ticket.
Thanks.
--
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
___
Qgis-user mailing list
Qgis-user@list
On Fri, Jan 6, 2012 at 1:25 PM, Martin Dobias wrote:
> SQL recognizes CASE statement with following alternate syntax:
>
> 1. "if" equivalent:
> CASE
> WHEN x > 10 THEN 'big' ELSE 'small'
> END
Just pushed a commit implementing that.
The syntax is:
CASE WHEN cond1 THEN exp1 [WHEN cond2 THEN exp2
Love your work Martin!
I'll add syntax highlighting for it tonight/tomorrow sometime.
- Nathan
On Sat, Jan 7, 2012 at 10:31 AM, Martin Dobias wrote:
> On Fri, Jan 6, 2012 at 1:25 PM, Martin Dobias wrote:
> > SQL recognizes CASE statement with following alternate syntax:
> >
> > 1. "if" equiva