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

Question

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:&nbsp;anyone seens this and know the reason and how to resolve it?&nbsp;Code:&nbsp;&nbsp;

RobbSalzmann · Answer

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

Forum Discussion

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

Related Content

Created a "Total" Entity but not totaling Entities

Create a Cubeview Entity List From "In Use" and Member Property "ReadWriteDataGroup"

How to Create a "Sort" Check Box in our Dashboards (used in schedules or reports)

Extender: User Inactivity Email

Extender: Auto Create Member