rahavtom Posted August 26, 2004 Posted August 26, 2004 Hello ! I'm trying to configure a relation between two tables in a dataset. It works well when I open the form at the first time, but when I close the form and open it again (still in runtime), I get the following error message: "Faild to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." I have no idea what table may cause this error and why it doesn't happen at the first run. I tried to dispose and clear the dataset when I close the form, but it didn't help. Thanks in advanced, Tom. Quote
Administrators PlausiblyDamp Posted August 26, 2004 Administrators Posted August 26, 2004 Could you post the relevant code? Whre have you created the variable to hold this dataset? Is it declared inslide the form or elsewhere? If elsewhere are yu populating it in the Form_Load? If so you will need to clear the dataset before you reload it. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
rahavtom Posted August 26, 2004 Author Posted August 26, 2004 Thanks Hi. I solved the problem already. Thanks anyway! Tom. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.