how can i code the logon system in form builder.
in p/sql editor . when click the push_button, i want to slect the username and passwordplease help me to fix them.
thanks select count(*) from custom
where cusername=:username_text_item and
cpassword=:password_text_item
if count(*)>0 then
:GLOBAL.cusername:=:username_text_item;
call_form ('u:\5059\CUSTOMER_SUB_SYSTEM.fmx');
else
DISPLAY_ALERT;
end if;
SELECT * form custom
where cusername=:username_text_item
if sql%found
then
messgae ('the username is available');
else
message ('the username has been used');
end if;
in p/sql editor . when click the push_button, i want to slect the username and passwordplease help me to fix them.
thanks select count(*) from custom
where cusername=:username_text_item and
cpassword=:password_text_item
if count(*)>0 then
:GLOBAL.cusername:=:username_text_item;
call_form ('u:\5059\CUSTOMER_SUB_SYSTEM.fmx');
else
DISPLAY_ALERT;
end if;
SELECT * form custom
where cusername=:username_text_item
if sql%found
then
messgae ('the username is available');
else
message ('the username has been used');
end if;
call the procedure as the results returned