SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 difficulty adding a record in SSMSE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

khyron
Starting Member

5 Posts

Posted - 08/21/2006 :  14:19:02  Show Profile  Reply with Quote
I'm new to SQL Server and I'm using 2005 Express with SSMSE, and having trouble adding a record to a table "manually" by typing in the data.

I find I can change most of the fields by viewing the table in SSMSE and just clicking on the field and editing it then clicking "execute SQL" but for some reason the changes don't "take" when a date field is involved.

Is there a special or proper way to enter a date that I'm not aware of? I'm not having much success figuring out this online help stuff from within SSMSE, I keep getting to help on the help system itself (oops).

TIA!

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 08/22/2006 :  04:08:06  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message  Reply with Quote
what format are you trying to insert the date as??

and post the error message you are getting??

Chirag
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 08/22/2006 :  04:08:52  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Clicking Execute SQL, while in edit mode, undo your edit.
You have to move focus from that cell, with either tab or arrow keys. Now click "Execute SQL" and you will se that the changes you made are there.

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

khyron
Starting Member

5 Posts

Posted - 08/22/2006 :  09:49:15  Show Profile  Reply with Quote
quote:
Originally posted by Peso

Clicking Execute SQL, while in edit mode, undo your edit.
You have to move focus from that cell, with either tab or arrow keys. Now click "Execute SQL" and you will se that the changes you made are there.

Peter Larsson
Helsingborg, Sweden



Thank you Peter! That was exactly what I was doing. I was being over-eager and either hitting the "Execute SQL" button in the menu bar or right clicking and choosing "Execute SQL" on the same cell, but each time I tried I had not changed focus yet.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000