Hello.

I´m using Sql Widget and I´m having an error... It says "Incorrect Syntax near what I wrote, but the name I typed on Test input is the same I have on my table....


Here is the Sql I implemented

Could really use some help

Thanks :)

Solution

Hi Camila Rodrigues,

Could you please try to execute/test the SQL query after changing the input parameter Expand Inline property value to No.

Hope this helps you!


Regards,

Benjith Sam

Solution

Thanks for the reply. It worked!

Camila Rodrigues wrote:

Hello.

I´m using Sql Widget and I´m having an error... It says "Incorrect Syntax near what I wrote, but the name I typed on Test input is the same I have on my table....


Here is the Sql I implemented

Could really use some help

Thanks :)The problem is in the output try to use a structure in the output of type Funcionario Identifier



Camila Rodrigues wrote:

Thanks for the reply. It worked!

You're welcome, Camila Rodrigues :)

As mentioned by @Adão Pedro, please make sure that the select statement attribute count and its value type matches the SQL Output structure attributes.


Regards,

Benjith Sam