Printable View
dear sirs
i have the folowing error
"failed to enable constraints one or more rows contain values violating non-null, unique or foreign key"
when i try to execute the attached code
Me.adapConnWay.Fill(DsCompanies1.T_ConnectionDetails)
in line 2964
im also added the db and the code itself
the file was too large
so i attached them seperately
If you try to preview the dataset data in the designer you will see what causes the problem. There are values in conndetails_entity_Code filed in T_ConnectionDetails table that does not exist in the parent table conntype_Code field. I guess you have made a mistake in editing the relations. Didnt you want to relate conndetails_conntype_Code to conntype_Code?
By the way, is that Hebrew?
I think there is something wrong in your project regarding the datasets. Is dsCompanies1 an instance of dsCompanies or another dataset? Seems they are mixed up. Try deleting the datasets and add them again.
Ok - so i have tried the to delete all the dscompanies1 and dscompanies - and created just dscompanies dataset. but still the X butten refuses to close the form - i attach the fixed code