Skip to Content
0
Former Member
Sep 22, 2008 at 07:54 AM

"QUERY Execution error " while deploying the model.

30 Views

Hi ,

I use the DB tables directly. I dragged the db table on to the story board and used BI integration wizard to initially get all the values from that table. Now i want the table to take dynamic values form the input form. For this i have used the SQl statement from the input field.

Ex: input form: X and Y. The table will take two values.

The sql statement : "Select * from Table name where FieldX = ' " & @X & " ' " AND FieldY = ' " & @Y & " ' " "

When i deploy this i get a error "QUERY EXECUTION ERROR"

But when i map the Input fields directly to the corresponding values i get the output.

Please can any one help.

Regards

Tekumalla