Re: system.cursor_value century problem

Mark Waring <mwaring_at_umabnet.ab.umd.edu> wrote:  

> In Forms4.5, :SYSTEM.CURSOR_VALUE returns DD-MON-YY for a text item
> with the datatype of DATE even if the format property is MM/DD/YYYY.
>
> In SQL*Forms V3.0, :SYSTEM.CURSOR_VALUE returns DD-MON-YYYY for a
> Date field if the format is MM/DD/YYYY.
>
> Is there a GENERIC way around this problem in Forms4.5?
>
> I'd appreciate any suggestions. You can email me at
> mwaring_at_umabnet.ab.umd.com
>
> Thanks for your help,

FUNCTION current_item_date RETURN varchar2 IS BEGIN
    RETURN to_char(name_in(:system.cursor_item),

          get_item_property(:system.cursor_item, format_mask); END; Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com Received on Wed Apr 30 1997 - 00:00:00 CEST