kayvey
asked on
MS SQL Server 2008 doesn't like my inputs
I'm trying to input values into my Microsoft SQL Server 2008 and it is making red exclaims at
me and my data goes bye bye
byeByeData.jpg
me and my data goes bye bye
byeByeData.jpg
if there is any foreign key field in that table make sure its reference else hit enter after input
the exclamation mark is "NOT" the problem.
please show the error you get, and the table structure, and any triggers you might have on the table.
please show the error you get, and the table structure, and any triggers you might have on the table.
ASKER
All these *@#& widget ding dangs are driving me crazy. I'm not 100% sure where to find what you are talking about, but I was trying to make a few FK/PK relationships. The red exclams are on fields that I didn't think I create such things. Here I show you a second table, that should be at the top of the tree
or whatever, no FK problems Automobile is linked to Customer by purchased_by which
is equal to PK license in Customer. It doesn't seem to like my Customer either. I also made a Sales_Rep I need PSmith I haven't created him yet, but I don't know why that should affect Customer
custCranky.jpg
or whatever, no FK problems Automobile is linked to Customer by purchased_by which
is equal to PK license in Customer. It doesn't seem to like my Customer either. I also made a Sales_Rep I need PSmith I haven't created him yet, but I don't know why that should affect Customer
custCranky.jpg
ASKER
There are no errors in this error window
errorsEmpty.jpg
errorsEmpty.jpg
ASKER
Everything disappears when I press exclam "execute SQL"
ASKER
here is another file
PSmithThere.jpg
PSmithThere.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Lots of nice pictures about this same database here:
https://www.experts-exchange.com/questions/23869526/MS-SQL-Server-2008-Data-integrity-FK-NULL.html
https://www.experts-exchange.com/questions/23869526/MS-SQL-Server-2008-Data-integrity-FK-NULL.html
ASKER
stoopid windoze craziness
you must know that I have done that error in the beginning also ... :)
glad I could help
glad I could help