Numerical formatting Portuguese (999999999.00)

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
Post Reply
LC_JK
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 46
Joined: Tue, 24 Aug 2004 2:02 pm
Location: São Paulo
Contact:

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?!
romulo
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 4
Joined: Wed, 02 Mar 2005 11:45 pm
Location: SP
Contact:
Rômulo

Hello dear friend when I needed to do this so I found it a single way ....
go to the regedit and modify nls_language of the machine where the runtime is installed.



ATS,


Rômulo
Alessandro
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 23
Joined: Mon, 05 Jul 2004 4:29 pm

I use the following mascará

999G999G990D00

Alessandro
User avatar
anderson
Rank: Analista Júnior
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.
Jezper
Rank: Programador Pleno
Rank: Programador Pleno
Posts: 36
Joined: Mon, 17 Aug 2009 11:02 am
Location: Gaspar-SC
Jeziel Peres

PL/SQL - Forms 6i

I need a mascara q Virgula boat from the second number but I can not ..... I looked at the answer aqui but did not work .... Someone please could mi help ????

Thanks.
User avatar
Porva
Rank: DBA Sênior
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



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:

Select all

99"."999"."999"/"9999"-"99
Do not enter, I need the forms to record the points in the database as well, how do I?


grateful
GuiSS
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 20
Joined: Mon, 14 Jun 2010 11:17 am
Location: São Paulo, SP
Guilherme

Rafael,

I believe you will only be able to store the information from the with points and bars if the field type in the bank is Varchar ...
Hugs .. .
User avatar
Porva
Rank: DBA Sênior
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

The field is varchar ..

I used this hyebahi tip in the topic: http://en.glufke.net/oracle/viewtopic.p ... ht=mascara

Select all

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)) 
* 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.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 7 guests