Forum Discussion

Nikpowar97's avatar
Nikpowar97
Contributor
3 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
mkohorst's avatar
mkohorst
New Contributor II
3 years ago

Isn't it this? dt.Constraints.Clear

JackLacava's avatar
JackLacava
Community Manager
3 years ago

The problem is that anything done before executeSql is effectively thrown away, to be replaced with the datatable that the function returns.