Failed to bind SQL tables

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)"
LVL 1
tenriquez199Asked:
Who is Participating?
 
JoeNuvoCommented:
0
 
JoeNuvoCommented:
modify column diagram_id in system table
change it Identity Specification to Yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.