This is driving me nuts!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to paste data into a table. The values are #'s such as 108.577645.
When I paste it over it comes out 108.577640. I've got the table set up to
hold six decimal places, but it still rounds off. Any suggestions.
 
RobertM said:
I'm trying to paste data into a table. The values are #'s such as 108.577645.
When I paste it over it comes out 108.577640. I've got the table set up to
hold six decimal places, but it still rounds off. Any suggestions.
Click to expand...


It sounds like the field size is Single, which is rather
limited. You probably need to change it to Double.
 
I have just tried it and it pastes OK. My number was set to Double with 6
decimal places. What number type is yours ?
 
Marshall said:
It sounds like the field size is Single, which is rather
limited. You probably need to change it to Double.
Click to expand...

It sound like the data is DECMIAL(n, 6) to me e.g.

SELECT TYPENAME(108.577645)

returns 'Decimal'.

Exmaple:

ALTER TABLE MyTable ADD price_euros DECIMAL(15, 6)
 
Back
Top