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 :)

Member Avatar

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.

Member Avatar

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.

commented: agree +13

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;
Member Avatar

hfx642

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