I'm getting the following error...
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
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
0
Ben
Top achievements
Rank 1
Rank 1
answered on 22 May 2009, 12:32 PM
Nevermind, apparently my query wasn't pulling everything.