[Qgis-user] SQL statement

[Jürgen E. Fischer]

Hi Filipe,

[please don't toppost]

On Wed, 02. May 2012 at 15:29:53 +0100, Filipe Silva Dias wrote:
> On Wed, May 2, 2012 at 3:19 PM, Jürgen E. <[1]jef at norbit.de> wrote:
> > I suppose something like:
> > CASE FIELD1='A' AND FIELD2<>'B' THEN X ELSE Y END

>    No, it doesnt work:
>     Expression is invalid "Syntax error unexpected COLUMN_REF, expecting WHEN"

Ok, that's why I said "like".  Add a "WHEN" after the CASE.


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-31
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de
committ(ed|ing) to Quantum GIS                         IRC: jef on FreeNode                         

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502