Re: Username/Password in SQL*Forms 3.0

Bowden (bowden_at_compsci.bristol.ac.uk) wrote:
: Hello,

: I'm using Forms v3.0, and I'm trying to run a report (using
: ReportWriter v1.1) from a form using the host command via
: a KEY-F0 trigger.
: Does anybody know which system variables within Forms hold
: the the user's username and password ? I've looked in all
: the relevant ORACLE manuals, but it is not mentioned.
 

: Thanks.

We have had exactly the same problem. You may retrieve the username from the sql function USER, but the password is unavailable within forms.

In our last project we solved the problem by means of SqlMenu, which coordinates our SqlForms applications. Instead of calling the forms with SqlMenu command type 4 we do it with command type 7 through a procedure which, among other things, initializes two global variables before launching the form

...
query_parameter('&un &pw');
:global.un := :un;
:global.pw := :pw;

...
os_command('(type = 4) runform30 my_application');

Now you may reference username as well as password in your form when you want to run a report.

Hope that helps

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+      Christian Mondrup                                                      +
+      UNI-C Aarhus, Danish Computing Centre for Research and Education.      +
+      Olof Palmes Alle 38, DK 8200 Aarhus N.                                 +
+                                                                             +
+      Phone:   +45 86 78 44 44                                               +
+      Telefax: +45 86 78 44 55                                               +
+      E-Mail:  Christian.Mondrup_at_uni-c.dk                                    +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++