How to use Function " Where " ?????

[fgolmahi]

Hi Dear friends

Please Help me

How to use Function "Where"in edit script If Read data from database ( SQL)   ?????

see attachment please

[prieper]

you may read the errormessage: "Incorrect syntax near =".

So please work systematically and try to load the data without a where-clause.

If this works, then you may critically check this clause. From the above screenprint can only assume that SQL does not interpret your condition as text.

Peter

[vishsaggi]

Are you trying to load data into QVD where ICDcode = 10? You should not use your where condition in your STORE Command. As suggested above by few dev's, use in your SQL Script.

Like:

SQL

SELECT ....

....

...

FROM shafa.dbo.qlikview

WHERE ICDCode = 10;

Store cod into cod.qvd(qvd);

[rupamjyotidas]

You can't use 'where' with Store command