Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reverse Engineering : Nulls

Status
Not open for further replies.

pellismgm

Programmer
Apr 22, 2004
2
GB
I am trying to reverse engineer a Sybase database. It's rather large so I'm selecting three tables that I know are related.

When I attempt to reverse engineer, I get the following Sybase error message :

Attempt to insert NULL value into column 3 in work table (table id : -456758); column does not allow nulls. Update fails.

Then I get a dialog box : Unable to select foreign keys.

This happens for every table I selected, so the result is I get a diagram with unrelated tables - not very helpful !

Can anyone suggest what I must be doing wrong ? It's a production database , so (i hope) the database itself is okay....
 
Cancel this query - it transpires that I was running version ***6*** of Powerdesigner - version 10 does not exhibit the same problems....!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top