>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?
I didn't know it did this. If so, in your SQL Select, you could use the round() function as one of the field sources.
Ex.
select round(myfield,7) as myfield from mytable into cursor mycursor
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao