Renamed Table Issue

Posts   
 
    
Posts: 8
Joined: 08-Feb-2010
# Posted on: 22-Feb-2010 18:16:21   

Hello, I think i did something i shouldn't have. I renamed an existing table 'schedule' to 'scheduledetails' then i created a new table, and named it schedule. It appears to be holding on to some of the old relations from the original table schedule. While i'm sure i could just rebuild from scratch, what would you suggest as the 'proper' way to remove the old fk references/rebuild? Thanks!

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 23-Feb-2010 02:42:00   

I would do this:

  1. Create the new scheduledetails table.
  2. Refersh catalog. LLBLGen Designer will ask you to match the missing table with the new one. Make sure that the _ManuallySelectRenamedTargetsAfterRefresh _flag is set to true in your project properties.
  3. Change the Schedule entity name to something else. Remember that the name will remain the same, so change it to ScheduleDetail, for instance.
  4. Add you new schedule table in your db.
  5. Refresh catalog.
  6. Add the new Schedule entity to your project entities.

Hope helpful..

David Elizondo | LLBLGen Support Team
Posts: 8
Joined: 08-Feb-2010
# Posted on: 24-Feb-2010 12:57:13   

You've nailed it again. Thanks so much for your help!