Information générale
Titre:
Rounding problem when appending records
I have a query that will have a result of one column that has 5 decimal places.
When I append that record to a dbf table which has 2 decimal places, it will automatically round it in 2 decimal places.
e.g.
query result is 0.78999
when i append this to my table the result will be 0.79
i dont want that to happen, what i want is 0.78
i know you can convert this to string and do the manipulation there. is there any way to go around with it.
thanks.
Suivant
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