RE: Validation in form6i

"pep0" <[email protected]> Wed, 29 Jan 2003 08:26:07 -0000
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-852841-2003.01.29-08.34.28--gcdod-oracle#[email protected]>
Hi!

Why don't you try to use a trigger to ensure that your data is properly
validated?
For example, create a POST-RECORD trigger (which fires once when focus
moves out of a record) and type some PL/SQL code to compare your record
against null.  

IF :canvas.item = NULL THEN
...
ELSE
...
END IF;


To get the desired result you should try with different kind of triggers
in order to find the most suitable for your purpose.

Good luck!
pep0.



> -----Mensaje original-----
> De: manit_jain [mailto:[email protected]] 
> Enviado el: miƩrcoles, 29 de enero de 2003 5:52
> Para: Oracle
> Asunto: [oracle] Validation in form6i
> 
> 
> hi  all,
> 
> 
>   can anyone please tell me how to validate text and list 
> value against null without setting the required property to yes.
> 
> 
> thanks .
> 
> 
> waiting for reply.
> Get Your Private, Free E-mail from Indiatimes at  
http://email.indiatimes.com Buy the best in Movies at
http://www.videos.indiatimes.com Bid for Air Tickets @ Re.1 on Air
Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid
Now !


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.




---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].