Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
2 years ago
Solved

Create View using Extender rule

Hi All - I am trying to create a View using a Extender BR and It is compainling without any issue but when I try to execute it am getting the below error. Any help would be appreciated.     Dim ...
Extenders
Henning's avatar
Henning
Valued Contributor II
2 years ago

I believe you have an error in your execution command:

 Brapi.Database.ExecuteSql(aDbConn,aDbConn.ToString,False)

 

This should be the SQL command you wish to execute I believe

I.e. you need to use the (in your case) vSQL in the second position:

Brapi.Database.ExecuteSql(aDbConn, vSQL, False)

 

If that does not work, write your vSQL into the error log and analyze it there in order to see the final string that is supposed to be executed:
brapi.ErrorLog.LogMessage(si,"vSQL script: See details below.", vSQL)

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    Thanks Henning. It was a good Catch and Now it is working.

    Appreciate your quick help.