How to varify ???

[adilsami]

Using Foms6i :

On the BUTTON click , how i can verify the login name n password from the database table , n upon that it allows to login , & it transfers after login-in to the other form ..wut will the coding for that !

please help meee out!!!!!!!

[simply_dba]

Select username,password from user_password_table into uname,pwd;
if upper(uname)=upper(:txt_username) and upper(pwd)=upper(:txt_password) then
   call_form (your_other_form_name)
else
   raise form_trigger_failure;
end if;