Re: Forms 6i and required fields

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:GLSx9.6568$6g.2392791_at_news1.news.adelphia.net...
> Forms [32 Bit] Version 6.0.8.11.3 (Production)
> Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.2.0 - Production
> Oracle Toolkit Version 6.0.5.35.0 (Production)
> PL/SQL Version 8.0.6.0.0 (Production)
> Oracle Procedure Builder V6.0.8.11.0 Build #449 - Production
> PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
> Oracle Query Builder 6.0.7.0.0 - Production
> Oracle Virtual Graphics System Version 6.0.5.35.0 (Production)
> Oracle Tools GUI Utilities Version 6.0.5.35.0 (Production)
> Oracle Multimedia Version 6.0.5.34.0 (Production)
> Oracle Tools Integration Version 6.0.8.10.2 (Production)
> Oracle Tools Common Area Version 6.0.5.32.1
> Oracle CORE Version 4.0.6.0.0 - Production
>
> Is there some way to put up a message to the user when a required field is
> null? Right now all it does is move the cursor to the field and that isn't
> very friendly for our use. It totally ignores the when-validate-item
trigger
> code until there is a value in the field.
>

This test for a null value is made BEFORE any written code kicks in. One way around your problem is to leave all fields as NULL ALLOWED and write When-Validate-Items triggers and When-validate-record triggers to catch a null value. This way you code the test and can produce whatever error you like, over-riding the default message on the status bar. Received on Thu Nov 07 2002 - 15:36:20 CET