This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have been evaluating Light Speed for use against an Oracle database. I am using the .Net Framework Data Provider For Oracle and have the latest nightly build . The problem that I am having is that when I drag the tables from server explorer I receive the output below: Multi-column foreign keys not supported - skipping (REPCAT$_RESOLUTION -> REPCAT$_CONFLICT)Multi-column foreign keys not supported - skipping (REPCAT$_PARAMETER_COLUMN -> REPCAT$_RESOLUTION) Multi-column foreign keys not supported - skipping (REPCAT$_AUDIT_COLUMN -> REPCAT$_CONFLICT) Multi-column foreign keys not supported - skipping (REPCAT$_FLAVOR_OBJECTS -> REPCAT$_REPCAT) Multi-column foreign keys not supported - skipping (REPCAT$_FLAVOR_OBJECTS -> REPCAT$_FLAVORS) Multi-column foreign keys not supported - skipping (REPCAT$_SITES_NEW -> REPCAT$_REPCAT) Model is already associated with a different data source; old association has been kept Unable to create entity definition for CUSTOMER. Check that the table has a primary key defined. |
|
|
|
|
This is correct -- LightSpeed 2 does not support multi-column foreign keys (because it does not support composite primary keys). However, from the look of those table names, I am guessing those are system tables rather than the tables you actually want to use in your app. If this is the case then you can ignore these warnings as they are unlikely to relate to your problem. I assume your problem is that the Customer entity is not being created. This is most likely because the CUSTOMER table does not have a primary key defined. If you could post the CREATE TABLE statement for the CUSTOMER table then we would be happy to have a look at this. If I've misunderstood the problem and you are trying to create entities for the REPCAT$_* tables then please let me know -- it would be useful to see the CREATE TABLE statements for whichever tables you're having trouble with. |
|
|
|
|
You are right the tables did get stuck in with the system tables. |
|
|
|
