OraFAQ Forum: Forms » Current user(database items) (merged 2)

Home » Developer & Programmer » Forms » Current user(database items) (merged 2) (10g)

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

Current user(database items) (merged 2) [message #540908]

Thu, 26 January 2012 09:32

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

Hello guys, I need help regarding database items. I have 2 forms one is LOGIN Form and the other one is MAIN FORM. On the login form, i have 2 text items namely: username and password. and when i click the login button, it should go directly to the main form. ON the main form i have a textbox. That textbox should display the user i entered on my username text item back in login form. I'm a VB.net programmer and I find it a lot complicated to program in PL/SQL.

desperate for help,

Report message to a moderator

Re: Current user(database items) [message #540909 is a reply to message #540908]

Thu, 26 January 2012 09:34

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Assuming the username is an actual oracle user then it can be obtained at any point with the user function.

<datablock item> := user;

Report message to a moderator

Re: Current user(database items) [message #540925 is a reply to message #540909]

Thu, 26 January 2012 10:16

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

is that user the database user?

Report message to a moderator

Re: Current user(database items) [message #540927 is a reply to message #540925]

Thu, 26 January 2012 10:21

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

That's what I said.

Report message to a moderator

Re: Current user(database items) [message #540929 is a reply to message #540927]

Thu, 26 January 2012 10:34

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

But I want to display the user found in my tables. Say for example this is the structure of my tblUsers user_id, username, password.
I have jonalyn as my username. and when i input my username in the username text item, it should display in my main form text item.

In VB.Net this is how i did it:

Me.TxtUsername.Text = Login.TxtUsername.Text

[Updated on: Thu, 26 January 2012 10:35]

Report message to a moderator

Re: Current user(database items) [message #540935 is a reply to message #540929]

Thu, 26 January 2012 10:45

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Then you probably will have to pass the username as a parameter between forms.
Or create a global variable to hold it.

Report message to a moderator

Re: Current user(database items) [message #540938 is a reply to message #540935]

Thu, 26 January 2012 10:55

baliberde
Messages: 201
Registered: January 2012
Location: outer space

Senior Member

So how can I do that?

Report message to a moderator

Re: Current user(database items) [message #540939 is a reply to message #540938]

Thu, 26 January 2012 10:58

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Read up on both parameters and global variables in form builder help. It has all the details with examples.

Report message to a moderator

Previous Topic:	Hierarchical Tree
Next Topic:	SENDING EMPLOYEE PAYROLL SLIP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 22:32:25 CST 2025