General information
Category:
Coding, syntax & commands
Edgar-
>When I do a SELECT into a cursor or to a table it rounds the numeric fields. How can I fix that to return exactly what is?
>I tried to SET DECIAMALS but that did not help. Any suggestions?
You can do the select adding 0 (with the maximum number of decimals places) to the numeric field. Something like this:
SELECT 000000000000.000000 + nNumeric FROM cTable
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only