Home » Developer & Programmer » Forms » Username Display
Username Display [message #558018] Mon, 18 June 2012 21:47 Go to next message
Sumanjeet
Messages: 1
Registered: June 2012
Junior Member
Hi All,
some1 help please,,,i want to display the current database username in a text field after logging in at run time,i.e after logging in the username should should display in a text field.e,g,,if i login as scott then 'scott' should display in the text box

Report message to a moderator

Re: Username Display [message #558029 is a reply to message #558018] Tue, 19 June 2012 00:13 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In WHEN-NEW-FORM-INSTANCE trigger, set (preferably control block's) item value to
:block_name.text_field := user;

Report message to a moderator

Re: Username Display [message #558064 is a reply to message #558029] Tue, 19 June 2012 03:23 Go to previous messageGo to next message
tanyadimple
Messages: 1
Registered: June 2012
Location: india
Junior Member
verify V$DATABASE

Report message to a moderator

Re: Username Display [message #558066 is a reply to message #558064] Tue, 19 June 2012 03:30 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you mean by that?

V$DATABASE is not accessible under "default" circumstances (lack of privileges). Besides, I don't think that it contains current username.

Finally, Forms offers USER variable which does exactly what Sumanjeet asked for.

Report message to a moderator

Previous Topic: microsoft product and oracle application are in one server ,
Next Topic: How to use duplicate record built in
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 01:13:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.