Link to home
Start Free TrialLog in
Avatar of kayvey
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
Avatar of Faizan Sarwar
Faizan Sarwar
Flag of United Kingdom of Great Britain and Northern Ireland image

if there is any foreign key field in that table make sure its reference else hit enter after input
Avatar of Guy Hengel [angelIII / a3]
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.
Avatar of kayvey
kayvey

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
Avatar of kayvey

ASKER

There are no errors in this error window
errorsEmpty.jpg
Avatar of kayvey

ASKER

Everything disappears when I press exclam "execute SQL"
Avatar of kayvey

ASKER

here is another file
PSmithThere.jpg
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kayvey

ASKER

stoopid windoze craziness
you must know that I have done that error in the beginning also ... :)
glad I could help