Question

PB代码，提示name附近有语法错误，帮忙看一下~

string ls_username,ls_password
ls_username=trim(sle_1.text)
ls_password=trim(sle_2.text)
if ls_username="" or ls_password="" then
messagebox("提示","用户名和密码不能为空")
else
SELECT "users"."name","users"."password","users"."admin"
INTO :gs_username,:gs_password,:gs_admin
FROM "users"
WHERE ("users"."name" = :ls_username ) AND
("users"."password" = :ls_password );
if sqlca.sqlcode=0 then
open(w_main)
close(w_login)
else
li_n=li_n - 1
if li_n<>0 then
messagebox("提示","用户名或密码错误")
else
messagebox("提示","错误超过3次,自动退出")
halt
end if
end if

end if

Answer 1

不同数据库的要求不一样，你把字段名，表名附近的"去掉后试试

Answer 2

datetime birthday1
定义变量不用加分号

Answer 3

pb对双引号很敏感。。。