头大了Parameters 'LR' not found帮我看看哪出错了,我用ACCESS数据库就没问题,用SQL2000的
类型是nvarcharprocedure TWXXZForm.Button1Click(Sender: TObject);
var
i:integer;
s:string;
begin
with Data.Qwxxz do
begin
SQL.Clear;
SQL.Add('Delete From WXXZ');
ExecSQL;
end;
for i:=0 to memo1.lines.count-1 do
with Data.Qwxxz do
begin
Close;
Sql.Clear;
Sql.Add('insert into WXXZ (LR) values (s)');
Parameters.ParamByName('LR').Value:=memo1.lines.Strings[I];
ExecSql;
end;
end;
类型是nvarcharprocedure TWXXZForm.Button1Click(Sender: TObject);
var
i:integer;
s:string;
begin
with Data.Qwxxz do
begin
SQL.Clear;
SQL.Add('Delete From WXXZ');
ExecSQL;
end;
for i:=0 to memo1.lines.count-1 do
with Data.Qwxxz do
begin
Close;
Sql.Clear;
Sql.Add('insert into WXXZ (LR) values (s)');
Parameters.ParamByName('LR').Value:=memo1.lines.Strings[I];
ExecSql;
end;
end;
多了个:号啊