with ADOQueryX do
begin
Close;
LockType:=ltBatchOptimistic;
SQL.clear; //CASE WHEN t1.GrossNettea=0 THEN ''净茶'' ELSE ''毛茶'' END as 毛净茶
SQL.text:='Select t1.*,a.caption as 商品'
+',a.caption as 品种,b.caption as 型,c.caption as 产地'
+',d.caption as 季节,e.caption as 计量单位,f.caption as 规格 From AccRecords t1'
+' left join BasicClass a on t1.Species = a.id'
+' left join BasicClass b on t1.Flavor = b.id'
+' left join BasicClass c on t1.PlaceOrigin = c.id'
+' left join BasicClass d on t1.ProduSeason = d.id'
+' left join BasicClass e on t1.Unit = e.id'
+' left join BasicClass f on t1.Specifications = f.id'
+' where 1=2'; //
Open;
end;这样下面的语句执行后会提示 多次产生 列名 caption 的错误,请问是怎么回事Properties['Unique Table'].Value='tablename'UpdateBatch(arAll);
begin
Close;
LockType:=ltBatchOptimistic;
SQL.clear; //CASE WHEN t1.GrossNettea=0 THEN ''净茶'' ELSE ''毛茶'' END as 毛净茶
SQL.text:='Select t1.*,a.caption as 商品'
+',a.caption as 品种,b.caption as 型,c.caption as 产地'
+',d.caption as 季节,e.caption as 计量单位,f.caption as 规格 From AccRecords t1'
+' left join BasicClass a on t1.Species = a.id'
+' left join BasicClass b on t1.Flavor = b.id'
+' left join BasicClass c on t1.PlaceOrigin = c.id'
+' left join BasicClass d on t1.ProduSeason = d.id'
+' left join BasicClass e on t1.Unit = e.id'
+' left join BasicClass f on t1.Specifications = f.id'
+' where 1=2'; //
Open;
end;这样下面的语句执行后会提示 多次产生 列名 caption 的错误,请问是怎么回事Properties['Unique Table'].Value='tablename'UpdateBatch(arAll);
我都是调用一个表