Solved

Failed to bind SQL tables

Posted on 2011-03-09
2
590 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 500 total points
ID: 35091687
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Creating and Managing Databases with phpMyAdmin in cPanel.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

837 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