OraFAQ Forum: Forms » network name inside form

Home » Developer & Programmer » Forms » network name inside form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

network name inside form [message #87417]

Sat, 01 January 2005 01:27

Senthil
Messages: 68
Registered: December 1999

Member

Hi

Is it possible to get the computer name(network name) inside the form ? i.e i want to get the computer name while running form to store the computer name in the database for monitoring purpose. What is the command to do this job.

Please help me.

Regards

Senthil

Report message to a moderator

Re: network name inside form [message #87420 is a reply to message #87417]

Sun, 02 January 2005 19:34

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
This can be achived by using functions provided in D2kwutil.pll libraray.

To get the WINDOW's user login name make use of
WIN_API_ENVIRONMENT.GET_WINDOWS_USER_NAME & to get any registry entry which also includes the network name of your computer make use of WIN_API_ENVIRONMENT.READ_REGISTRY.

HTH
Regards
Himanshu

Report message to a moderator

Re: network name inside form [message #273631 is a reply to message #87420]

Thu, 11 October 2007 02:20

iffi_97
Messages: 2
Registered: October 2007

Junior Member

Hi,
please can u help me how to write the code for WIN_API_ENVIRONMENT.GET_WINDOWS_username. I have attached the said library but dont know how to use this feature.

Please tell me with an example. how and where to use this code in forms 6i

Report message to a moderator

Re: network name inside form [message #276346 is a reply to message #273631]

Wed, 24 October 2007 23:03

sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi

Member

salam brother
first u have to create a database function given below

CREATE OR REPLACE FUNCTION RETURN_USER_NAME
RETURN VARCHAR2
IS
USER_NAME_V VARCHAR2(100);
BEGIN
SELECT SYS_CONTEXT('USERENV','OS_USER')
INTO USER_NAME_V
FROM DUAL;
RETURN(USER_NAME_V);
END;

then say on ur given form "form1" write this tirgger
when-new-form-instance
:block1.user_name := return_user_name;

and on text item "user_name" in block1 u will get client side operating system user name

regards

Report message to a moderator

Re: network name inside form [message #276349 is a reply to message #276346]

Wed, 24 October 2007 23:06

sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi

Member

sorry brother
in function return_user_name
change
'os_user' with 'TERMINAL'

Report message to a moderator

Previous Topic:	capturing client operating system user name
Next Topic:	how to create a calendar?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 14:39:30 CDT 2025