OraFAQ Forum: Forms » Item Validation.

Home » Developer & Programmer » Forms » Item Validation. (Forms 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Item Validation. [message #529329]

Mon, 31 October 2011 03:37

samssams2006
Messages: 28
Registered: July 2010

Junior Member

Please see below screenshot.
/forum/fa/9515/0/

I have one colum Value his Datatype is varchar2 and I want to validete it with Type column his values are(Char,Date,Number).

If Column Type have value Number then column value should accept number input only. How we 'll achieve this.

Please suggest.

Regards,
Sams

Attachment: P.PNG
(Size: 4.65KB, Downloaded 1200 times)

Report message to a moderator

Re: Item Validation. [message #529338 is a reply to message #529329]

Mon, 31 October 2011 03:59

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle is smart enough to do it by itself - you don't have to do anything. If a column data type is NUMBER, you won't be able to enter anything but numbers in there. If it is a DATE, only valid DATE values are accepted. VARCHAR2 is much more flexible, and accepts virtually anything.

Report message to a moderator

Re: Item Validation. [message #529356 is a reply to message #529338]

Mon, 31 October 2011 05:21

samssams2006
Messages: 28
Registered: July 2010

Junior Member

Thankx for reply.
you are right.Oracle is smart enough to do it by itself but in above scenarios what I should do.

[Updated on: Mon, 31 October 2011 05:21]

Report message to a moderator

Re: Item Validation. [message #529359 is a reply to message #529356]

Mon, 31 October 2011 05:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Maybe I didn't understand the question ...

Explain why do you think that you *should* do anything? Reinventing a wheel or what?

You might try with regular expressions and detect whether a value inserted was a valid number.

Report message to a moderator

Previous Topic:	FRM-30351: No list elements defined for list item.
Next Topic:	Doubt dynamical fields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 06:07:31 CST 2025