Re: forms 5 required field

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: Tue, 29 Aug 2000 19:01:27 -0700
Message-ID: <sqoqfc95c5d89_at_corp.supernews.com>


"Neville Sweet" <sweet.neville.nj_at_bhp_xxx_.com.au> wrote in message news:8ofbcb$sj6$1_at_gossamer.itmel.bhp.com.au...
> Hi Diane,
>
> Online Help tells you why it doesn't work:
> "Even when Required is set to Yes, there are circumstances when an item's
> value could be NULL. Form Builder checks for required items as part of its
> validation process: each item in a new record is subject to validation, but
> queried data is presumed to be valid and an item is not validated unless it
> is changed.".
>
> A couple of possible solutions are:
> Force validation by setting the item to itself if the item is null. You
> could do it in a Post-Query trigger.
> Ensure the item is not null yourself, before issuing Commit_Form (assuming
> you have attached the commit process to a trigger, eg. when-button-pressed).

Also check to see if the field has an initial value defined or if PRE-INSERT or PRE-UPDATE is supplying a value.

-Matt Received on Wed Aug 30 2000 - 04:01:27 CEST

Original text of this message