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
Andrey Zavyalov, PM

Hello,

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

Avatar
Christian Bléas

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

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
contact

Hello in the second View I have a cast Problem

'ActiveQueryBuilder.Core.DataSourceGroup' in type 'ActiveQueryBuilder.Core.DataSource'.

Avatar
Sergey Kraikov

I still cannot reproduce this issue. ActiveQueryBuilder loads both queries without errors.
Could you please provide more details? Step-by-step instruction or sample project or code snippet to reproduce the issue?

Avatar
contact

test.zip

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

Avatar
Andrey Zavyalov, PM

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.

Avatar
Sergey Kraikov

Hello,

Thank you for detailed report, I reproduced the issue on my side, and currently fixing it.

Avatar
contact

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


Avatar
Sergey Kraikov

Hello,

this issue is fixed upstream, and the fix will be included in the next release,
which will be available in next few days.