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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement