语句未结束的错误

来源:百度知道 编辑:UC知道 时间:2024/05/29 08:44:38
sql="select * from 成绩单 where username='"&username&"' And no="&no&" And password='"&password"'"

sql = "select * from 成绩单 where username='" & username & "' And no=" & no & " And password='" & password & "'"

少了个&符号还有变量和&之间要有空格。

select * ;
from 成绩单;
where username="&username&" And no="&no&" And password="&password"