Skip to main content
Contributor
Jul 28, 2023 4:10 PM UTC
Solved

Error while trying to create a view using DB Extender BR - "Create View must be first statement"

Hi All,

I am trying to create a simple view using SQL in BR. it works if do it directly in SQL server so no issue with the syntax. When i am trying to do the same using a BR it gives this error: 

Ashok_0-1690560394516.png

anyone seens this and know the reason and how to resolve it?

Code:

Ashok_0-1690560694627.png

    RobbSalzmann
    Employee - Advisor
    Jul 28, 2023 5:21 PM UTC

    Use:
    BRApi.Database.ExecuteActionQuery(dbConnApp2, dml.ToString(), True, True)

    1 reply

    RobbSalzmann
    Employee - Advisor
    Employee - Advisor
    Jul 28, 2023 5:21 PM UTC

    Use:
    BRApi.Database.ExecuteActionQuery(dbConnApp2, dml.ToString(), True, True)