?
Solved

Failed to bind SQL tables

Posted on 2011-03-09
2
Medium Priority
?
594 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
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 Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

650 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