Forum Discussion

Nikpowar97's avatar
Nikpowar97
Contributor
2 years ago

Enforce Constraints on Data Table. Failed to enable constraints. One or more rows contain values.

I am trying to return a SQL query in a Data table inside the business rule. But I am Getting the issue: Failed to enable constraints. One or more rows contain values violating non-null, unique, or fo...
Dashboards
DanielWillis's avatar
DanielWillis
Valued Contributor
2 years ago

Does it work if you change it to the below?

 

Using dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
return BRApi.Database.ExecuteSql(dbConnApp, sql.ToString, False)
End Using

 

Most of the other stuff seems unnecessary to me at a quick glance unless it has been simplified for the example.