Please friends, I would like to know how I can use numerical formatting in Portuguese (999.999.999.00) if in the forms in the "format mask" it only accepts formatting in english?! can anybody help me?!
Note: I know that in reports has as I change the virgins by point ... will it be that in forms have something similar?!
Numerical formatting Portuguese (999999999.00)
-
- Rank: Programador Júnior
- Posts: 23
- Joined: Mon, 05 Jul 2004 4:29 pm
I use the following mascará
999G999G990D00
Alessandro
999G999G990D00
Alessandro
- anderson
- Rank: Analista Júnior
- Posts: 75
- Joined: Mon, 06 Jun 2005 1:08 pm
- Location: Toledo - PR
- Contact:
Anderson Nuernberg
---
---
Use the following mascara:
FM999G999G990D00
Where:
The FM withdraws the blank spaces from the field;
The G is the separator of a thousand and;
D is the decimal separader.
But remember that it depends on the configuration of your bank.
FM999G999G990D00
Where:
The FM withdraws the blank spaces from the field;
The G is the separator of a thousand and;
D is the decimal separader.
But remember that it depends on the configuration of your bank.
- Porva
- Rank: DBA Sênior
- Posts: 342
- Joined: Mon, 29 Jan 2007 7:36 am
- Location: São Paulo/SP
Rafael S. Nunes
São Paulo/SP
São Paulo/SP
I'll post here so I do not have to create another topic ..
I made a screen in Forms 6i and put the following mask for CNPJ:
99"."999"."999"/"9999"-"99
grateful
- Porva
- Rank: DBA Sênior
- Posts: 342
- Joined: Mon, 29 Jan 2007 7:36 am
- Location: São Paulo/SP
Rafael S. Nunes
São Paulo/SP
São Paulo/SP
The field is varchar ..
I used this hyebahi tip in the topic: http://en.glufke.net/oracle/viewtopic.p ... ht=mascara
* Remembering that the CNPJ had to be adapted / corrected, this testing inside the bank to see how it worked
but in the forms, only worked pro cpf, because the 'regExp_Replace' function does not work inside the forms
and I did not want to create an external function (inside the bank) to do this.
was only the pro CPF formatting.
I used this hyebahi tip in the topic: http://en.glufke.net/oracle/viewtopic.p ... ht=mascara
SELECT decode(cpf
,NULL
,NULL
,translate(to_char(cpf / 100, '000,000,000.00'), ',.', '.-')) cpf_com_mascara
,regexp_replace(cpf,'([0-9]{3})([0-9]{3})([0-9]{3})([0-9]{2})','\1.\2.\3-\4') cpf_com_mascara_regexp
FROM ((SELECT '12345678912' cpf
,'12345678000189' cnpj
FROM dual))
but in the forms, only worked pro cpf, because the 'regExp_Replace' function does not work inside the forms
and I did not want to create an external function (inside the bank) to do this.
was only the pro CPF formatting.
-
- Information
-
Who is online
Users browsing this forum: Google [Bot] and 12 guests