A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Database Self-referencing foreign key bug in visio 2000



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2004, 09:51 AM
Michel
external usenet poster
 
Posts: n/a
Default Database Self-referencing foreign key bug in visio 2000

Hello,

I did a reverse engeneering for both Oracle and MSAcces of a table that have a self referencing foreign key.
When I check the resulting model, visio 2000 gives an error L3022 Self-referencing foreign key column 't.b' cannot exist as both a parent and a child in the same relationship.
IMHO that error L3022 is a visio 2000 bug.

I created a table in access and Oracle and try the reverse engeneering from both with the same problem.
create table t (
a integer not null,
b integer not null,
c integer not null,
constraint t_pk primary key (a, b),
constraint t_fk1 foreign key (c, b) references t (a, b)
);
The c field is a reference to a parent record that have the same b field in the same table.

Thank in advance for your comments.
Can someone reproduce my test with a more recent version of visio ?
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.