>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?
Add a 0 result that specifies a maximal precision greater than the precision of your SET DECIMALS setting
eg:
Rather than
SELECT Foo FROM bar INTO CURSOR mumbleTry SELECT Foo + 00000.0000000 AS Foo FROM bar INTO CURSOR mumble
That's equivalent to N(13,7), but if your result gets too big or you try specifying preceion > 16 places, you're a heavy favorite to be an unhappy camper because of the internal data format inability to do computation with an intermediate result of better acurracy than a DOUBLE (64 bit ANSI/Intel FP representation).
No, there's no way to do that with field wildcarding AFAIK, and you have to be careful with HAVING clauses