Table relations: Column type problems
Posted by:
Lou Arnold
Date: September 26, 2006 05:13PM
This was done with VC++2005 Express with Net2.0 and MySqlConnector 1.0.7.
Two tables are in a .NET dataset. One is a main table and the second is a lookup table. The main table therefore has a foreign key into the lookup table. The primary and therefore foreign keys are all INTEGER UNSIGNED. The database was created by the Fabforce's DBDesigner 4.0.5.6 Beta.
In the dataset, I tried to create a DataRelation. At run time, the first error message said that the Parent and Child fields were different. I checked with the debugger and found the foreign key to be UInt32, and the lookup table primary key as type Int32. I changed the database types to be both INT UNSIGNED, and then the dataset types both came out as Int32. At that point the error message column does not have unique values. Duhhhh, a foreign key column is never expected to have unique values.
Can someone help?
Subject
Written By
Posted
Table relations: Column type problems
September 26, 2006 05:13PM
September 27, 2006 07:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.