sql.add('update sjtj set
sjks=(select min(sjbh) from cxgc where sjbh like '11%') ,
sjjs=(select max(sjbh) from cxgc where sjbh like '11%') where tx='cxgc_c1'');
sjks=(select min(sjbh) from cxgc where sjbh like '11%') ,
sjjs=(select max(sjbh) from cxgc where sjbh like '11%') where tx='cxgc_c1'');
sql.add('update sjtj set
sjks=(select min(sjbh) from cxgc where sjbh like ''11%'') ,
sjjs=(select max(sjbh) from cxgc where sjbh like ''11%'') where tx='cxgc_c1'');再更正一下,看还有什么错?
sql.add('update sjtj set
sjks=(select min(sjbh) from cxgc where sjbh like '"11%"') ,
sjjs=(select max(sjbh) from cxgc where sjbh like '"11%"') where tx='cxgc_c1'');
sjks=(select min(sjbh) from cxgc where sjbh like '11%') ,
sjjs=(select max(sjbh) from cxgc where sjbh like '11%') where tx=:cxgc');
dataset.parambyname('cxgc').Asstring:='cxgc_c1';