Fields on Related fields designer problem.

Posts   
 
    
tbelknap
User
Posts: 36
Joined: 28-Jun-2006
# Posted on: 22-Sep-2007 18:45:46   

I have a few entites that have fields on related fields set up. When I refresh my catalog those fields are deleted. I have to manually go back to re-add those fields everytime.

I am using the recent 2.5 version.

Thomas

Posts: 254
Joined: 16-Nov-2006
# Posted on: 23-Sep-2007 00:36:25   

I can't reproduce this issue when I have created a few fields mapped on related fields and then refreshed from the catalog.

It would be useful if you could save two copies of the lgp project, one with the field present, and then one after refreshing the catalog and then saving the project file when the field is missing.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 23-Sep-2007 20:54:47   

I can't reproduce that neither.

Could you please explain what DB change are you performing before your refresh (i.e. rename a table, rename a field, remove a table, etc.)?

Are you performing a Unattended refresh or a normal refresh?

Did you change some Catalog Refresh properties at your Project Properties or User Preferences?

David Elizondo | LLBLGen Support Team
tbelknap
User
Posts: 36
Joined: 28-Jun-2006
# Posted on: 24-Sep-2007 00:22:24   

daelmo wrote:

I can't reproduce that neither.

Could you please explain what DB change are you performing before your refresh (i.e. rename a table, rename a field, remove a table, etc.)?

Are you performing a Unattended refresh or a normal refresh?

Did you change some Catalog Refresh properties at your Project Properties or User Preferences?

I am using firebird database. It has happened when deleting a field and add a field to an unrelated table.

I have not changed any project refresh properties.

This is a normal refresh.

Edited: This is what I am getting in the report for those fields once I refresh. Maybe I am missing a setting somewhere. I know I didn't change any setting under the refresh catalog section.

Field mapped on related field 'Address_' removed because related field was removed

I added a field to the related table that has address on it.

Thomas

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 24-Sep-2007 11:18:44   

Would you please check the relation between the main entity and its related entity is still mentained in the LLBLGen Pro Designer?

I suspect the relation got deleted or hidden someway or another, maybe the PK-FK relation was dropped on the database.

tbelknap
User
Posts: 36
Joined: 28-Jun-2006
# Posted on: 28-Sep-2007 07:54:16   

Walaa wrote:

Would you please check the relation between the main entity and its related entity is still mentained in the LLBLGen Pro Designer?

I suspect the relation got deleted or hidden someway or another, maybe the PK-FK relation was dropped on the database.

All relations still exist.

Thomas

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 28-Sep-2007 12:08:43   

Would you please create and attach a repro case with a dummy fdb file using userid/password: admin/admin and an llblgen pro project?

Thanks.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 25-Apr-2008 15:33:41   

This was lately reported here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=13163

And happened to be a bug that then was fixed in designer build April 23rd, 2008.