Designer hanga when fk & pk in same table

Posts   
 
    
jshallard
User
Posts: 62
Joined: 23-Mar-2005
# Posted on: 01-Aug-2007 18:41:43   

I have a problem with my LLBLGenPro Designer hanging. This seems to happen when i refresh catalogs after adding a foreign key relationship with a primary key in the same table.

Further Detail I have a table named "Category" (see attachment for diagram). This has several fields, including a primary key column named "pk_ID" and a foreign key field named "fk_ParentID". When i set up the relationship so that Category.fk_ParentID is a foreign key to Category.pk_ID, and then refresh all cataloges, the designer goes through all the steps of retrieving the schema - but then hangs at the end of it (the mouse pointer never returns from the "timer" icon)

Additional Info I am using: - Designer Version 2.5 Beta (June 22nd Build) - Platform: Vista (I have been using LLBLGenPro successfully on vista for several months) - .Net 2.0 - Adapter templates.

Any help appreciated!

Attachments
Filename File size Added on Approval
CategoryTable.jpg 20,762 01-Aug-2007 18:43.03 Approved
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 01-Aug-2007 19:18:32   

This is fixed in the next build. See: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=10688

This thread also shows a workaround, by setting removeunderscores.. to true in the preferences. (it's likely switched to false in your case)

We'll release a new build tomorrow.

Frans Bouma | Lead developer LLBLGen Pro
jshallard
User
Posts: 62
Joined: 23-Mar-2005
# Posted on: 01-Aug-2007 19:25:04   

Thanks very much for the fast response!