Home » Developer & Programmer » Forms » how make pass word (mulie user)
how make pass word [message #403937] Tue, 19 May 2009 10:40 Go to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
hi everyone

i have table name pass
include 4 columns
id ,name,pass,dept_name
i wont make form password check 3 values
and if dept_name = it then
open form3
or if dept_name = market then
open form2
or if dept_name = sales then
open form1
like this

please see jbge


  • Attachment: PASS WORD.JPG
    (Size: 86.22KB, Downloaded 152 times)
Re: how make pass word [message #403952 is a reply to message #403937] Tue, 19 May 2009 16:21 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, so what is the question / problem?
Re: how make pass word [message #403959 is a reply to message #403937] Tue, 19 May 2009 18:28 Go to previous messageGo to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
hi Littlefoot

my question how can do that

nad i have three forms
forms 1 name it , forms 2 name sales , formas 3 market

exmple

name ali and password 2849 deptname it

then open form it

like this
Re: how make pass word [message #403998 is a reply to message #403959] Wed, 20 May 2009 00:24 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that your first message is on the track; you'll need to use IF-THEN-ELSE and call the form user selects. As you've almost already done it, I can't guess what the real problem is ...
Re: how make pass word [message #404668 is a reply to message #403937] Fri, 22 May 2009 13:25 Go to previous messageGo to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
hi Littlefoot

i do this but u forget
the 3 values must check but
problem department
Re: how make pass word [message #404682 is a reply to message #404668] Fri, 22 May 2009 15:10 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd first check whether USERNAME + PASSWORD combination is valid. If not, raise an error. Otherwise, check department name and call the appropriate form.
Re: how make pass word [message #404686 is a reply to message #403937] Fri, 22 May 2009 15:53 Go to previous messageGo to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
hi Littlefoot

manythanks for help my frind
Re: how make pass word [message #404942 is a reply to message #403937] Mon, 25 May 2009 10:12 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Did your Problem Solved?


Shahzaib
Re: how make pass word [message #404958 is a reply to message #403937] Mon, 25 May 2009 15:13 Go to previous messageGo to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
realy no
if u have answer pls write
Re: how make pass word [message #404961 is a reply to message #404958] Mon, 25 May 2009 15:56 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
And the question is ...? I mean, what answer do you expect?
Re: how make pass word [message #404977 is a reply to message #403937] Mon, 25 May 2009 23:38 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
ok Please find the attachment i hope it will solve your problem
Its not only a list item i also create this with Radio button Too



Regards


Shahzaib Ismail
  • Attachment: DEPTUSER.fmb
    (Size: 60.00KB, Downloaded 160 times)
Re: how make pass word [message #405185 is a reply to message #403937] Tue, 26 May 2009 16:25 Go to previous messageGo to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
hi Shahzaib Ismail many thans for help
but u make user name , and password static
but i wont user name and password vailbile and check from table

we have table name userpass

look this cod


declare

v_count number(3);
begin
select cout(*)
into v_count
from userpass
where id =:userpass.user_id and pass=:userpass.pass and deptid=:userpass.ideptid

if v_count =0 then
message ('error password');
else
open_form(d:/doda.fmx);
exit_form;
end if;
end;

this easy ccode password for mulite user
but i wont make code check lke this
i ll try for git it
Re: how make pass word [message #405203 is a reply to message #403937] Tue, 26 May 2009 23:54 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
^^

What's the need to save there password in table because its will be easy for any one to connect database and get your password ? for example if i am working in IT department and want to check market record but i don't have market password then i know that password is save in table so i can easily get the market password.

Any way if you want to user_id and password in your table i have another solution which i do for Registration of my software You can make 4 Text box

2 for user id
and 2 for password


1 user id and 1 password text box will visible and other are not visible

And of New_from_instance set execute record for those invisible text box and write

if visible text box = invisible text box then
go_form what ever you want

Its an easy tricks to do this

But i Recommended don't save your password in database


Regards

Shahzaib Ismail
Re: how make pass word [message #405237 is a reply to message #403937] Wed, 27 May 2009 02:41 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Ok as far as your requirement is


I Create a form which will help you to learn more please find the attachment of userpas.fmb


Check when new_form_instance_trigger and create the table and record which is in new_form_instance_trigger

Change OK Triger and change the path of form


Regards


Shahzaib Ismail
  • Attachment: USERPAS2.fmb
    (Size: 68.00KB, Downloaded 155 times)
Previous Topic: procedure in oracle trigger
Next Topic: Can we Change Database Column Name in Run Form
Goto Forum:
  


Current Time: Thu Dec 08 02:15:48 CST 2016

Total time taken to generate the page: 0.11916 seconds