Active Query Builder support area

Syntax SQL server is not running with two "ON" in the view

Avatar
  • updated
  • Completed

Hello I use sql server and management, if I write my view like this there are an error

SELECT dbo.[tbl intervention ot rapport].arretnecessaireon, dbo.[tbl unité fonctionnelle ensemble].code AS equipement
FROM dbo.[tbl unité fonctionnelle ensemble] RIGHT OUTER JOIN
dbo.[tbl intervention ot rapport] INNER JOIN
dbo.[tbl configuration ot dt] ON dbo.[tbl intervention ot rapport].[num origine défaillance] = dbo.[tbl configuration ot dt].[num origine défaillance] ON
dbo.[tbl unité fonctionnelle ensemble].[num unité fonctionnelle ensemble] = dbo.[tbl intervention ot rapport].[num unité fonctionnelle ensemble sel]

if I write this it s it s good

SELECT dbo.[tbl intervention ot rapport].arretnecessaireon, dbo.[tbl unité fonctionnelle ensemble].code AS equipement
FROM dbo.[tbl intervention ot rapport] INNER JOIN
dbo.[tbl configuration ot dt] ON dbo.[tbl intervention ot rapport].[num origine défaillance] = dbo.[tbl configuration ot dt].[num origine défaillance] LEFT OUTER JOIN
dbo.[tbl unité fonctionnelle ensemble] ON dbo.[tbl intervention ot rapport].[num unité fonctionnelle ensemble] = dbo.[tbl unité fonctionnelle ensemble].[num unité fonctionnelle ensemble]


The reason seem come from the "ON" in view is directly after an other "ON" is there a solution to have the good translation

Thank you




Avatar
Sergey Kraikov

Hello,

seems both your queries are perfectly valid for MS SQL Server and Active Query Builder.
Could you please explain your issue with more details?

Avatar
Christian Bléas

Thank you It the last version for winforms and I use mssqlSyntaxProvider

Avatar
Andrey Zavyalov, PM

Hello,

What is your component's version and edition? What syntax provider you use in your project?