UC知道PB查询中的错误
来源：百度知道 编辑：UC知道 时间：2024/06/07 11:42:44
String username,userpwd;
long l_cnt
ls_ename=Trim(sle_1.Text)
ls_pwd=Trim(sle_2.Text)
l_nums= l_nums + 1
if Len(ls_ename) = 0 then
MessageBox("用户登陆","请输入用户名")
sle_1.Setfocus( )
Return
end if
if Len(ls_pwd)=0 then
Messagebox("用户登陆","请输入密码!");
sle_2.Setfocus( )
return ;
end if
SELECT count(*)
INTO :l_cnt
FROM "login"
WHERE ( "login"."ename" = :ls_ename ) AND
( "login"."pwd" = :ls_pwd );
select count(*) into :l_cnt
from login
where Ename=:ls_ename and Pwd=:ls_pwd ;
if l_cnt > 0 then
open(w_1)
Close(parent)
else
messagebox("警告","用户名或密码输入错误,请在确认后重新输入正确的用户名称和密码!",Stopsign!)
sle_1.text= ""
sle_2.text= ""
sle_1.setfocus()
if l_nums >=3 then
messagebox(&quo
long l_cnt
ls_ename=Trim(sle_1.Text)
ls_pwd=Trim(sle_2.Text)
l_nums= l_nums + 1
if Len(ls_ename) = 0 then
MessageBox("用户登陆","请输入用户名")
sle_1.Setfocus( )
Return
end if
if Len(ls_pwd)=0 then
Messagebox("用户登陆","请输入密码!");
sle_2.Setfocus( )
return ;
end if
SELECT count(*)
INTO :l_cnt
FROM "login"
WHERE ( "login"."ename" = :ls_ename ) AND
( "login"."pwd" = :ls_pwd );
select count(*) into :l_cnt
from login
where Ename=:ls_ename and Pwd=:ls_pwd ;
if l_cnt > 0 then
open(w_1)
Close(parent)
else
messagebox("警告","用户名或密码输入错误,请在确认后重新输入正确的用户名称和密码!",Stopsign!)
sle_1.text= ""
sle_2.text= ""
sle_1.setfocus()
if l_nums >=3 then
messagebox(&quo
错误信息是什么？
另外，SELECT count(*)
INTO :l_cnt
FROM "login"
WHERE ( "login"."ename" = :ls_ename ) AND
( "login"."pwd" = :ls_pwd );
select count(*) into :l_cnt
from login
where Ename=:ls_ename and Pwd=:ls_pwd ;
你怎么把这个语句写了两遍？第一个select如果没报错就按第一个那么写。
我觉得应该是字段名区分大小写问题
你可以这样来检查一下,你用一个正确的值带进来运行一下,看能不能成功.这样:
select *
from login
where Ename='正确的值' and Pwd='正确的值' ;
执行这个,如果不成功那就是这里的问题,最简单的SQL语句,没说的,你自己仔细检查咯,另外1楼说的这个,你怎么把这个语句写了两次,一次就好,我觉得把那个带双引号的删掉.