Home » Developer & Programmer » Forms » logon query ?
icon3.gif  logon query ? [message #212871] Mon, 08 January 2007 12:18 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

My question is that ,
i have a table with 2 columns ,
1st ===== user_name and
2nd ===== user_password;
and i have one record in that table
now what i want that when i run my form it shows me my first canvas i.e. logon canvas where there are 3 fields first is user_name,
second is user_password and the third is a button to logon.
now when a user enter a data in these particular fields ,
then tha data has to be checked in the table that is it exist in table
or not if not then through me an error.


I create a form and attach it also just check it out and then please reply.
  • Attachment: ALL.fmb
    (Size: 104.00KB, Downloaded 172 times)
icon2.gif  Re: logon query ? [message #212954 is a reply to message #212871] Mon, 08 January 2007 22:55 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
check it using when validate item...
Re: logon query ? [message #212995 is a reply to message #212954] Tue, 09 January 2007 01:26 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
WHEN-BUTTON-PRESSED on the "click for login" button might look like this:
declare
  l_alert number;
  l_it_exists varchar2(1);
begin
  select null
    into l_it_exists
    from password_table p
    where p.user_name     = :user_logon.user_name
      and p.user_password = :user_logon.user_password;

  go_block('dept');
  	    
exception
  when no_data_found then
    l_alert := show_alert('alert');
end;
Previous Topic: Open another form
Next Topic: No changes to save
Goto Forum:
  


Current Time: Sun Dec 04 18:44:57 CST 2016

Total time taken to generate the page: 0.11110 seconds