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
kayveyAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>when I press exclam "execute SQL"

THAT explains it.
that button will return the SELECT * FROM TABLENAME ... and putting to the trash you input.
instead, just click anywhere outside the row, or for example "key down", and it will run the INSERT/UPDATE instead
0
 
sm394Commented:
if there is any foreign key field in that table make sure its reference else hit enter after input
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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.
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
kayveyAuthor Commented:
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
0
 
kayveyAuthor Commented:
There are no errors in this error window
errorsEmpty.jpg
0
 
kayveyAuthor Commented:
Everything disappears when I press exclam "execute SQL"
0
 
kayveyAuthor Commented:
here is another file
PSmithThere.jpg
0
 
kayveyAuthor Commented:
0
 
kayveyAuthor Commented:
stoopid windoze craziness
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you must know that I have done that error in the beginning also ... :)
glad I could help
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.