| how make pass word [message #403937] |
Tue, 19 May 2009 10:40  |
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
|
|
|
|
|
|
| Re: how make pass word [message #403959 is a reply to message #403937] |
Tue, 19 May 2009 18:28  |
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 #405185 is a reply to message #403937] |
Tue, 26 May 2009 16:25 |
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 |
shahzaib_4vip@hotmail.com
Messages: 410
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 |
shahzaib_4vip@hotmail.com
Messages: 410
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 1048 times)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
