topic Cannot get 'WHERE' to work in script in QlikView

Cannot get 'WHERE' to work in script

Tue, 10 Nov 2009 23:48:10 GMT

QlikView will not accept the 'WHERE' statement in the script. What am i doing wrong?

ODBC

SQL

SELECT *

FROM

DKXXX400.EGDTA.FAKSTAP1;

WHERE FKKUNR = '900000500';

CONNECT TO EGDTA;

SQL

SELECT *

FROM

DKXXX400.EGDTA.FAKSTAP1;

WHERE FKKUNR = '900000500';

CONNECT TO EGDTA;

SQL

SELECT *

FROM

DKXXX400.EGDTA.FAKSTAP1;

WHERE FKKUNR = '900000500';

Cannot get 'WHERE' to work in script

Tue, 10 Nov 2009 23:50:23 GMT

Try to remove the ";" after

DKXXX400.EGDTA.FAKSTAP1



SELECT *
FROM


DKXXX400.EGDTA.FAKSTAP1 WHERE FKKUNR = '900000500' AND XXXXXXXXXXXXX;

Cannot get 'WHERE' to work in script

Tue, 10 Nov 2009 23:57:40 GMT

OK, have tried this, dosn't work, any ideas?

ODBC CONNECT TO EGDTA;
SQL SELECT *
FROM DKXXX400.EGDTA.FAKSTAP1
WHERE FKKUNR = '900000500';

Cannot get 'WHERE' to work in script

Wed, 11 Nov 2009 01:17:35 GMT

Does it work correctly without the where clause?

Cannot get 'WHERE' to work in script

Wed, 11 Nov 2009 01:25:33 GMT

Yes, no problem, but it dosen't stop.

You can also see this as the text 'WHEN' dosn't get highlighted as the other SQL statements. (the blue colour)

I have tried to write 'SQL WHEN' and this gets highlighted...?!

Cannot get 'WHERE' to work in script

Wed, 11 Nov 2009 02:13:27 GMT

It should be WHERE as far as I know.

Worth noting is that WHERE doesn't bet blue for me either in Qlikview although it does work for me.

Cannot get 'WHERE' to work in script

Wed, 11 Nov 2009 03:18:05 GMT

IT WORKS....thank you. You were absolutly right...Its a good thing i posted this question under "getting started". Thank you for your help.

Cannot get 'WHERE' to work in script

Wed, 11 Nov 2009 20:54:25 GMT

You are welcome. Glad it worked out for you!

Cannot get 'WHERE' to work in script

Wed, 25 Nov 2009 19:27:46 GMT

Great answer! I was having trouble with a WHERE clause until I saw this hidden comment that the WHERE text does not turn blue ... I had written it correctly but never ran it because there was no colour change ... could have saved myself a couple hours had I spotted this earlier.