Re: Please HELP - Forms 4.5
Date: 1997/11/15
Message-ID: <19971115012201.UAA12288_at_ladder02.news.aol.com>#1/1
>We've a very simple forms 4.5 application (10 fields). ID and SPECIES
>fields cannot be null. I've a trigger on both fields to make certain
>that neither are null.. When I enter the form my first enterable
>field is ID and the cursor is placed there. If I click anywhere
>prior to entering the ID I receive an error (that I must enter ID) as
>I should. However, after I've entered ID if I use my mouse to skip
>over the SPECIES field I don't get a similar error unless I've first
>entered the SPECIES field. I've tried using each of the WHEN-MOUSE...
>triggers to no avail. I do have a pre-insert/update trigger that
>checks that both fields are not null & these do prevent commiting bad
>data to the database. I would, however, like to write a trigger to
>immediately inform the user that SPECIES cannot be null whenever
>they've used a mouse to skip over the field. Any solution?
>
Hi
Wecome to the world of GUI where those pesky users can (and do) click wherever they like.
Our standard is not to make text items required but to check them in a WHEN-VALIDATE-RECORD trigger. This allows the users to dart around all they want to within the record but stops them if they try to leave it with an appropriate message.
Regards
John
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com
e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/
The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.
Received on Sat Nov 15 1997 - 00:00:00 CET