我是一个DELPHI初学者,有个问题请大侠帮忙,特别感谢。
问题如下:这个语句那里有问题 sqlstr:='DELETE borrowbook.db WHERE BookNo='+str; 其中 str:string, BookNo为主键
DELPHI 的错误提示:''Invalid use of keyword''
问题如下:这个语句那里有问题 sqlstr:='DELETE borrowbook.db WHERE BookNo='+str; 其中 str:string, BookNo为主键
DELPHI 的错误提示:''Invalid use of keyword''
就行了
procedure TReturnBook.Button1Click(Sender: TObject);var
sqlstr,
str:string;begin
str:=Edit2.Text;
sqlstr:='DELETE borrowbook.db WHERE BookNo='+str;
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add(sqlstr);
Query1.ExecSQL;
end;完整的错误提示:
"Project Project1.exe raised exception class EDBEngineError with message 'Invalid use of keyword.
Token:borrowbook.db
Line Number:1'.Process stoped.use step or Run to Continue."
sql删除的语法是:
delete from tablename
你忘记加from