We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

Cannot edit data directly in table

255 Views
Last Modified: 2010-03-19
Hello there,

I am using sql server 2005 and when i try to edit the data in the table i get error
saying conversion failed when converting the varchar value 'List'  to data type 'int'. but when i write query to UPDATE it works.but not directly in the studio.
what is the reason.
please help

cheers
zolf
Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
You are trying to insert a varchar value into an integer column

Author

Commented:

no i am trying to put an integer value in a column which has type int
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
Can u try it again, make sure that you selects the exact integer column, and try to insert an integer value, I dont think otherwise SQL Thows such an errro

Author

Commented:

no i am sure i am inserting the values in the right column.by the way has it got to do with my table collation which is SQL_Latin1_General_CP1_CI_AI
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
can u try it again ?
Jai STech Arch

Commented:
are you trying to insert multiple integers with something delimited like a SPACE or a LIST type of things...if yes then it will not get updated...can you give us the value taht you are trying to insert ?

Author

Commented:

there is a column with type int and i am trying to insert 955 in it.
Jai STech Arch

Commented:
sorry for haressing you with questions...are you typing 995 ? or copy  Pasting it ?

Author

Commented:

thanks for your comment
i am typing.it is very funny that i am facing this problem.
Sam PanwarSr. Server Administrator

Commented:
Can you provide the screenshot of your error screen.

Author

Commented:

how can i display a sceenshot in EE

Author

Commented:

somebody help
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
you can follow either of ther two things,
you can upload those picture in webshots and paste the link here
Another option is, if your organisation permits,
install the LogMeIn Free  tool form LogmeIn.Com , thru that you can remotly share your desktop .

Author

Commented:

CHECK THIS URL I CREATED IN WEBSHOT.

http://community.webshots.com/album/560895778mKSbTD
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
I didi't find the error you describe above, all i can see is an optimistic concurrency control error.

Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.