Sunday, February 19, 2012

How can I force money field works with comma instead dot?

How can I force money field works with comma instead dot?
Hi,
How can I force money field works with comma instead dot?
The default language of my Data Base is Portuguese.
Because I have to make something as below to work ok:
LgValor = Request("txtValor")
LgValor = Replace(LgValor,",",".")
So I have to put always this in the bank: 99999.99 .....
Thanks,
VILMAR
BRAZILFor input, you cannot have comma instead of dot. This is how the SQL language and SQL Server work,
quite simply.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Vilmar Brazão de Oliveira" <suporte@.hitecnet.com.br> wrote in message
news:e9KLP4ZxDHA.1680@.TK2MSFTNGP12.phx.gbl...
> How can I force money field works with comma instead dot?
> Hi,
> How can I force money field works with comma instead dot?
> The default language of my Data Base is Portuguese.
> Because I have to make something as below to work ok:
> LgValor = Request("txtValor")
> LgValor = Replace(LgValor,",",".")
> So I have to put always this in the bank: 99999.99 .....
> Thanks,
> VILMAR
> BRAZIL
>

No comments:

Post a Comment