I use pb made a login interface, but the database have n users, land input account password, can only be normal enter data into the database first login, and input the data, is an error, says login id error, next is how to return a responsibility excuse me? The SQL statement is wrong?

SELECT "name", "password"
INTO: pass_id, : pass_password
FROM "login";
If pass_id=passid and pass_password=password then
Open (m_admin)
Close (w_admin)

The else
Li_state=MessageBox (" wrong administrator!" , & amp;
"Enter the administrator ID or password error, whether or not to enter?" , StopSign! YesNo! The 1)
If li_state=1 then
Open (w_admin)
Sle_1. Text=""
Sle_2. Text=""

After I change the code to the following cases, randomly enter an id and password can enter the system, still can't normal functionality,
SELECT count (*)
INTO: rc
Where pass_id=name and pass_password=password
FROM "login";
If the rc=0 then
Open (m_admin)
Close (w_admin)

The else
Li_state=MessageBox (" wrong administrator!" , & amp;
"Enter the administrator ID or password error, whether or not to enter?" , StopSign! YesNo! The 1)
If li_state=1 then
Open (w_admin)
Sle_1. Text=""
Sle_2. Text=""
I use databases is the access,

CodePudding user response:

SELECT "name", "password"
INTO: pass_id, : pass_password
FROM "login";


Add the WHERE condition matching query password

CodePudding user response:

Query conditions, indeed

CodePudding user response:

SELECT count (*)
INTO: rc
Where pass_id=name and pass_password=password
FROM "login";
This has a problem

CodePudding user response:

If the rc=0 then
Open (m_admin)
Close (w_admin)

It should be
If the rc & gt; 0 then
Open (m_admin)
Close (w_admin)

CodePudding user response:

Name_test=sle_1. Text
Passwordid=sle_2. Text=""

SELECT the name and the password
INTO: pass_id, : pass_password
The FROM the login where name=: name_test and password=: password_test;

If isnull (pass_id=true then
.

CodePudding user response:

Wrong, under the correct..
Passwordid=sle_2. Text

CodePudding user response:

You to give a variable an array???????

Is the first data system must have a default...

CodePudding user response:

Have any PB can master to moonlight as a training instructor? If an interested friends, please send resume

To: [email protected], please contact: QQ: 174629429 MSN:[email protected]

CodePudding user response:

is a lack of conditions, the other one is the right conditions

CodePudding user response:

Xiongshouyong
The positive solution of