Hi Team,
   No matter how many records are for this query to return, TEDBQuery1.RecCount always gives 1.


{sql}
select sum("QtyUsed") as QtyUsed, sum("QtyReq") as QtyReq, sum("LineTotalSell") as LineTotalSell from Lineitems
where JobNo=:JobNo
{sql}

   I have done the following for now..
{sql}
select sum("QtyUsed") as QtyUsed, sum("QtyReq") as QtyReq, sum("LineTotalSell") as LineTotalSell, count("JobNo") as
RecordCount from Lineitems
where JobNo=:JobNo
{sql}

   But why aren't I getting an accurate RecCount in the first instance?

Regards,
Ian

Ian


Firstly what is RecCount?

Secondly you will only ever get 1 row from that query - you're telling it to add everything up and just give you the totals.

Roy Lambert

Roy Lambert wrote:

> Ian
>
>
> Firstly what is RecCount?
>
> Secondly you will only ever get 1 row from that query - you're telling it to add everything up and just give you the
> totals.
>
> Roy Lambert

Ahhhhhhh!!!!  Well colour me Red.  Of course.

I will just slink away now....

Tks Roy.