怎么样才能把QuickRep下的QRDBText11的dateset指定ADOQuery
我把QuickRep下的QRDBText11的dateset指定ADOQuery
可是发现没有办法指定DateField,错误提示“Missing SQL property”
是不是因为我的ADOQuery得SQL是动态的?
ADOQuery的部分源代码如下:
QueryHuo->Close();
QueryHuo->SQL->Clear();
QueryHuo->SQL->Add("select b.product_id as 商品编码,c.name as 商品名称,c.price as 商品价格,sum(b.amount) as 数量 from usrsales a inner join usrdetail b on a.ordinal=b.ordinal,usrproduct c where b.product_id=c.id ");
if (rbAllBumen->Checked)
{
}
else
{
QueryHuo->SQL->Add(" and a.WorkStation='"+Trim(cbWorkStation->Text)+"'");
}
if (rbOneProduct->Checked)
{
QueryHuo->SQL->Add(" and b.Product_ID='"+Trim(meProduct->Text)+"'");
}
if (rbOneday->Checked)
QueryHuo->SQL->Add(" and Floor(Convert(float,Op_DateTime))=Convert(DateTime,'"+DateToStr(dtOneday->Date)+"',20)");
else
{
QueryHuo->SQL->Add(" and Floor(Convert(float,Op_DateTime))>=Convert(DateTime,'"+DateToStr(dtBegin->Date)+"',20)");
QueryHuo->SQL->Add(" and Floor(Convert(float,Op_DateTime))<=Convert(DateTime,'"+DateToStr(dtEnd->Date)+"',20)");
}
QueryHuo->SQL->Add(" group by b.product_id,c.name,c.price");
QueryHuo->SQL->Add(" order by b.product_id");
QueryHuo->Open();
怎么样才能把QuickRep下的QRDBText11的dateset指定ADOQuery
是不是也要动态指定???