Skip to Content (Press Enter)
UserImage.jpg
Camila Rodrigues
80Views
4Comments
Solved
Sql error
Question
Reactive
New to OutSystems

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 :)

0
0
14 May 2020
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP
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

0
0
14 May 2020
Copy Link
UserImage.jpg
Camila Rodrigues

Thanks for the reply. It worked!

0
0
14 May 2020
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

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

0
0
14 May 2020
Copy Link
2025-12-23 12-24-14
Adão Pedro

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



0
0
14 May 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.