Home » Developer & Programmer » Forms » main form not getting displayes thru login form login button when clicked (Oracle 10g App Server, windows xp sp2)
main form not getting displayes thru login form login button when clicked [message #522804] Wed, 14 September 2011 01:06
oratech10
Messages: 26
Registered: September 2011
Junior Member
Hi All
When I am clicking the login button of the login form to call the main form, I could not
see the main form on the display.
Note 1: Oracle 10g application server, windows xp env
Note 2:I am using http, port 8080 to use the application.
Note 3: The URL in the below code is correct, not sure why the called from is not getting diplayed,
but the same is perfect when I am running on the developer suit.


code:
declare
pl_id paramlist;
--vVar1 NUMBER;
a varchar2(80);
b varchar2(40);
begin

SELECT user_name,mc_name into b,a FROM Mc_users
WHERE user_name = :block3.username and -- Check the case sensitivity use UPPER function on requirement
pwd = :block3.pwd and mc_name = :block3.mc;



if :username is not null
then

pl_id := get_parameter_list('tempdata');
if not ID_NULL(pl_id) then destroy_parameter_list(pl_id); end if;
pl_id := create_parameter_list('tempdata');

add_parameter(pl_id,'mc_name',text_parameter,a);
add_parameter(pl_id,'user_name',text_parameter,b);

call_form('D:\OraHome_2\forms\fdtlnew3.fmx',hide,do_replace,no_query_only,pl_id);
--:global.mc := :block3.username;
--call_form('D:\orant\forms90\storedb.fmx',hide,do_replace,no_query_only);

else
message('Invalid user account or Account has been blocked.');
message('Invalid user account or Account has been blocked.');
end if;

end;
---------

Please help me on this. Thankyou!
oratech10
Previous Topic: Form 6i (which user is using which form?)
Next Topic: Highlisght a particular record
Goto Forum:
  


Current Time: Sat Sep 07 12:56:57 CDT 2024