| Logon Authentication [message #340025] |
Mon, 11 August 2008 01:52  |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
Dear Sir,
I am using this trigger on NEW_FORM_INSTANCE
logout;
logon('scott@local','tiger');
execute_query;
where scott is username , local is my DB string and tigger is password.
I want to perform two different tasks on
either successful log on or failure.
if logon is succcess then
execute_query;
else it must show some cuomize message....(you are not logged on).....
how is it possible?????
regards.
|
|
|
|
|
|
| Re: Logon Authentication [message #340206 is a reply to message #340051] |
Mon, 11 August 2008 23:25  |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
| gurupatham wrote on Mon, 11 August 2008 04:32 | try to solve your problem by using Form_Success
Ex:
if form_success then
Message('Success');
else
Message('Not Logged on');
end if;
|
Dear Sir
Thanks for the reply.
I have already tried this option on ON-Logon Trigger, Post-Logon Trigger....... but it is of no use...... this does not solve the problem....
please do some thing.....
regards.
|
|
|
|
| Re: Logon Authentication [message #340738 is a reply to message #340206] |
Thu, 14 August 2008 01:49 |
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
|
Member |
|
|
Use the following Code in On-Logon Trigger .
It must work ,in case any problem in Logon ,it goes to the else part where you can give your own customize message and exit the form.
Logon('scott@local','tiger' ,false );
IF form_success then
Message('in');pause;
else
message('Out');pause;
end if;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
