Syntax SQL server is not running with two "ON" in the view
CompletedHello 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
-
I give you a backup with the database from sql server Express 2012/
in the view I put the view with problems (test1)
I test it in your program GENERALDEMO
-
Hi,
Unfortunately, this isn't something we've been able to reproduce on our side.
We've extracted your database and tested the General demo (C#) with it using the latest components' version 3.1.1.1028.
Please open the General demo project on your PC, go to the References section, find the Active Query Builder Core assembly and make a screenshot of its properties in Visual Studio. If the version number that's displayed in the properties is "3.1.1.1028", please send us the step-by-step guide how to reproduce it, or make a screencast of your actions that illustrate this problem on unmodified General demo project.
Please provide as much as possible information about this problem.
-
hello you can find a video that what I do step by step with the link below
www.maintexpress.com/telechargements/test.zip
My computer is in french version
I use the version "3.1.1.1028",
thank you
Please sign in to leave a comment.
Comments
13 comments