Hola amigos
Hace mucho tiempo se expuso en este foro
el problema que tenemos en Europa con
la presentación de cantidades monetárias
en nuestro caso el Euro €, a diferencia
de otras parte del Mundo, nosotros presentamos
los decimales con -> "," ejemplo 1.245,56 €
pero el sistema nos suele presentar la
cifra de esta manera-> 1245.56
En su momento el maestro Roberto incorporó
al TEXTBOX la posibilidad de que se presentara
de la forma Europea con FORMAT 'E', pero en mi
caso tanto en Report como en LABEL no conseguía
que saliera dicha representación.
Encontre una Rutina de EDUARDO V. FLORES RIVAS
que crea una función bastante acertada pero
he tenido que modificala para que tenga el
resultado necesario añadiendo -> STUFF
espero que les pueda servir esta contribución.
*----------------Geogle -----------------------*
Hello friends
Long ago I discussed in this forum
the problem we have in Europe
the presentation of monetary amounts
in our case the Euro €, unlike
other part of the world, we present
decimals, -> "," example 1.245,56 €
but the system usually has us
figure this way-> 1245.56
At the time the master Roberto joined
the TEXTBOX the possibility that he Report
European form with FORMAT 'E', but in my
If both Report and LABEL could not
he left such representation.
I found a Routine EDUARDO V. FLORES RIVAS
that creates a pretty good feature but
I had to modify it to have the
adding necessary result -> STUFF
I hope you can serve this contribution.
regards
Mustafa
Europa money decimals
Moderator: Rathinagiri
- mustafa
- Posts: 1159
- Joined: Fri Mar 20, 2009 11:38 am
- DBs Used: DBF
- Location: Alicante - Spain
- Contact:
Europa money decimals
- Attachments
-
- Euro_Money.zip
- (753.74 KiB) Downloaded 282 times
-
- screenshot.jpg (36.93 KiB) Viewed 4143 times
- serge_girard
- Posts: 3166
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: Europa money decimals
Fine sample, thanks!
But, Ihave another question - how to treat comma as decimal point while numeric data input?
Has anybody solution for it?
But, Ihave another question - how to treat comma as decimal point while numeric data input?
Has anybody solution for it?
Re: Europa money decimals
Hola, yo utilizo:
TRAN(nVar, "@E 999,999,999.99")
TRAN(nVar, "@E 999,999,999.99")
Re: Europa money decimals
You didn,t understand. I don't want to translate dot to comma, I need reactio for comma pressed to enter decimal piece of number
Re: Europa money decimals
Sorry, my comment was written for Mustafa.
- mustafa
- Posts: 1159
- Joined: Fri Mar 20, 2009 11:38 am
- DBs Used: DBF
- Location: Alicante - Spain
- Contact:
Re: Europa money decimals
Hola amigo lalacas:
TRAN(nVar, "@E 999,999,999.99") , muy bueno perfecto
saludos
Mustafa
TRAN(nVar, "@E 999,999,999.99") , muy bueno perfecto
saludos
Mustafa