Skip to main content
A
Ashok
Contributor
July 28, 2023

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

  • July 28, 2023
  • 1 reply
  • 0 views

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

 

 

    1 reply

    RobbSalzmann
    RobbSalzmann
    Legend
    July 28, 2023

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

      Terms & ConditionsAccessibility statement