daogu

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.

---

Answer:try to solve your problem by using Form_Success

Ex:

---

Answer:

gurupatham wrote on Mon, 11 August 2008 04:32

try to solve your problem by using Form_Success Ex:

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.

---

Answer: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;

---

Answer:thanks dear

it really worked.

regards.

Related posts:

1. Builtin Logon procedure slow when i am using the builtin LOGON Procedure its...
2. ORA-12560 ……….. How could it resolve ? I installed both forms 6i , 10g …… both...
3. Help on Logon Hi guyz, I have a table Logon Data is...
4. Block status chages.. Hi, Following is my code, ——————— If :global.mode in...
5. Forms Services Installation Problem I have loaded the Developer Suite and am now...