?
Solved

Failed to bind SQL tables

Posted on 2011-03-09
2
Medium Priority
?
596 Views
Last Modified: 2012-05-11
Hello

Well, I have a problem when i try to bind two tables

I have next tables

TABLE 1                                                                 TABLE 2
Name       TYPE                                                 Name               TYPE
mes              float                                                      mes                     float
venta      float                                                      VolumeShare       float
                                                                      MoneyShare        float

I make the bind on my Diagram binding mes(T1) with mes (t2)
But show the next message:


"Cannot insert the value NULL into column 'diagram_id', table 'Sicom.dbo.sysdiagrams'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'sp_creatediagram' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. (.Net SqlClient Data Provider)"
0
Comment
Question by:tenriquez199
  • 2
2 Comments
 
LVL 11

Expert Comment

by:JoeNuvo
ID: 35091648
modify column diagram_id in system table
change it Identity Specification to Yes
0
 
LVL 11

Accepted Solution

by:
JoeNuvo earned 2000 total points
ID: 35091687
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question