From: lcunning@linknet.net (Lewis Cunningham) Subject: Re: Logon procedure in Oracle Forms 4.5 Date: 1996/11/17 Message-ID: #1/1 references: <01bbd1c9$2491fec0$1b600893@win95pc.hku.hk> newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.tools I had the same thing happen to me. I think it has something to with recursion but I'm not sure. Anyway, use NULL; in the on-logon and move your logon code to a seperate form. Call the logon form from the pre-form trigger and that should work. If it doesn't and you'ld like a sample (i.e., the logon i use), e-mail me and I'll send it to you. Lewis "Horace Kwong" wrote: >I have a problem when overriding the default logon screen by using my own >logon screen. Please see the following code: >/* on-logon trigger */ >if :logon.bypass_logon is not null then > logon(:logon.username, :logon.password || '@t:xxxxxx:xxx'); > if not form_success then > raise form_trigger_failure; > end if; >end if; >/* end of on-logon trigger */ >/* when-new-form-instance trigger */ >:logon.bypass_logon := 'F'; >:global.logon_failure := 0; >show_my_logon_screen; >/* end of when-new_form_instance trigger */ >/* when-button-pressed trigger for the OK button in the my_logon_screen */ >execute_trigger('ON-LOGON'); >if form_success then > hide_my_logon_screen; > message('You logon successfully'); > continue .... >elsif :global.logon_failure = 2 then > exit_form(no_validate); >else > :global.logon_failure := :global.logon_failure + 1; > message('Incorrect username or password. Please try again'); > remain in my_logon_screen; >end if; >/* end of when-button-pressed trigger */ >Note that the above code work alright in forms 4.0. But when I ported the >code to run in forms 4.5, problems come. If I type a wrong username or >password, then I am remain in my_logon_screen. Afterwards, I type a right >one and I am virtually logon successfully. Unfortunately, if the program >run to a sentence that request data from database, Application error saying >: F45RUN caused a General Protection Fault in module PLR1171W.DLL at >0003:CF58. >However, if I can type the correct username and password the first time, >everything works alright. >Do any of you know what's happening? >Best Regards, >Horace Kwong