Svetlana
9 years agoOccasional Contributor
How to use GetData in SQL in DataSource
Hello,
I'm trying to use GetData in SQL Query.
- If I use an expression ... WHERE Column1 = “${TestStep1#Variable1 it errors out: Parsing error. Failed to parse SQL query. Invalid SELECT statement. Unexpected token ‘{’ at line.
If I use an expression ... WHERE Column1 = “${PreparedProperty1#Variable1}” it errors out: Can’t get the connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name ‘${PreparedProperty1#Variable1}’.
How to use GetData in SQL in DataSource?