Re: PL/SQL and FORMS30 questions
Date: 26 Apr 93 08:54:04 EDT
Message-ID: <7195.2bdba32d_at_hayes.com>
In article <1317_at_kps.se>, ded_at_kps.se (David Edwards /DP) writes:
> In article <1ii7jjINNoi3_at_terminator.rs.itd.umich.edu> pha_at_citi.umich.edu (Paul H. Anderson) writes:
> +1) setting the date in a displayed, but non-enterable field.
> +
> + I have a pre-record trigger that is attempting to automatically
> + store the date of entry into a base table field. If I convert the
> + date, and store it in some other enterable field (e.g. a character
> + comment field), etc, it shows up. (hence the trigger is working like I want).
> + Likewise, if I set the field to be enterable, I can have it's value
> + appear there (override any default value).
> + However, when I do the fairly obvious, which is to set a displayed,
> + but non-enterable date field equal to sysdate, nothing shows up.
> + How can I do this?
> +
> +
> +Paul Anderson
> +pha_at_umich.edu
>
> Set the default value to $$DATE$$ for a date field. The strange thing
> is one needs a form mask if you do this. I use YYMMDD although I
> suppose any valid date format could be used. (The default mask for
> dates
> is not used).
>
> This way you avoid triggers and keep the form simple.
>
> David Edwards
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> The surface of the strange, forbidden planet was roughly textured and
> green, much like cottage cheese gets way after the date on the lid
> says it is all right to buy it.--Scott Jones
You do have the ECHO INPUT attribute selected don't you? If you have only selected DISPLAYED, then any changes, such as in you pre-record trigger, will not display.
| Frank Greene | _/_/_/ _/_/_/ | | DELPHI SYSTEMS, Inc. | _/_/ _/_/ | | Telephone [615] 458-6032 | _/_/ _/_/ _/_/_/ | | Compuserve 74200,427 | _/_/ _/_/ _/_/ | | 324 Ootsima Way | _/_/ _/_/ _/_/ | | Loudon, TN 37774 | _/_/_/ _/_/_/ _/_/_/ | ---------------------------------------------------------------------------- | Of course, any opinions or suggestions are strictly my own | ----------------------------------------------------------------------------Received on Mon Apr 26 1993 - 14:54:04 CEST