select query

[manoranjan_d]

Hi,

I want to select specific table with specified field. so i used

select * from table name

where field name ="xxx"

but when i check its showing error as "Expected 'Case'" in select line of the macro.

pls help me

[prma7799]

Can you post error screen shot?

[anbu1984]

Can you post your script       

[manoranjan_d]

i cant share its confidential, can tell me how to select the table and how to use where condition in the macro

[anbu1984]

Your Select sql looks ok. Do you use Case statement in Sql?

[manoranjan_d]

no.

For example you can try the same coding below and click check in the macro  it will show error as expected case in the top.

select * from table name

where field name ="xxx"

pls assign ur self a table in qlikview with some value and then create a text box. in the text box action try this above macro coding