Validate the form field

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
  

Poston Sat, 21 May 2016 4:15 pm

Good afternoon, guys!

I have a question on how to validate a set of character in a form.
I'm giving maintenance in form and created a column in the screen to the user types a key number. This number has to be in this format. XX-X-XXXX, if the point and the strokes are not, the form cannot allow saving the different format of this.

Has anyone done something similar?
To make the property in a trigger " WHEN_VALIDATE_ITEM pallet ", the customization of the form?

If anyone can help, I'm grateful Hug
Deniskywalker

Poston Mon, 23 May 2016 7:52 am

Good morning, folks.

Nothing like a good weekend playing guitar and reading a bit to relax and stimulate the mind.
I solved the above problem by using a trigger block item.

Using a trigger WHEN_VALIDATE_ITEM was so
Code: Select all
IF SUBSTR(:BOM_OPERATION_SEQUENCES.ATTRIBUTE5,3,1) <> '.'
AND SUBSTR(:BOM_OPERATION_SEQUENCES.ATTRIBUTE5,6,1) <> '-'
AND SUBSTR(:BOM_OPERATION_SEQUENCES.ATTRIBUTE5,8,1) <> '-' THEN
   MSG_ALERT('Erro. A instrução deve ser inserida no padrão XX.XX-X-XXXX','E',TRUE);
END IF;
Deniskywalker



Return to Forms

Who is online

Users browsing this forum: No registered users and 7 guests