Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2007, 08:42 PM
ZarrinPour ZarrinPour is offline
Senior Member
 
Join Date: Jul 2003
Posts: 232
Default Arithmetic overflow error for type int, value

Hi all
Today I'm so incredibly annoyed.
I have a simple Table which has one Identity column plus an integer Column with Unique constraint and some varchar fields.When i change the value of that Unique Constraint Column , the value will change successfully But today i find a record (Just By Chance) that when i change the value of its filed (whether through DML (Update...set..) script or Through Enterprise manager)i recieve the following Error: its filed has the value of 2519 and i wanted to update it to 2520 !!!

---------------------------
SQL Server Enterprise Manager
---------------------------
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for type int, value = 6262227669.000000.

[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
---------------------------
OK Help
---------------------------

As i said earlier i have no problem with other records , that's strange.

Could anyone help me Please?

Thanks in advance.
Kind Regards.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT. The time now is 07:00 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.