2,497
社区成员
发帖
与我相关
我的任务
分享
procedure TForm1.Button3Click(Sender: TObject);
var
str1,str2:string;
begin
str1:='XJ4FUPS42-1';
str2:='20130101' ;
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('update 测试时间');
query1.SQL.Add('set 测试时间=''20130101''');
query1.SQL.Add('where 蓄电池组名称=''XJ4FUPS42-1''');
query1.ExecSQL;
end;
procedure TForm1.Button3Click(Sender: TObject);
const S_SQL = 'update 测试时间 set 测试时间 = %s where 蓄电池组名称 = %s';
var
str1,str2 : string;
begin
str1:='XJ4FUPS42-1';
str2:='20130101' ;
query1.Close;
try
query1.SQL.text := format(S_SQL, [quotedstr(str1), quotedstr(str2)]);
query1.ExecSQL;
except on e: exception do
showmessage(e.message);
end;
end;
var str1,str2:string;
begin
str1:='XJ4FUPS42-1';
str2:='20130101' ;
with query1 do
begin
close;
sql.Clear;
sql.Add('update 表名 set 测试时间='''+str1+''' where 蓄电池组名称='''+str2+'''');
ExecSQL;
end;
end;
{修改成这样,亲测!}