Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » LIST2 Pattern Problem
Re: LIST2 Pattern Problem [message #2146 is a reply to message #2120] Mon, 22 June 2009 11:10 Go to previous messageGo to previous message
ajwid01 is currently offline  ajwid01
Messages: 26
Registered: June 2009
Location: UK
Junior Member
Ok,

Got a little further now...


I introduced a third 'pseudo' column in the table definitions which I introduced into the PK/FK relationship, to see if indeed it was just missing out on the last column of the PK array.

Result is:

It's not missing out the field at all. It's now missing out the MIDDLE field of the PK composite.

The is the only field that is 'named differently' between the Outer/Inner tables, whereas the other columns match.

I understood earlier that I needed to 'rewrite' the query definition somewhere, such that it would translate the columns automatically.

I believe I actually did this in an earlier effort, so will now attempt to "retrace my steps" and see where I implemented this: although if I do it like I did it before... it likely won't work still - so I'm presuming I did something wrong previously.

Maybe a retrace and reread will open my eyes a bit further.

Glad I have ruled out a problem with the array though.

Smile

T.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Question about the session page stack
Next Topic: AUTO_INCREMENT PK Column for Oracle Table
Goto Forum:
  


Current Time: Sun Nov 24 03:07:58 EST 2024

Total time taken to generate the page: 0.03770 seconds