1. Home
  2. LLBLGen Pro
  3. LLBLGen Pro Runtime Framework

can't why does the "relation Description" not contain the correct relation?

Posts   
 
    
yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 22-Oct-2007 18:05:43   

version 1.0.2005.1 final (self-servicing) VS2005 asp.net 2.0

hiya,

I have a scenario that is very similar to this one:

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=11386

In that scenario, I was advised to select an alternative relation. It worked fine.

The thing is, the typedList that I want to create is based on the SAME database table. However, for whatever reason, I can't find the correct relation.

As far as I can see, I have set up the typedList correctly.

In the "relation Description", it should say:

tblDog.SIREId -father.dogId (m:1)

yet it says

tblDog.DAMId -father.dogId (m:1)

I have tried going ahead and databinding, but it does indeed bind to "damId", instead of "sireId"

Any suggestions?

As I say, I have a very similar typedList that works, and it hits the same scema as the one that's cuasing me the hassles :=(

many thanks,

yogi

goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 22-Oct-2007 20:28:39   

Hi yogiberr, could you please attach your lgp file?

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 22-Oct-2007 20:50:36   

hiya.

Here you go.

yogi

goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 22-Oct-2007 22:31:23   

What is the typedlist you're stuck with? or what are the tables you're trying to join?

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 22-Oct-2007 23:31:19   

hiya Goose,

Sorry, the typedList is "TListLitter". The table itself is "tblDog"

It's a self refrerencing table. The field I'm having trouble with is father.dogId.

As I say, the typedList field of mother.dogId is ok, so I need this to work for father.dogId.

Also, TlistPedigree contains the relationship that I want, I just can't seem to crack it with "TListLitter".

Does this make sense?

Many thanks,

yogi

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 23-Oct-2007 11:14:21   

I found the following: When I selected the tblDog.DAMId -father.dogId (m:1) I didn't find the tblDog.SIREId -father.dogId (m:1) in the alternative relations dropdown. But I've found this one tblDog.dogId -father.SIREId (m:1) I set this one, and then I selected it from the Relations Used and then I found the correct one in the Alternative dropdown, so I set it tblDog.SIREId -father.dogId (m:1)

P.S. I used v.2.5, which I think will have the same behaviour as your version.

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 23-Oct-2007 15:30:32   

hiya Walaa,

I mamged to get it working by a combination of you instructions and bumbling thru.

Thanks,

yogi