Home » Developer & Programmer » Forms » logon query ?
icon3.gif  logon query ? [message #212871] Mon, 08 January 2007 12:18 Go to next message
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 184 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
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
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
WHEN-BUTTON-PRESSED on the "click for login" button might look like this:
  l_alert number;
  l_it_exists varchar2(1);
  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;

  when no_data_found then
    l_alert := show_alert('alert');
Previous Topic: when-mouse-Leave trigger in 10g R2
Next Topic: making a Counter Bar
Goto Forum:

Current Time: Tue Aug 22 17:46:54 CDT 2017

Total time taken to generate the page: 0.02400 seconds