-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
A Long Integer doesn't have decimal places; therefore, when you
converted the text to the Long the decimal places were dropped. Since
Long's don't have decimal places, when you change the Long to a Decimal,
there weren't any decimal places to convert to the Decimal.
Instead of
String -> Long -> Decimal
Do
String -> Decimal
This should preserve you decimal places.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQji+GYechKqOuFEgEQKzSwCgg5bUNcx9XRYU1tCW69gfPp 41y84AnjPS
OKOUx0EhCjsGFqJZk5lFhfTx
=SvTQ
-----END PGP SIGNATURE-----
italia wrote:
I changed the Fieldsize Property from text to Long Integer and Decimal
Places = 6.
I had decimals in the original field. But after the transfer, the
digits after the decimals are gone.
Now even after I have change the Fieldsize propert to Decimal with
Scale = 2, the digits after the decimal are not seen.
For eg. If the text was 16.27. After I changed to long integer, it
changed to 16. Now when I convert to decimal it is still 16. The digits
after the decimal point are lost.
Does anyone know if there is a way I can get those digits back?
Thanks,
Ken