Hi All,

When I do a query to the database that has a UNION in it, and 1 of my 2 fields is N(11), the other C(12) or whatever. When the cursor is returned the field has 2 decimal places. The same as the DECIMAL setting in the program. If I SET DECIMALS TO 0 before the query. Then reset them back to 2 all is ok. Is this the way to resolve this? Or is there a setting on the ODBC that I've missed?

TIA
Mike

P.S. VFP6 SP5 Oracle 8i