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

Completed

Comments

13 comments

  • Avatar
    Sergey Smagin (Product manager)

    Hello,

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

    0
    Comment actions Permalink
  • Avatar
    cbleas

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

    0
    Comment actions Permalink
  • 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?

    0
    Comment actions Permalink
  • Avatar
    contact

    Hello in the second View I have a cast Problem

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

    0
    Comment actions Permalink
  • 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?

    0
    Comment actions Permalink
  • 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

    0
    Comment actions Permalink
  • Avatar
    Sergey Smagin (Product manager)

    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.

    0
    Comment actions Permalink
  • Avatar
    Sergey Kraikov

    Hello,

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

    0
    Comment actions Permalink
  • 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


    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • Avatar
    contact

    thank you

    0
    Comment actions Permalink
  • Avatar
    Sergey Smagin (Product manager)

    Hello,

    The bug has been fixed in the new version 3.2.0.1029. Please confirm that it's fixed on your side.

    0
    Comment actions Permalink
  • Avatar
    contact

    Thank you it s perfect

    0
    Comment actions Permalink

Please sign in to leave a comment.