Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
2 years ago

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
    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)

Henning's avatar
Henning
Valued Contributor II

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.