This question is locked. New answers and comments are not allowed.
Hi. i have problem with mapping database view. especailly with primary keys. i had "null oid" error or wrong result.
I had two onetomany relational tables (tableQuestion , tableAnswer). TableQuestion could has many TableAnswer.
And i needed these table into mixed one table at the database view. i created view and then mapping.
And of course gave me error that primary key should select.
1- if I select primary key to second level table id (tableAnswer.id) i am taking null oid error. Because i have Questions that not answered yet. if i choose two primeray key result didnt change naturally.
2- if i select primary key top level table id (tableQuestion.id) i am seeing only one first answer result, because all answer's TableQuestion.id is same. i cant see others answers for that question. all questions only has one answer with that way.
I need extra id column for view mapped from database. how can i do this. i have to see all answers and questions that not answer yet.
there one exp here about voa_keygen. but I am newby, could you explain simple , step by step.
thanks.
I had two onetomany relational tables (tableQuestion , tableAnswer). TableQuestion could has many TableAnswer.
And i needed these table into mixed one table at the database view. i created view and then mapping.
And of course gave me error that primary key should select.
1- if I select primary key to second level table id (tableAnswer.id) i am taking null oid error. Because i have Questions that not answered yet. if i choose two primeray key result didnt change naturally.
2- if i select primary key top level table id (tableQuestion.id) i am seeing only one first answer result, because all answer's TableQuestion.id is same. i cant see others answers for that question. all questions only has one answer with that way.
I need extra id column for view mapped from database. how can i do this. i have to see all answers and questions that not answer yet.
there one exp here about voa_keygen. but I am newby, could you explain simple , step by step.
thanks.