posted 15 years ago
I have that two Tables with Table1 containing ID_NAME as a primary key
and Table2 containing ID_NAME as a normal row
(that means, it s not a primary-key or a foreign-key). I mapped that in common way.
But when I want to get the ID_NAME from Table2, then this failure occurs:
42703: An undefined column, attribute, or parameter name was detected.
But the column ID_NAME is definitly in my database both in Table1 and Table2.
What does this sql-error mean:
The strange thing is, that the database-column is definitly called ID_NAME and not IDNAME (as produced in the failure-message), another point is, that idName is my property in Table2 and not a correlated column to any other tables. However, I have idName in another Table called Table1 in which this property is a common primary key. But I have not association between Table1 and Table2.
What is wrong?
Does anyone know a solution?