OraFAQ Forum: Forms » validate text item in a database block

Home » Developer & Programmer » Forms » validate text item in a database block

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

validate text item in a database block [message #81884]

Sat, 29 March 2003 08:48

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi,
I have a text item in a database block displaying 10 rows in my form.I need to validate this text box value to contain 'Y' or 'N'.

I can`t write when -validate or post text trigger for this since it will fire only for first row.I have been told not to use when validate or new instance triggers and timer triggers.So how to validate this text box....
otherthan creating an Lov...
Please give me some solutions..

Thanks
~V~

Report message to a moderator

Re: validate text item in a database block [message #81894 is a reply to message #81884]

Sun, 30 March 2003 23:18

utsav
Messages: 94
Registered: March 2003

Member

Hi,

Y r u using text boxes its its Y or N use the check box instead and all u r problems are solved.

In case of problems do let me know.

utsav.

Report message to a moderator

Re: validate text item in a database block [message #81898 is a reply to message #81884]

Mon, 31 March 2003 04:04

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi,
Thanks a lot.I have been told to use only text box for this though i asked for the use of check box there.
Any suggestions????
Thanks
~V~

Report message to a moderator

Re: validate text item in a database block [message #81924 is a reply to message #81898]

Wed, 02 April 2003 03:47

utsav
Messages: 94
Registered: March 2003

Member

Hi well since u have not mentioned post change trigger so i am going to use that.
In the post-change trigger write
if :itemvalue <>'Y' or :itemvalue <>'N'
then
raise form_trigger_failure;
end if;
end;

I hope this solves u r problem.

Utsav.

Report message to a moderator

Previous Topic:	how to read text file from form
Next Topic:	PLAY FLASH FILE IN FORM BUILDER APPLICATION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 09:48:09 CDT 2024