The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Nikpowar97
3 years agoContributor
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...
mkohorst
3 years agoNew Contributor II
Actually agree with Daniel, normally you just do something like this:
Dim dt As DataTable = Nothing
Using dbConnApp As DbConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)
dt = BRApi.Database.ExecuteSql(dbConnApp, sql.ToString, False)
End Using
Or this:
Using dt As DataTable = BRApi.Database.ExecuteSql(dbConnApp, sql.ToString, False)
End Using
- JackLacava3 years ago
OneStream Employee
Fails with that too, I checked.
Related Content
- 1 year ago
- 3 years ago