Changing User in Form Runtime

[devdba]

I wonder if somebody had any idea about changing user login in forms runtime. I wish that I should not need to close the form and re-connect.
I am using D2K with Oracle 7&8i on Windows 98&XP

 

[lewisp]

Use LOGOUT and LOGON triggers. You will need to put LOGON(NULL,NULL); somewhere in your code. Then in an ON-LOGON trigger, use some code like this

LOGOUT;
LOGON('username','password@database');