Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> Problem with Typed List and self joined table
 

Pages: 1
Designer
Problem with Typed List and self joined table
Page:1/1 

  Print all messages in this thread  
Poster Message
like2175
User



Location:
Camberley, United Kingdom
Joined on:
27-Mar-2006 16:16:06
Posted:
83 posts
# Posted on: 26-Sep-2006 09:01:23.  
I have a table of items with pk item_id and 3 other attributes: item_description, from_item_id, to_item_id and main_item_id. The table is joined to itself so that from_item_id, to_item_id and main_item_id must exist in the item_id table.

I now want to fill an asp.net gridview with:

item_id, item_description, from_description, to_description

I've gone into the typed list designer added the item table 3 times but cannot make connections between item.item_id to item.from_item_id *and*item.item_id to item_to_item_id

Am I doing something wrong Confused ?

I'm trying to convince colleagues that llblgen is the way to go and this is a showstopper.

v1.0.2005.1 Final March 31st 2006
  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14569 posts
# Posted on: 26-Sep-2006 09:43:09.  
Assuming that the relations are correctly set in the database, andare found in the LLBLGen Pro Designer without any of them being hidden.

In the Designer -> Typed List properties.
You should select different Entities from the "Entities selected for this Typed List" List.
And then use the "Select alternative" ComboBox to select the appropriate relation you want to use. Don't forget to press the Button "Set".

Also please use the latest release of v1.0.2005.1


  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.