• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

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
0
zolf
Asked:
zolf
  • 7
  • 6
  • 2
  • +1
1 Solution
 
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
 
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 6
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now