Help: formula checkbox not updating nicely

From: Olli-Pekka Tarna <ollipekka.tarna_at_akermar.com>
Date: Sat, 23 Oct 1999 12:37:58 GMT
Message-ID: <7usa77$jb9$1_at_nnrp1.deja.com>

[Quoted] [Quoted] Hi real Gurus, these formula fields are driving me crazy!

On my form I have 4 check boxes that are supposed to indicate if dates in 4 respective columns are not null. They are all in the same block.

Check boxes are set as:

Value when checked: Y
Value when unchecked: N
Value when other... : Unchecked
Database Item: No

Calculation Mode:     Formula
Formula:              decode_date('block.field')

Function Decode_Date that returns the value for the formula field is:

FUNCTION decode_date(pcField IN char) RETURN char IS

BEGIN
  if name_in(pcField) is not NULL then
    return 'Y';
  else
    return 'N';
  end if;
END; The problem is that the check box fields do not change their state when dates are entered. Not even after committing the form. They reflect [Quoted] [Quoted] the current state of the respective date fields only after the form being requeried.

This is not what I want. Any help to get the check boxes updated at least after committing would be more than welcome.

OPT Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 23 1999 - 14:37:58 CEST