Re: PL/SQL and FORMS30 questions

From: <fgreene_at_hayes.com>
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

Original text of this message