cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Freehand -error on ECC Query with where statement (1.29)

former_member182373
Participant
0 Kudos

Guys,

    Using the SQL Freehand  to read from ECC .

Works ok for simple select;

Select *  from "Local"."INFOSET"."ZBWTEST1"

However add a filter & it errors with a useless pop up message ( attached)

Select *  from "Local"."INFOSET"."ZBWTEST1" where "KNA1-LAND1" = "DE"

Any ideas ? Im guessing its a syntax issue.

Thanks

Tony

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Hi Tony - please see step 3 of Linda's blog here:

Check the use of your single quotes and double quotes - looks like you are using double quotes on DE and should be single quotes, but check the syntax in Linda's blog above

former_member182373
Participant
0 Kudos

Tammy,

  Well spotted - works ok now .

Thanks

Tony

Answers (0)