insert into错误
为什么总报错误那?那个大哥帮忙看看
HWMC:= ZXCLDBGridEh.DataSource.DataSet.Fields.Fields[0].Value;
PP:= ZXCLDBGridEh.DataSource.DataSet.Fields.Fields[1].Value;
XH:= ZXCLDBGridEh.DataSource.DataSet.Fields.Fields[2].Value;
JG:= ZXCLDBGridEh.DataSource.DataSet.Fields.Fields[4].Value;
SL:= DBEditEh1.Value;
ZJ:= SL*JG;
with SZSJFADM.ZXFAADOQ do
begin
close;
sql.Clear;
sql.Add('insert into 装修方案([货物名称],[品牌],[型号],[数量],[单价],[总价])'+'values(HWMX,PP,XH,SL,JG,ZJ)') ;
ExecSQL;
------解决方案--------------------
sql.Add('insert into 装修方案([货物名称],[品牌],[型号],[数量],[单价],[总价])'+'values("' + HWMX+ '","'+ PP +'",'+ XH +',' + SL+',' +JG+',' +ZJ)') ;