Question

pb sql语句问题

select U_Name, U_Code
into :username, :usercode
from User
where U_Name = rtrim(ltrim(:sle_1.text));

总是报错：
Database C0038:在关键字‘User’附近有语法错误。

Answer 1

string username,username,txt
txt=trim(sle_1.text)
select U_Name, U_Code
into :username, :usercode
from User
where U_Name = :txt;

where条件里边的变量不能直接把控件名加冒号那样引用