Home » Developer & Programmer » Forms » logon logout screen?
logon logout screen? [message #542022] Fri, 03 February 2012 23:27 Go to next message
nvsr
Messages: 51
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..

Re: logon logout screen? [message #544827 is a reply to message #542022] Fri, 24 February 2012 03:11 Go to previous message
GoGreen
Messages: 26
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;


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


Current Time: Thu Aug 21 17:59:14 CDT 2014

Total time taken to generate the page: 0.09638 seconds