ADOQuery3.Close;
ADOQuery3.SQL.Clear;
ADOQuery3.SQL.Add('update Fw_user set Fwname='+Quotedstr(trim(Rzedit1.Text))+',Fpw1='+quotedstr(ryk1)+',Fpw2='+quotedstr(ryk2));
ADOQuery3.SQL.Add(',Fpw3='+quotedstr(ryk3)+',Fpw4='+quotedstr(ryk4)+',Fpw5='+quotedstr(ryk5)+',Fpw6='+quotedstr(ryk6));
ADOQuery3.SQL.Add(',Fpw7='+quotedstr(ryk7)+',Fpw8='+quotedstr(ryk8)+',Fpw9='+quotedstr(ryk9)+',Fpw10='+quotedstr(ryk10));
ADOQuery3.SQL.Add(',Fpw11='+quotedstr(ryk11)+',Fpw12='+quotedstr(ryk12)+',Fpw13='+quotedstr(ryk13)+',Fpw14='+quotedstr(ryk14));
ADOQuery3.SQL.Add(',Fpw15='+quotedstr(ryk15)+',Fpw16='+quotedstr(ryk16)+',Fpw17='+quotedstr(ryk17)+',Fpw18='+quotedstr(ryk18));
ADOQuery3.SQL.Add(',Fpw19='+quotedstr(ryk19)+',Fpw20='+quotedstr(ryk20)+' where Fwid='+quotedstr(trim(Rzedit2.Text)));
ADOQuery3.ExecSQL;我用这个做更改时怎么老跳出提示说:
标准表达式中数据类型不匹配
ADOQuery3.SQL.Clear;
ADOQuery3.SQL.Add('update Fw_user set Fwname='+Quotedstr(trim(Rzedit1.Text))+',Fpw1='+quotedstr(ryk1)+',Fpw2='+quotedstr(ryk2));
ADOQuery3.SQL.Add(',Fpw3='+quotedstr(ryk3)+',Fpw4='+quotedstr(ryk4)+',Fpw5='+quotedstr(ryk5)+',Fpw6='+quotedstr(ryk6));
ADOQuery3.SQL.Add(',Fpw7='+quotedstr(ryk7)+',Fpw8='+quotedstr(ryk8)+',Fpw9='+quotedstr(ryk9)+',Fpw10='+quotedstr(ryk10));
ADOQuery3.SQL.Add(',Fpw11='+quotedstr(ryk11)+',Fpw12='+quotedstr(ryk12)+',Fpw13='+quotedstr(ryk13)+',Fpw14='+quotedstr(ryk14));
ADOQuery3.SQL.Add(',Fpw15='+quotedstr(ryk15)+',Fpw16='+quotedstr(ryk16)+',Fpw17='+quotedstr(ryk17)+',Fpw18='+quotedstr(ryk18));
ADOQuery3.SQL.Add(',Fpw19='+quotedstr(ryk19)+',Fpw20='+quotedstr(ryk20)+' where Fwid='+quotedstr(trim(Rzedit2.Text)));
ADOQuery3.ExecSQL;我用这个做更改时怎么老跳出提示说:
标准表达式中数据类型不匹配
^_^
又出现一个问题:
ADOQuery4.Close;
ADOQuery4.SQL.Clear;
ADOQuery4.SQL.Add('Delete Fw_user where Fwid='+Rzedit2.Text);
showmessage(ADOQuery4.SQl.CommaText);
ADOquery4.ExecSQL;
这里也报错:
语法错误(操作符丢失)在‘Fw_user where Fwid=4’中???
是怎么回事
//Access中好像要加上from