I added in a very simple table to my existing DA/WPF app which stores user notes, and has a single integral key value to link to other tables. Very very simple, yet i’m getting a DA/server exception which states this:
An exception occurred on the server: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
this is occuring on my DALINQ statement which is this:
cnl := (from nrec in fDataModule.DataAdapter.GetTable<campnotes> where nrec.CampaignID.Equals(crec.CampaignID) select nrec).ToList;
this table is dirt simple - three fields. The CampaignID integral key field, the ‘Notes’ field, and some extra unused space in a third field for future expansion. All three fields are flagged as non-null. There is an existing record for my test scenario, so this query should return a single record, but instead i’m getting this exception. Any idea why?
I’m using the latest Elements and DA beta releases, in VS 2019, latest version.