Using Visual Studio with MySQL.
In my XSD dataset I created a query. It runs perfect. I can preview the data fine.
In my BLL I wrote code (see below) to retrieve the query results and I'm getting...
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Why would previewing the data work but in code it fails?
Using db As New dsDemoTableAdapters.DemoTableAdapter
Dim dt As New DataTable
dt = db.GetDemo(DemoId) ' ERROR HAPPENS HERE