4/27/2024 10:29:52 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
Removing Parent Child Relationships
Posted: 16 Sep 09 7:22 AM
|
Hello all,
I'm using SLx v6.2.3. I have some tables which were created as children of the ADDRESS table (one 1:1, two 1:M). I need to remove the parent child relationship, so the (currently) child tables become stand alone tables globally.
Although I removed the global joins the relationship in SLx DB Manager still shows the tables as children of ADDRESS.
I am still seeing the relationship even after closing SLxSystem.exe and restarting the SLx Server Service.
I have looked at the RESYNCTABLEDEFS and SECTABLEDEFS but cannot see anything that would hold onto the relationship.
I must be missing something obvious here.
Any help greatly appreciated.
James
|
|
|
|
Re: Removing Parent Child Relationships
Posted: 16 Sep 09 10:52 AM
|
If it were me, I would create brand new tables, in exactly the format you require, and then copy the data over to them. Otherwise you will be left with the confusing legacy of puzzling primary and foreign key fields in the soon-to-be-orphaned tables.
Then delete the unwanted tables (after modifying your underlying custom code accordingly, of course). |
|
|
|
Re: Removing Parent Child Relationships
Posted: 17 Sep 09 7:23 AM
|
There are a couple of things to double check:
- Query the JoinData table directly and make sure that indeed the Joins are no longer present.
- Check the ResyncTableDefs table, check if there is a DefaultGlobalIDPath
- Also, seems as if the Schema hasn't been rebuilt yet.
- Check if the Schema is scheduled to be rebuilt (you may need to actually make a table change for this to happen).
- If the Schema is flagged to be updated, log into the Client and run the Group Builder. Verify after the Shema has been rebuilt.
I do agree with Phil that you should consider just creating a New Standalone table, migrate your data onto it and drop the existing table. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|