OraFAQ Forum: Forms » logon logout screen?

Home » Developer & Programmer » Forms » logon logout screen?

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

logon logout screen? [message #542022]

Fri, 03 February 2012 23:27

nvsr
Messages: 54
Registered: December 2011
Location: HYDERABAD

Member

hi all..

i am developing menu.. in that menu having 5 different forms.. these forms are 3 one schema ( i.e X ) and remaining 2 forms are one schema ( i.e Y )..

i am calling x schema

form level trigger on_logoon :

onlogon('a','a@X');

a for Username and x database name

and another form

in form level trigger on_logon : coding

logout;

logon('b','b@Y');

b for Username and y database name

but the form is not executeing and not saving the record's..

Report message to a moderator

Re: logon logout screen? [message #544827 is a reply to message #542022]

Fri, 24 February 2012 03:11

GoGreen
Messages: 28
Registered: February 2012
Location: Java Island

Junior Member

create 1 item ( list item, for ex. group )),
ELEMENTS IN LIST
INSERT LIST ELEMENS
A
INSERT LIST ITEM VALUE
A

INSERT LIST ELEMENS
B
INSERT LIST ITEM VALUE
B

INSERT LIST ELEMENS
C
INSERT LIST ITEM VALUE
C

1. trigger "on logon"
IF :blk_login. group = 'A' THEN
LOGOUT;
LOGON('A','A@XE',FALSE);
ELSIF :blk_login. group = 'B' THEN
LOGOUT;
LOGON('B','B@XE',FALSE);
ELSIF :blk_login. group = 'C' THEN
LOGOUT;
LOGON('C','C@XE',FALSE);
END IF;

2. create procedure :

PROCEDURE Login IS
begin

IF :blk_login. group = 'A' THEN
LOGOUT;
LOGON('A','A@XE',FALSE);
ELSIF :blk_login. group = 'B' THEN
LOGOUT;
LOGON('B','B@XE',FALSE);
ELSIF :blk_login. group = 'C' THEN
LOGOUT;
LOGON('C','C@XE',FALSE);
END IF;

End;

3. CREATE item button to login
4. Create trigger "WHEN-BUTTON-PRESSED"
in trigger
login;

Report message to a moderator

Previous Topic:	Insert picture (split from unrelated thread)
Next Topic:	how to select multiple records?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 04:07:56 CST 2025