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

Ashok
New Contributor III

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 1

RobbSalzmann
Valued Contributor

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