how to do this in pl/sql?

[bettybarnes]

Hi i'm a newbie in pl/sql and i need some help from the experts. I'm a vb programmer. Just want to ask you how do you do this in pl/sql?

If I log in on my account my username should appear in a textbox.
From this LoginForm I have 2 textboxes namely, txtUsername and txtPassword.
And on the MainForm, my username should be displayed in a textbox named txtUser

txtUser.Text = loginForm.txtUsername.text

any help would be highly appreciated. thanks and God bless :)

[hfx642]

Well... You can't really run PL/SQL unless you're logged in.
That's like trying to drive a car, without getting in the car.
What is your "front end" tool that users are using to log in?
Forms and SQL*Plus already ask for Username and Password.

[bettybarnes]

Forms Builder

[hfx642]

Well, then you have nothing to do.
Oracle will take care of users logging in.
Just program your Form to do it's function.

[bettybarnes]

hey why does another call overrides my other form?
here is my problem

I have a poplist wherein its items are Business, ITE, and Arts.
then i also have 3 tlist items for each items Business, ITE, Arts.

this is my code for them

BEGIN
	


	IF
		:MAIN.lstCEAE = 'Archi' THEN
		OPEN_FORM('C:\AdvisementDSS\MOD_ARCHI.fmx');
	END IF;
	
	
	
	IF
		:MAIN.lstCEAE = 'CE' THEN
		OPEN_FORM('C:\AdvisementDSS\MOD_CE.fmx');
	END IF;
	
	IF
		:MAIN.lstCEAE = 'ECE' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_ECE.fmx');
	END IF;
	
	IF
		:MAIN.lstCEAE = 'EE' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_EE.fmx');
	END IF;
	
	IF
		:MAIN.lstCEAE = 'IE' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_IE.fmx');
	END IF;
	
	IF
		:MAIN.lstCEAE = 'MarE' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_MARE.fmx');
	END IF;

	IF
		:MAIN.lstCEAE = 'ME' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_ME.fmx');
	END IF;
		
	IF
		:MAIN.lstCITE = 'IS' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_IS.fmx');
	END IF;
	
	IF
		:MAIN.lstCITE = 'CS' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_CS.fmx');
	END IF;
	
	IF
	:MAIN.lstCITE = 'ACT' THEN
		CALL_FORM('C:\AdvisementDSS\MOD_ACT.fmx');
	END IF;

	
		IF :MAIN.lstCBE = 'ACCNTCY' THEN
		OPEN_FORM('C:\AdvisementDSS\MOD_ACCNTCY.fmx');
		END IF;
	IF 
		:MAIN.lstCBE = 'LM' THEN
		OPEN_FORM('C:\AdvisementDSS\MOD_LM.fmx');
		END IF;
	
END;

[hfx642]

In 4 of your calls, you are using Open_Form.
Replace these with Call_Form, as in your other calls.