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
|
|
|