Toad World® Forums

TDM - Bad type for FKs


When I create a relationship between two entities the created FK has the whrong data type. In my case the key is a user defined type called ‘technical_ID’ (called domain in this version of TDM) which is in fact a NUMBER but the data type of the FK is CHAR(30) or CHAR() which causes a message box to popup when I save the change (see attached image).
So: wrong data type for generated FKs.




Access Violation commes back
After deleting a relationship the PK was not anymore PK. When I put the field in the keyan save the change then I have the error message box that I attached.



I’m pleased to inform you that this problem has already been fixed.

Thanks for your co-operation!