Re: How to close LOGON_SCREEN pop up without any entry?
From: Eric C. Janzen <ejanzen_at_telusplanet.net>
Date: Tue, 08 Feb 2000 19:08:38 GMT
Message-ID: <WQZn4.9069$jW4.129024_at_news0.telusplanet.net>
END;
Date: Tue, 08 Feb 2000 19:08:38 GMT
Message-ID: <WQZn4.9069$jW4.129024_at_news0.telusplanet.net>
Try this:
BEGIN
Logon_Screen;
--Get the UserID, Password and Connect String;
user_id :=
UPPER(RTRIM(LTRIM(GET_APPLICATION_PROPERTY(USERNAME))));
pass_wrd :=
UPPER(RTRIM(LTRIM(GET_APPLICATION_PROPERTY(PASSWORD))));
db_name :=
RTRIM(LTRIM(GET_APPLICATION_PROPERTY(CONNECT_STRING)));
-- LOG the User onto the database
IF ( db_name IS NOT NULL ) THEN
LOGON(user_id, pass_wrd||'_at_'||db_name,FALSE);
ELSE
LOGON(TIN_userid||user_id, pass_wrd,FALSE);
END IF;
IF NOT FORM_SUCCESS THEN
RAISE LOGON_FAIL;
END IF;
EXCEPTION
WHEN LOGON_FAIL THEN MESSAGE('Invalid username, password or database;
Logon denied.');
SYNCHRONIZE;
RAISE FORM_TRIGGER_FAILURE;
WHEN OTHERS THEN RAISE;
END;
-- -------------------------------------------------- Eric Janzen E. Janzen Consulting Inc. Oracle Development Specialist -------------------------------------------------- Ajay Madan <ajay_madanNOajSPAM_at_usa.net.invalid> wrote in message news:0da8adac.0437255e_at_usw-ex0108-061.remarq.com...Received on Tue Feb 08 2000 - 20:08:38 CET
> My application is on the Oracle 8i server and the Front end
> is Developer6. My application requires that we pop up a
> Logon screen just before the form is displayed. In my WHEN-
> NEW-FORM-INSTANCE I have used the buitin "LOGON_SCREEN"
> which pops up a screen for Userid, Password and connection
> string. It has two buttons OK and CANCEL.
>
> My requirement is that, in case I forget the id and
> password I should be able to cancel the Logon screen and
> exit the application. The problem is that if I want to exit
> by clicking the close button or clicking the CANCEL button
> of the Logon Window without entering anything, it does not
> exit but does the validations for the Userid and Password.
>
> How do I capture the Button Pressed or Window Closed event
> for this LOGON_SCREEN buitin? Or is there any other way of
> doing this?
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful