This is a migrated thread and some comments may be shown as answers.

Some parent values equal 0

1 Answer 21 Views
Menu
This is a migrated thread and some comments may be shown as answers.
Ben
Top achievements
Rank 1
Ben asked on 21 May 2009, 01:41 PM
I'm getting the following error...

This constraint cannot be enabled as not all values have corresponding parent values.


I'm using a prebuilt database that already has a path system in place. I'm trying to use the same data from the database so that when changes are made, they reflect in all applications using that database. I'm thinking that the reason i'm getting this error is because some of the initial Parent IDs are 0s. Is there a way to get around this?

Here is a link to a screen shot of the table
http://img188.imageshack.us/img188/5590/70368387.png



1 Answer, 1 is accepted

Sort by
0
Ben
Top achievements
Rank 1
answered on 22 May 2009, 12:32 PM
Nevermind, apparently my query wasn't pulling everything.
Tags
Menu
Asked by
Ben
Top achievements
Rank 1
Answers by
Ben
Top achievements
Rank 1
Share this question
or