Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Ummmmm. |
Sun, Dec 9 2018 10:42 PM | Permanent Link |
Ian Branch | 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 |
Mon, Dec 10 2018 2:35 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Mon, Dec 10 2018 3:34 AM | Permanent Link |
Ian Branch | 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. |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |