用Adoquery就行 设置好Adoquery的连接属性 执行如下代码 with ADOQuery1 do begin close; sql.clear; sql.add(update MsgDB set RZ='+#39+'1'+#39+' where id <= 104954); execsql; close; end; #39是引号
sql.add('update MsgDB set RZ='+#39+'1'+#39+' where id <= 104954');
用ADOQuery1,在属性中点SQL后的...,写上你要执行的语句!
with ADOQuery1 do begin close; sql.clear; sql.Text:='update MsgDB set RZ='+#39+'1'+#39+' where id <= 104954'; execsql; close; end;
设置好Adoquery的连接属性
执行如下代码
with ADOQuery1 do
begin
close;
sql.clear;
sql.add(update MsgDB set RZ='+#39+'1'+#39+' where id <= 104954);
execsql;
close;
end;
#39是引号
with ADOQuery1 do
begin
close;
sql.clear;
sql.Text:='update MsgDB set RZ='+#39+'1'+#39+' where id <= 104954';
execsql;
close;
end;