我有如下程序段:
with ADOQuery1 do
begin
try
close;
sql.Clear ;
sql.Add('select * from CountBarCode where BarCode=:ss');
Parameters.ParamByName('ss').Value:=str;
open;
if RecordCount<=0 then
begin
close;
sql.Clear ;
Sql.Add('Insert into CountBarCode(Count,BarCode) values(:ss1,:ss2)');
Parameters.ParamByName('ss1').Value := 1;
Parameters.ParamByName('ss2').Value := str ;
ExecSQL;//出错地点
end;
end;
错误为:
Project sf.exe raised exception class EOleException with message 'INSERT INTO 语句的语法错误'.Process stopped.Use Step or Run to continue.很急!!!各位大虾来帮忙呀!
with ADOQuery1 do
begin
try
close;
sql.Clear ;
sql.Add('select * from CountBarCode where BarCode=:ss');
Parameters.ParamByName('ss').Value:=str;
open;
if RecordCount<=0 then
begin
close;
sql.Clear ;
Sql.Add('Insert into CountBarCode(Count,BarCode) values(:ss1,:ss2)');
Parameters.ParamByName('ss1').Value := 1;
Parameters.ParamByName('ss2').Value := str ;
ExecSQL;//出错地点
end;
end;
错误为:
Project sf.exe raised exception class EOleException with message 'INSERT INTO 语句的语法错误'.Process stopped.Use Step or Run to continue.很急!!!各位大虾来帮忙呀!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货