Europa money decimals

HMG Samples and Enhancements

Moderator: Rathinagiri

Post Reply
User avatar
mustafa
Posts: 1159
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Contact:

Europa money decimals

Post by mustafa »

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 :idea:
Attachments
Euro_Money.zip
(753.74 KiB) Downloaded 282 times
screenshot.jpg
screenshot.jpg (36.93 KiB) Viewed 4143 times
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: Europa money decimals

Post by bpd2000 »

Nice
Thank you for sharing
BPD
Convert Dream into Reality through HMG
User avatar
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

Post by serge_girard »

Thanks Mustafa!

Serge
There's nothing you can do that can't be done...
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Europa money decimals

Post by mol »

Fine sample, thanks!

But, Ihave another question - how to treat comma as decimal point while numeric data input?
Has anybody solution for it?
User avatar
lalacas
Posts: 11
Joined: Fri Sep 19, 2014 8:27 am
Location: Spain

Re: Europa money decimals

Post by lalacas »

Hola, yo utilizo:

TRAN(nVar, "@E 999,999,999.99")
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: Europa money decimals

Post by mol »

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
User avatar
lalacas
Posts: 11
Joined: Fri Sep 19, 2014 8:27 am
Location: Spain

Re: Europa money decimals

Post by lalacas »

Sorry, my comment was written for Mustafa.
User avatar
mustafa
Posts: 1159
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Contact:

Re: Europa money decimals

Post by mustafa »

Hola amigo lalacas:
TRAN(nVar, "@E 999,999,999.99") , muy bueno perfecto
saludos
Mustafa
Post Reply