Board index » delphi » update statement

David Gallaher

Delphi Developer
Sat, 13 Mar 2004 05:55:54 GMT

update statement

Hi I have a Temporary  table ( #Temp ). My statement is
 select LastName, 0.00 as Amount
into #Temp
from Table1

This works fine.
Later I run an Update statement:
Update #Temp set Amount = 2.22

This returns an error message saying arithmetic overflow. I get this error
in both the idea of Delphi 6 and in SQL query analizer. Any ideas on what I
should do?

 
Mumtaz Mohame

Delphi Developer
Mon, 15 Mar 2004 22:02:01 GMT

Re:update statement


Hi,

When inserting data into the #Temp table do the following:

Select LastName, convert(money,0.00) as Amount
into #Temp
from Table1

Update #Temp set Amount = 2.22

This would solve your problem

Regards

Quote
"David Gallaher" <dgalla...@quantum.ca> wrote in message

news:00Or7.12705$GQ2.1131944@news20.bellglobal.com...
Quote
> Hi I have a Temporary  table ( #Temp ). My statement is
>  select LastName, 0.00 as Amount
> into #Temp
> from Table1

> This works fine.
> Later I run an Update statement:
> Update #Temp set Amount = 2.22

> This returns an error message saying arithmetic overflow. I get this error
> in both the idea of Delphi 6 and in SQL query analizer. Any ideas on what
I
> should do?

Other Threads

1. Update Memo-Column with SQL UPDATE Statement

2. TDatasetProvider doesn't formulate correct update statement

3. UPDATE statement problem

4. Problem with UPDATE statement

5. Help needed with SQL - Update Statement

6. SQL update statement, set to nil??

7. parametrized subqueries in Update statement

8. Update Statements

9. TQuery UpDate Statement

10. Simple Blob select and update statement for storing images in database