Cannot edit data directly in table

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
zolfAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
In optimistic concurrency control, users do not lock data when they read it. When a user updates data, the system checks to see if another user changed the data after it was read. If another user updated the data, an error is raised. Typically, the user receiving the error rolls back the transaction and starts over. This is called optimistic because it is mainly used in environments where there is low contention for data, and where the cost of occasionally rolling back a transaction is lower than the cost of locking data when read.

0
 
Aneesh RetnakaranDatabase AdministratorCommented:
You are trying to insert a varchar value into an integer column
0
 
zolfAuthor Commented:

no i am trying to put an integer value in a column which has type int
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
 
zolfAuthor 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
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
can u try it again ?
0
 
Jai STech ArchCommented:
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 ?
0
 
zolfAuthor Commented:

there is a column with type int and i am trying to insert 955 in it.
0
 
Jai STech ArchCommented:
sorry for haressing you with questions...are you typing 995 ? or copy  Pasting it ?
0
 
zolfAuthor Commented:

thanks for your comment
i am typing.it is very funny that i am facing this problem.
0
 
Sam PanwarSr. Server AdministratorCommented:
Can you provide the screenshot of your error screen.
0
 
zolfAuthor Commented:

how can i display a sceenshot in EE
0
 
zolfAuthor Commented:

somebody help
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
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 .
0
 
zolfAuthor Commented:

CHECK THIS URL I CREATED IN WEBSHOT.

http://community.webshots.com/album/560895778mKSbTD
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
I didi't find the error you describe above, all i can see is an optimistic concurrency control error.

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.