Personal is the following:
I am developing a registration system in jdeveloper and in one of the registration processes I want the data to be entered only as uppercase, regardless of the user to enter them in tiny.
Does anyone know how to do this?
Thanks
Inserts in capital in the bank
-
- Moderador
- Posts: 53
- Joined: Mon, 12 Jul 2004 11:24 am
- Location: Salvador
Atenciosamente,
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
What can you do, if you do not want to mess with the programs, it's to create a trigger before insert ...
in it, you take the desired field and do so:
0]]]
in it, you take the desired field and do so:
0]]]
-
- Moderador
- Posts: 53
- Joined: Mon, 12 Jul 2004 11:24 am
- Location: Salvador
Atenciosamente,
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
Thanks man .... I'll apply.
-
- Moderador
- Posts: 53
- Joined: Mon, 12 Jul 2004 11:24 am
- Location: Salvador
Atenciosamente,
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
Face is the following,
the trigger that you indicated me is functional, but my situation is as follows:
previously I I was inserting a word in a form and commiting this word in another form, so the trigger worked beauty.
Only now I need to insert the word and commit it in the same form, hence when I go to the main form the word is already changed.
have some suggestion?
the trigger that you indicated me is functional, but my situation is as follows:
previously I I was inserting a word in a form and commiting this word in another form, so the trigger worked beauty.
Only now I need to insert the word and commit it in the same form, hence when I go to the main form the word is already changed.
have some suggestion?
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
I think what's missing there is a refresh, or something ... I do not know if you will get it without messing with the codes of your program ...
-
- Moderador
- Posts: 53
- Joined: Mon, 12 Jul 2004 11:24 am
- Location: Salvador
Atenciosamente,
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
Eduardo Santana
"Viva o dia de hoje como se fosse amanhã, por isso, não perca as oportunidades...."
Pow man, I solved the problem.
The case was: When I fired the trigger, there were some data in one of the tables I had not seen. It hurt error.
The trigger as it is, is running perfectly.
Thanks again.
The case was: When I fired the trigger, there were some data in one of the tables I had not seen. It hurt error.
The trigger as it is, is running perfectly.
Thanks again.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 8 guests