Re: How to get Oracle instance name and forms generation date/time

In article <33333da1.2692256_at_news.netspace.net.au>, David Martin <djmartin_at_netspace.net.au> wrote:
>I am trying to build a string that I will append to the Window Name so
>that when users screen print a problem we know where, when, by whom
>and which form.
>
>This string would contain:
>(1) the User Id (I know this one),
>(2) Oracle Instance name (we have three instances PROD, DEV1, TEST
>each addressable by Listener and defined in the TNSNAMES.ORA file),
>(3) the form name,
>(4) the date/time stamp of this form.
>
>I need help with numbers 2 and 4.

For #2:

        select global_name from global_name;

For #4, define a private program unit in each form and edit the program unit in the FMT file before converting to FMB and generating. It's risky perhaps, but it might work. We used to do this with FORMS3.

Before:

FUNCTION syf$form_version RETURN varchar2 IS BEGIN
    RETURN '<form_version>';
END; After Edit:

FUNCTION syf$form_version RETURN varchar2 IS BEGIN
    RETURN 'Mar. 26,1997';
END; Then use the function to construct the title.

Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com Received on Thu Mar 27 1997 - 00:00:00 CET