if sle_1.text="" OR sle_2.text=""then
messagebox("警告","账号或密码不能为空！")
else
a=trim(sle_1.text)
select password
into : b
from user
where id=:a;
//using sqlca;
if b=sle_2.text then
messagebox("恭喜","登陆成功！")
open(w_main)
close(w_load)
else
messagebox("Error","密码错误！")
sle_1.setfocus()
i=i+1
if i=3 then
messagebox("ERROR","窗口将立即关闭!")
close(parent)
end if
end if
end if
已设全局变量 a ，b和局部变量i
运行警告：database:c0038:sqlstate=37000[sybase][odbc drive]]adaptive server anywhere]syntax error or access violation: near 'user ' in...password from[user]where id= ' '...
------解决方案--------------------
这个问题刚才我也碰到了，找了很多方法都不行，你试试把user表删了，换成其他名字的表，应该是PB的BUG吧！经常抽！