Microsoft SQL Server : Syntax Error output additional keyword (Failing in Swagger)

Self-Host
1

Syntax Error output additional keyword mentioned in SQL Server, Failing in Swagger

{
“message”: “There was a syntax error in your SQL query.”,
“info”: {
“message”: “insert into [dbo].[Employee] ([EmployeeDepartment], [EmployeeName], [created_at], [created_by], [updated_at], [updated_by]) output values (@p0, @p1, @p2, @p3, @p4, @p5) - Incorrect syntax near the keyword ‘values’.”,
“code”: “EREQUEST”
}
}

1 Like
2

I am facing this issue too. Have you found any fixes?

3

This is because nocodb is generating an OUTPUT clause incorrectly. it should have generated OUTPUT inserted.*