acitano
Guest
Bye to all,
I am using the famous adolisp_library.lsp library of ms. jonh fleming.
I am questioning a table of a db of access 2007 with numerical fields that contain numbers like these:
200345.34289
79234.587
1024.12
30.05.56
etc.
when I run the sqlstatement:
(setq sqlstatement "select" from [mytable]"
I am returned:
200345.3
79234.6
1024.12
30.05.56
I don't understand why with the fourth number the three decimals are returned to the right while for the first two no!
I don't understand why with the third number two decimals are returned to me!
I believe that if the number is larger than 5 digits on the left adolisp_library truncates to one digit after the comma
I need the three decimal digits to the right also of the first 3 numbers (200345.34289 - 79234.58755 - 1024.123) without truncating them, how do I do?
thanks acitano
I am using the famous adolisp_library.lsp library of ms. jonh fleming.
I am questioning a table of a db of access 2007 with numerical fields that contain numbers like these:
200345.34289
79234.587
1024.12
30.05.56
etc.
when I run the sqlstatement:
(setq sqlstatement "select" from [mytable]"
I am returned:
200345.3
79234.6
1024.12
30.05.56
I don't understand why with the fourth number the three decimals are returned to the right while for the first two no!
I don't understand why with the third number two decimals are returned to me!
I believe that if the number is larger than 5 digits on the left adolisp_library truncates to one digit after the comma
I need the three decimal digits to the right also of the first 3 numbers (200345.34289 - 79234.58755 - 1024.123) without truncating them, how do I do?
thanks acitano