Delphi中的代码为
with ADOQuery1 do
begin
close;
sql.Clear;
sql.add('update tb_ProPlan set YN = ''是'' where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
sql.Add('update tb_ProPlan set Checker='+ QuotedStr(CheckerEdit.Text)+'where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
execsql;
end;
麻烦大家帮忙了,O(∩_∩)O谢谢
with ADOQuery1 do
begin
close;
sql.Clear;
sql.add('update tb_ProPlan set YN = ''是'' where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
sql.Add('update tb_ProPlan set Checker='+ QuotedStr(CheckerEdit.Text)+'where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
execsql;
end;
麻烦大家帮忙了,O(∩_∩)O谢谢
with ADOQuery1 do
begin
close;
sql.Clear;
sql.add('update tb_ProPlan set YN = ''是'' where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
sql.Add('update tb_ProPlan set Checker='+ QuotedStr(CheckerEdit.Text)+'where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
execsql;
end;
begin
close;
sql.Clear;
sql.add('update tb_ProPlan set YN = ''是'' where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
sql.Add('update tb_ProPlan set Checker='+ QuotedStr(CheckerEdit.Text)+'where ProPlanID= ' + QuotedStr(ProPlanIDEdit.Text));
execsql;
end;