在dbgrideh里我想要把我按两个时间段查找出来的记录,进行一条一条把系统时间,当前用户名,标记,更新到相应的字段里去,字段是(assessor,auditdate,sign),请大家指点,下面应该怎么加好呢
with frmlaborage.qbaseinfo do
begin
Close;
SQL.Clear;
SQL.add('insert into laborage(assessor,auditdate,sign)');
sql.add('select .....from laborage');
sql.add('where convert(varchar(10),rq,120)>='+QuotedStr(DatetimeToStr(datetimepicker1.date))+' and convert(varchar(10),rq,120)<='+QuotedStr(DatetimeToStr(datetimepicker2.date)));
Open;
end;
with frmlaborage.qbaseinfo do
begin
Close;
SQL.Clear;
SQL.add('insert into laborage(assessor,auditdate,sign)');
sql.add('select .....from laborage');
sql.add('where convert(varchar(10),rq,120)>='+QuotedStr(DatetimeToStr(datetimepicker1.date))+' and convert(varchar(10),rq,120)<='+QuotedStr(DatetimeToStr(datetimepicker2.date)));
Open;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货