Cannot get 'WHERE' to work in script

[#1]

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'; WHERE FKKUNR = '900000500';

WHERE FKKUNR = '900000500';

CONNECT TO EGDTA;

SQL

SELECT *

FROM

DKXXX400.EGDTA.FAKSTAP1;

WHERE FKKUNR = '900000500'; WHERE FKKUNR = '900000500';

WHERE FKKUNR = '900000500';

CONNECT TO EGDTA;

CONNECT TO EGDTA;

SQL

SELECT *

FROM

DKXXX400.EGDTA.FAKSTAP1;

WHERE FKKUNR = '900000500'; WHERE FKKUNR = '900000500';

WHERE FKKUNR = '900000500';

[#2 · Accepted solution]

Try to remove the ";" after

DKXXX400.EGDTA.FAKSTAP1

SELECT *
FROM


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

[#3]

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

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

[#4]

Does it work correctly without the where clause?

[#5]

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...?!

[#6]

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.

/F

[#7]

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

[#8]

You are welcome. Glad it worked out for you!

/F

[#9]

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.