"Failed to enable constraints. One or more rows contain values violating non-null, un

[gicio]

"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." string





Hi!

I get this error when I excetute this code

(error on line: m_dataAdapter.Fill(m_dsCarTrade,"CustomerAddress")


also I get one error in one Row:



(Tables have a relationship to eachother)

		private OleDbDataAdapter m_dataAdapter;

		private OleDbConnection m_accessConnection;

		private OleDbCommand m_accessCommand;


		private	const string m_conStrAccessConnection  = "provider=Microsoft.JET.OLEDB.4.0; " + 
													   "data source = C:\\Visual Studio Projects\\" +
													   "CarTrade\\CarTradeDB.mdb";	

                private const string m_conStrSelectCommandCustomer = "SELECT Customer.*, CustomerAddress.* FROM Customer INNER JOIN CustomerAddress ON Customer.CustomerID = CustomerAddress.CustomerID";


		private void LoadFreshCustomersFromDB()
		{
			//we create an access object
			m_accessConnection = new OleDbConnection(m_conStrAccessConnection);
			m_accessCommand = new OleDbCommand(m_conStrSelectCommandCustomer, m_accessConnection);
			m_dataAdapter = new OleDbDataAdapter(m_accessCommand);

			//we open the connection to DB
			m_accessConnection.Open();

			try
			{
				m_dataAdapter.Fill(m_dsCarTrade,"CustomerAddress");

				m_dataAdapter.Fill(m_dsCarTrade,"Customer");

			}
			catch (Exception e)
			{
				MessageBox.Show("Sorry....but we have some problems with database. " + "Error message from database : " + e.Message,"ERROR!!!");

			}
			finally
			{
				//we close the connection to DB
				m_accessConnection.Close();
			}

			m_dtCustomers = m_dsCarTrade.Tables["Customer"];
		}

Know someone why this error caused?



gicio

[Paul Victorey]

This is Java?

Can you provide the information about OleDbDataAdapter.Fill()?

[doctorgonzo]

This is C++, right?

I found this as a possible solution:

"1) "Failed to enable constraints" usually means there are constraints in
your DataSet that your database tables don't satisfy. First, try removing
all your DataSet constraints."

I can't seem to find where you initialize m_dsCarTrade, so I am assuming you initialize it elsewhere. Try setting m_dsCarTrade.EnforceConstraints=False.

[gicio]

it's C#



gicio

[aym]

I was really puzzled when reading your code, it uses const so it's not Java, but everything else (private location, exception handling ...) looks like Java!
Any way, I'm sorry I don't know C#, so I can help.